Roundups of open-source data and analytics tools by job: BI and dashboards, pipeline orchestration and real-time analytical databases, each judged on license, architecture and what it takes to self-host.
Shortlist guide to self-hosted BI: Apache Superset, Metabase and Redash in depth, with Lightdash and Grafana covered for dbt-centric and operational dashboard needs. Compares licenses and paid editions, SQL versus no-code exploration, embedding, SSO and the upkeep each needs.
Apache Airflow, Dagster and Prefect compared side by side, with Kestra covered as the YAML and event-driven option. Looks at authoring model, scheduling and backfills, what each keeps for paid cloud or enterprise editions, and the effort to run each in your own infrastructure.
ClickHouse and Apache Druid against PostgreSQL for analytics: when a general-purpose database is enough, when a columnar or real-time engine pays off, and how architecture, ingestion, licensing and operating effort differ.
OpenMetadata, DataHub and Apache Atlas side by side, with Amundsen noted as archived in September 2026: metadata models, connectors, lineage and governance features, managed services, the infrastructure each needs and release activity.
Trino, Presto and Spark SQL compared for querying a self-hosted lakehouse, with StarRocks named for teams that also want their own storage: architecture, connectors and table formats, fault tolerance, governance and the operating effort of each.
TimescaleDB, InfluxDB 3 Core and ClickHouse compared for metrics, IoT and event data: storage engines, query languages, licenses and paid editions, high availability in the open-source build, and which fits alongside an existing PostgreSQL estate.
Tell us what you're working on, whether it's a deployment, an audit, a security test or a cyber range. You'll speak with an engineer who can help you scope it.