drizzle-sqlite

v0.1.0curated

Complete SQLite data layer with Drizzle ORM — schema, migrations, UUID v7 keys, audit fields, naming conventions, environment separation.

database:sqliteorm:drizzlelanguage:typescript
archgate adr import packs/drizzle-sqlite

Decisions (7)

SQLite as Embedded Database

Applications that need a lightweight, embedded database must choose a technology that impacts deployment complexity, data portability, user privacy, and application architecture.

1 rule
Drizzle ORM for Schema and Data Access

Applications need a clear, maintainable way to define data models and access the database from TypeScript code.

1 rule
Schema Migrations with Drizzle Kit

As applications evolve, database schemas must change to support new features, fix issues, or optimize performance.

1 rule
UUID v7 Primary Keys

Traditional auto-incrementing integer primary keys require the database to generate the next sequential ID, which only works when connected to the database.

1 rule
Audit Fields (created_at and updated_at)

Understanding when records were created and last modified is essential for debugging, data analysis, user experience (e.g., "last updated 5 minutes ago"), and synchronization in offline-first appli...

1 rule
Field Naming Convention

When working with Drizzle ORM and TypeScript, there is a fundamental naming mismatch between language conventions.

1 rule
Database Environment Separation

SQLite databases are stored as single files on the filesystem.

1 rule