Show HN: Latitude – Developer-first embedded analytics

[geclos]

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

Hey HN ,

I'm Gerard, co-founder @ Latitude. Over the past two years, we've been building data tools aimed at both technical and non-technical folks. After numerous tweaks and revisions, we chose to keep the best features, ditch the rest, and develop a code-first, open-source approach that's laser-focused on embedded analytics.

Latitude is an embedded analytics framework designed with developers in mind. It integrates seamlessly with your database or data warehouse, leveraging SQL and straightforward frontend components.

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

[XCSme]

Is there a demo of the interface/API?

I am looking for a solution to enable custom-dashboards for https://www.uxwizz.com

[XCSme → XCSme]

Also, what does Latitude do exactly?

Because I see you still have to write the queries and view, why is it better than simply writing a PHP PDO query and outputting the HTML for the chart/data?

[geclos → XCSme]

Hey ,

Latitude is a code-based solution, so there's no UI. In the future we might provide a web interface to build views that get persisted in our code framework, but for now we wanted to focus on the coding experience. I'm not familiar with PHP PDO but comparing Latitude to most backend frameworks we make things more simple and fast to code. Some of the main features we provide:

- Ready made UI components for charts, inputs and buttons

- Parametrised queries with template syntax and control flow (if/else, for loops..)

- Automatic caching layer for faster performance

- Automatic API: you write an sql query and it gets automatically exposed in its own API endpoint

[atonse]

Ahh it’s LGPL, can’t consider it for our products.