NobbZ
For some python projects at work we found that there are pytest-{postgres,mysql,redis} and probably more.
These tools take the burden off of you to maintain a Dev database locally which you need to configure your in Dev applications accordingly.
Those are basically plugins for pytest, which use the fixture mechanism of pytest to provide temporary “installations” of the tool in question, “persisting” it’s data into temporary folders and removing after the suite has run.
Even though this has an obvious runtime cost to initialise the tooling for each test run, it really made onboarding the junior quite easy. We just told them to install mysql package for their Ubuntu WSL and told them to run make test which wrapped the actual test run with proper command line arguments. No need to walk them through configuring a local mysql or having remember to run some docker(-compose) whenever changing projects.
Has anyone seen something similar for elixir or is there any interest in it?
Where Next?
Trending in Discussions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Error tracking, logs, APM, uptime and cron monitoring in one dev-friendly platform. Find and fix problems before your users notice.
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
- #ai
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #blog-post
- #ecto-query
- #elixirconf-us
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #elixirconf-eu
- #api
- #forms
- #security
- #hex
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.
Bringing learning, work and compliance together since 1987.
The deployment platform built for Elixir: PaaS ease, VPS control.
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 9- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
dimitarvp
I am sorry, what exactly do those packages do? Didn’t get it. What tool? What temporary installations? Why once per test? Could you clarify?
webuhu
I archive this behavior by using Nix.
At least it works perfectly with running PostgreSQL in a temporary directory.
→ GitHub - webuhu/elixir_nix_example · GitHub
The probably interesting PostgreSQL part under:
https://github.com/cw789/elixir_nix_example/blob/main/pkg/temporary_postgresql_db.nix
So it means within WSL - install Nix - run nix-shell command x…
If you run the command a second time, runtime cost isn’t anymore much higher.
NobbZ
Yeah, using nix such a thing is easy, I know, though even I wrap most of my stuff in flakes nowadays, I try to make it that potential contributors don’t need nix installed.
webuhu
That would be wonderful. Difficult onboarding is always an issue.
NobbZ
They start the tool they are made for, eg mysql, and remove its runtime folders afterwards. It does not affect any potentially running instances of that software that might already be on the system.
And it’s not per test, but per run.
So only the first test hitting the database is actually slow as it needs to wait for everything beeing set up.
As I said already it comes with a low cost for setting things up, and might also enable to test behaviour against different database versions.
webuhu
So I’m not aware of anything like this deticated for Elixir and not using Docker.
But I think without any container or virtual machine sandboxing it is difficult to not affect any other running instances.
But I’m of course interested.
dimitarvp
I’m still not sure I get it.
Are you talking about something like the
PGDATAenvironment variable that allows you to specify where will PostgreSQL store its data? I’ve had projects where that was used to kinda sorta enforce some isolation.NobbZ
We used the MySQL version of those plugins, that basically starts a mysql demon with a configuration pointing the data dir to somewhere in tmp, listening on specified ports or domain sockets.
It manages the full database application lifecycle.
dallagi
If I understood your requirement correctly, you may be interested in excontainers, a library I developed to tackle exactly this problem.
Unfortunately it has not seen much adoption yet, but in case you decide to give it a try I’d be happy to hear about any problem you may encounter or any feedback you may have