Hi! I'm tasked with migrating a existing db project from a proprietary database to "a better solution" as the current one is becoming quite unstable due to various bugs and the fact that it reached EOL years ago.<p>The workflow is pretty simple: mass update existing records or appending new records once in a while (this will be done in a controlled fashion invoked by someone - no services) -> do some ETL work -> re-build existing tables from source after doing some join magic -> export tables for delivery to customers.<p>Tables have around 10 to 100 million rows and 10 to 300 fields (will probably normalize a bit..) The data is relational and as for now the size is ~400GB which I expect to grow around 3% each time. There wont be much reads as the tables will be exported for further process and the the writes will be in a controlled fashion as stated above.<p>I'm looking at mysql and postgresql - which one would you choose? Or something else?
postgrsql's future is pretty safe, whereas MariaDB/MySQL was pretty worrying for a while.<p>pgsql is closer to the (SQL) standard and has a rock-solid track record.<p>However, given the size of your project, you might want to test both in "real" conditions, see which ones work correctly. You should perhaps even call for a contractor.