Hacker News on Saturday, 22 April 2023

The “Build Your Own Database” book is finished(build-your-own.org)

598 points by tim_sw 3 years ago | 86 comments

Blog post by James Smith announcing completion of the "Build Your Own Database" book, explaining why learning database internals from scratch matters.

iOS 17 app sideloading might only be available in Europe(techradar.com)

554 points by walterbell 3 years ago | 954 comments

TechRadar news article reporting that app sideloading in iOS 17 may be limited to Europe, with other regions keeping Apple's walled garden.

Show HN: I made a SQL game to help people learn / challenge their skills(lost-at-sql.therobinlord.com)

498 points by robinLord 3 years ago | 98 comments

Lost at SQL is a browser-based nautical-themed game for learning SQL through a story mode and SQL challenges.

Parrots learn to make video calls to chat with other parrots: study(news.northeastern.edu)

439 points by tosh 3 years ago | 200 comments

Northeastern Global News article on research showing pet parrots learned to make video calls to other parrots and formed friendships.

Sundar Pichai received $226M compensation, boosted by a triennial stock grant(bloomberg.com)

367 points by sine_break 3 years ago | 375 comments

Bloomberg article reporting Alphabet CEO Sundar Pichai's 2022 pay rose to $226 million due to a triennial stock award; page shows a bot-check captcha.

Prompt engineering vs. blind prompting(mitchellh.com)

324 points by Anon84 3 years ago | 190 comments

Mitchell Hashimoto's blog post distinguishing rigorous prompt engineering from 'blind prompting', a crude trial-and-error approach with little testing.

Why the brain’s connections to the body are crisscrossed(quantamagazine.org)

279 points by rolph 3 years ago | 122 comments

Housing should be affordable except for when I sell my house for $1M(mcsweeneys.net)

229 points by baron816 3 years ago | 183 comments

The Four Hobbies, and Apparent Expertise(brooker.co.za)

226 points by luu 3 years ago | 132 comments

Moths are more efficient pollinators than bees: new research(phys.org)

216 points by wglb 3 years ago | 88 comments

The magic of DC-DC voltage conversion(lcamtuf.substack.com)

201 points by zdw 3 years ago | 117 comments

Finetuning Large Language Models(magazine.sebastianraschka.com)

201 points by headalgorithm 3 years ago | 63 comments

Effective Immediately: A central hub for people who've been recently laid off (2020)(github.com)

197 points by derwiki 3 years ago | 86 comments

Saturn's Interior After the Cassini Grand Finale(arxiv.org)

184 points by belter 3 years ago | 47 comments

Google Mars (2005)(google.com)

173 points by belter 3 years ago | 76 comments

System D(en.wikipedia.org)

167 points by diddlybopshubop 3 years ago | 90 comments

Methane may not warm the Earth quite as much as previously thought(sciencenews.org)

166 points by starkd 3 years ago | 285 comments

Using solar farms to generate fresh desert soil crust(phys.org)

160 points by PaulHoule 3 years ago | 46 comments

How much can Duolingo teach us?(newyorker.com)

159 points by herbertl 3 years ago | 249 comments

Compromising Garmin Sport Watches: A Deep Dive into GarminOS and Its MonkeyC VM(anvilsecure.com)

153 points by anishathalye 3 years ago | 51 comments

The Sell ∀ ∃ as ∃ ∀ Scam(win-vector.com)

152 points by jmount 3 years ago | 97 comments

Animal Meat and Milk Sales Drop in Europe as Vegan Versions Hit Record Highs(plantbasednews.org)

152 points by gbenga4real 3 years ago | 181 comments

How did the chess pieces get their names?(atlasobscura.com)

146 points by Brajeshwar 3 years ago | 68 comments

Ask HN: Is prompt engineering just snake oil?

141 points by wg0 3 years ago | 143 comments

My shell setup with Fish and Tmux (2021)(milanvit.net)

139 points by behnamoh 3 years ago | 74 comments

Boot to Vim, Vim as Pid 1 (2014)(raymii.org)

128 points by jandeboevrie 3 years ago | 68 comments

When a mosquito can’t stop drinking blood, the result isn’t pretty(entomologytoday.org)

125 points by sohkamyung 3 years ago | 67 comments

The Sudan crisis and the Sahel gold rush(adamtooze.substack.com)

116 points by hackandthink 3 years ago | 88 comments

More than 19k undersea volcanoes discovered(science.org)

115 points by tamaharbor 3 years ago | 82 comments

Explosions are great, actually(1517.substack.com)

104 points by areoform 3 years ago | 42 comments

Modern Transactional Stack(a16z.com)

104 points by opiniateddev 3 years ago | 72 comments

Why Did Thomas Harriot Invent Binary?(link.springer.com)

103 points by nanna 3 years ago | 41 comments

Amazon investigates after high-value orders were switched for cheaper products(bbc.co.uk)

100 points by vanilla-almond 3 years ago | 89 comments

Ask HN: Why is TSMC so competitive in semiconductor fabrication?

97 points by YourDadVPN 3 years ago | 88 comments

I just learned about HTML redirects (2020)(apitman.com)

94 points by sc90 3 years ago | 64 comments

Writing Portable ARM64 Assembly(ariadne.space)

87 points by goranmoomin 3 years ago | 17 comments

Negative Mass(students.tools)

87 points by thunderbong 3 years ago | 57 comments

Schools bought millions of Chromebooks and 3 years later they’re breaking down(theverge.com)

86 points by redundantly 3 years ago | 92 comments

Indigo: A game engine for functional programmers, in Scala(indigoengine.io)

86 points by based2 3 years ago | 42 comments

WebAssembly Text Code Samples(eli.thegreenplace.net)

83 points by tim_sw 3 years ago | 14 comments

Navigating the world when your senses conjure up phenomena others can’t perceive(theamericanscholar.org)

75 points by Caiero 3 years ago | 67 comments

JSON vs. XML with Douglas Crockford(corecursive.com)

74 points by ZeljkoS 3 years ago | 64 comments

XINF(xinf.dev)

73 points by ZeroTerabytes 3 years ago | 14 comments

Design quirks, limited parts, and other ways Chromebooks frustrate repairs(arstechnica.com)

72 points by PaulHoule 3 years ago | 69 comments

ReceptioGate and the (Absolute) State of Academia(thecritic.co.uk)

71 points by nkurz 3 years ago | 19 comments

Email yourself from a Google Sheet(blog.bettersheets.co)

70 points by kamphey 3 years ago | 19 comments

Magic3D: High-Resolution Text-to-3D Content Creation(research.nvidia.com)

63 points by T-A 3 years ago | 9 comments

Maintain consistent styles for developers working across various editors(editorconfig.org)

61 points by pmarin 3 years ago | 38 comments

First ROM Shadowing(os2museum.com)

59 points by kencausey 3 years ago | 15 comments

Medical wordlists in English, French and Ukrainian(github.com)

57 points by ouzb64ty 3 years ago | 18 comments

Re-live buying a computer in 1995 [video](youtube.com)

55 points by indigodaddy 3 years ago | 39 comments

Should you remove duplicate files?(eclecticlight.co)

54 points by ingve 3 years ago | 47 comments

Will we run out of ML data? Evidence from projecting dataset size trends (2022)(epochai.org)

53 points by kurhan 3 years ago | 93 comments

Show HN: DontBore – Accessible, fast, low-footprint Login sharing for the masses(dontbo.re)

52 points by midzer 3 years ago | 16 comments

The loophole that made cars in America so big(distilled.earth)

52 points by jseliger 3 years ago | 54 comments

How does the New York Times make a game?(nytimes.com)

51 points by drdee 3 years ago | 52 comments

The many ways of converting FP32 to FP16(corsix.org)

51 points by jsnell 3 years ago | 6 comments

Singapore plans to execute man over 1kg of cannabis(taipeitimes.com)

50 points by graderjs 3 years ago | 39 comments

Apple will launch a journaling app(arstechnica.com)

45 points by isaacdl 3 years ago | 63 comments

Say Hi to SoFi. It’s Suing to Force You to Repay Student Loans Faster(nytimes.com)

43 points by mistersquid 3 years ago | 33 comments