News for hackers. Stuff that matters.

A comment on Why TigerBeetle is the most interesting database in the world. Parent comment

Re:Why TigerBeetle is the most interesting database in the w... by cmrdporcupine on Wednesday October 01, 2025 @10:12AM (#45437967)
No, I'm arguing in fact the opposite and you'll have to prove the point wrong instead of drive-by insisting on this. The point of Codd's original paper was to separate concerns about data storage from its representation and to propose an elegant representational & transformation & query model based on first order logic and I believe he succeeded.

SQL was the first serious attempt to translate this into a working system, and it's full of warts, but the underlying model it is reaching towards retains its elegance.

But most importantly the principle of not tying the structure of data to its storage model is absolutely key. Not least because we can iteratively and flexibly improve the storage model over time, and not be stuck with decisions that tie us to one particular structure which is the problem that 1960s "network" and "hierarchical" databases (and modern day "key value" or "NoSQL" databases) cause.

[ Parent | on HN ]
Re:Why TigerBeetle is the most interesting database in the w... by 9rx on Wednesday October 01, 2025 @10:21AM (#45438068)
The opposite of what? There is no contention with Codd's original paper. I'd suggest that Codd's Alpha paper was lacking in the same way SQL struggles, but that's a bit orthogonal to what you seem to be trying to say. I know its a bit confusing as SQL tries to name many different, independent things with the same name, but when confused it is best to become unconfused, not go off to la-la land.
[ Parent | on HN ]
Re:Why TigerBeetle is the most interesting database in the w... by cmrdporcupine on Wednesday October 01, 2025 @10:33AM (#45438185)
Notably, you edited your comment after my reply :-)
[ Parent | on HN ]
Re:Why TigerBeetle is the most interesting database in the w... by 9rx on Wednesday October 01, 2025 @10:35AM (#45438216)
Strangly off-topic, but if that's where you want to go, what's notable about that? Given the confusion, there should have been no rush to reply before some minor adjustments were made. That is how you ended up here in the first place. Understand first, the consider replying.
[ Parent | on HN ]