Earlier quoted context omitted.
I did not realize MySQL was also named after one of his kids.
Yeah, "My" is actually pronounced wrong by 99% of all MySQL users.
[deleted]
K1 Buys MariaDB
31–40 of 94 posts
Re: K1 Buys MariaDB
#32What are some reasons to use MariaDB over PostgreSQL?
They’re both great systems but there are a few differences primarily in small ways for most applications: Maria supports partitioning, Postgres (as of my last knowledge) does not. Unstructured data is more flexible in Maria natively, but Postgres can support it in a variety of ways. You can find lists and lists of head to head comparisons out there which will highlight all of the niche differences that each brings ov…
> Maria supports partitioning, Postgres (as of my last knowledge) does not.
PostgreSQL's manual indicates that partitioning is a thing[1]. Is the something different than what you're thinking of?
One of my projects has the need to drop millions of rows a month based on the time period, and I've been considering a switch to postgres because they also have a module that will do that automatically.
What am I missing?
[1] https://www.postgresql.org/docs/current/ddl-partitioning.htm...
Re: K1 Buys MariaDB
#33What are some reasons to use MariaDB over PostgreSQL?
They’re both great systems but there are a few differences primarily in small ways for most applications: Maria supports partitioning, Postgres (as of my last knowledge) does not. Unstructured data is more flexible in Maria natively, but Postgres can support it in a variety of ways. You can find lists and lists of head to head comparisons out there which will highlight all of the niche differences that each brings ov…
> Maria supports partitioning, Postgres (as of my last knowledge) does not.
Modern versions of postgres have all the partioning features you'd expect (except automatic ranged partion creation)
Re: K1 Buys MariaDB
#34Earlier quoted context omitted.
> All that big facebook and apple data is happening in cassandra (and foundationdb for apple) Not sure about Instagram, but I can tell you with complete confidence that Facebook proper (meaning specifically Facebook, not the rest of Meta) moved away from Cassandra well over a decade ago. They originally used Cassandra for FB messages / Messenger, but soon migrated to HBase and then over to MySQL / MyRocks.
That is not at all surprising. We all know they have the resources to find a solution to their massive data problems.
yep and the solution is sharded MySQL
Re: K1 Buys MariaDB
#35What are some reasons to use MariaDB over PostgreSQL?
From the experience of my one man big web project with 12 languages I had a hard time setting up a search that ignores things like éê from other languages in postgres while mariadb innodb just ignores it.
Re: K1 Buys MariaDB
#36For those who are using MariaDB in a business context: does this make you more or less likely to choose it for your next project? I don't know anything about K1, so all I have is confusion (and a sudden urge to switch entirely to postgres).
From my POV, it's a supplier that is no longer beholden to shareholders demands for profit. A platform and service that can operate using customer sourced revenue and respond to market demand without a profit driven board is a big win for everyone while funding development and maintenance of a great open source project.
I think that’s exactly the wrong impression I get. Private equity is going to cause them to quickly get to better profitability through price increases, layoffs, and reduced R&D.
Re: K1 Buys MariaDB
#37For those who are using MariaDB in a business context: does this make you more or less likely to choose it for your next project? I don't know anything about K1, so all I have is confusion (and a sudden urge to switch entirely to postgres).
I’d say less. This acquisition screams that some MBA looked at their financials, saw money left on table, likely by not completely screwing over customers, and said, let’s do this! Think Broadcom/VMware on smaller scale.
You don’t put yourself in debt and replace the CEO unless you see some value not currently being realized.
They might even try license shenanigans but with GPLv2, not sure what they can do.
Re: K1 Buys MariaDB
#38Only question is will it remain open source and free.
MariaDB Server is GPL and must always remain GPL, as it's a fork of MySQL which was also GPL. Also the MariaDB Foundation is separate from the commercial/enterprise entity MariaDB plc. This article is about the latter being taken private.
This code base has been sold like 3x now and is still around.
Re: K1 Buys MariaDB
#39Monty needs a new kid for his next db https://en.m.wikipedia.org/wiki/Michael_Widenius
He already has Max. MaxDB sounds like good name tbh.
Re: K1 Buys MariaDB
#40What are some reasons to use MariaDB over PostgreSQL?
Scale and ease of “sysadmin” level management for things such as clustering, replication, etc.
Some of that will be personal preference but I’ve never found administration of a Postgres database cluster to be nearly as intuitive as MySQL/MariaDB.