Post AxBPnCVTrUkl848Meu by icculus@mastodon.gamedev.place
(DIR) More posts by icculus@mastodon.gamedev.place
(DIR) Post #AxBPn7JbAFHH1lXIwa by mcc@mastodon.social
2025-08-14T17:02:48Z
0 likes, 0 repeats
[BIKESHED COLOR ADVICE REQUEST]I do all my self-hosting on a couple of VPSes. Because I have been using a single configuration for a couple decades, they both use MySQL for all databases.Do you want to try to convince me I should switch from MySQL to PostgreSQL? If I should switch, why?
(DIR) Post #AxBPn8Gnc8dHzNEaDg by icculus@mastodon.gamedev.place
2025-08-14T22:41:31Z
0 likes, 0 repeats
@mcc I'm slowly working on moving all my MySQL things to sqlite3, since none of them are particularly heavy lifts and MySQL is a giant pain in the ass...but I'm wondering if I should be talked out of this before I discover I regret it.
(DIR) Post #AxBPn9M9ZiVfMGkNCi by mcc@mastodon.social
2025-08-14T22:53:11Z
0 likes, 0 repeats
@icculus everyone's trying to convince me to use sqlite… apparently it's not uncommon for web stuff now ?!
(DIR) Post #AxBPnAYF8Fm543PXge by icculus@mastodon.gamedev.place
2025-08-14T22:57:56Z
0 likes, 0 repeats
@mcc My (POSSIBLE TOTALLY INCORRECT) attitude is that if you don't have to scale to multiple redundant database servers, sqlite will work well for just about anything you do, has bindings for just about any programming language, and it's just a single C file worth of code and a single data file for the database that you can move/backup/access trivially.And it's battle tested on just about everything that qualifies as a computer across the planet, including web stuff.
(DIR) Post #AxBPnBUNe6HLyMbyIy by mcc@mastodon.social
2025-08-14T23:06:49Z
0 likes, 0 repeats
@icculus I just can't fathom giving up the ability to run a second process??!
(DIR) Post #AxBPnCVTrUkl848Meu by icculus@mastodon.gamedev.place
2025-08-14T23:22:53Z
1 likes, 0 repeats
@mcc It has locking, two processes can use the database at the same time.
(DIR) Post #AxBPnCanXj0TOYcbwm by mcc@mastodon.social
2025-08-14T17:03:48Z
0 likes, 0 repeats
Follow-up question: If I switched out MySQL for MariaDB, is it a drop in replacement? Would migrating my databases be any harder than a mysqldump? Would I have to change my ancient DBI/DBD-based Perl Scripts?