Hi,

I need to do the following tasks for me project using Sqlite3 existing dbs (files):

• connect to each of the Sqlite db/files in the repository
• list all the tables in the db.
• select (filter) some tables of interest
• for selected tables execute one query to extract some data (a very simple query such as SELECT items FROM table WHERE condition)
• return a map with all the collected results

So far, I managed (with difficulties) to install and configure Exqlite into the project.
I tried to follow the documentation Readme — Exqlite v0.38.0 and did:

{:ok, conn} = Exqlite.Sqlite3.open("path_to_one_db")
:ok = Exqlite.Sqlite3.execute(conn, "SELECT name FROM sqlite_master WHERE "type"='table'");

…and I got stuck. I don’t know how to use this library further on. The documentation is not very clear. There are no examples/tutorial online.
Next step is to get the list with the tables in the db.

Thanks for your help,
T.

PS: As you might have noted, I am quite new to Elixir.