rodloboz
Lotus - Lightweight, SQL query runner and storage for Phoenix apps
I’ve started working on a new library to run SQL queries and do basic business intelligence.
Think “Blazer for Elixir.”
Currently it features a SQL explorer + saved queries + schema browser — mounted right inside your Phoenix app. Supports both Posgresql and SQLite (multiple data source repos).
It can be used as standalone or with the web UI (separate repos):
Most Liked
dimitarvp
In the age of the LLMs this expression gives me PTSD. 
Thanks for adding the screenshot. Would love seeing a video later if you ping this thread in the future.
rodloboz
Almost forgot a big one: You can now export results to CSV too 
rodloboz
rodloboz
New package website with demo you can play with:
rodloboz
@dimitarvp Here’s a video demo of Lotus
Popular in Announcing
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Build Elixir applications with speed and confidence.
Categories:
Sub Categories:
Forums
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"