What is Latitude?
Latitude is an open-source framework for embedded analytics that allows developers to create API endpoints on top of their database or warehouse using just SQL, and embed interactive visualizations natively in their favorite frontend framework or through an iframe.
Features of Latitude
Easy to Implement, Maintain, and Scale
Latitude provides an easy-to-use framework for embedded analytics, making it simple to implement, maintain, and scale.
SQL-to-API
Write SQL queries that automatically get exposed as API endpoints, making it easy to integrate them with frontend applications.
Zero-Config Deployments
Deploy embedded analytics to production with one command, with zero-config infrastructure that's always performant and scales automatically.
Parameterized SQL
Manage permissions and scope variables in code through parameters in queries, and expose these SQL parameters as HTTP query parameters.
Built-in Cache Layer
Out-of-the-box caching ensures load times stay snappy, with a lightning-fast query engine to deliver an amazing embedded analytics experience.
Modular Queries
Compose modular SQL queries for better analytics organization and to reuse parts of code, making it easy to maintain and scale.
Works on Top of Your Data
Bring data from your database or warehouse through a simple configuration file, with support for all major databases as well as local CSV files.
Unparalleled Customization
Choose how you want to display your analytics, with native frontend components and a layout engine that supports all npm packages and can be extended to your needs with Typescript.
How to Use Latitude
To get started with Latitude, simply write SQL queries that automatically get exposed as API endpoints, and integrate them with your frontend applications. Use the built-in cache layer and modular queries to ensure fast and scalable analytics.
Pricing of Latitude
Latitude is free and open-source, making it an affordable solution for embedded analytics.
Helpful Tips for Using Latitude
- Use parameterized SQL to manage permissions and scope variables in code.
- Leverage the built-in cache layer to ensure fast load times.
- Compose modular SQL queries for better analytics organization and to reuse parts of code.
Frequently Asked Questions
Is Latitude Secure?
Yes, Latitude provides cache encrypted at rest, SSL-ready, encrypted SQL parameters, and parameterized queries to protect against SQL injection attacks.
Can I Contribute to Latitude?
Yes, Latitude is an open-source project, and we welcome contributors to join our community and help build the framework.
What Frontend Frameworks are Supported?
Latitude currently supports React, with support for Svelte and Vue coming soon.