rodloboz
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):
Where Next?
Trending in Announcing
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
At WyeWorks, we believe great software is built by combining technical excellence with genuine human connection
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #blog-post
- #elixirconf-us
- #elixir-ls
- #ai
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Practical resources that improve the lives of professional developers.
Master modern tools, write cleaner code, and tackle real-world challenges.
**Building the future of software with AI, trust, and human connection.**
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 10- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
dimitarvp
I think I get what is this about and I love the idea but a few screenshots and a video would be great.
rodloboz
Thanks @dimitarvp . You’re absolutely right. I added a screenshot to the original post.
I’ll have to record a demo video to share!
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
hahaha… is GPT/Claude lingo seeping into my speech patterns?
I’ll share a video demo here later on.
rodloboz
@dimitarvp Here’s a video demo of Lotus
FlyingNoodle
This is so neat. I love it. Thank you for your contribution to the ecosystem!
rodloboz
Thank you for the kind words. I’m glad you like it and hope others will find it useful
RemyXRenard
Nice work on this, it looks great.
[Previous job catharsis]: My prior end users would have asked for a drag and drop graphical query editor and wonder why it couldn’t predict their queries and graph them in twelve dimensions. However, Lotus seems like nifty tool to have in the toolbox, and they aren’t my end users anymore. Haha!
Please note, that was not a feature request!
Thanks for this.
dbern
This is really fantastic. Thanks for sharing this!
A7mad
This looks great!!
How do you manage to make it read only? Do I have to create a read only account for it or you just check the statement if it only a select statement? If you check the statement I can do some deletes or inserts inside a CTE will this be caught as well?