trilogy

A simple Promise-based SQLite layer for TypeScript and JavaScript, supporting both native C++ (sqlite3) and pure JavaScript (sql.js) backends. Version 2.0.5 is the latest stable release. Key differentiators include automatic type casting between JS and SQLite types, swappable backends without code changes, lifecycle hooks, and first-class TypeScript support. It is not an ORM; instead it provides a Mongoose-inspired API for schema-defined models with query building via knex. Suitable for Node.js and Electron environments.