News>Announcing

Lotus - Lightweight, SQL query runner and storage for Phoenix apps

#ecto#postgresql#sqlite#lotus
rodloboz

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):

23 comments
#ecto#postgresql#sqlite#lotus
87 953 23

Most Liked

dimitarvp

dimitarvp

:scream:

In the age of the LLMs this expression gives me PTSD. :grin:

Thanks for adding the screenshot. Would love seeing a video later if you ping this thread in the future.

7
Post #4
rodloboz

rodloboz

Almost forgot a big one: You can now export results to CSV too :tada:

6
Post #23
rodloboz

rodloboz

Here is a screenshot from local development:

CleanShot 2025-08-28 at 10.25.25
CleanShot 2025-08-28 at 10.25.251200×599 25.7 KB

5
Post #16
rodloboz

rodloboz

New package website with demo you can play with:

5
Post #24
rodloboz

rodloboz

@dimitarvp Here’s a video demo of Lotus

4
Post #6

Where Next?

View thread on forum (has 23 responses!)
ecto
postgresql
sqlite
lotus
Home News>Announcing
#ecto#postgresql#sqlite#lotus
87 956 23
Last post

Popular in Announcing Top

zachdaniel
News>Announcing

AshEvents: Event Sourcing Made Simple For Ash
Hey folks! AshEvents Release We’ve just released the first version of AshEvents, an Event Sourcing tool for Ash Framework apps. Check o...
/ash#ash-news#ash-extension
137 1520 44
New
zachdaniel
News>Announcing

Ash Framework 3.0
Ash Framework 3.0: Official Release! I’m here with the fine folks at Gig City Elixir, pushing the button live on stage :sunglasses: T...
/ash#release
134 3216 18
New
sorentwo
News>Announcing

Oban - Reliable and Observable Job Processing
Hello! tl;dr Announcing Oban, an Ecto based job processing library with a focus on reliability and historical observability. After spen...
/oban#ecto#postgres#job-processing
977 41022 311
New
hauleth
News>Announcing

PhoenixBakery - better compression for your Phoenix assets
PhoenixBakery is library for Phoenix 1.6 (and later) that provides modules implementing Phoenix.Digester.Compressor. There are currently ...
/phoenix#assets#zstd#static-assets#brotli
62 2584 6
New
Antrater
News>Announcing

Moon LiveView - component library
Hi there! At Moon Design System, we have been working hard for the past six months on the next generation of our LiveView component libra...
#liveview
14 491 3
New
bentanweihao
News>Announcing

I made a GenServer cheatsheet. Tell me what you think!
Here’s a preview: Here’s the link to download: GenServer cheatsheet Tell me what you think!
#book-the-little-elixir-and-otp-guidebook#cheatsheets#genserver
42 3499 7
New
tugayac
News>Announcing

Usher - Manage invitation links for your app built in Elixir
Hey Elixir Community! A few months back, I open sourced a link management system we had built into an app. It’s now got enough features ...
#ecto#library#invite
10 250 2
New
kraleppa
News>Announcing

LiveDebugger - tool for debugging LiveView apps
I’m happy to announce LiveDebugger v0.1.0! :mega: LiveDebugger is a browser-based tool for debugging LiveView applications, designed to ...
/phoenix#debugging#liveview#developer-experience#livedebugger
85 1096 11
New
fhunleth
News>Announcing

Circuits GPIO, I2C and SPI - Use Elixir to control hardware and read sensors
Elixir Circuits is a set of libraries for interacting with hardware. We previously announced Circuits.UART, and now we’re ready to announ...
/nerves#hardware#circuits_gpio#circuits_i2c#circuits_spi
40 4486 11
New
Asd
News>Announcing

Repatch - Everything you need for mocking and patching
Hi, I am happy to release the Repatch library for mocking and patching implementation in tests and anywhere else. It brings new possibili...
#testing#mocking#mocks#mock#patching#repatch
28 834 13
New

Other popular topics Top

JDanielMartinez
Questions & Help>Questions

** (RuntimeError) could not lookup Ecto repo Repo because it was not started or it does not exist
Hi! May someone helps me, please! I have two apps into an umbrella project: the first one is Database, which manages queries, and the se...
#umbrella#testing#repo#runtimeerror
11 15040 14
New
peerreynders
Learning Resources>Chat/questions

Elixir Book & Learning Resources Sales / Discounts Thread
Manning 2016 Halloween weekend sale via Deal of the Day Friday, October 28 - Half off all MEAPs - code WM102816LT Saturday, October 29 ...
#discounts
326 29600 154
New
sorentwo
News>Announcing

Oban - Reliable and Observable Job Processing
Hello! tl;dr Announcing Oban, an Ecto based job processing library with a focus on reliability and historical observability. After spen...
/oban#ecto#postgres#job-processing
977 41022 311
New
vonH
Questions & Help>Questions

Why would I choose Elixir as a general purpose programming language?
In asking this question I am more interested about the expressiveness of the language itself and less concerned about the availability of...
#functional-programming#use-cases
65 34758 13
New
lessless
Questions & Help>Questions

How are you dealing with CSV files that uses CR line breaks?
I believe there are people here who are dealing with CSV files import on the daily basis, and since Excel is a really popular tool there ...
#how-to-question
10 18353 17
New
grych
Your Libraries & Projects>Libraries

Drab: remote controlled frontend framework for Phoenix
Hi folks, Few months ago I have announced the proof-of-concept of the library to manipulate the browsers DOM objects directly from Elixi...
/phoenix#web-frameworks#frontend#javascript#drab
639 49522 488
New
vertexbuffer
Questions & Help>Questions

Deleting item from a list
Hello, can anybody help here..? I have a list of players and I what to delete an element, but every for loop the list is reverting to ori...
7 24097 4
New
alice
Questions & Help>Questions

What are the main benefits of Elixir compared to Clojure?
Hey, Just curious what are the main benefits of Elixir compared to Clojure? When is Elixir more useful than Clojure and vice versa? Th...
#clojure
223 32979 47
New
vonH
Questions & Help>Questions

How do I kill a process ` #PID<0.186.0` in iex?
When I run the Plug and I recompile I wind up having to use Ctrl C to quit iex and start again. Witht the help of rlwrap I can use the cu...
#iex#processes#how-to-question
36 21149 8
New
AstonJ
Chat & Discussions>Wikis

Phoenix LiveView Info
We’ve put together this wiki for Phoenix LiveView - please feel free to add any info you feel is worth including. What is Phoenix LiveV...
/phoenix#wiki#stickies#liveview
220 25307 74
New
Back to top

News>Announcing

News Announcing ❯

Latest on Elixir Forum

Elixir Forum ❯

Sponsor Spotlight

EEF

Supporting innovation across the BEAM ecosystem.

Our Sponsors

Dashbit

Build Elixir applications with speed and confidence.

EEF

Supporting innovation across the BEAM ecosystem.

Coders51

We build reliable cloud platforms for business-critical systems.

AppSignal

Catch errors, track performance, monitor hosts and more.

Manning

Develop your skills with books, videos, and courses.

ElixirCasts

Producing high quality Elixir screencasts since 2017.

Potions

The deployment platform built for Elixir: PaaS ease, VPS control.

Pragmatic Studio

Courses that'll move you from confusion to "Aha, now I get it!"

View all our sponsors ❯

Categories:

Sub Categories:

Forums

Our Sponsors

Dashbit

Build Elixir applications with speed and confidence.

EEF

Supporting innovation across the BEAM ecosystem.

Coders51

We build reliable cloud platforms for business-critical systems.

AppSignal

Catch errors, track performance, monitor hosts and more.

Manning

Develop your skills with books, videos, and courses.

ElixirCasts

Producing high quality Elixir screencasts since 2017.

Potions

The deployment platform built for Elixir: PaaS ease, VPS control.

Pragmatic Studio

Courses that'll move you from confusion to "Aha, now I get it!"

View all our sponsors ❯

We're in Beta

About us Mission Statement