Exqlite - make it work with existing Sqlite db

I’ve never actually used this lib, but according to the README, you should use the Exqliste.Sqlite3.step function: GitHub - elixir-sqlite/exqlite: An SQLite3 driver for Elixir · GitHub

Thanks but I already try this.
It does nothing:

:ok

The README has a decent set of examples of the low-level API:

Looks like executing a query needs a prepare, possibly a bind, and then a loop that repeatedly calls step until it returns :done (or fetch_all).

One comment - the API exposed by Exqlite.Sqlite3 is the lowest-level, closest to the underlying native code that calls into SQLite3. You may find it easier to use a library like db_connection that exposes higher-level functionality.

There is a simpler API here Exqlite.Basic

Thanks but that README is not so decent for me. Very “cryptic”. It does not work when I replicate it in my case. Some sort of tutorial would be fine, step by step, with real-world examples. Similar to this: SQLite PHP in php.
In general, I find that all of hexdocs are not very helpful for beginners like me, coming from the OOP world.

Thanks, this might be simpler, but none of the functions of the Basic API are documented.

Yep, I noticed that too. But I dont think it will be very hard to guess how it works

{:ok, db} = Exqlite.Basic.open(":memory:")

db
|> Exqlite.Basic.exec("create table books (title, author)")

db
|> Exqlite.Basic.exec("insert into books (title, author) values (?, ?)", ["test", "bob"])

db
|> Exqlite.Basic.exec("select * from books")
|> Exqlite.Basic.rows()

Results in this

{:ok, [["test", "bob"]], ["title", "author"]}

It might be worth looking at using exqlite through ecto, which is quite well documented.

Yeah, that is a good idea. Will get you some typecasting as well since there are not many types in sqlite.

This is it!
Thanks @kwando