TryGhost/node-sqlite3

Features

• Embedded Databases - Implements a lightweight relational database engine that runs directly within the application process.
• SQL Query Execution - Provides a native Node.js interface for running SQL queries and retrieving structured data from SQLite.
• Local File Storage - Persists application state and user data directly to local disk storage using SQLite files.
• Database Connection Management - Creates and manages connections to SQLite database files or in-memory stores.
• Single Row Fetches - Retrieves the first matching record from a query result as a single JavaScript object.
• All-Record Retrievers - Retrieves all matching records from a query result and returns them as a complete array.
• Relational Data Stores - Provides a relational database client for executing SQL queries against local or in-memory stores.
• Statement Executions - Executes SQL statements such as INSERT or UPDATE that modify data without returning result rows.
• SQLite3 Node.js Drivers - Provides native bindings to enable Node.js applications to interact with SQLite databases.
• Node.js Database Integration - Connects Node.js applications to SQLite databases for structured data storage and retrieval.
• Node.js Native Addons - Links JavaScript to the SQLite C library as a C++ native addon for direct memory access.
• Parameter Bindings - Maps JavaScript types to SQLite C types to prevent SQL injection and handle binary blobs securely.
• Query Optimization - Optimizes database interactions using prepared statements and streamed results to handle large datasets efficiently.
• Local Database Security - Implements page-level encryption for local database files by integrating SQLCipher.
• Prepared Statements - Compiles a query once to be reused multiple times with different parameters for faster execution.
• Compilation Caches - Pre-compiles SQL strings into bytecode within the engine to reduce parsing overhead during repeated executions.
• Result Streaming - Iterates through result rows one by one via a callback to handle large datasets without memory exhaustion.
• Row-Based Result Streaming - Processes large query result sets one row at a time via an iterator to minimize memory consumption.
• SQLCipher-Based Encryptions - Integrates with SQLCipher to provide transparent page-level encryption for local database files.
• Database Page Encryption - Provides transparent page-level encryption for database files through optional SQLCipher linking.

Star history