I have a simple relational database structure I want to do simple CRUD operations on.

Open the database, create a new record, open a result set, scan for those I want, update or delete them. If anyone has used the ADODB in PHP they will understand what I want. I have taken a look at Ecto, but what I have seen seems too complicated for what I need, or it may because the examples don’t focus on my immediate use case.

I have seen something that seems to fit the bill - GitHub - robconery/moebius: A functional query tool for Elixir · GitHub - which seems to fit the bill but only works for Postgres. If there is something similar which deals with multiple databases that will be better, as Postgres is overkill for what I want to accomplish. Something like moebius that handles SQLite will be better.

Is there some guide to ecto that teaches how to do the simple actions above on an existing database? It is a small database which is only expected to handle a few 1000 records, so if I am using ecto I am hoping ecto can inspect the schema and create its own schema code from it, like Django’s South.