We have made an Ecto3 Adapter for SQLite3,
We have successfully on-boarded the full suite of integration tests (320+) that
ecto_sql provide, as well as writing a good amount of our own integration tests and functional tests for the query-generation logic, giving us a great degree of confidence that this adapter is stable and ready for everyday usage. Due to its newness, it hasn’t seen much production use, but we are eager to have people start trying it out and let us know any issues they hit.
This adapter is mainly possible thanks to the
exqlite SQLite3 driver, which is an Elixir-written successor to the Erlang SQLite3 NIF
esqlite. It leverages Dirty NIF functionality to make the code easier to reason about and maintain.
Lastly, we have begun work on adding a
--database sqlite3 option to Phoenix to make this adapter easy to use for new projects. Of course, even without those changes, switching from e.g., Postgres to SQLite3 is usually only a couple of lines of config changes
Feel free to file any issues you encounter in the Github repo.
cc @warmwaffles , who lead most of the development