Tagged articles
Database Access
12 articles · Page 1 of 1
The article breaks down four ways a Data Agent can reach enterprise data—direct database connections, business APIs, data‑warehouse layers, and knowledge‑base/RAG—detailing their strengths, limitations, and how combining them with stable integration pipelines enables reliable AI‑driven analytics and actions.
API IntegrationData AgentDatabase Access
0 likes · 20 min read

This article compares Spring Data JDBC and Spring Data R2DBC for Spring Boot 3.x/4.x projects, detailing setup, Maven dependencies, configuration, entity definitions, repository and service implementations, transaction handling, performance trade‑offs, and provides a hybrid approach that wraps JDBC calls in reactive Monos for WebFlux, helping developers decide which persistence layer best fits their reactive architecture.
Database AccessJDBCR2DBC
0 likes · 22 min read

The article explains why MyBatis can execute database queries without concrete method implementations by using JDK dynamic proxies, detailing the roles of MapperProxy, MapperMethod, SqlSession and Executor, and walks through the four‑step process from proxy creation to result mapping.
Database AccessJavaMapperProxy
0 likes · 27 min read

This article explains the fundamentals of intelligent DNS, its resolution process and strategy algorithms, evaluates its advantages and drawbacks, and critically examines whether using intelligent DNS for database access in dual‑active architectures is appropriate, highlighting potential pitfalls and recommended practices.
Database AccessDual-Active ArchitectureIntelligent DNS
0 likes · 16 min read

Although IO multiplexing can boost performance, most Java applications continue to use connection pools like c3p0 or Tomcat because JDBC is blocking, DB protocols require multiple sessions, and integrating NIO drivers into existing web containers adds significant complexity and ecosystem constraints.
Database AccessIO MultiplexingJDBC
0 likes · 9 min read

Learn how to install MariaDB on Windows, test local connections with Navicat, set up cpolar to create a TCP tunnel, obtain a public address, and configure a fixed TCP port for stable remote access to your MariaDB database from anywhere.
Database AccessMariaDBNavicat
0 likes · 7 min read

This guide explains how to set up Spring Data R2DBC with Spring Boot, covering driver selection, dependency configuration, application properties, entity definitions, CRUD services, controllers, repository usage, and optimistic locking for reactive relational database interactions.
Database AccessReactive ProgrammingSpring Boot
0 likes · 9 min read

This article walks through the step‑by‑step evolution from raw JDBC queries to the MyBatis persistence layer, highlighting why JDBC should be wrapped, the design improvements MyBatis introduces, core components, execution flow, initialization mechanisms, and related design patterns, all illustrated with code snippets and diagrams.
Database AccessJDBCJava Persistence
0 likes · 37 min read

This article introduces the Java Persistence API (JPA), explains why Spring Data JPA has become an essential skill for large companies, outlines its benefits for development efficiency and career growth, and recommends the comprehensive book “Spring Data JPA: From Basics to Advanced” with its detailed structure and practical examples.
Database AccessJavaJava Persistence API
0 likes · 27 min read

The BeetlSQL 3.1.5 update resolves two persistent bugs related to @Version and @LogicDelete annotations, provides the Maven dependency snippet, and outlines its broad support for traditional databases, big‑data stores, IoT time‑series databases, SQL query engines, and in‑memory databases.
BeetlSQLDatabase AccessJava
0 likes · 2 min read

BeetlSQL provides a unified, high‑performance database access framework supporting traditional, big‑data, and time‑series databases, outlines its Maven dependency, and presents detailed M3‑phase performance benchmarks across various query methods and ORM tools.
BeetlSQLDatabase AccessMaven
0 likes · 6 min read

Ctrip DAL is an open‑source, multi‑language database access framework that supports sharding, code generation, and cross‑team management, enabling large‑scale enterprises to protect existing investments while rapidly scaling their data layer across MySQL and SQL Server.
C++CtripDAL
0 likes · 4 min read
