MySQL belongs to Oracle. That’s literally all you need to.know in order to avoid it.
Isn’t that the point of Postgresql. It’s basically an open source version of MySQL.
I’m sure there are some proprietary nonsense that MySQL has, but I’ve never needed it in 17 years
That is an insult to PostgreSQL. PostgreSQL was fully featured relational database even before it implemented SQL. It started much earlier tha MySQL.
And MySQL didn’t have proper transactions or data integrity constraints (including foreign keys) for long time, while calling itself an ‘SQL database’.
What year is this? No one should be using Mysql since MariaDB came about.
No one should be using MySQL since 2010.
Stop using mysql, you have postgres.
And mariaSQL
Hell, even SQLite is good enough for most small projects.
SQLite is underrated. I’ve used it for high traffic systems with no issues. If your system has a large number of readers and a small number of writers, it performs very well. It’s not as good for high-concurrency write-heavy use cases, but that’s not common (most apps read far more than they write).
My use case was a DB that was created during the build process, then read on every page load.
Wow, I never thought about storing build data in an SQLite file. That’s quite clever.
One of SQLite’s recommended use cases is as an alternate to proprietary binary formats: https://sqlite.org/appfileformat.html. Programs often store data in binary files for performance, but you get a lot of the same functionality included with SQLite (fast random access, concurrent usage, atomicity, updates that don’t need to rewrite the whole file, etc) without having to implement a file format yourself.
I’m not sure if this is still the case, but Facebook’a HHVM used to store the compiled bytecode for the whole site in a single SQLite database: https://docs.hhvm.com/docs/hhvm/advanced-usage/repo-authoritative/. Every pageload loaded the bytecode for all required files from the DB.
They also have a (one-time fee) encryption extension.
Fascinating read, I should definitely also make way more use of sqlite for little side projects.
Thanks for the link!
