awesome-repositories.com
Blog
MCP
awesome-repositories.com

Discover the best open-source repositories with AI-powered search.

ExploreCurated searchesOpen-source alternativesSelf-hosted softwareBlogSitemap
ProjectMCP serverAboutHow we rankPress
LegalPrivacyTerms
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
WiseLibs avatar

WiseLibs/better-sqlite3

0
View on GitHub↗

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.

AI search

Explore more awesome repositories

Describe what you need in plain English — the AI ranks thousands of curated open-source projects by relevance.

Start searching with AI

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.
7,311 stars·465 forks·JavaScript·MIT·41 views

Star history

Star history chart for wiselibs/better-sqlite3Star history chart for wiselibs/better-sqlite3

How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.

Frequently asked questions

What does wiselibs/better-sqlite3 do?

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.

What are the main features of wiselibs/better-sqlite3?

The main features of wiselibs/better-sqlite3 are: Synchronous SQL Executions, Synchronous, SQLite Write Optimizations, WAL Mode Enabling, SQLite3 Clients, Synchronous SQLite3 Executions, Node.js Bindings, WAL Mode Database Libraries.

Which projects share features with wiselibs/better-sqlite3?

Projects with overlapping indexed features include: nodejs/node-addon-api — This project provides a header-only C++ wrapper for the Node-API, serving as a framework for building high-performance… nodejs/nan — This project is a compatibility layer and abstraction library for building native C++ addons for Node.js. It provides… napi-rs/napi-rs — napi-rs is a framework and toolkit for building high-performance native extensions for Node.js using Rust. It… kelektiv/node.bcrypt.js — This is a bcrypt password hashing library and cryptography module for Node.js. It provides a toolset for generating… justadudewhohacks/opencv4nodejs — opencv4nodejs is a set of JavaScript wrappers and a C++ native addon that provides Node.js bindings for the OpenCV… automattic/node-canvas — node-canvas is a server-side 2D vector graphics and image processing library for Node.js. It provides a server-side…

Projects sharing features with Better Sqlite3

These projects share indexed features with Better Sqlite3. Shared tags can include platform or build tooling; verify the primary use case before treating a result as a replacement.
  • nodejs/nannodejs avatar

    nodejs/nan

    3,351View on GitHub↗

    This project is a compatibility layer and abstraction library for building native C++ addons for Node.js. It provides a consistent C++ API that allows a single codebase to compile against multiple versions of the V8 JavaScript engine by hiding version-specific differences behind macros and inline functions. The toolkit differentiates itself through specialized wrappers and managers, including a monadic wrapper for handles to avoid explicit null checks, a persistent reference manager for objects that must survive handle scope disposal, and a buffer abstraction API for version-compatible memory

    C++nodenodejs
    View on GitHub↗3,351
  • nodejs/node-addon-apinodejs avatar

    nodejs/node-addon-api

    2,400View on GitHub↗

    This project provides a header-only C++ wrapper for the Node-API, serving as a framework for building high-performance native addons for Node.js. It acts as a bridge between C++ and JavaScript, offering an object-oriented interface that simplifies the creation of compiled extensions while managing the complexities of the language boundary. The library distinguishes itself by providing type-safe abstractions for data marshalling and memory management, ensuring that native and script-side objects are tracked and reclaimed correctly. It includes mechanisms for coordinating asynchronous tasks bet

    C++nodenodejs
    View on GitHub↗2,400
  • napi-rs/napi-rsnapi-rs avatar

    napi-rs/napi-rs

    7,500View on GitHub↗

    napi-rs is a framework and toolkit for building high-performance native extensions for Node.js using Rust. It functions as a bridge between Rust and JavaScript runtimes, enabling the conversion of data types and the execution of native functions within a JavaScript environment. The project provides a native binary compiler and a cross-platform module orchestrator to automate the compilation and publishing of packages across multiple operating systems and architectures. It generates corresponding JavaScript type definitions and platform-specific binaries to ensure consistent installation. The

    Rustjavascriptnapinapi-rs
    View on GitHub↗7,500
  • automattic/node-canvasA

    Automattic/node-canvas

    10,676View on GitHub↗

    node-canvas is a server-side 2D vector graphics and image processing library for Node.js. It provides a server-side implementation of the HTML5 Canvas API using the Cairo graphics library as its rendering engine to draw shapes, text, and paths. The library enables the programmatic generation of dynamic images and the creation of scalable vector graphics and PDF documents. It supports the registration of custom and system fonts for typography rendering and allows for the import of image assets via local paths, buffers, data URIs, and remote URLs. Capabilities include low-level pixel manipulat

    JavaScript
    View on GitHub↗10,676
Compare all 30 related projects→