News for hackers. Stuff that matters.

A comment on Hctree is an experimental high-concurrency database back end for SQLite. Parent comment

Re:Hctree is an experimental high-concurrency database back ... by amluto on Wednesday January 18, 2023 @11:18PM (#34436649)
I have an absolutely horrifying Python script that makes a little sort-of-container that spins up a brand new MySQL instance, initializes it with a provided set of statements (from mysqldump), and runs it. And cleans it up when it’s done.

And I have a wrapper that does it in a shell.

This makes it possible to run MySQL-dependent tests, in parallel, on a dev machine, without too much misery.

(MySQL is awful. Don’t use it for new designs. MariaDB isn’t obviously better. AWS RDS MySQL is, in my considered opinion after wasting days on it, even worse. RDS CANNOT INGEST THE OUTPUT OF mysqldump WITHOUT ILL-CONSIDERED AND POORLY DOCUMENTED KLUDGES!!! WTF!! Don’t get me started on how defective every MySQL replication mode is.)

[ Parent | on HN ]
Re:Hctree is an experimental high-concurrency database back ... by LAC-Tech on Wednesday January 18, 2023 @11:34PM (#34436726)
(Don’t get me started on how defective every MySQL replication mode is.)

I was actually reading up on this this the other day (doing a bit of a breadth first search of multi-master replication in industry).

I thought the way it worked was... interesting. Sounds like it's just as interesting in production.

[ Parent | on HN ]
Re:Hctree is an experimental high-concurrency database back ... by hot_gril on Thursday January 19, 2023 @12:17AM (#34436967)
Yeah, I use Postgres. It's good. MySQL only has the advantage of being offered by more cloud providers and thus being cheaper sometimes.
[ Parent | on HN ]
Re:Hctree is an experimental high-concurrency database back ... by tehbeard on Thursday January 19, 2023 @08:31AM (#34440047)
Doesn't MySQL also not need you to configure a bouncer/proxy if you want more than a dozen connections at a time?
[ Parent | on HN ]
Re:Hctree is an experimental high-concurrency database back ... by hot_gril on Thursday January 19, 2023 @12:29PM (#34442996)
Postgres in my experience can handle like 100 connections with the default config I get installing it on my Ubuntu server, but at some point you want pg-bouncer, and I vaguely remember MySQL having higher limits. Idk, it's been a while cause I've almost always limited the number of connections in my own code instead.
[ Parent | on HN ]