Awesome GitHub RepositoriesBatch Statement Execution

This project is a pure JavaScript database driver for Node.js that implements the native MySQL binary protocol. It serves as a comprehensive connector for managing persistent network links to MySQL servers, enabling applications to execute queries, manage transactions, and handle complex data operations without requiring external middleware. The driver distinguishes itself through its integrated support for connection pooling and distributed database routing. It maintains managed sets of reusable network sockets to optimize resource usage under high request volumes, while simultaneously provi

node-sqlite3 is a relational database client and a set of native bindings that allow Node.js applications to interact with SQLite databases. It functions as a C++ native addon, linking JavaScript to the SQLite C library to manage data stored in local files or in-memory stores. The project includes optional support for SQLCipher, enabling page-level encryption to secure local database files. The driver covers a wide range of database management capabilities, including executing SQL queries with parameter binding, managing connections to database files, and preparing statements for repeated ex

Sqlpad 是一个基于 Web 的 SQL 客户端与多租户工作台，用于在多个关系型及分析型数据库中编写、执行和保存查询。它作为 ODBC 数据库管理器，使用户能够通过浏览器界面管理数据库连接并探索架构。 该平台作为一个协作环境脱颖而出，用户可以在此共享 SQL 文档并协调数据分析。它集成了通过 OpenID Connect、SAML、LDAP 和 OAuth 实现的身份联合认证，并提供了一个将查询结果渲染为图表与表格的可视化系统。 该系统涵盖了广泛的能力领域，包括用于限制数据库连接的基于角色的访问控制（RBAC）、用于多语句事务的状态化会话管理，以及用于增强安全性的运行时凭据替换。它还提供查询持久化与历史记录追踪，以管理已保存 SQL 语句的生命周期。

ActiveRecord Import 是一个用于通过单条或批量查询将大型数据集插入数据库的库。它作为一个批量数据导入器和 SQL 批量插入工具，旨在最大限度地减少查询开销并提高写入性能。 该项目包含一个 Upsert 引擎，通过更新现有记录或忽略重复项来处理唯一约束冲突。它还具有递归关联导入器，允许在单次操作中插入父记录及其嵌套的子关联。 该库提供了一个预插入验证层，用于在提交数据前验证记录有效性并报告失败。它通过将数据集拆分为批次来管理大规模数据迁移，以控制内存使用并避免数据库包大小限制。 该工具提供包含成功计数和记录标识符的结果摘要，以及用于数据批次的进度跟踪。

Kùzu is an embedded property graph database engine designed for high-performance analytical queries and local data management. It operates as a library within the host application process, utilizing a columnar-based storage architecture and just-in-time query compilation to execute complex graph traversals and pattern matching efficiently. By mapping database files directly into system memory, it ensures data durability and high-speed access while maintaining ACID-compliant transactional integrity. The engine distinguishes itself by integrating vector similarity search and full-text search di

This project is a PHP library designed for parsing, beautifying, and syntax-highlighting SQL queries. It provides a set of utilities to improve the readability of database code, facilitate debugging, and assist in the maintenance of complex query structures. The library distinguishes itself by offering both aesthetic and functional processing capabilities. It can transform raw SQL strings into structured, indented formats for human review, or compress them by removing comments and unnecessary whitespace to optimize them for network transmission and logging. Additionally, it includes a syntax