InsightTrack v1.0.0

First tagged release of InsightTrack — a self-hosted web analytics platform with a dual-database architecture.

Architecture

PostgreSQL is the system of record for tracking events, authentication and site management. An embedded DuckDB instance, kept current by an incremental sync process, serves every analytics query. The split lets the transactional store stay normalised and write-optimised while analytical aggregations run against a columnar engine in the same process, with no separate warehouse to operate.

What's included

• Dashboard — React 18 + Vite, with dark mode throughout
• API — Express 4 with JWT auth, per-site membership and roles
• SQL editor — allowlist-validated and scoped to a single tenant
• Retention — configurable policies that delete from both stores
• Privacy — honours Do Not Track and Global Privacy Control
• Pulse — built-in AI analyst, with bring-your-own-key support
• MCP toolkit — exposes analytics to MCP clients

Benchmarks

Ships with a seeded, reproducible engine benchmark harness (fixed seed, 30 measured runs per query, recorded environment) comparing PostgreSQL and DuckDB execution times at 100K, 1M and 5M rows. Raw CSV and JSON results are included under benchmark-results/.

License

MIT.