3 个仓库
Mechanisms for pre-compiling and executing repetitive database queries.
Distinguishing note: Focuses on performance optimization via pre-compilation.
Explore 3 awesome GitHub repositories matching data & databases · Prepared Statement Interfaces. Refine with filters or upvote what's useful.
DuckDB is an in-process analytical database engine designed to run directly within an application process. As a zero-dependency, embedded system, it provides enterprise-grade SQL data processing capabilities without the overhead of managing a dedicated database server. It is built to handle complex analytical and aggregation tasks by storing and retrieving information in columns, allowing for high-performance relational data manipulation. The engine distinguishes itself through a columnar vectorized execution model that maximizes CPU cache efficiency during query operations. It employs adapti
Allows the execution of pre-compiled SQL statements to improve performance for repetitive queries.
asyncpg is an asynchronous database driver and binary protocol client for PostgreSQL. It provides a non-blocking interface for executing SQL statements, streaming result sets, and managing data transfer between an application and a PostgreSQL database. The driver implements the PostgreSQL binary protocol directly to facilitate efficient data transfer and type conversion. It includes a connection pool to maintain and reuse open database connections, reducing the latency associated with repeated handshakes. The project covers a broad range of database integration capabilities, including atomic
Supports server-side prepared statements to pre-compile queries and improve execution speed.
该项目是一个仅包含头文件的 C++ 库,为 SQLite 数据库提供了对象关系映射(ORM)层。它使开发者能够将原生类结构直接映射到数据库表,从而促进类型安全的数据持久化和检索,而无需原始查询字符串。 该库的特色在于使用基于模板的元编程,允许编译时模式映射和查询构建。通过利用流式接口,它将方法调用转换为优化的数据库语句,同时其对预编译语句缓存的支持最大限度地减少了重复操作的解析开销。该系统还包括自动模式同步,以确保数据库结构与应用对象定义保持一致。 除了核心映射外,该库还提供了一套全面的数据库管理功能,包括对关系连接、聚合数据计算和原子事务管理的支持。它同时适应持久化存储和易失性的内存数据库配置。此外还提供了一个命令行实用程序,通过将源文件和头文件合并为合并输出来协助项目分发。
Executes strongly-typed, pre-compiled database statements to improve performance and security.