l3nz
I’m trying to use the DatabaseConnection smart cell in a livebook to query a SQLite database.
When I connecti it, it says:
{:ok, #PID<0.293.0>}
But If I try creating a query it fails with {:error, :invalid_connection} when I run:
{:ok, statement} = Exqlite.Sqlite3.prepare(c2, "select * from table")
In fact it works if I create a connection manually:
{:ok, c2} =Exqlite.Sqlite3.open("my.db")
But the connection is different - it’s a reference not a PID:
{:ok, #Reference<0.4102545559.2337144860.146613>}
So how do I use the smartcell’s own connection? I’m sure I’m missing something trivial. With MySql it just works.
Where Next?
Trending in Questions
Other Trending Topics
Latest Livebook Threads
Latest on Elixir Forum
Sponsor Spotlight
Elixir, Erlang & messaging conferences from Code Sync. Next up: ElixirConf US (10–11 Sep) & Code BEAM Europe (21–22 Oct), Haarlem + online.
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
- #ai
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #elixirconf-eu
- #metaprogramming
- #hex
Our Sponsors
Build Elixir applications with speed and confidence.
We build reliable cloud platforms for business-critical systems.
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.
Producing high quality Elixir screencasts since 2017.
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 2- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
jonatanklosko
There are two different layers, the cell starts a “connection” process and you can use the
Exqlitemodule functions to interact with the connection. TheExqlite.Sqlite3module works on a specific reference available to the opening process.So for your example, you want to use
Exqlite.prepare(or justExqlite.query). Note that Livebook also has “SQL query” cell with SQL editor, that does it for you : )l3nz
Thank you - the handling of results seemed bit low-level…