Rendered at 16:13:53 GMT+0000 (Coordinated Universal Time) with Cloudflare Workers.
alexpadula 3 days ago [-]
Introducing the first major release of TideSQL for MySQL. A transactional storage engine built from first principles and on modern research that's write and space optimized, highly effective on reads, and offers parity with InnoDB. Do check it out, we would love your thoughts!
dofm 16 hours ago [-]
My thoughts: please, please get someone to rewrite this page from LLM poetry to a real person's writing.
handfuloflight 16 hours ago [-]
As for me, I've copied and pasted the text into Claude, prompted: "Distill key insights" and got everything I needed to know.
In fact... I read most of HN like this nowadays, including the comments.
dofm 15 hours ago [-]
This is really not better. Well… not much better.
I've spent my entire life reading, writing, condensing and explaining stuff, and I'm pretty good at it, but I find reading this stuff intensely tiring.
But my underlying concern remains. Why are people who want to communicate important ideas leaving it to Claude — which writes like an obscurantist gnome wizard from a bad fantasy novel — to do so, only to lead us to use LLMs to corral it into a less gnomic form?
People used to describe their own products in their own words.
handfuloflight 11 hours ago [-]
> This is really not better. Well… not much better.
That's just your unsubstantiated opinion. I'm saving time and getting the meat.
dofm 9 hours ago [-]
Is your own opinion more substantiated? Weird thing to say.
handfuloflight 3 hours ago [-]
It is actually, I provided the artifact and stated that it saves time and provides the substance.
dpark 36 minutes ago [-]
“Yes. My opinion is substantiated because it is my own.”
solatic 10 hours ago [-]
I think most of the market these days is running a managed database - AWS RDS, GCP CloudSQL, etc. Any news on when people could expect this to be a supported plugin?
alexpadula 4 hours ago [-]
Very much possible over time. Currently it’s not. We are working closely with MariaDB and Oracle on making TidesDB available in server releases through extended means. MariaDB you can already use TidesDB from version 11, included through their Foundry.
compiler-devel 15 hours ago [-]
Will it be available for MariaDB, too?
alexpadula 15 hours ago [-]
It is available for MariaDB 11.4.x forward to latest 13.x.x and offers real vector support where the MySQL plugin is still lacking though there are proposals in place.
bratao 15 hours ago [-]
Finally a replacement for RocksDB / MyRocks.
I want to move from MySQL to Postgres, but without a space optimized storage as the MySQL has in Percona, it is impossible to me.
alexpadula 15 hours ago [-]
Indeed! Postgres vacuum can be troublesome on lots of write and delete heavy workloads and no way to just set a table to another engine. TidesDB is highly efficient on amplification rather that be write, read, or space for an LSM based engine. Reads are also pretty great with our LSMB+tree hybrid architecture; You can read about TPC-C analysis against InnoDB in MariaDB (larger than memory) and see TidesDB keeping up and even surpassing InnoDB on this very heavy benchmark.
Is there some specific reason/feature why you would prefer Postgres? Or you just prefer it as a standard or some non-technical reasons? (The latter is valid too f course, just more subjective.)
alexpadula 4 hours ago [-]
I’d say Postgres is generally very fast for the average workload in analysis and the external extensibility is truly great, being able to use different index types for example. Postgres also has good support for modern SQL and many datatypes. With those 2 aspects the ecosystem is rather large thus lots of ways to extend Postgres. MySQL and MariaDB are now starting to expand their horizons in this regard.
sugarkjube 9 hours ago [-]
Is there also a comparison with innodb with compressed tables (Storage size/speed/cpu load/mem usage )? (I assume at least some of the benefit in storage/performance may be due to the compression being on by default)
alexpadula 4 hours ago [-]
For the analysis comparison question, yes many articles but because InnoDB does sync compression and not async like TidesDB it’s not performant, but there is analysis on our blog, and against RocksDB as well at library and server level.
alexpadula 4 hours ago [-]
For MySQL yes on by default, for MariaDB no off by default. In this articles analysis compression was on indeed.
sgarland 16 hours ago [-]
How does this differ from RocksDB / MyRocks?
alexpadula 15 hours ago [-]
MyRocks have been archived for MySQL. MyRocks in MariaDB is using a very old version of RocksDB in which is rather buggy. TideSQL is similar to MyRocks but it goes a lot further with it's features, trying to offer parity with InnoDB. TideSQL's core is using TidesDB the library which is a write, and space optimized storage engine written in C from first principles, so from the ground up.
popularonion 14 hours ago [-]
So if Meta stopped maintaining MyRocks, are they moving to a different solution?
hingo 4 hours ago [-]
My understanding is that Meta continues to use MySQL and specifically MySQL, but have decided they aren't investing in upgrading to the newer MySQL versions. And possibly their fork contains a lot of custom patches beyond just MyRocks. So as a consequence of this decision they no longer support MyRocks for newer versions of MySQL and otoh MySQL no longer supports the 5.x versions.
alexpadula 13 hours ago [-]
Not sure at the moment what they are moving to or have moved to. I just heard from Mark Callaghan few months ago about the archiving, not much besides that.
kumarvvr 15 hours ago [-]
Curious to know if MySQL has any distinct advantages over Postgres at this point.
otterley 13 hours ago [-]
Not needing a connection pooler (MySQL scales to thousands of connections via threads without breaking a sweat) and not having to deal with garbage collection (vacuuming) are two.
deepsun 11 hours ago [-]
"Why Uber Engineering Switched from Postgres to MySQL"
I love PostgreSQL, but the clustering story is definitely easier in MySQL land.
alexpadula 15 hours ago [-]
I mean, quite a bit. You use the right tool for the job. To use Postgres for everything is wrong to me. The beauty of MySQL based servers is the internal extensibility where Postgres is still rather lacking. MySQL and MariaDB are caching up on the external extensibility front.
kumarvvr 14 hours ago [-]
Could you please give me examples of this extensibility.
alexpadula 14 hours ago [-]
Of course MySQL has obviously the deep support for custom storage engines, then it has loadable functions, auth, component service and these are currently internal extensibility but going forward we are working on a way to manage this extensibility externally through a new proposal which I will be going over in the upcoming MySQL contributor summit in November. Postgres though highly externally extensible doesn't cut into the core like MySQL or MariaDB does thus making it hard to for example make TidesDB integration as TidesDB has to handle the MVCC, for example. OrioleDB is another example and it has to utilize a custom Postgres fork for this reason, the core not being very extensible, though I hear this is being worked on heavily.
Link: https://claude.ai/share/6cf78509-e283-49cc-89b1-c892bfce0641
In fact... I read most of HN like this nowadays, including the comments.
I've spent my entire life reading, writing, condensing and explaining stuff, and I'm pretty good at it, but I find reading this stuff intensely tiring.
But my underlying concern remains. Why are people who want to communicate important ideas leaving it to Claude — which writes like an obscurantist gnome wizard from a bad fantasy novel — to do so, only to lead us to use LLMs to corral it into a less gnomic form?
People used to describe their own products in their own words.
That's just your unsubstantiated opinion. I'm saving time and getting the meat.
https://tidesdb.com/articles/benchmark-analysis-hammerdb-tpc...
https://www.uber.com/us/en/blog/postgres-to-mysql-migration/