Analytics

1 tutorials · 4 guides

Tutorials

How to Self-Host Plausible Analytics on Ubuntu 24.04

Self-host Plausible Analytics on a Raff Ubuntu 24.04 VM using Docker Compose. Get privacy-friendly website analytics with no cookies, no GDPR consent banners, and full data ownership on your own infrastructure.

May 1, 202614 min read

DockerSelf-HostingUbuntu

Guides

For: Data engineers and developers optimizing ClickHouse tables and queries for production dashboards, event analytics, and high-concurrency analytical workloads.

ClickHouse Query Performance: ORDER BY, Keys & Memory Trade-Offs

Optimize ClickHouse queries by designing ORDER BY and sparse primary keys for pruning, measuring rows/bytes read, and controlling aggregation, memory, joins, and concurrency.

Aug 24, 202613 min read

ClickHouseQuery PerformanceORDER BY

For: Data engineers, developers, and platform teams using ClickHouse materialized views to accelerate repeated analytical queries and rollups.

ClickHouse Materialized Views: Pre-Aggregation & Query Trade-Offs

Use ClickHouse materialized views for pre-aggregation without losing correctness: compare incremental vs refreshable views, backfills, target tables, and write trade-offs.

Aug 24, 202612 min read

ClickHouseMaterialized ViewsAnalytics

For: Developers, data engineers, founders, and platform teams deciding whether to use managed ClickHouse or operate ClickHouse themselves for production analytics.

Managed ClickHouse vs Self-Hosted ClickHouse: Cost, Scaling & Ownership

Compare managed and self-hosted ClickHouse across pricing models, scaling, backups, HA, operational ownership, and total cost for production analytics.

Aug 24, 202616 min read

ClickHouseManaged DatabasesDatabase Hosting

For: Developers, data engineers, founders, and small platform teams designing ClickHouse ingestion, schema, retention, query performance, and production ownership

ClickHouse Architecture for Production Analytics: Ingestion & Operations

Understand ClickHouse architecture for production analytics across ordering keys, ingestion, partitions, TTL, materialized views, replication, and monitoring.

Aug 12, 202615 min read

ClickHouseAnalyticsManaged Databases

Learn something new every week

The tutorials, guides, and comparisons we publish, rounded up in one weekly email. Unsubscribe anytime.

Put it into practice

Spin up a Linux or Windows server and follow any tutorial here on real infrastructure. RDP and SSH ready, 14-day money-back guarantee.

Deploy a server