Skip to main content

7 docs tagged with "sqlite"

View all tags

Database Guides

All common open-source relational database management systems are supported in all versions of Atlas.

Descending Indexes in SQLite

What descending indexes are in SQLite, when an ORDER BY DESC query benefits, and how to declare one in an Atlas HCL schema and apply it to the database.

Functional Indexes in SQLite

Learn how to create functional (expression) indexes in SQLite to speed up case-insensitive searches and queries on computed values, and how to manage them in schema migrations with Atlas.

Partial Indexes in SQLite

What partial indexes are in SQLite, when they beat a full index, and how to declare one in an Atlas HCL schema so Atlas plans the migration for you.

SQLite Migrations with Declarative HCL in Atlas

Learn how to manage SQLite migrations and schemas using Atlas and declarative HCL. This step-by-step guide covers inspecting, editing, and applying schema changes for efficient SQLite schema management

SQLite Migrations with Declarative SQL in Atlas

Learn how to manage SQLite migrations and schemas using Atlas with declarative SQL. This step-by-step guide covers inspecting, editing, and applying schema changes for efficient SQLite schema management.

Turso Schema Migrations with Atlas

Manage Turso and libSQL database schemas with Atlas. Connect over libsql://, apply a declarative HCL schema to an edge database, and inspect the result.