Hacker News on Saturday, 17 February 2024

My notes on Gitlab's Postgres schema design (2022)(shekhargulati.com)

432 points by daigoba66 2 years ago | 114 comments

A blog post by Shekhar Gulati with notes on how GitLab designs its PostgreSQL database schema.

Considerations for a long-running Raspberry Pi(dzombak.com)

426 points by ilikepi 2 years ago | 300 comments

Blog post by Chris Dzombak on keeping a Raspberry Pi running reliably for months or years without intervention, part of his Pi Reliability series.

Big Pharma spends billions more on executives and stockholders than on R&D(arstechnica.com)

400 points by PaulHoule 2 years ago | 180 comments

Ars Technica article on a Senate report finding major drug companies spend more on executive pay and shareholder payouts than on R&D, citing patent thickets.

The Ute Tribe will construct one of the largest solar farms in the US(ksut.org)

341 points by namanyayg 2 years ago | 268 comments

KSUT public radio news story reporting that the Ute Mountain Ute Tribe will build one of the largest solar farms in the United States.

Ollama is now available on Windows in preview(ollama.com)

337 points by pentagrama 2 years ago | 137 comments

Ollama blog post from February 15, 2024 announcing a preview release of Ollama for Windows.

So long, and thanks for all the bytes(chethaase.medium.com)

329 points by ckue 2 years ago | 130 comments

Medium post by Chet Haase, Android team developer advocate, announcing his departure from Google with a farewell reflection.

Representation Engineering: Mistral-7B on Acid(vgel.me)

290 points by alexmolas 2 years ago | 53 comments

We Have to Start Over: From Atom to Zed(zed.dev)

274 points by tosh 2 years ago | 187 comments

Automated Unit Test Improvement Using Large Language Models at Meta(arxiv.org)

264 points by mfiguiere 2 years ago | 163 comments

From engineer to manager: what I love, what I hate(thoughtspile.github.io)

253 points by signa11 2 years ago | 168 comments

Headphone and Amp Impedance (2011)(nwavguy.blogspot.com)

213 points by Tomte 2 years ago | 83 comments

"Stolen" radio tower missing for at least a year(radiodiscussions.com)

190 points by LeoPanthera 2 years ago | 115 comments

I worry our Copilot is leaving some passengers behind(joshcollinsworth.com)

186 points by headalgorithm 2 years ago | 99 comments

Show HN: macOS-cross-compiler – Compile binaries for macOS on Linux(github.com)

185 points by shepherdjerred 2 years ago | 67 comments

It’s Official, Apple Kills Web Apps in the EU(open-web-advocacy.org)

181 points by szasamasa 2 years ago | 172 comments

Progman: X11 WM modeled after Program Manager from the Windows 3 era(github.com)

180 points by signa11 2 years ago | 42 comments

OS-Copilot: Towards Generalist Computer Agents with Self-Improvement(os-copilot.github.io)

160 points by lokimedes 2 years ago | 37 comments

Mistral AI launches Mixtral-Next(chat.lmsys.org)

159 points by varunvummadi 2 years ago | 31 comments

The epidemic of fraudulent DMCA takedowns(taxpolicy.org.uk)

156 points by colinprince 2 years ago | 65 comments

I Ended Up with Just 0.15% of My Own Startup

134 points by johnrushx 2 years ago | 60 comments

Microsoft bets on Germany in €3.2B AI push(reuters.com)

123 points by thunderbong 2 years ago | 92 comments

The game theory of seduction and marriage with Jane Austen(optimallyirrational.com)

121 points by delichon 2 years ago | 90 comments

Kremlin runs disinformation campaign to undermine Zelensky, documents show(washingtonpost.com)

116 points by lxm 2 years ago | 60 comments

Basic proxy implementation using io_uring(git.kernel.dk)

110 points by mfiguiere 2 years ago | 45 comments

Nebula is not the fastest mesh VPN, but neither are the others(defined.net)

107 points by lenova 2 years ago | 33 comments

Welding of Plutonium (1958) [pdf](sgp.fas.org)

102 points by sohkamyung 2 years ago | 69 comments

Releasing my tools under the MIT License was probably a mistake (2023)(donatstudios.com)

96 points by marbu 2 years ago | 61 comments

DiskClick: Ever wanted to hear old hard drive sounds(deervo.itch.io)

96 points by zdw 2 years ago | 58 comments

Visualize Latent Spaces(github.com)

95 points by skadamat 2 years ago | 22 comments

Altman's Ambition(thezvi.substack.com)

93 points by dustingetz 2 years ago | 73 comments

Let me clear a huge misunderstanding(twitter.com)

89 points by YeGoblynQueenne 2 years ago | 64 comments

A vision of a multi-threaded Emacs (2022)(coredumped.dev)

89 points by tosh 2 years ago | 7 comments

Spnec fast-tracks ₱200B solar farm in Central Luzon(businessmirror.com.ph)

86 points by doener 2 years ago | 53 comments

Why diets backfire: A year after weight loss, the desire to eat grows (2018)(latimes.com)

84 points by paulpauper 2 years ago | 103 comments

Flowers grown floating on polluted waterways can help clean up nutrient runoff(arstechnica.com)

84 points by mikece 2 years ago | 26 comments

Mushroom Sprouting Out of a Living Frog(journals.ku.edu)

83 points by sorokod 2 years ago | 38 comments

The adult consequences of being bullied in childhood(sciencedirect.com)

83 points by cdepman 2 years ago | 66 comments

JSR first impressions: a JavaScript package manager by the Deno team (2023)(kitsonkelly.com)

81 points by satvikpendem 2 years ago | 60 comments

Options for genuine ECC RAM on the desktop in (early) 2024(utcc.utoronto.ca)

80 points by ingve 2 years ago | 75 comments

Tree-Sitter(tree-sitter.github.io)

80 points by tosh 2 years ago | 12 comments

Ink/Stitch: An open-source machine embroidery design platform based on Inkscape(inkstitch.org)

80 points by Tomte 2 years ago | 4 comments

Replicate vs. Fly GPU cold-start latency(venki.dev)

77 points by venkii 2 years ago | 29 comments

Most people with addiction simply grow out of it (2014)(psmag.com)

77 points by jseliger 2 years ago | 34 comments

Chain-of-Thought Reasoning Without Prompting(arxiv.org)

76 points by og_kalu 2 years ago | 21 comments

Raising Children on the Eve of AI(juliawise.net)

74 points by lwhsiao 2 years ago | 122 comments

Making SVG Loading Spinners: An Interactive Guide(fffuel.co)

70 points by debesyla 2 years ago | 6 comments

Bypassing the WiFi Hardware Switch on the Lenovo X201 (2023)(btxx.org)

68 points by bradley_taunt 2 years ago | 40 comments

The Early History of Usenet (2019)(cs.columbia.edu)

68 points by ogurechny 2 years ago | 13 comments

Mysterious 280M-year-old fossil is mostly just black paint(arstechnica.com)

67 points by Brajeshwar 2 years ago | 35 comments

Code for the Byte Pair Encoding algorithm, commonly used in LLM tokenization(github.com)

65 points by magoghm 2 years ago | 19 comments

Bevy 0.13: ECS-driven game engine built in Rust(bevyengine.org)

64 points by _cart 2 years ago | 20 comments

Master of the Playing Cards(en.wikipedia.org)

63 points by keiferski 2 years ago | 6 comments

Show HN: AI Generated (Not-Real) User Avatar Images for Development Needs(avatars.tzador.com)

61 points by timz 2 years ago | 39 comments

Signal v7.0.0 with phone number privacy(github.com)

61 points by p4bl0 2 years ago | 38 comments

Unreal Engine 5 can now run in a web browser(pcgameshardware.de)

58 points by astlouis44 2 years ago | 9 comments

Show HN: I built an alternative to product tours(vykee.co)

58 points by giaco_hendel 2 years ago | 21 comments

TrueType Fonts for OpenTTD(openttd.org)

55 points by davikr 2 years ago | 4 comments

Greenmask: PostgreSQL Dump and Obfuscation Tool(github.com)

55 points by thunderbong 2 years ago | 12 comments

Agile Is a Tainted Term(pcloadletter.dev)

54 points by peterkonsz 2 years ago | 43 comments

My MacBook Setup (the 2024 version)(github.com)

54 points by maoxiaoke 2 years ago | 74 comments