WiseLibs/better-sqlite3
Better Sqlite3
better-sqlite3 is a high-performance SQLite3 client for Node.js that executes queries synchronously, returning results directly without callbacks or promises. It compiles as a native addon using N-API, binding directly to the SQLite3 C library for immediate query execution and zero-copy result serialization into native JavaScript objects.
The library is optimized for Write-Ahead Logging (WAL) mode, enabling faster concurrent reads and writes in web applications. It provides durability level tuning through the synchronous pragma, allowing adjustments between FULL, NORMAL, and OFF modes to balance write performance against crash safety. The library also includes checkpoint starvation prevention, monitoring WAL file growth and triggering forced checkpoints to prevent unbounded disk usage during high-write workloads.
The project handles multi-gigabyte databases efficiently with proper indexing and joins, and its synchronous API eliminates callback overhead and promise wrappers for straightforward query execution.
Features
- Synchronous SQL Executions - Runs SQL statements synchronously in Node.js and returns results directly without callbacks or promises.
- Synchronous - Binds directly to the SQLite3 C library using synchronous calls for immediate query execution.
- SQLite Write Optimizations - Improves read and write performance for concurrent database access by enabling Write-Ahead Logging.
- Synchronous - A Node.js database driver that runs SQLite3 queries synchronously, returning results inline without async patterns.
- WAL Mode Enabling - Switches the database to Write-Ahead Logging for dramatically faster concurrent reads and writes.
- SQLite3 Clients - A high-speed SQLite3 client for Node.js that handles multi-gigabyte databases with efficient indexing and joins.
- Synchronous SQLite3 Executions - Runs SQL queries in Node.js with synchronous execution, returning results directly without callbacks or promises.
- Node.js Bindings - The fastest synchronous SQLite3 library for Node.js, executing queries directly without callbacks or promises.
- WAL Mode Database Libraries - Provides a SQLite3 library optimized for Write-Ahead Logging, enabling faster concurrent reads and writes.
- SQLite WAL Integrations - Enables Write-Ahead Logging through direct pragma configuration for concurrent reads and writes.
- Node.js Native Addons - Compiles as a Node.js native addon using N-API for direct C-level access to SQLite3.
- Large Data Volume Handling - Processes queries efficiently on multi-gigabyte databases using proper indexing and joins.
- WAL Checkpointing - Monitors and forces WAL file checkpoints to prevent unbounded disk usage in long-running applications.
- Starvation Prevention - Monitors WAL file growth and forces checkpoints to prevent unbounded disk usage during high-write workloads.
- Database Performance Utilities - Processes queries efficiently on multi-gigabyte SQLite3 databases with proper indexing and joins.
- Zero-Copy - Returns query results as native JavaScript objects without intermediate copying using direct memory access.
- Transaction Durability Relaxations - Trades write performance for guaranteed durability by setting the synchronous pragma to FULL in WAL mode.
- SQLite Durability Tunings - Adjusts write durability levels by setting synchronous pragmas to balance performance and data safety.
- Durability Level Adjustments - Adjusts synchronous pragma settings to balance write performance against crash safety in WAL mode.
