So what is the problem with sqlite?

Yeah, I found that repo after some more searching once I posted the question.
That’s also WIP so it could be a good project to contribute.

1 Like

@outlog @lambrospetrou Thanks for the mention. I have a “help wanted” section in the README in which I describe what work I think remains to bring sqlite_ecto2 from its current prerelease state to something we could legitimately call a 2.0.0 release.

PRs welcome!

@sotojuan I agree (which is why I started this project :smile:). One caveat that isn’t (yet) in the README: You really should avoid using SQLite in any context where you are deploying as a cluster (unless there is a single database node in the cluster). Since SQLite works with its database stored as a local file rather than communicating over-the-wire with an independent database server, each machine in the cluster would wind up operating on independent versions of the data. Certain doom awaits.

2 Likes

SQLite is a good choice for the IOT (such as the raspberry pi) devices that don’t need a full blown database.

2 Likes

Very true! Indeed @ConnorRigby who is the current maintainer of https://github.com/elixir-sqlite/sqlite_ecto2 often uses it on Nerves based systems running on devices like the Raspberry PI https://nerves-project.org/

SQLite is an A+ option for Nerves in my opinion. Unfortunately the adapter needs a bit of love for Ecto2 as well as work for Ecto3. That said i use it in production today and it’s a great library once you understand what it’s use cases are.

3 Likes

ecto_sqlite3 didn’t end up causing a dependency conflict on the day that is today, 2021-08-06.