Roadmap for upgrading or creating an Ecto adapter?

Hey everybody,
The purpose of this thread is to answer three questions:

  1. How do we go about upgraging an Ecto 2.2.x adapter that is not on the latest 2.2.x version, to the latest 2.2.x version?
  2. How do we go about upgraging an adapter that is at the latest Ecto 2.2.x version, to Ecto 3.1.x?
  3. How do we go about making an Ecto 3.1.x adapter from scratch?

I apologise to the people I mentioned via an @ in advance. Making this crystal clear here and now: I do not ask those people to produce any code, I am asking them only to help me gather an authoritative collection of informational resources to get me and other interested maintainers started.

I would like to modernise the Sqlite database support in Elixir. This means two things:

  1. (OPTIONAL) Contribute to sqlite_ecto2 so it works with the latest Ecto 2.2.x version (as of the time of this post, 2.2.12). This is mostly for exercise and to dip my toes and hopefully learn well how to approach the Ecto 3.1.x work. If this proves to consume unjustified amounts of energy and time and/or turns out to be unrelated to the Ecto 3.1.x work then I might drop it.

  2. (MAIN GOAL) Make a new library that brings Sqlite to Ecto 3.1.x (as of the time of this post, 3.1.6).

I have tracked several resources:

@michalmuskala Pointed at two useful pages to get new maintainers started here:

There is also another post on his blog – Creating Ecto Adapters – but it’s from 2015 and I am not sure if it’s still relevant.

@jwarlander contributed a link to the MyXQL adapter development blog series: Building a new MySQL adapter for Ecto, Part I: Hello World (links to the rest of the articles are inside this one, and every subsequent one as well).

Additional honorable mentions with a plea for other and/or more modern articles: @josevalim, @ericmj, @wojtekmach, @fishcakez and @whatyouhide.


It’s a great collection of resources you’ve started on, @dimitarvp! It reminds me that I saw an interesting blog post series about implementing an Ecto adapter (by @wojtekmach, on the Plataformatec blog):

Building a new MySQL adapter for Ecto, Part I: Hello World

I’ve always meant to take a deep dive into that one, and see if I can piece together something useful.

1 Like

Really valuable link, forgot about it and thank you for bringing it up! Still reading, and gathering a lot of useful info from it. Also added your link to the entire list.