Episode 268 of [Thinking Elixir](https://podcast.thinkingelixir.com). News includes a new library called Lotus and LotusWeb that provides a safe, read-only environment for running SQL analytics queries with organized storage for saved queries. After the news, we had an interview with Mateusz Front about the Popcorn project, which enables Elixir to run in WebAssembly (WASM) in the browser courtesy of AtomVM. We dig into how it works, what it’s capable of doing, and where it could go in the future!
2 Likes
Thanks for covering Lotus in such detail
Your summary is spot on… the idea is for something super easy to mount on your Phoenix app and expose behind an authed route that your non-tech product manager/owner can use
A couple of updates on latest version:
- Lotus now supports result and schema introspection caching (ETS based)
- The web interface has input widgets (text, select, date picker) to make queries dynamic with param substitution
- MySQL Ecto repos can be passed as data sources
2 Likes