The article questions whether dedicated vector databases are truly needed for AI applications, examining market hype, the rapid emergence of many vector‑DB products, real‑world examples like PostgreSQL pgvector and major vendor integrations, and the hidden costs of data fragmentation and operational complexity.
The Go team introduced a new uuid package to the standard library, offering lightweight functions for generating, parsing, serializing, and comparing UUID version 4 and version 7 values, integrating with database/sql, using a [16]byte type compatible with google/uuid, and providing detailed design rationale, implementation details, and a comparison with the existing third‑party library.
The article introduces the open‑source DBSyncer middleware that enables full‑stack data synchronization across MySQL, Oracle, SQL Server, PostgreSQL, Elasticsearch and Kafka, outlines its visual composition, full‑ and incremental sync, real‑time monitoring, and provides step‑by‑step installation instructions while also mentioning related Java learning projects.
This article provides a comprehensive technical overview of the Model Context Protocol (MCP), an open‑standard JSON‑RPC 2.0 protocol that enables large language models to securely interact with external data sources, tools, and services, detailing its design, architecture, Python SDK implementation, transport mechanisms, and real‑world deployment examples such as the DW‑DBA‑MCP project.
This article explains why synchronizing MySQL with Elasticsearch is beneficial and compares five practical solutions—dual‑write, scheduled tasks, binlog, Canal, and MQ asynchronous—detailing their implementation, advantages, disadvantages, and suitable scenarios for each.
This article explains how to use standard SQL on PolarDB PostgreSQL to directly invoke multimodal AI services for image feature extraction and vectorization, eliminating data migration and complex toolchains while providing low‑threshold integration, flexible scenario adaptation, full‑link security, and serverless, pay‑as‑you‑go deployment.
This article demonstrates how to integrate SQL database interactions into Locust, a performance testing framework, using Python's mysql-connector-python library to execute read/write operations, enabling data validation and test data retrieval within load testing scenarios.
This tutorial explains how to overcome the limitations of Retrieval‑Augmented Generation by using the Model Context Protocol (MCP) together with a MongoDB database, providing detailed setup steps, configuration examples, and performance comparisons that demonstrate significantly higher query precision for large language models.
The article traces the evolution of embedding technology from a secret weapon of tech giants to a mainstream developer tool, explains the rapid rise and subsequent integration of vector databases into traditional search engines, and argues that vector databases are essentially search engines with added vector capabilities.
This article explains how to integrate Spring Boot with MyBatis, configure a single Druid data source, implement a dynamic routing data source for multiple databases, and use custom annotations and AOP to switch databases at runtime, including full code examples and transaction management.
This article explores how PostgreSQL’s advanced features—UNLOGGED tables, JSONB, SKIP LOCKED, TimescaleDB, pg_cron, PostGIS, full‑text search, JSON generation, pgaudit, and GraphQL adapters—can replace specialized tools like Kafka, Redis, MongoDB, and others, simplifying the tech stack while boosting performance and maintainability.
This guide walks you through installing Webman on ServBay, configuring routes, controllers, and multiple databases, then running the project to demonstrate high‑concurrency PHP web applications with real‑time API endpoints.
This guide explains how to enable Dameng database support in Nacos 2.3.2 by adding a custom SPI plugin, configuring connection properties, and optionally building the integration from source, complete with migration scripts, driver setup, and sample configuration files.
esProc SPL, a pure‑Java, lightweight data‑processing engine, offers richer data source support, built‑in flow control, and easier complex calculations compared to SQLite, making it a powerful alternative for small applications that need database‑like capabilities without the overhead of traditional databases.
This tutorial walks you through adding MongoDB dependencies to a Spring Boot project, configuring the connection, defining entity and repository classes, implementing service and controller layers, and optionally setting up sharding or replica‑set architectures for scalable data management.
This article walks through setting up a Starwift cloud‑native data warehouse on JD Cloud, configuring network access, installing the ClickHouse client on macOS, and demonstrates both TCP and HTTP Rust integrations with example code, while noting common dependency conflicts.
Apache Superset is a modern, enterprise‑ready open‑source business intelligence web application that offers rich data visualizations, an easy‑to‑use interface, dashboard sharing, robust security, a semantic layer, and integration with a wide range of relational and analytical databases.
The article examines the strengths and weaknesses of combining HBase and Elasticsearch for massive data storage and retrieval, outlines three integration patterns and their challenges, and presents Alibaba Cloud's Lindorm Searchindex as a SQL‑driven, low‑cost, strongly consistent solution that simplifies development and improves performance.
This article examines the complementary strengths of HBase and Elasticsearch, outlines three integration patterns and their associated challenges, and introduces Alibaba Cloud's Lindorm Searchindex as a SQL‑driven, low‑cost solution that simplifies storage and full‑text search for massive data workloads.
This tutorial walks you through upgrading Spring Boot, introduces MongoDB basics, and provides a hands‑by‑step guide to adding the spring‑boot‑starter‑data‑mongodb dependency, defining entity and repository classes, writing unit tests, and configuring connection properties for robust backend data management.
This article introduces how backend developers can leverage PyCharm Professional’s integrated Database tool and HTTP Client to manage databases and test RESTful APIs directly within the IDE, eliminating the need for separate tools like Navicat and Postman.
This tutorial walks through integrating MongoDB into a Spring Boot mall project, covering installation, configuration, Spring Data MongoDB usage, defining document and repository classes, implementing service and controller layers, and testing CRUD operations for product browsing records.
A SQL Server 2005 linked server to an Oracle database throws error 9803 for a numeric(19,4) column, with values ≥10 showing inconsistent failures, and the issue is resolved by installing the Oracle 11g client on the SQL Server host.
