dimitarvp
Hey everybody,
The purpose of this thread is to answer three questions:
- 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?
- How do we go about upgraging an adapter that is at the latest Ecto 2.2.x version, to Ecto 3.1.x?
- 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:
-
(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.
-
(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:
- Sqlite_ecto2 new maintainer - #7 by ConnorRigby (post by @ConnorRigby in ElixirForum)
- Version working with ecto 3 (
sqlite_ecto2GitHub issue) - Instructions on how to contibute (
sqlite_ecto2GitHub issue)
@michalmuskala Pointed at two useful pages to get new maintainers started here:
- Upgrading to DBConnection 2.0 (
db_connectionGitHub issue) - Ecto 3.0 CHANGELOG on adapter changes from 2.2 (
ectoGitHub changelog)
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.
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Producing high quality Elixir screencasts since 2017.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #blog-post
- #elixirconf-us
- #elixir-ls
- #ai
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Master modern tools, write cleaner code, and tackle real-world challenges.
Producing high quality Elixir screencasts since 2017.
**Building the future of software with AI, trust, and human connection.**
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 2- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
jwarlander
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.
dimitarvp
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.