{"library":"sqlite3orm","type":"library","category":null,"description":"ORM library for SQLite3 in TypeScript/JavaScript (v3.0.0). Uses ES decorators (@table, @id, @field) to map classes to database tables with automatic schema creation, connection pooling, and online backups. Provides type-safe queries with a filter syntax that eliminates SQL injection risks. Released under MIT, maintained with regular updates. Key differentiator: full control over schema naming, support for temporary tables, and partial model mapping. Also offers automatic upgrades and integration with NestJS via companion package @homeofthings/nestjs-sqlite3.","language":"javascript","status":"active","version":"3.0.0","tags":["javascript","typescript","sqlite","sqlite3","sqlcipher","ORM","DAO","schema"],"last_verified":"Thu Jun 04","install":[{"cmd":"npm install sqlite3orm","imports":["import { SqlDatabase } from 'sqlite3orm';","import { schema } from 'sqlite3orm';","import { table } from 'sqlite3orm';"]},{"cmd":"yarn add sqlite3orm","imports":[]},{"cmd":"pnpm add sqlite3orm","imports":[]}],"homepage":"https://github.com/gms1/HomeOfThings","github":"https://github.com/gms1/HomeOfThings","docs":null,"changelog":null,"pypi":null,"npm":"sqlite3orm","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}