better-sqlite3-patterns

What problem does it solve?

This Skill simplifies and standardizes the use of the better-sqlite3 library in Node.js applications, providing clear patterns for common database operations.

Core Features & Use Cases

• Database Connection & Configuration: Establish secure and efficient connections to SQLite databases, including in-memory options and performance tuning.
• Prepared Statements: Efficiently execute queries with parameter binding and leverage advanced statement methods like pluck and raw.
• Transactions: Manage atomic database operations with helper functions and different transaction modes (deferred, immediate, exclusive).
• User-Defined Functions: Extend SQLite's capabilities by creating custom scalar, aggregate, and table-valued functions in JavaScript.
• Backup & Restore: Implement online backup and serialization/deserialization for database persistence.
• Type Safety: Utilize TypeScript interfaces and the repository pattern for robust and maintainable data access.
• Error Handling: Gracefully manage SQLite errors and check database states.

Quick Start

Use the better-sqlite3-patterns skill to create a new SQLite database connection in memory.