frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

The perils of UUID primary keys in SQLite

https://andersmurphy.com/2026/06/05/the-perils-of-uuid-primary-keys-in-sqlite.html
16•emschwartz•2h ago

Comments

yepyoukno•2h ago
Perils of “UUIDv4”. Everyone knows that’s what UUIDv7 was really for, and you should always convert that to binary to optimize everything.
JSR_FDED•39m ago
Small nit: uuid7 is 128 bits (16 bytes) by definition. So there’s no need to convert it to binary. It already is. Unless you’re working with a stringified version of the uuid7.
yepyoukno•34m ago
Oh yes, I meant don’t store as an ID in its string format!
dumbledorf•1h ago
Wait how is sqlite doing a million inserts a second?
kg•1h ago
sqlite is really fast. I'm surprised it's only a million.
smitty1e•52m ago
':memory:'

https://sqlite.org/inmemorydb.html

JSR_FDED•45m ago
In batches
blopker•54m ago
UUIDs are way over used. There is almost always a better key to use, usually a bigint for databases. If you're making some kind of leaderless distributed data store, then maybe, but even then there are other ID sharding strategies I'd go for first depending on the constraints.

For a single database, bigints are smaller and faster, with less footguns.

UUIDs can be nice for an opaque public ID, however I'd still prefer something like a Sqid for space and usability.

bob1029•19m ago
I am finding UUIDs help a lot if your primary schema consumer is an LLM.

Inappropriate aliasing of integer keys allows for silent errors in queries because it will actually return some result a lot of the time. A UUID is immune to this problem. The model recognizes its mistake a lot more reliably when previously non-empty tables start showing up empty after attempting a join.

The intracies of modern camera lens repair (2024)

https://salvagedcircuitry.com/sigma-45mm.html
29•transistor-man•1h ago•0 comments

Show HN: ABC Classic 100 Rankings visualised

https://classic100.gotski.workers.dev/
4•gotski•6m ago•0 comments

Astronauts told to return to ISS after sheltering over air leak repairs

https://www.bbc.com/news/live/c4g44ew3g1kt
358•janpot•10h ago•231 comments

pg_durable: Microsoft open sources in-database durable execution

https://github.com/microsoft/pg_durable
320•coffeemug•9h ago•77 comments

Gemma 4 QAT models: Optimizing compression for mobile and laptop efficiency

https://blog.google/innovation-and-ai/technology/developers-tools/quantization-aware-training-gem...
266•theanonymousone•9h ago•86 comments

New method turns ocean water into drinking water, without waste

https://www.rochester.edu/newscenter/what-is-desalination-definition-ocean-water-704732/
252•speckx•10h ago•113 comments

Mouseless – keyboard-driven control of macOS/Linux/Windows

https://mouseless.click
453•riddley•2d ago•190 comments

Did Claude increase bugs in rsync?

https://alexispurslane.github.io/rsync-analysis/
302•logicprog•12h ago•302 comments

My Agent Skill for Test-Driven Development

https://www.saturnci.com/my-agent-skill-for-test-driven-development.html
130•laxmena•1d ago•51 comments

Gov.uk has replaced Stripe with Dutch provider Adyen

https://www.theregister.com/public-sector/2026/06/04/govuk-goes-dutch-on-payments-as-it-dumps-str...
345•toomuchtodo•8h ago•123 comments

The Quiet Numbers Station: Decoding Nineteen Years of GPS Cryptography

https://www.benthamsgaze.org/2026/06/02/the-quiet-numbers-station-decoding-nineteen-years-of-gps-...
62•lordgilman•12h ago•65 comments

Conventional Commits encourages focus on the wrong things

https://sumnerevans.com/posts/software-engineering/stop-using-conventional-commits/
265•jsve•9h ago•204 comments

Transformers are inherently succinct

https://openreview.net/pdf?id=Yxz92UuPLQ
89•brandonb•6h ago•30 comments

Ask HN: What was your "oh shit" moment with GenAI?

161•andrehacker•1d ago•383 comments

I tested every IP KVM in my Homelab

https://www.jeffgeerling.com/blog/2026/i-tested-every-ip-kvm/
237•vquemener•11h ago•65 comments

Launch HN: General Instinct (YC P26) – Frontier models on edge devices

45•guanming0717•9h ago•14 comments

"Maybe later" was a feature

https://arnorhs.dev/posts/2026-06-04/maybe-later-was-a-feature/
78•arnorhs•1d ago•25 comments

India's surprise baby bust

https://www.economist.com/leaders/2026/06/04/indias-surprise-baby-bust-is-a-warning-to-the-world
129•hakonbogen•10h ago•570 comments

Cooldown Support for Ruby Bundler

https://blog.rubygems.org/2026/06/03/cooldown-let-new-gems-be-vetted.html
143•calyhre•2d ago•37 comments

The perils of UUID primary keys in SQLite

https://andersmurphy.com/2026/06/05/the-perils-of-uuid-primary-keys-in-sqlite.html
16•emschwartz•2h ago•9 comments

Aging and Eye Problems

https://ldstephens.net/posts/aging-and-eye-problems/
51•speckx•7h ago•24 comments

Tracing a powerful GNSS interference source over Europe

https://arxiv.org/abs/2606.03673
361•mimorigasaka•17h ago•197 comments

C++: The Documentary

https://herbsutter.com/2026/06/04/c-the-documentary-released-today/
373•ingve•21h ago•271 comments

Inside FAISS: Billion-Scale Similarity Search

https://fremaconsulting.ch/blog/faiss
42•tohms•1d ago•3 comments

Mantine-datatable (and others) compromised – owner account suspended

https://github.com/icflorescu/mantine-datatable/discussions/813
60•justsomehuman•8h ago•23 comments

Redis 8.8: New array data structure, rate limiter, performance improvements

https://redis.io/blog/announcing-redis-8-8/
202•ksec•2d ago•92 comments

South Korean forums will need to scan every images with AI censorship tools

https://discuss.privacyguides.net/t/south-korean-online-communities-will-need-to-scan-every-image...
218•Cider9986•1d ago•132 comments

Show HN: Lowfat – pluggable CLI filter that saved 91.8% of my LLM tokens

https://github.com/zdk/lowfat
112•zdkaster•16h ago•58 comments

Changing how we develop Ladybird

https://ladybird.org/posts/changing-how-we-develop-ladybird/
811•EdwinHoksberg•18h ago•515 comments

Three of our worst VC stories

https://twitter.com/eastdakota/status/2062860530360959273
183•orgonon•6h ago•92 comments