ティージェーグレェ「teajaygrey」 on Nostr: npub14d70x…zdm4s I've run MySQL way too much and would avoid it if at all possible. ...
npub14d70xk632yuqshz7hdrnnj79j3yufrphy4u7ryekmpr7vztwvf5q8zdm4s (npub14d7…dm4s) I've run MySQL way too much and would avoid it if at all possible.
I've even slept on the couch of one of the former MySQL creators, Brian Aker. No beef with him, though I think once Sun was sold to Oracle, most of the original people who contributed to it kind of left the building?
I've had employers pay for Percona's extra mojo for MySQL and found it too, lacking in many ways that would really make this weary burnt out sysadmin's life easier.
Postgres and SQLite don't seem to get enough love IMHO, but sometimes (at least for me) such decisions were made long ago and migration to another SQL implementation is not in the cards.
Absolutely avoid at all costs: MS-SQL. Every place where MSDE is used, IMHO would be better served by SQLite too. Albeit, MS has done worse, everything with JET (which includes Exchange) is fundamentally horrific.
Sybase I thankfully haven't touched in prod in decades, but it was IMHO way too popular for way too long, perhaps because NeXT bundled it once upon a time or something inane like that?
For those who can forgo SQL, LMDB isn't exactly the "new hawtness" anymore, but is certainly way better than venerable BDB, and even cooler: LumoSQL is basically breathing new life into the SQLightning project (which was SQLite with LMDB) so I am keen to see how that shapes up over time, but when I last looked at it, it was very much a work in progress and not yet copasetic on any BSDs.
I've even slept on the couch of one of the former MySQL creators, Brian Aker. No beef with him, though I think once Sun was sold to Oracle, most of the original people who contributed to it kind of left the building?
I've had employers pay for Percona's extra mojo for MySQL and found it too, lacking in many ways that would really make this weary burnt out sysadmin's life easier.
Postgres and SQLite don't seem to get enough love IMHO, but sometimes (at least for me) such decisions were made long ago and migration to another SQL implementation is not in the cards.
Absolutely avoid at all costs: MS-SQL. Every place where MSDE is used, IMHO would be better served by SQLite too. Albeit, MS has done worse, everything with JET (which includes Exchange) is fundamentally horrific.
Sybase I thankfully haven't touched in prod in decades, but it was IMHO way too popular for way too long, perhaps because NeXT bundled it once upon a time or something inane like that?
For those who can forgo SQL, LMDB isn't exactly the "new hawtness" anymore, but is certainly way better than venerable BDB, and even cooler: LumoSQL is basically breathing new life into the SQLightning project (which was SQLite with LMDB) so I am keen to see how that shapes up over time, but when I last looked at it, it was very much a work in progress and not yet copasetic on any BSDs.