Crystaldba

Added
- **Enriched terminal experience** for improved usability.
- **Statement execution timeout** to prevent long-running query execution.

Fixed
- **Preference storage** now saves setting when user chooses not to share data.

Added
- **Crystal DBA CLI** the client application for a chat-based AI DBA teammate.

Changed
- **Updated README** to highlight new Crystal DBA chat-based interface.

Added
- **Backfill support** to rapidly populate a Prometheus database with historical snapshots.

Changed
- **Renamed to Crystal DBA** to reflect the current product positioning.
- **Prometheus default configuration** to limit resource usage.

Fixed
- **Filter by query** previous release introduced a regression in filtering by query.
- **Timeseries data returned out of order** when data spans more than one day.

Added
- **Prometheus recording rules** to improve query performance and reduce server load.
- **Prometheus self-monitoring** for better observability of the monitoring system.
- **Support for podman-compose** as a fallback when Docker Compose is not available.
- **PostgreSQL log collection from the collector** for improved debugging capabilities.
- **2-day time range option** in the time selector for extended analysis periods.
- **Export snapshots via API** enabling external data access and integration.
- **`--no-collector` mode** in run.sh for flexible deployment options.
- **`--reprocess-full-snapshots` and `--reprocess-compact-snapshots` flags** for data reprocessing.

Changed
- **Enhanced time selector UI** with improved usability and support for arbitrary start and end times.
- **Optimized input data collection** and PromQL queries for better performance.
- **Upgraded Prometheus** with improved query capabilities.
- **Renamed time-series labels** for better consistency.
- **Code quality improvements** with Biome linting and formatting.
- **Improved query storage architecture** by moving query text to SQLite and storing only fingerprints in Prometheus for better performance.

Fixed
- **Stale-marker cache initialization** from Prometheus.
- **Installation script** to run from any directory.
- **Query filter options** to properly include database identifier.
- **Installation issues** affecting new deployments.

Security
- **Added CRYSTALDBA_FORCE_BYPASS_ACCESS_KEY environment variable** for flexible authentication control during development and testing.

Added
- **Docker Compose support** with multiple `Dockerfile`s. This improves the architecture by running each service in a separate container.
- **Shared secret authentication between Browser and Agent**, enhancing security in communications.
- **API key support as an environment variable** for `collector-api`, providing flexible configuration options.
- **New Collector build artifact**, allowing separation of metrics collection from processing at the AutoDBA agent.

Changed
- **Incremental Docker build improvements**, reducing build time and enhancing efficiency.
- **Service deployment changes** to improve deployment reliability.

Fixed
- **Documentation updates**: added Google Cloud Platform usage details and missing prerequisites for improved setup guidance.

Added
- **PostgreSQL 12, 13, 14, 15, and 16 support**, extending compatibility to all these PostgreSQL versions.
- **Google Cloud SQL support**, enabling monitoring of databases hosted on Google Cloud SQL.

Changed
- **README automatically updated on release**, streamlining the release process.
- **Removed AWS RDS requirement**, making AutoDBA usable without AWS credentials.
- **Removed Prometheus exporters**, now integrating fully with the Collector for time-series data handling. This is made possible after adding support for ingesting Full Snapshots from the Collector.
- **Lightweight integration tests**, ensuring basic end-to-end functionality from the database to the Collector API Server. While not comprehensive, these tests provide a foundation for validating core data flow.