Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
groot544283dMaria db is open source community based branched out of MySQL code. Pick Maria db.
C0D430624283dMariaDb is just MySQL with more regular updates.
If you know 1 you already know the other, although MariaDB does have a few quirks fixed that you may be used to having in MySQL for good and bad.
What they said.
Maria db just gets faster updates and has small quality of life things.
As for the headaches, just make sure your database design is good and that you mirror your structure.
Beware of triggers and collations, those two will fuck your day up.
Otherwise, I use local mostly for development and optimization.
Ps, I do optimization locally cause my work pc is slower, so if I get an increase there, I know it can't be a coincidence lol
starrynights895244283dThanks for the feedback guys. I guess I'll commit to Mariadb. Now if only we can get oracle to sell off the good parts of Java. 😉
I think I'm going to setup the database on the server as I may need to access it from different clients. Anything I need to look out for with security when setting up SQL for remote access?
starrynights895244283dAlso I dumped my Debian server as the package conflicts were causing my SQL database grief. To give RedHat credit, their yum and rpm packages are managed a lot better.
Your Job Suck?
Take a quick quiz from Triplebyte to skip the job search hassles and jump to final interviews at hot tech firms
Get a Better Job