1171
SQL Keys in Depth
The internet is full of dogmatic commandments for choosing and using keys in relational databases. At times it verges on a holy war: should you use natural or artificial keys? Auto-incrementing integers, UUIDs?
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 14,537 posts.
1172
Instant database clones with PostgreSQL 18
Learn how to clone PostgreSQL databases instantly using reflinks. Turn slow template copies into milliseconds with PostgreSQL 18's new file copy options.
1173
1174
Wake up! 16b
Released at the Outline Demoparty in May 2026, Ommen, NL An exploration of algorithmic density in 16 bytes of x86 assembly.
1175
1176
1177
Bug squash: An underrated interview question
I love bug squash interviews.
1178
SQL should be the default choice for data transformation logic
SQL should be the first option considered for new data engineering work. It’s robust, fast, future-proof and testable. With a bit of care, it’s clear and readable.
1179
1180
1181
Zig builds are getting faster
Andrew Kelley famously (or infamously, depending on your views) said "the compiler is too damn slow, that's why we have bugs." 1
1182
How Google Code Search Worked: Regex Matching with a Trigram Index (2012)
In the summer of 2006, I was lucky enough to be an intern at Google. At the time, Google had an internal tool called gsearch that acted as if it ran grep over all the files in the Google source tree and printed the results. Of course, that implementation would be fairly slow, so what gsearch actually did was talk to a…
1183
Moving efficiently in the CLI
A cheatsheet for moving efficiently in the CLI!
1184
A leap year check in three instructions
How to test for leap years (until year 102499) in the proleptic Gregorian calendar with just three 32-bit instructions, with detailed explanation of the bit-level tricks.
1185
Designing very large JavaScript applications
Originally published on my blog Industrial Empathy.
1186
1187
1188
Clocks for Software Engineers
If you have a software background and you want to pick up digital design,then one of the first things you need to learn about early on is the conceptof the c...
1189
The Making of Underrun – A WebGL Shooter in 13kb of JavaScript
I participated in this year's js13kGames , a JavaScript game development competition with a file size limit of 13kb, including code, assets and everything else. My entry was Underrun , a twin stick shooter using WebGL.
1190
Why are we templating YAML? (2019)
I was at cfgmgmtcamp 2019 in Ghent, and did a talk which I think was well received about the need for some Kubernetes configuration management as well as the solution
1191
Why Haskell?
Haskell is a great programming language with many features that make it easier to write robust software, and yet it is rarely taken up by software engineering teams. This essay aims to explain my views as to why Haskell is a great choice for programmers.
1192
If PHP Were British (2011)
PHP, as the result of a spectacular error of judgement, appears to be written in US English. How do we developers ensure the traditions of the British Empire continue to be upheld, even in the digital age?
1193
1194
All you may need is HTML
Readers occasionally request which static HTML generator is used by fabiensanglard.net , and if they can take the same stylesheet/ fonts to start their own blog. I usually send back the whole 134 lines of gen.php [1] and invite them to copy whatever they need to get started [2] .
1195
Maybe getting rid of your QA team was bad
If you have a QA team, please read this and give them a large raise.
1196
1197
Code that will break in Python 4
With the end of support for Python 2 on the horizon ( in 2020 ), many package developers have made their packages compatible with both Python 2 and Python 3 by using constructs such as:
1198
How to contribute to an open source project on GitHub
If this is your domain name you must renew it immediately before it is deleted and permanently removed from your account. To renew this domain name visit NameBright.com
1199
Facebook senior software engineer interview
I have been working at Facebook as a software engineer for a while now. During this time, I have got different inquiries from friends and…
1200
Node.js packages don't deserve trust
Another week, another npm supply chain attack . Yikes! People on hacker news are wringing their hands about what should be done. The problem seems dire.