# quackdb v0.7.0 - Table of Contents

> DuckDB for Elixir: supervised server, DBConnection client, and Ecto adapter

## Pages

- [QuackDB 🦆](readme.md)
- [Contributing](contributing.md)

- Guides
  - [Getting started](getting-started.md)
  - [Ecto](ecto.md)
  - [Writes](writes.md)
  - [Observability](observability.md)
  - [Type support](type-support.md)
  - [Examples](examples.md)
  - [Managed DuckDB binary](managed-duckdb.md)
  - [Explorer and Table.Reader](explorer.md)
  - [Sources, extensions, and secrets](sources.md)
  - [Snapshots and Time Travel](snapshots.md)
  - [Spatial](spatial.md)
  - [Full-text search](full-text-search.md)
  - [Telemetry](telemetry.md)

- Reference
  - [Quack protocol coverage](coverage.md)
  - [Protocol fixtures](fixtures.md)
  - [Ecto coverage](ecto-analytical-coverage.md)

## Modules

- [Ecto.Adapters.QuackDB](Ecto.Adapters.QuackDB.md): Minimal Ecto SQL adapter for QuackDB.
- [Ecto.Adapters.QuackDB.Connection](Ecto.Adapters.QuackDB.Connection.md): Ecto SQL connection callbacks backed by the QuackDB DBConnection driver.
- [Ecto.Adapters.QuackDB.Query](Ecto.Adapters.QuackDB.Query.md): Read-oriented Ecto query SQL generation for QuackDB.
- [QuackDB](QuackDB.md): DuckDB for Elixir applications: the DBConnection client.
- [QuackDB.Analytics](QuackDB.Analytics.md): Direct SQL helpers for DuckDB analytical statements.

- [QuackDB.Binary](QuackDB.Binary.md): Downloads and locates a DuckDB executable for local `QuackDB.Server` usage.
- [QuackDB.Columns](QuackDB.Columns.md): Column-oriented query result.
- [QuackDB.Cursor](QuackDB.Cursor.md): Cursor metadata used by `DBConnection` streaming.
- [QuackDB.DDL](QuackDB.DDL.md): Small DuckDB DDL SQL builders.
- [QuackDB.DDL.Check](QuackDB.DDL.Check.md): An inline CHECK constraint built by `QuackDB.DDL.check/1`.
- [QuackDB.DML](QuackDB.DML.md): Small DuckDB DML SQL builders.
- [QuackDB.DuckLake](QuackDB.DuckLake.md): SQL builders for DuckLake catalogs: listing snapshots, reading the rows that
changed between them, tagging commits, and expiring old snapshots.
- [QuackDB.Ecto](QuackDB.Ecto.md): Convenience imports for Ecto-based QuackDB query modules.
- [QuackDB.Ecto.Analytics](QuackDB.Ecto.Analytics.md): DuckDB analytical expression helpers for Ecto queries.
- [QuackDB.Ecto.Conditionals](QuackDB.Ecto.Conditionals.md): Conditional expression helpers for Ecto analytical queries.
- [QuackDB.Ecto.Decimal](QuackDB.Ecto.Decimal.md): An Ecto decimal type retaining DuckDB cast precision and scale.
- [QuackDB.Ecto.FTS](QuackDB.Ecto.FTS.md): DuckDB full-text search expression helpers for Ecto queries.
- [QuackDB.Ecto.List](QuackDB.Ecto.List.md): DuckDB LIST/ARRAY expression helpers for Ecto queries.
- [QuackDB.Ecto.Map](QuackDB.Ecto.Map.md): DuckDB MAP expression helpers for Ecto queries.
- [QuackDB.Ecto.Regex](QuackDB.Ecto.Regex.md): DuckDB regular-expression helpers for Ecto queries.
- [QuackDB.Ecto.Series](QuackDB.Ecto.Series.md): Ecto source helpers for DuckDB `generate_series` table functions.
- [QuackDB.Ecto.Snapshot](QuackDB.Ecto.Snapshot.md): Reads Delta, DuckLake, and Iceberg tables as they were at an earlier
snapshot, through DuckDB's `AT (VERSION => ...)` and `AT (TIMESTAMP => ...)`
clauses.
- [QuackDB.Ecto.Spatial](QuackDB.Ecto.Spatial.md): DuckDB spatial expression helpers for Ecto queries.
- [QuackDB.Ecto.Star](QuackDB.Ecto.Star.md): DuckDB star and `COLUMNS(...)` expression macros for Ecto SQL generation.
- [QuackDB.Ecto.Struct](QuackDB.Ecto.Struct.md): DuckDB STRUCT expression helpers for Ecto queries.
- [QuackDB.Ecto.Text](QuackDB.Ecto.Text.md): DuckDB text-expression helpers for Ecto queries.
- [QuackDB.Ecto.Variant](QuackDB.Ecto.Variant.md): DuckDB 2.0 `VARIANT` expression helpers for Ecto queries.
- [QuackDB.Ecto.WindowFrames](QuackDB.Ecto.WindowFrames.md): DuckDB window-frame helpers for Ecto queries.
- [QuackDB.Explorer](QuackDB.Explorer.md): Optional Explorer integration for QuackDB results.
- [QuackDB.Extension](QuackDB.Extension.md): SQL builders for DuckDB extension management.
- [QuackDB.FTS](QuackDB.FTS.md): SQL helpers for DuckDB's full-text search extension.
- [QuackDB.Geometry](QuackDB.Geometry.md): Helpers for DuckDB spatial `GEOMETRY` values.
- [QuackDB.Interval](QuackDB.Interval.md): DuckDB interval value preserving month, day, and microsecond components.
- [QuackDB.List](QuackDB.List.md): SQL expression helpers for DuckDB LIST/ARRAY values.
- [QuackDB.Map](QuackDB.Map.md): SQL expression helpers for DuckDB MAP values.
- [QuackDB.Meta](QuackDB.Meta.md): DuckDB catalog and metadata helpers.
- [QuackDB.Meta.Column](QuackDB.Meta.Column.md): A row from DuckDB's `pragma_table_info` table function.
- [QuackDB.Meta.Database](QuackDB.Meta.Database.md): A row from DuckDB's `PRAGMA database_list`.
- [QuackDB.Meta.Table](QuackDB.Meta.Table.md): A row from DuckDB's table listing pragmas.
- [QuackDB.NanosecondTime](QuackDB.NanosecondTime.md): DuckDB `TIME_NS` value stored as nanoseconds since midnight.
- [QuackDB.NanosecondTimestamp](QuackDB.NanosecondTimestamp.md): DuckDB `TIMESTAMP_NS` value stored as nanoseconds since the Unix epoch.
- [QuackDB.Profile](QuackDB.Profile.md): DuckDB query profiling helpers.
- [QuackDB.Profile.IO](QuackDB.Profile.IO.md): I/O metrics of a DuckDB profile.
- [QuackDB.Profile.Operator](QuackDB.Profile.Operator.md): A DuckDB plan or profiling operator node.
- [QuackDB.Profile.Planner](QuackDB.Profile.Planner.md): Planner timings of a DuckDB profile, in seconds.
- [QuackDB.Profile.Query](QuackDB.Profile.Query.md): Query-level metrics of a DuckDB profile. Times are in seconds.
- [QuackDB.Profile.System](QuackDB.Profile.System.md): Memory and scheduling metrics of a DuckDB profile.
- [QuackDB.Query](QuackDB.Query.md): Query metadata used by the DBConnection driver.

- [QuackDB.Result](QuackDB.Result.md): Normalized query result.
- [QuackDB.SQL](QuackDB.SQL.md): Client-side SQL parameter formatting for DuckDB Quack queries.
- [QuackDB.SQL.Fragment](QuackDB.SQL.Fragment.md): Reusable SQL fragments shared by QuackDB statement builders.
- [QuackDB.Secret](QuackDB.Secret.md): SQL builders for DuckDB secrets.
- [QuackDB.Sequence](QuackDB.Sequence.md): Helpers for DuckDB sequences.
- [QuackDB.Server](QuackDB.Server.md): Supervises a local DuckDB Quack server process with MuonTrap.
- [QuackDB.Source](QuackDB.Source.md): Safe SQL fragment builders for DuckDB table-producing data sources.
- [QuackDB.Spatial](QuackDB.Spatial.md): SQL helpers for DuckDB's spatial extension.
- [QuackDB.Storage](QuackDB.Storage.md): DuckDB storage observability helpers.
- [QuackDB.Storage.CompressionSummary](QuackDB.Storage.CompressionSummary.md): Compression summary grouped by table column.
- [QuackDB.Storage.DatabaseSize](QuackDB.Storage.DatabaseSize.md): A row from DuckDB's `pragma_database_size` table function.
- [QuackDB.Storage.Segment](QuackDB.Storage.Segment.md): A row from DuckDB's `pragma_storage_info` table function.
- [QuackDB.Stream](QuackDB.Stream.md): Lazy stream returned by `QuackDB.stream/4`.

- [QuackDB.Struct](QuackDB.Struct.md): SQL expression helpers for DuckDB STRUCT values.
- [QuackDB.TimeWithTimeZone](QuackDB.TimeWithTimeZone.md): DuckDB `TIME WITH TIME ZONE` value.
- [QuackDB.Type](QuackDB.Type.md): DuckDB SQL type rendering shared by DDL and source helpers.

- Exceptions
  - [QuackDB.Error](QuackDB.Error.md): Structured error returned by the QuackDB client.