Supabase Logs: open source logging server

Summary

Supabase is releasing Supabase Logs for self-hosted users and CLI development, built around Logflare, which processes more than 1 billion log events daily from Supabase services. Logflare is a multi-node, highly available Elixir cluster that ingests events through Vector or native integrations, streams them to BigQuery, and exposes SQL-backed HTTP Endpoints for Studio, Logs Explorer, and usage charts. Endpoints support parameterized queries, in-memory read-through caching, configurable cache warming, and select-only query sandboxing, allowing views over billions of daily events without querying many terabytes on every request. The release changes Logflare’s license to Apache 2.0, replaces closed-source SQL parsing with rust-based sqlparser-rs, and improves environment-based configuration for self-hosting; BigQuery is currently the supported backend, with more planned.

Takeaways

1. 1

   Logflare processes more than 1 billion daily log events from the API gateway, Postgres, Storage, Edge Functions, Auth, and Realtime using a multi-node Elixir cluster.

2. 2

   Endpoints combine parameterized SQL, read-through caching, and active cache warming; an example reduces thousands of requests to five BigQuery queries over a 10-minute interval.

3. 3

   Logflare is now Apache 2.0 licensed and uses rust-based sqlparser-rs, while BigQuery remains its current supported backend.