DEV Community

Cover image for Latitude: The missing analytics layer between your database and your users 🀝🏽
Gerard Clos for Latitude

Posted on

9 2

Latitude: The missing analytics layer between your database and your users 🀝🏽

What is Latitude?

Latitude is the open-source framework for embedded analytics.

Create API endpoints on top of your database or warehouse using just SQL, and embed interactive visualizations natively in your favorite frontend framework or through an iframe.

Introducing Latitude Deploy πŸš€

Today we’re introducing Latitude Deploy so you can push your embedded analytics to production with a single command. Zero-config infrastructure that's always performant and scales automatically.

Image description

Support us ⭐

We know that building embedded analytics from scratch can be difficult. That is why we created Latitude. We're developing it as an open-source project. If you're keen to give it a try, here's a quick start guide available on our repository. If you like what you see, consider showing your support by giving us a star ⭐

https://github.com/latitude-dev/latitude


Latitude it's fast to get started, easy to maintain, and scales with your data.

Here are our main features:

SQL-to-API automatically

Write SQL queries that automatically get exposed as API endpoints so you can easily integrate them with your frontend applications.

Parameterized SQL

Manage permissions and scope variables in your code through parameters in your queries. Expose these SQL parameters as HTTP query parameters.

Built-in cache layer

Out-of-the-box caching ensures load times stay snappy. Leverage our lightning-fast query engine to deliver an amazing embedded analytics experience.

Modular queries

Compose modular SQL queries for a better analytics organization and to reuse parts of your code. Easy to maintain and scale.

Works on top of your data

Bring data from your database or warehouse through a simple configuration file. Support for all major Databases as well as local CSV files.

Native frontend components

Use our native React hook to query data from your Latitude project to your React app, and display it with our native React components, or do whatever you want with it. Support for Svelte and Vue coming soon!

Layout engine

Build standalone state-of-the-art frontend applications using our layout engine. It’s Svelte-based, supports all npm packages, and can be extended to your needs with Typescript.

Embed safely

Cache encrypted at rest, SSL-ready, encrypted SQL parameters, and parameterized queries to protect against SQL injection attacks.


We'd love to hear your thoughts and are on the lookout for contributors!

If you like it, it’d be great if you could give us a star so we can keep working on this! ⭐

https://github.com/latitude-dev/latitude

Image description

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

πŸ‘‹ Kindness is contagious

Immerse yourself in a wealth of knowledge with this piece, supported by the inclusive DEV Communityβ€”every developer, no matter where they are in their journey, is invited to contribute to our collective wisdom.

A simple β€œthank you” goes a long wayβ€”express your gratitude below in the comments!

Gathering insights enriches our journey on DEV and fortifies our community ties. Did you find this article valuable? Taking a moment to thank the author can have a significant impact.

Okay