This article demonstrates how to set up Sharding-JDBC in a Spring Boot project, covering project structure, Maven configuration, entity, controller, service, mapper code, database DDL for multiple shards, sharding rules in application.properties, and API testing with Postman.
An upgrade of MyBatis from 3.2.3 to 3.4.6 caused parameterType mismatches in XML mappings, turning previously ignored type declarations into enforced ones, which led to ClassCastException errors for LocalDateTime and other types, prompting a root‑cause analysis and recommendations for careful version testing and configuration alignment.
This article explains how to define and use Laravel Eloquent relationships—including one-to-one, inverse, and default model handling—by showing the necessary model methods, query constraints, and code examples for both sides of the association.
This article explains how to add, update, and manage related Eloquent models in Laravel—including saving single or multiple related records, using associate/dissociate for belongsTo relations, and handling many‑to‑many pivots with attach, detach, sync, toggle, and timestamp propagation.
This article explains Laravel Eloquent's eager loading techniques, demonstrating how to replace lazy-loaded N+1 queries with the with() method, preload multiple or nested relationships, select specific columns, apply constraints, and use lazy eager loading methods like load and loadMissing, all illustrated with PHP code examples.
This article explains how to define and use Laravel Eloquent relationships—including remote one‑to‑many (hasManyThrough), polymorphic, many‑to‑many polymorphic, and various query constraints—by showing required database schemas, model methods, and example code for retrieving and counting related records.
This article explains how to define many-to-many relationships in Laravel's Eloquent ORM, covering the required pivot table, model methods, query constraints, pivot customization, and the use of custom pivot models with code examples.
This article explains how to define and use one-to-many and inverse (belongsTo) relationships in Laravel's Eloquent ORM, including default foreign key conventions, accessing related records, applying query constraints, and customizing foreign and local keys with code examples.
This article explains the powerful MyBatis resultMap element, covering basic getter/setter injection, constructor injection, inheritance, one-to-one and one-to-many associations, and discriminators, while providing complete XML examples and Java entity code to help developers map complex relational data efficiently.
A deep dive into recent Spring team poll results, Google Trends, Stack Overflow statistics, and expert opinions reveals why MyBatis is often preferred over Hibernate for fast‑moving, internet‑scale Java applications.
This article explains the differences between Laravel's ORM and DB query builder, outlines their advantages and appropriate use cases, and provides step‑by‑step code examples for defining models, retrieving, creating, and deleting records, as well as handling transactions.
This cheat sheet provides a concise yet comprehensive guide to Laravel's Eloquent Model, covering definition, artisan commands, common CRUD methods, soft‑deletes, relationship types, model events, and configuration tips, all illustrated with ready‑to‑copy code examples.
This article provides a comprehensive overview of Laravel, covering its definition, advantages over other PHP frameworks, core components such as migrations, facades, service container, Eloquent models, events, query builder, route naming, closures, testing techniques, traits, autoloading, generators, and various PHP language features with practical code examples.
This guide explains Laravel Eloquent's relationship types—including one-to-one, one-to-many, many-to-many, polymorphic and has‑many‑through—showing how to define, query, preload, and manipulate them with PHP code examples and detailed explanations for backend development in applications.
This tutorial explains how to configure Laravel's Eloquent ORM, create and customize model classes, manage table names, primary keys, timestamps, perform queries, insert, update, delete records, handle soft deletes, apply global and local scopes, and work with model events and observers, all with practical PHP code examples.
This article explains how Laravel Eloquent returns Collection objects, demonstrates iterating and chaining collection methods such as reject and map, lists the extensive base collection API, and shows how to create custom collections by overriding the newCollection method in a model.
This article explains how to create a JetBrains IntelliJ plugin that parses MySQL DDL statements, performs lexical analysis to extract table and column information, and automatically generates corresponding Python ORM model classes, illustrating the underlying state‑machine lexer, recursive parsing logic, and sample code.
This article explains the core principle of MyBatis by demonstrating how Mapper interfaces are turned into dynamic proxy objects using JDK proxy mechanisms, walks through manual simulation code, and clarifies each step of the proxy creation and method invocation process.
This article introduces MyBatis, a Java persistence framework that separates SQL from code, outlines its key features, explains its layered architecture, and details the core components such as SqlSessionFactory, SqlSession, MapperProxy, Executor, StatementHandler, ParameterHandler, and ResultSetHandler with code examples.
This guide explains how to define Django model classes, map them to database tables, and use the makemigrations and migrate commands to generate and apply migrations, illustrated with Users and Files examples and the resulting SQL schema.
This tutorial explains how to integrate MyBatis into a Spring Boot project, covering the framework's basics, Maven dependencies, annotation‑based CRUD operations, XML‑based mappings, entity definitions, controller implementations, Swagger testing, and Druid monitoring, with complete code examples and download links.
Learn how to replace verbose JDBC code with Spring’s JdbcTemplate by first understanding JDBC basics, then adding the necessary Maven dependencies, configuring a connection pool, defining entity and repository classes, and writing unit tests, all illustrated with complete Java examples.
The article provides a series of advanced MyBatis-Plus query examples, including table creation, data initialization, and four detailed cases that demonstrate the use of like, nested, in, and limit clauses with QueryWrapper, accompanied by SQL statements, Java test code, and execution screenshots.
This article walks through building a MySQL user table, defining the corresponding Java entity and MyBatis‑Plus mapper, and demonstrates basic query operations such as selectList, selectById, selectBatchIds, and selectByMap with full code examples and the generated SQL statements.
This article presents a series of MyBatis-Plus advanced query cases, including data preparation, detailed SQL and Java QueryWrapper examples, difficulty ratings, and complete code snippets to help developers master complex query operations in a Java backend environment.
This article provides a step‑by‑step tutorial on using MyBatis‑Plus select queries, including data preparation, SQL table creation, and detailed Java code examples for retrieving specific fields and filtering by age with both simple and advanced query wrappers.
This tutorial demonstrates how to create a User table, define the corresponding entity and mapper classes, and perform basic MyBatis-Plus queries such as selectList, selectById, selectBatchIds, and selectByMap, including the required SQL scripts and Java code examples.
This article demonstrates how to perform sophisticated MyBatis‑Plus queries—such as date filtering, manager name prefix matching, sub‑queries, INNER JOIN, dynamic SQL with apply, and inSql—while highlighting potential SQL‑injection risks and providing complete Java test code examples.
This article presents a series of MyBatis-Plus advanced query examples, including how to filter users by name patterns, age ranges, and email presence, and demonstrates ordering and combined conditions with complete Java test code and a sample User table schema.
This tutorial demonstrates how to perform advanced MyBatis-Plus queries—including subqueries, INNER JOIN, apply, and inSql methods—while highlighting difficulty levels, code examples, and the risk of SQL injection in dynamic query construction.
This tutorial showcases MyBatis-Plus advanced query techniques through three practical case studies, providing sample data, detailed SQL conditions, and complete Java test code snippets to help developers master complex database queries.
This article examines the long‑standing debate between MyBatis and JPA, analyzing usage statistics, regional preferences, and technical factors that make Chinese developers favor MyBatis and foreign teams prefer JPA, while offering practical insights for choosing the right ORM.
This article provides detailed answers to 18 common MyBatis interview questions, covering the differences between #{ } and ${ }, XML mapping tags, DAO interface behavior, pagination techniques, plugin development, batch operations, dynamic SQL, result mapping, association handling, lazy loading, executor types, enum mapping, and the internal configuration structure.
This article demonstrates how to automate e‑commerce test data creation by retrieving schema information with SQLAlchemy ORM, defining mapping classes, generating realistic data using Faker, and submitting it via HTTP requests with the Requests library, covering database interactions, data assembly, and API communication.
This article compiles a comprehensive guide to MyBatis, covering typical mistakes such as misuse of # vs $, handling of dates and null values, multi‑parameter strategies, XML escaping, dynamic SQL pitfalls, and a balanced list of its advantages and disadvantages for Java developers.
This article explains JDBC fundamentals, detailing its core interfaces such as Driver, Connection, Statement, PreparedStatement, and CallableStatement, outlines transaction isolation levels, common methods, ResultSet handling, and emphasizes the importance of mastering JDBC for effective use of Java ORM frameworks.
This article explains a rare MyBatis exception caused by a concurrency issue in OGNL expression evaluation, shows the stack trace, reproduces the bug with multithreaded test code, analyzes the root cause in method accessibility, and notes that upgrading to Ognl 2.7 or MyBatis 3.3.0 resolves the problem.
The article outlines several SQL injection vulnerabilities discovered in various Sequelize ORM versions, explains the underlying causes related to improper JSON path key handling for MySQL, MariaDB, Postgres, and SQLite, provides reproduction screenshots, and strongly advises upgrading to patched releases.
This article explains why using Laravel for web development saves time and effort by offering built‑in authentication, convention‑over‑configuration, powerful ORM, easy email handling, Artisan CLI, testing support, simple routing, and a vibrant community, making it a top PHP backend choice.
This article explains the differences between MyBatis resultType and resultMap, outlines their common points, and provides clear usage scenarios with examples and images to help Java developers choose the appropriate mapping strategy.
Learn how to replace fragile numeric status codes with clean enum handling in Java using MyBatis TypeHandler, explore built‑in handlers like EnumOrdinalTypeHandler and EnumTypeHandler, and create custom handlers for seamless database‑Java type conversion, complete with configuration tips and practical examples.
This article explores the challenges of building layered, flexible database queries in Go, compares GORM, sqlx, and squirrel, and proposes a custom, option‑based query‑builder pattern that stays idiomatic and extensible for complex search scenarios.
This article examines the contrasting popularity of MyBatis in China and Hibernate abroad, using Google Trends, Stack Overflow statistics, and industry anecdotes to reveal how cultural, managerial, and risk‑aversion factors shape Java ORM choices across regions.
This article walks through MyBatis' internal workflow—from parsing the global XML configuration and building the SqlSessionFactory, to creating a SqlSession, executing a query via the Executor, handling caching, and finally mapping results—illustrated with key code snippets and a diagram.
Discover the most common MyBatis pitfalls—from # vs $ usage, handling nulls, resultMap quirks, and dynamic SQL issues—to master safe query practices, optimize performance, and avoid runtime errors, while comparing its strengths and weaknesses against Hibernate for effective Java backend development.
This article explains why MyBatis may execute unexpected additional SQL statements, reveals the default caching behavior, shows the required XML configuration and Serializable implementation, and offers practical steps to prevent cache clearing on inserts for more efficient backend data access.
This tutorial walks you through configuring Django templates, static files, and MySQL database settings, then guides you step‑by‑step to create models, views, URLs, and templates for a complete library management system with publishers, books, and authors.
This article explains why Hibernate is used, defines ORM, shows how to view SQL logs, describes HQL/SQL/Criteria queries with code examples, discusses entity class design, caching layers, object states, session handling methods, and the requirement for a no‑argument constructor.
This tutorial walks you through creating a complete Django project, covering settings configuration for templates, static files, and middleware, MySQL database integration, model definitions for publishers, books, and authors, view functions for CRUD operations, and essential front‑end template snippets, all with ready‑to‑run code examples.
This article provides a step‑by‑step tutorial on using MyBatis3 annotation‑based CRUD, mapping, and provider annotations to replace XML configuration in a Spring Boot project, covering basic annotations, result mapping, dynamic SQL, Maven dependencies, configuration files, entity classes, database scripts, controller code, and testing procedures.
This guide compares Python MySQL libraries, focuses on using PyMySQL, and provides step‑by‑step instructions with screenshots for installation, importing, connecting, querying, inserting, batch inserting, and updating data in MySQL from Python.
This article introduces Laravel, a modern PHP framework, highlighting its MVC architecture, robust ORM, Blade templating, streamlined routing, controller organization, and built‑in authentication, while providing code examples to show how these features boost developer productivity.
This tutorial explains how to install Flask‑SQLAlchemy, configure a Flask app to connect to MySQL, define ORM models, perform queries, handle pagination, update records, and execute join queries, providing code examples and best‑practice tips for backend development.
This guide introduces Laravel's Eloquent ORM, explains its core concepts, and provides step‑by‑step code examples for retrieving, querying, and sorting records, helping developers harness the power of object‑relational mapping in PHP applications.
This tutorial walks you through creating a real‑world Django project, covering template, static, and middleware settings, switching to MySQL, defining models with one‑to‑many and many‑to‑many relationships, implementing CRUD views, configuring URLs, and building simple HTML templates with code examples and key configuration screenshots.
This article provides an in‑depth exploration of the Objective‑C runtime, covering the underlying object model, class and metaclass structures, the isa_t layout, how classes are loaded and initialized, dynamic loading mechanisms, and practical applications such as ORM and automatic NSCoding implementation.
This comprehensive guide introduces Django, outlines its key features, explains the standard project structure, walks through essential commands, demonstrates view and URL configuration, covers template syntax and tags, and details model creation, database operations, and form handling with both GET and POST methods.
This article explains why Laravel has become the most successful PHP framework by highlighting its modular architecture, micro‑service support, routing, middleware, caching, authentication, billing integration, task automation, encryption, event handling, pagination, ORM, testing, and queue features, all illustrated with clear code examples.
Discover a collection of ten practical Eloquent ORM techniques—including increment/decrement shortcuts, conditional method chaining, boot method customizations, advanced relationship queries, and the when() helper—that empower Laravel developers to write cleaner, more efficient database code and avoid common pitfalls.
This tutorial walks you through configuring Django templates, static files, middleware, and MySQL database settings, then defines models for publishers, books, and authors, implements CRUD views and URL routing, and creates the necessary front‑end templates to build a complete library management application.
This article provides an in‑depth tutorial on using Django's ORM, covering model creation, custom table names, single and composite indexes, one‑to‑many and many‑to‑many relationships, forward and reverse lookups, performance tuning with select_related and prefetch_related, and model validation techniques.
This article provides a comprehensive overview of Django, covering its MVC/MTV architecture, key features, project directory layout, essential configuration settings for databases and static files, and detailed routing examples with code snippets for creating and managing a Django web application.
This article introduces MyBatis as a lightweight persistence framework for Java, explains its history and core concepts, compares it with Hibernate, and provides a step‑by‑step guide with configuration files, entity classes, mapper interfaces, XML mappings, utility classes, and a test service to perform basic CRUD operations.
This article explains Laravel's Query Builder and Eloquent ORM, showing how to convert raw SQL into fluent builder methods, create database tables and models, and demonstrate practical querying techniques with nested conditions, aggregation, and result handling.
This article introduces core Java backend concepts such as reflection and annotations, explains ORM principles, and provides concise overviews of major frameworks—including Hibernate, MyBatis, Struts2, Spring, and Spring MVC—along with related tools like JUnit, SVN, and Maven.
This tutorial demystifies Python metaclasses by showing how the fundamental "Dao" concept maps to type, metaclass, class and instance, then walks through creating a dynamic ORM layer and a batch proxy‑crawling framework using those metaclasses.
This article outlines the core professional skills, project experience, development processes, tools, interview questions, and negotiation tips that Java developers need to master to succeed in job interviews and advance from junior to senior positions.
The article thoroughly examines MyBatis’s first‑level (session) and second‑level (namespace) caches, detailing their configurations, internal workflows, source‑code implementations, experimental behaviors, common pitfalls such as stale or dirty data, and advises disabling built‑in caching in favor of dedicated solutions for production.
The article introduces WCDB Swift, a pure‑Swift rewrite of Tencent's mobile database, detailing its model binding via Codable, language‑integrated queries, thread‑safe concurrency, encryption, full‑text search, and innovative use of Swift’s KeyPath and Mirror to achieve high performance and stability on iOS.
This article compares Hibernate and MyBatis across development speed, workload, SQL optimization, object management, and caching mechanisms, highlighting their respective strengths, weaknesses, and suitable project scenarios for Java backend development.
This article provides a comprehensive guide to Android's Room persistence library, covering the creation of Entity classes, defining Data Access Objects (DAO), building the RoomDatabase, handling foreign keys, embedded objects, query methods, LiveData and RxJava return types, as well as database migrations and type converters for complex data types.
This tutorial explores Python metaclasses, demonstrating how to create dynamic classes, implement a lightweight ORM using metaclasses, and build a flexible proxy crawler with multiple site support, all illustrated with clear code examples and step‑by‑step explanations.
This article explains the fundamentals of Object‑Relational Mapping (ORM) with a focus on Hibernate in Java, detailing the save and get execution flow, differences between get and load, object lifecycle states, first‑ and second‑level caching, and how pessimistic and optimistic locking address transaction concurrency issues.
This article explains how MySQL stores dates in UTC, why Sequelize returns UTC values despite a configured timezone, and demonstrates using custom getter methods (with moment) to automatically format DATE fields, including an advanced approach to apply the getter across multiple models.
This article walks through creating a Python blog website, covering project structure, HTTP workflow, ORM implementation, aiohttp web framework integration, and showcases the final UI screenshots, while reflecting on lessons learned and future learning needs.
This article outlines 25 critical areas—from object‑oriented design and core Java libraries to JVM internals, web frameworks, middleware, and project experience—that aspiring developers must master to become expert Java backend engineers, emphasizing both deep technical knowledge and practical project work.
This tutorial walks you through Django fundamentals, including its MTV architecture, project and app creation, URL routing, views, templates, static files, form handling, and database integration, enabling you to build a functional web service from scratch.
This tutorial walks through implementing one-to-one and one-to-many relationships in MyBatis, showing database tables, entity classes, XML mapping files, key configuration attributes, and test results with clear diagrams and code snippets.
This article examines WCDB’s design principles for efficient, complete, and easy-to-use client-side databases, explains the pitfalls of SQL string concatenation such as code redundancy, debugging difficulty, and injection attacks, and describes how WCDB’s WINQ abstraction and ORM layer safely encapsulate SQLite syntax to enable concise, compile-time-checked queries.
This article introduces WCDB, the official WeChat mobile database component, covering its architecture, ORM macros, WINQ integrated query, multithreaded high‑concurrency support, corruption repair, and advanced usage such as as‑redirection, chainable calls, and custom field binding for iOS/Mac development.
Learn the fundamentals of Object‑Relational Mapping (ORM) and how to use Python’s SQLAlchemy library to define models, initialize sessions, create tables, and perform CRUD operations, with clear examples and code snippets that illustrate switching databases and advanced query techniques.
koa‑restql automatically creates full RESTful CRUD endpoints from Sequelize models, mapping each database table to standard GET, POST, PUT, and DELETE routes, handling query filters, pagination, and associations via query strings, and offering middleware or association‑level options for access control, thus eliminating repetitive data‑operation code in Koa backends.
This article compares Ruby on Rails' ActiveRecord and Elixir's Ecto, explaining their mapping definitions, data retrieval, query syntax, write operations, validations, callbacks, and associations, while highlighting the trade‑offs between the convenience of ActiveRecord and the explicitness of Ecto.
This article explains the concept of database transactions, their ACID properties, and provides a step‑by‑step Node.js example using the Bookshelf.js ORM to safely perform multi‑table operations within a transaction.
The article presents the design and implementation of Albianj, a Java‑based distributed development framework that emphasizes consistency, scalability, and data routing to handle massive real‑time data across hundreds of servers, detailing its architecture, kernel, IoC, DataRouter, ORM, and distributed transaction mechanisms.
The article examines the increasing storage bottleneck in large-scale web systems, explains vertical and horizontal database sharding, discusses the technical difficulties they introduce—including join rewrites, transaction handling, and ORM integration—and proposes practical approaches to minimize service impact and manage distributed transactions.
The article explains the concepts of vertical and horizontal database splitting, compares their technical difficulties, discusses the impact on joins and transactions, and proposes practical approaches such as careful SQL refactoring, ORM decoupling, and selective use of distributed‑transaction techniques to maintain system stability and scalability.
This article examines the challenges of lazy loading in J2EE ORM tools, compares eager fetching and pre-fetching, and proposes a modular solution using Aspect‑Oriented Programming to inject custom fetching strategies at the repository level, reducing SQL queries, connection usage, and code bloat.
