[pwmtr]

Do you mean writing something similar for MySQL or building a MySQL service at Ubicloud?

For the first one, the answer would be no, because I don't have any expertise on MySQL. I only used it years ago on my hobby projects. I'm not the best person to write something like this for MySQL.

For the second one, the answer would be maybe, but not any time soon. We have list of services that we want to build at Ubicloud and currently services like K8s have more priority.

[wg0]

I meant the second one. Thank you for your answer.

Second unrelated question that anyone might want to add to, why is MySQL falling out of favour in recent years in comparison to Postgres?

[tracker1]

Every time I've used MySQL for anything, I will come across something that annoys me. You can use ANSI-Quotes mode for tables, columns, etc, but when making a foreign key reference it has to be back-ticks.

UTF8 isn't, which is a holdover from during UTF8 design, but even then, it should have been retired and re-aliased from the next major release (as a breaking change, that wouldn't break much).

Magic (stylized) single-quotes work as apostrophes in queries, meaning you can't use simple escape logic if you're writing a custom client, and a whole new level risk of security bugs. Yeah, you should use parameterized queries, but still.

If your default indexing is case-insensitive, if you do an index on a binary field, it's going to be case-insensitive (which can/will cause annoying issues).

There are so many more one-off and analogies people have when working with MySQL. PostgreSQL by contrast has been far more consistent in the usage, development and application of query support. Custom enhancements and so many other features just work, and better.

[pixl97]

https://news.ycombinator.com/item?id=35906604

From just over a year ago. And honestly the recent reasons look like all the reasons why I moved away from it in the past.

[mxuribe]

> ...why is MySQL falling out of favour in recent years in comparison to Postgres

I'm curious about this myself! Anyone know, or care to share?

[pixl97]

Anecdotal evidence?

I used to work with/host lots of small php apps that tied in with MySQL. PHP has dropped in popularity over the years.

Add to this hosting for Postgres has become common so you're not tied to cheap hosting for MySQL only.

At least I think that the Oracle name being tied to MySQL made it icky for a lot of people that think the big O is a devil straight from hell. This is something that got me looking at Postgres way back when.

There's probably a myriad of 'smaller' reasons just like this that enforce the trend.

[mxuribe]

Thanks; makes sense!

[fcatalan]

Until I switched to Postgres 8 years ago I knew a lot about MySQL. I barely know anything about Postgres