Implements high-performance database patterns using the better-sqlite3 library for Node.js applications.
This skill provides a comprehensive set of implementation patterns and best practices for the better-sqlite3 library, the fastest SQLite wrapper for Node.js. It equips Claude with the technical knowledge to configure performance-optimized database connections, manage type-safe prepared statements, and handle complex transaction logic including nested and immediate modes. Whether you are building a local-first application, a high-performance backend, or a CLI tool, this skill ensures your data layer follows industry-standard patterns for reliability and speed.
Características Principales
01Optimized database initialization with WAL mode and performance PRAGMAs
02Advanced transaction management including nested and exclusive locking modes
036 GitHub stars
04Standardized Repository Pattern implementation for clean data access layers
05Type-safe prepared statements with positional and named parameter binding
06User-defined functions for custom scalar, aggregate, and table-valued logic
Casos de Uso
01Managing online database backups and serialization without stopping the application
02Building high-performance local data storage for Node.js desktop or CLI applications
03Implementing a type-safe SQL data access layer in a TypeScript backend service
