WiseLibs/better-sqlite3

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.

Star history