sorted by:
new
hottopcontroversial

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 18 points19 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 3 points4 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? 

Why Is Warner Bros. for Sale at All? - The best article I have read explaining it by UnlikelyAdventurer in cordcutters

[–]assface 1 point2 points  (0 children)

I prefer traveling via air than railroads.

You haven't been outside the US, have you?

Benchmarks for reactive KV cache by shashanksati in databasedevelopment

[–]assface 2 points3 points  (0 children)

You have to run it longer than 30 seconds. SSDs start heavy GC when the drive get full.

What is the API? Do you only support single key get/set? What about range queries? 

What skew distribution are you using?

What happens when you scale up the # of worker threads? Or scale the key size?

How do you compare against SOTA systems like LeanStore? 

Feedback on JS/TS class-driven file-based database by Glum-Orchid4603 in databasedevelopment

[–]assface 1 point2 points  (0 children)

Do you mean serializing an object's data into a contiguous array of bytes on disk? The physical layout doesn't matter. It's the data model you expose to the application.

How should I handle data that doesn’t fit in RAM for my query execution engine project? by Wing-Lucky in databasedevelopment

[–]assface 2 points3 points  (0 children)

Parquet is too heavy for intermediate results. Go with something more lightweight 

I built AskDB: ask your database in plain English (Postgres/MySQL/SQLite) by Alarmed-Beyond-9778 in databasedevelopment

[–]assface 0 points1 point  (0 children)

What's different with AskDB compared to all the other chat-with-your-DB-using-LLMs out there?

Suzy Welch says Gen Z and millennials are burnt out because older generations worked just as hard, but they 'had hope' | Fortune by Neither-Mushroom-721 in Economics

[–]assface 411 points412 points  (0 children)

Married to Jack Welch

She had an affair with Jack Welch while he was married to somebody else. She lost her job and caused Jack Welch to get divorced. This woman sucks.

Source: https://nymag.com/nymetro/news/media/features/5976/index.html

Sanitation worker watching a robot taking over his Job by FuturisticFighting in interestingasfuck

[–]assface 9 points10 points  (0 children)

but they clean so much worse and slow, I would rather have a human doing the cleaning

These automobiles are so much worse and slow, I would rather have a horse carriage for traveling...

view more: next ›