Skip to main content

4 docs tagged with "sqlite hcl schema"

View all tags

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 Schema

Comprehensive reference for defining SQLite schemas using Atlas HCL. Learn about supported blocks, attributes, and examples for schemas, tables, columns, triggers, indexes, and views in SQLite with Atlas.