Hacker News on Friday, 5 July 2024

PostgreSQL and UUID as Primary Key(maciejwalkowiak.com)

387 points by taubek 2 years ago | 296 comments

A blog post by Maciej Walkowiak discussing the use of UUIDs as primary keys in PostgreSQL, including storage and performance considerations, with Java examples.

Put the DVD logo in the corner (2023)(eieio.games)

381 points by EndXA 2 years ago | 74 comments

A developer's game diary post about building a PICO-8 arcade game where you steer the bouncing DVD logo into the corner.

Let's stop counting centuries(dynomight.net)

358 points by surprisetalk 2 years ago | 357 comments

A Dynomight essay arguing that people should stop referring to centuries by ordinal numbers like "18th century" and use clearer date ranges such as "the 1700s" instead.

Ente Auth: open-source Authy alternative for 2FA(ente.io)

350 points by memset 2 years ago | 182 comments

Product page for Ente Auth, an open-source two-factor authenticator app with end-to-end encrypted backups, pitched as an Authy alternative.

I have no constructor, and I must initialize(consteval.ca)

286 points by cyber1 2 years ago | 181 comments

Starcraft (A History in Two Acts)(filfre.net)

268 points by dmazin 2 years ago | 147 comments

Show HN: I’ve made a cheaper SEO research tool(withtelescope.com)

242 points by kulhavy 2 years ago | 98 comments

Tao Te Ching translated by Ursula Le Guin (1997)(github.com)

241 points by martythemaniak 2 years ago | 104 comments

Radio Garden(radio.garden)

238 points by peterburkimsher 2 years ago | 54 comments

How I turned seemingly 'failed' experiments into a successful PhD(science.org)

170 points by bookofjoe 2 years ago | 90 comments

Moving to a RTOS on the RP2040(blog.brixit.nl)

160 points by lupyuen 2 years ago | 91 comments

Space Age release date(factorio.com)

153 points by franknord23 2 years ago | 52 comments

The Software Crisis(wryl.tech)

152 points by todsacerdoti 2 years ago | 160 comments

Detect Migrating Birds with a Plastic Dish and a Cheap Microphone(spectrum.ieee.org)

142 points by cyberlimerence 2 years ago | 25 comments

I was at AMD in the mid-late 2000s helping design CPU/APU/GPUs(twitter.com)

142 points by jxub 2 years ago | 93 comments

DuckDB Community Extensions(duckdb.org)

128 points by isaacbrodsky 2 years ago | 15 comments

YouTube's eraser tool removes copyrighted music without impacting other audio(techcrunch.com)

127 points by thunderbong 2 years ago | 90 comments

Mimicking the cells that carry hemoglobin as a blood substitute(science.org)

110 points by rbanffy 2 years ago | 54 comments

Firefox "Copy" has been inconsistent and broken for 8 months(bugzilla.mozilla.org)

105 points by 462436347 2 years ago | 65 comments

Research into homeopathy: data falsification, fabrication and manipulation(skeptic.org.uk)

103 points by zaik 2 years ago | 126 comments

Preserving a floppy disk with a logic analyzer and a serial cable(chzsoft.de)

98 points by jnord 2 years ago | 24 comments

Why Vivaldi won't follow the current AI trend?(vivaldi.com)

96 points by botanical 2 years ago | 98 comments

Volcanoes can affect climate(usgs.gov)

88 points by thunderbong 2 years ago | 73 comments

"Technical" Skills(sashalaundy.com)

86 points by todsacerdoti 2 years ago | 86 comments

VPN ban is strangling communication in Myanmar(irrawaddy.com)

84 points by PaulHoule 2 years ago | 30 comments

The magic of small engineering teams(newsletter.posthog.com)

80 points by surprisetalk 2 years ago | 32 comments

Tiny robots with a big impact: microrobots for single-cell handling(advancedsciencenews.com)

77 points by mdp2021 2 years ago | 10 comments

Harvester pulls 1.5 gallons of drinking water from arid air per day(newatlas.com)

74 points by Brajeshwar 2 years ago | 78 comments

Rogers networks reliability and resiliency assessment after 2022-07-08 outage(crtc.gc.ca)

74 points by threesevenths 2 years ago | 76 comments

General Electric HTRE-3 Nuclear Jet Engine(planehistoria.com)

71 points by bane 2 years ago | 58 comments

Trackmania Nightmares(hallofdreams.org)

71 points by luu 2 years ago | 19 comments

Philip Morris International has funded Japanese academics(bath.ac.uk)

67 points by XzetaU8 2 years ago | 25 comments

Programming in Unison(lwn.net)

66 points by sohkamyung 2 years ago | 2 comments

Antidotes for Melancholy in Early Modern England(folger.edu)

64 points by benbreen 2 years ago | 2 comments

How I swapped my ivory tower for the world of science fiction(nature.com)

63 points by bookofjoe 2 years ago | 63 comments

Constantine: modular, high-performance, zero-dependency cryptography stack(forum.nim-lang.org)

63 points by michaelsbradley 2 years ago | 9 comments

Cloudflare 1.1.1.1 incident on June 27, 2024(blog.cloudflare.com)

63 points by el_duderino 2 years ago | 18 comments

Debian GNU/Hurd now can compile 71% of the packages from the Debian archive(gnu.org)

59 points by pjmlp 2 years ago | 21 comments

UK election day 2024: traffic trends and attacks on political parties(blog.cloudflare.com)

58 points by emot 2 years ago | 3 comments

Fresh wind blows from historical supernova(u-tokyo.ac.jp)

57 points by geox 2 years ago | 4 comments

7-Eleven is reinventing its food business to be more Japanese [video](youtube.com)

57 points by indigodaddy 2 years ago | 44 comments

Goldman on Generative AI: doesn't justify costs or solve complex problems [pdf](web.archive.org)

56 points by edzitron 2 years ago | 18 comments

Refined Input, Degraded Output: The Counterintuitive World of Compiler Behavior(dl.acm.org)

54 points by matt_d 2 years ago | 1 comments

Deactivating an API, one step at a time(apichangelog.substack.com)

50 points by bpedro 2 years ago | 38 comments

A Louisiana gas plant sea wall shows challenges of flooding, energy demand(washingtonpost.com)

46 points by howard941 2 years ago | 37 comments

Why Michigan Still Uses a Ford Model T for Official Government Business(theautopian.com)

45 points by jshprentz 2 years ago | 35 comments

Vertical-Align: All You Need to Know (CSS) (2014)(christopheraue.net)

45 points by not_a_boat 2 years ago | 4 comments

Gardeners can grow a genetically modified purple tomato made with snapdragon DNA(npr.org)

44 points by NoRagrets 2 years ago | 39 comments

The IBM Magnetic Tape Selectric Composer(blog.bruchez.name)

44 points by kens 2 years ago | 18 comments

Five common English words we don't know the origins of–including 'boy' and 'dog'(phys.org)

42 points by bikenaga 2 years ago | 42 comments

ChatGPT just (accidentally) shared all of its secret rules(techradar.com)

39 points by sabrina_ramonov 2 years ago | 47 comments

The EU should be the heat-pump pioneer(economist.com)

39 points by doener 2 years ago | 53 comments

Welsh government commits to making lying in politics illegal(theguardian.com)

36 points by stubish 2 years ago | 23 comments

Graph-Based Ceramics(alexreichert.com)

35 points by nezaj 2 years ago | 9 comments

UK election live updates: Labour Party wins enough seats to form majority gov(apnews.com)

34 points by llllllllew 2 years ago | 1 comments

Kien, the most-delayed video game in history, released after 22 years(theguardian.com)

28 points by isaacfrond 2 years ago | 12 comments

DJI announces an electric mountain bike drive system(dji.com)

28 points by Logans_Run 2 years ago | 34 comments

Fossil of Neanderthal child with Down's syndrome hints early humans' compassion(theguardian.com)

25 points by bryanrasmussen 2 years ago | 5 comments

Sony Is Killing the Blu-ray, but Physical Media Isn't Dead Yet(kotaku.com.au)

25 points by austinallegro 2 years ago | 34 comments

NFL is liable for $4,707,259,944 in 'Sunday Ticket' case(apnews.com)

24 points by geox 2 years ago | 2 comments