Transferring a database from SQLite to MySQL or PostgreSQL?

Question

Database

I am writing a small site in django, by default I use the SQLite database and somehow did not think about another. Now the question is, if in the future, for some reason, I have to move to a more "stronger" database - like MySQL or PostgreSQL, how painful will the transition be? Or is it just a conversion without problems? Or can you now specifically begin to regret that you didn’t think about it earlier and didn’t connect MySQL or PostgreSQL from the very beginning?

Answer 1

It's better to connect PostgreSQL right away, it's the best for django. And SQLite can be played like that, well, or for development (although I immediately connect PostgreSQL during development), it is not very designed for competitive access.