What other databases work with Phoenix Framework besides PostgreSQL and I know about MySQL, MySQL lite, MongoDB.
1 Like
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: How to set up Elixir dev environment on Linux? - #7 by AstonJ
4 Likes
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.
6 Likes
Yep, SQLite. Expect news on this forum about this.
Soon 
.
11 Likes
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.
3 Likes
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.
1 Like
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?
1 Like
What about a complete reformat of my PC and reinstalling Ubuntu all over again?
I think it will just swap your current problems with a different set of problems.
In your project, there is specified that it needs an old OTP version, that might be for a reason, or it might be just because no one ever tried an update.
Whether or not building this project with a newer version of erlang is not a given, neither is it a given that it would work with an older. You will still have problems getting the correct version to run properly.
You seem to be new to linux and maybe are also new to elixir and even programming. Learning all at once is very likely overwhelming.
I still think that a mentor who can be in the same room as you would be the best thing, and that you should learn the things one after the other.
1 Like
If you’re just starting out and you have nothing to lose on the old machine, I say there’s nothing wrong with a fresh start.
Sometimes things get really confusing when you first start to go down these rabbit holes. Wiping the slate clean gives you a chance to try again, without having to worry about the mistakes you made along the way. Just make sure you’re a little more careful this time. 
My recommendations:
- Use asdf to install Erlang/Elixir
- Use apt (the Ubuntu package manager) to install the Postgres server and client tools. (I use Docker images, but that’s an extra layer of complexity to understand.)
Good luck! Have fun and break stuff!
1 Like
If you have a botched asdf installation, shouldn’t the first step being removing and reinstalling asdf?
1 Like
That could be an option, I would need to learn how to do that. Thank you for this idea.
MS SQL Server
All my corporate clients run this database.
Hence Tds works well for all my elixir apps.
I usually use Postgresql and Sqlite3 but really wish if Elixir support Oracle as the enterprises we deal with mostly have this as the database and options like FDW is not accepted by them.
2 Likes
Sorry, but I don’t understand. What is the problem with running multiple database systems on the same machine? I’m biased towards PostgreSQL, but I have had both PostgreSQL and MySQL/MariaDB running on the same machine before without any issues. You could just not start either at bootup and then just fire up the one you need at the time. I don’t see why you would need to reinstall your whole OS just to change database server. Both servers are available for most modern operating systems.
IIRC, some KDE component uses MariaDB for something so I’m probably running it currently, but I didn’t intentionally install it. I always use PostgreSQL for my development work.
2 Likes
Interesting. I tried to get TDS working wih MS SQL, but I couldn’t get it to compile.
