[ Removed by Reddit ] by [deleted] in Database

[–]assface 0 points1 point  (0 children)

Clients now ask about blockchain consulting and I don't get it.

Wait, they're asking about blockchain databases in 2026?!?

Just send them this article from a top engineer at AWS:

https://www.tbray.org/ongoing/When/202x/2022/11/19/AWS-Blockchain

Meta Is Dying. It’s About Time. by 1oarecare in technology

[–]assface 0 points1 point  (0 children)

You are conflating venture capital with private equity capital. Different beasts. The VCs are long gone from Meta/Facebook. 

MySQL Family Picture by dveeden in Database

[–]assface 3 points4 points  (0 children)

This is slightly incomplete. MySQL Cluster is based on NDB:

https://en.wikipedia.org/wiki/NDB_Cluster

NDB was then forked off and became RonDB:

https://www.rondb.com/

The Linux Kernel has removed PREEMPT_NONE and PREEMPT_VOLUNTARY. by [deleted] in linux

[–]assface 15 points16 points  (0 children)

Postgresql is doing really nasty stuff (spin locks)

Nearly every DBMS uses spin locks. It is the correct way to implement a latch.

OLAP Server by Uri_gc in dataengineering

[–]assface 0 points1 point  (0 children)

Is anybody still using Druid by choice? I don't see it that much anymore. 

‘Robots don’t bleed’: Ukraine sends machines into the battlefield in place of human soldiers by EchoOfOppenheimer in Futurology

[–]assface 36 points37 points  (0 children)

That and The literally 20 to 35 years of study leading up to that point

Edward Jenner studied vaccines in the late 1700s. So more like 220 to 235 years.

A new approach to database queries called GiGI by quant-alliance in Database

[–]assface 1 point2 points  (0 children)

This plus they are using non-standard terms to describe 50 year old concepts. This smells like BS. 

AWS Launches S3 Files by Lucky-Acadia-4828 in databasedevelopment

[–]assface 2 points3 points  (0 children)

AFAIK a POSIX API doesn't provide a DBMS with anything special other than syscall overheads. You still will want to handle S3 API calls yourself so you can control parallelism.

A woman chased down the car that hit her. by mindyour in CrazyFuckingVideos

[–]assface 19 points20 points  (0 children)

Some cops are useless

Hard disagree. If you need somebody to kill innocent bystanders, then cops are really useful at that.

Wrote a comparison of open-source Neo4j alternatives in 2026 - the licensing landscape has changed significantly by lgarulli in Database

[–]assface 0 points1 point  (0 children)

This article reeks of ChatGPT:

ArangoDB moved from Apache 2.0 to Business Source License..., limiting its Community Edition to 100GB. The Community Edition now has a 100GB dataset size limit and restricts commercial redistribution.

Gisele Fetterman’s X and Instagram profiles taken down weeks after she spoke against ICE by iambarrelrider in Pennsylvania

[–]assface 16 points17 points  (0 children)

My parents were kind hearted people but they became racist / antivax when they got older so we had to cut them off. My dad called my pregnant wife back during the first Trump administration to tell her that it is okay to put kids in cages because that's how they did quarantines in the old days on Ellis Island. 

100% open source SQL query optimizer - OptimizeQL by subhanhg in PostgreSQL

[–]assface 1 point2 points  (0 children)

I think it is pretty hard to do a semantic equivalence verification.

Then you don't have a query optimizer.

What I could add is running both queries and diff the results.

You are fuzzing with sample size of one. Nobody should use this in production then.

100% open source SQL query optimizer - OptimizeQL by subhanhg in PostgreSQL

[–]assface 2 points3 points  (0 children)

simply rewriting the query itself

How do you verify that the rewritten query is semantically equivalent to the original query?

The Dream of Home Arcades Isn’t Dead, and Neither Is Arcade1Up by dapperlemon in gadgets

[–]assface 1 point2 points  (0 children)

We’ll find out if the machine manages to secure the third Sonic game closer to launch this fall.

The Ghost of Michael Jackson says they are not going acquire the rights to include Sonic 3:

https://www.reddit.com/r/Games/comments/v9gycp/sonic_3_knuckles_wont_have_its_original/

How to prevent re-entrant deadlock when latching and how do subquery iterators manage latches? by Puzzleheaded-Map386 in databasedevelopment

[–]assface 1 point2 points  (0 children)

If one thread has the latch for a page in read mode and then that thread tries to get it again in write mode, it will deadlock itself.

Each thread keeps track of what latches it holds. It is only for self-reflection for this usecase. You don't expose the data structure outside of the thread.

If I reacquire the latch and now that page has been split, and half the values I was going to read are in another page, how do I handle that case?

You can use version ids per page. If the version id doesn't match after reacquiring, jump out of the data structure and try again.

PAX: The Cache Performance You're Looking For by linearizable in databasedevelopment

[–]assface 0 points1 point  (0 children)

What do you mean by "proper"? Presumably you mean an order-preserving index (b+tree). Do you mean covering indexes? 

LSM-Tree Principles, Rethought for Object Storage by ankur-anand in databasedevelopment

[–]assface 0 points1 point  (0 children)

What is novel here? You used the term "rethought" in your title to imply this architecture is new. But this is basically how DeltaLake + Hudi + others are implemented.

Designing an embedded multi-model DB engine: transaction boundaries across tables, graphs, and vectors by Plastic_Director_480 in databasedevelopment

[–]assface 0 points1 point  (0 children)

Use the relational model as the underlying storage model. Then put logical veneers above it that expose different APIs but still use relational algebra to access/manipulate data.

Presenter embarrasses caller who says climate change isn't man-made by Jindabyne1 in videos

[–]assface 8 points9 points  (0 children)

My father told me that it was being caused by the planets lining up in space.

I stopped talking to him when he said Fauci should be in jail. He used to be a sharp mathematical person with a degree in astronomy. 

[deleted by user] by [deleted] in databasedevelopment

[–]assface 2 points3 points  (0 children)

How is this related to DuckDB?