Latitude

Latitude is an open-source framework for building embedded analytics into your applications. You write SQL queries against your database or data warehouse, and Latitude converts them into API endpoints that you can call from your frontend code. It handles the backend infrastructure, letting you focus on the analytics logic itself rather than building a separate API layer. The tool is designed for teams that want to embed charts, dashboards, and interactive visualisations directly into their products without managing complex backend services. It works particularly well if you're already comfortable with SQL and want to avoid writing boilerplate API code. You can embed visualisations using React components, iframes, or by calling the APIs directly, giving you flexibility in how you integrate the analytics into your user interface. Latitude includes practical features like query parameterisation for dynamic filtering, built-in caching to improve performance, and zero-configuration deployments so you can get started quickly. Security features include encryption at rest and SSL support. Since it's open-source, you can self-host it and inspect the code yourself.