ClickHouse backup

ClickHouse is an open-source, column-oriented database management system for online analytical processing (OLAP) and real-time analytics. It stores data by column and uses optimized compression and vectorized query execution to process analytical SQL queries while using available CPU resources efficiently. It supports large-scale workloads such as real-time analytics, observability, data warehousing, and machine learning or generative AI applications, including vector search and aggregations. ClickHouse can be self-managed on a machine or deployed through ClickHouse Cloud on AWS, Google Cloud, and Microsoft Azure. ClickHouse Local runs queries on local files such as CSV, TSV, and Parquet without a server. The project provides installers for macOS, Linux, FreeBSD, and Windows, as well as Docker and playground options; the self-managed database is open source.

OpenAnalytics is an open-source, self-hostable web analytics stack developed by OpenLabs. It uses a lightweight browser tracker without cookies, fingerprinting, or cross-site profiles, and provides aggregate-only analytics for page views, custom events, sessions, web vitals, funnels, retention, embeddable widgets, public sharing, live presence, and Stripe revenue attribution. The repository is a pnpm monorepo comprising a tracker, ingestion collector, queue worker, API, ClickHouse query gateway, realtime SSE service, Next.js dashboard, and CLI. Postgres stores control-plane data, ClickHouse stores events and rollups, and Valkey provides the event queue and realtime cache. The query gateway is the only component permitted to read ClickHouse and verifies Ed25519-signed query envelopes; visitor identity uses a salted hash that rotates nightly, while optional city-level geolocation is resolved against a database on the host. It also includes CSV/JSON import and export, an MCP server, and an AI assistant. The project is licensed under AGPL-3.0. It can be self-hosted with Docker Compose, or used through the authors' hosted instance at getopen.so. Release images are published to GitHub Container Registry.

Microsoft Azure is an open cloud computing platform and enterprise infrastructure service used to deploy and operate software. It provides infrastructure as a service, virtual machines, databases, containers, serverless computing, Kubernetes, storage, networking, monitoring, security, analytics, and developer tools. Azure also hosts AI-oriented services for models, machine learning, applications, and agents, and connects AI, data, business context, applications, and agents across an enterprise.

Helix Foundry is a local-first data workspace built on HelixDB and DuckDB. It connects databases, SaaS tools, REST APIs, object storage, and uploaded files, then proposes an ontology that links matching customers and records across those sources. The workspace stores immutable, versioned Parquet snapshots, profiles schemas and reviews schema drift, and queries the snapshots through isolated DuckDB processes. Its Home and Analyst views provide metrics and answer questions with the SQL executed and citations to the relevant snapshot. AI runs locally by default through Ollama, with Claude and OpenAI also supported; AI-proposed changes require review. The application runs on the user's computer without accounts or hosted infrastructure, and provides an OpenAPI interface, TypeScript SDK, scoped API tokens, and backup and restore scripts. It is distributed under the Apache License 2.0.

OpenObserve is an open-source, self-hosted observability platform for logs, metrics, traces, dashboards, frontend monitoring, pipelines, and incidents. It accepts OpenTelemetry data and provides SQL queries for logs and traces and SQL or PromQL queries for metrics. The platform is built in Rust and supports single-binary deployment, using Parquet columnar storage with an S3-native architecture; it also offers a unified web interface and cloud-hosted edition.