Ecto

Decided to switch from (A)Mnesia to Ecto with SQLite3 for my NVD (CVE) caching application.

1. The historic NVD data is over 1GB which means I’m already starting to run into limitations.
2. The planned database is extremely simple (two tables?).
3. Experience with Ecto is more important in the long term for planned projects.

Useful and interesting links:

• Ecto 3 Documentation.
• Programming Ecto book.
• ElixirConf 2017 - Thinking In Ecto - Darin Wilson: Good high-level overview starting video.
• Guilherme de Maio - Ecto without SQL - ElixirConf EU 2019: Time 15:39 demonstrating custom cast definition.
• Doing weird things with Ecto | Nikola Begedin | ElixirConf EU 2021.
• Creating Migrations - Alchemist Camp: Indexes aren’t quite right.
• Using Ecto Schemas with Database Views.
• Ecto 3 Upserts: Crucial to my project as the stored CVE data is updated on a near daily basis.
• Ecto.Adapters.SQLite3.
• Elixir and Ecto with SQLite3.

All notes and comments are my own opinion. Follow me at @rgacote@genserver.social