5 ms·
As a hobby-projects-only developer, would there be any reason to switch from mariaBD to postgreSQL? Scalability is no issue for me (I don't have to scale). And
by gnur 13y ago
As a hobby-projects-only developer, would there be any reason to switch from mariaBD to postgreSQL?
Scalability is no issue for me (I don't have to scale). And lately I hardly write any queries myself because of django..
- andybak 13y agoYep. South is much happier with postgrSQL as it can do schema changes in a transaction and roll them back if there's a problem. MySQL will just leave you with a half completed schema change which you'll have to fix by hand.
- gnur 13y agoAh good to know, doing my research also tells me Django 1.7 will include migrations out of the box with schema change transactions as well. Thanks!
- raverbashing 13y agoFor your case, especially using the Django ORM, no reason whatsoever. Or, ok, there may be a reason, South used to not play so well with MySQL/MariaDB, this has improved over time but still may be a reason to use PostgreSQL (Or just don't bother and use SQLite, depending on your case it may be just fine)
- collyw 13y agoSouth still regularly complains at me for not using Postgress.
- raverbashing 13y agoYes, it complains, still, I'm not sure how much is truly "PostgreSQL is better" and how much is South not caring/not working around some issues. Or even how much is limitations on the Python or Django DB drivers (two separate things)
- DrJokepu 13y agoI don’t know anyone who has ever regretted choosing PostgreSQL or migrating to PostgreSQL. Not a single person. None.