What databases are just as good as PostgreSQL for Phoenix Framework

Many people will say just use Postgres, but MySQL/MariaDB are often used too. However if you’re asking this because of the problem in your dev environment on the computer you were given, then I would suggest considering reformatting it and starting from scratch so you can be sure everything is set-up correctly. Just be sure to back up all of you important files first and read up on it before starting.

Alternatively you may want to read up on some Elixir dev env set-up guides for Linux, I posted my macOS guide in your other thread: https://forum.elixirforum.com/t/how-to-set-up-elixir-dev-environment-on-linux/73708/7?u=astonj

SQLite.

If you decide to run it in production, enable WAL mode and Litestream.io for backups.

Can be convenient for single-node setups and side-projects because of no maintenance.

Yep, SQLite. Expect news on this forum about this.

Soon .

I prefer using PostgreSQL.

So my choices are either reformat my computer or use SQL lite.

How do you get to these conclusions?

You have many choices.

I have come to this conclusion because I am having problems with my asdf apparently and it’s looking like I have to reformat my OS as I use Linux.

I’m pretty sure asdf installs itself on a per-user basis. You can probably get away with making a new user.

They also have an uninstall guide:

If it’s for Postgres, there are many other ways to get it. I.e apt-get install on Debian/Ubuntu or a Docker container you could run.

You’re suggesting that I make a new user and see if that fixes my problem instead of reformatting my laptop

I am not sure if a new user would fix your problems, neither am I sure a reinstallation would.

You got a preconfigured system, without any support on how to actually use it. If the person who has set this up for you, is not available to explain the different things to you, then a reinstallation might solve some of your problems, but also create new ones.

In my opinion, you should get the person who set this up for you and ask for explanations. Or at least find someone in the neighborhood who has some experience in using Linux and some of the tooling to help you fix this. Here is a lot of opportunity to learn.

Though to get a little bit back to topic.

I do not think the question should be, whether there are databases that work well with phoenix (as the relevant library is ecto) but instead, you should ask, among this 5ish available, which one has the features I will need for the final product?