# AxialDB

> Columnar analytics extension for SQL and NoSQL databases. A sidecar helper runs heavy analytical queries on Parquet snapshots so OLTP stays protected — not a standalone database.

AxialDB installs inside databases you already run (for example MySQL `ENGINE=AXIALDB`, SQLite extension). You materialize once with `CREATE AXIALDB VIEW`; repeat `SELECT` on the view reads a frozen snapshot in the sidecar, not live tables on every refresh.

## Core capabilities

- Isolated analytical views: snapshot defining query to Parquet; analytics off the OLTP read path.
- Sidecar columnar engine (DataFusion on Parquet) on your host — Windows or Linux eval builds available.
- Workload separation vs live-table accelerators (pg_duckdb, DuckDB ATTACH): production is not scanned on each chart refresh.
- Create on demand — one view for the report you need, not a warehouse sync for every table.
- Configurable retention: unused snapshots can expire when not queried.

## Common bottlenecks

- **Slow GROUP BY on OLTP:** Transactional engines scan row-oriented storage; large aggregations compete with inserts and reports for CPU, memory, and I/O.
- **Warehouse or ETL overkill:** Fivetran-style sync and lakehouses are powerful but often too complex and expensive for a handful of dashboards.
- **Analytics hurts production:** Heavy reports on live tables slow the app; read replicas or a full data platform feel absurd for small teams.

## Supported eval targets

- MySQL 9.7 (Windows x64, Linux x64) — evaluation builds on GitHub.
- SQLite extension — development path in product roadmap.

Downloads are **evaluation only**. Commercial licensing and production deployment: contact info@axialdb.com.

## Links

- Home: https://axialdb.com/
- Download: https://axialdb.com/download.html
- Eval releases: https://github.com/AxialDB/releases
- Release history: https://github.com/AxialDB/releases/blob/main/RELEASES.md
- Contact: mailto:info@axialdb.com

## Honest bounds

- `CREATE AXIALDB VIEW` touches live data once per snapshot; refresh means re-create.
- Snapshot numbers are as-of until you recreate the view.
- Do not position as "fastest engine" — lead with isolation, separation, and control.