Hey ,Latitude is a code-based solution, so there&#x27;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&#x27;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&#x2F;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

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&#x2F;data?

Is there a demo of the interface&#x2F;API?I am looking for a solution to enable custom-dashboards for <a href="https:&#x2F;&#x2F;www.uxwizz.com" rel="nofollow">https:&#x2F;&#x2F;www.uxwizz.com</a>

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

Hey HN ,I&#x27;m Gerard, co-founder @ Latitude. Over the past two years, we&#x27;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&#x27;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&#x27;d love to hear your thoughts and are on the lookout for contributors!

Show HN: Latitude – Developer-first embedded analytics