Ask HN: What engineering trivia earned you the most cred

2 porkbrain 2 5/7/2025, 5:48:18 PM

Is there a specific piece of engineering knowledge that powered you to substantially contribute?

A software engineering example: knowing that Postgres FK doesn't implicitly create an index. Three different projects I joined weren't aware of this and we managed to improve the performance with a negligible amount of effort.

Keen to hear your wins (and make them mine ^^

Comments (2)

catlover76 · 13h ago

> knowing that Postgres FK doesn't implicitly create an index.

Damn really lol

What does it do then, just block "breaking" deletes?

porkbrain · 13h ago

You can cascade the deletes in db layer rather than in app layer

No comments yet

Show HN (sleepcalculators.com)

The forgotten Skype phones (ravi64.com)

Ask HN: Books for LLMs

Multistep forms with Rails and the Wicked gem (avohq.io)

'"I Humbly Beg Your Speedy Answer"' Review: Instruction Fit to Print (wsj.com)

Open source project curl is sick of users submitting "AI slop" vulnerabilities (arstechnica.com)

Technology Grows (A Restatement of Definite Optimism) (danwang.co)

OpenAI and the FDA are reportedly discussing AI for drug evaluations (techcrunch.com)

ConclaveSim: Simulating the 2025 Papal Election with LLM Agent (github.com)

Publish your designs on the web with Figma Sites (figma.com)

Open-Source AI Powered Kubernetes Assistant by Google (github.com)

ClickHouse and Parquet: A foundation for fast Lakehouse analytics (clickhouse.com)

AI Slop: How Low-Quality AI Books Are Overwhelming Libraries (shellypalmer.com)

Intel Geti is available on GitHub (github.com)

Show HN: Odyssea AI to decode your Subconscious mind (odyssea.ai)

Don't use Cloudflares 1.1.1.1 on servers

Show HN: Weblish – Web programming in natural English (github.com)

Best ways to create technical docs

Zero-Copy (De)Serialization (iggy.apache.org)

Field-scale evaluation of ecosystem service benefits of bioenergy switchgrass (acsess.onlinelibrary.wiley.com)

stow: Package Manager When You Can't Use Your Package Manager (theartofmachinery.com)

Key trends from the swyx's AI Engineer Summit 2025 (kisekilabs.com)

Ask HN: How to find farm work in Dakota

Maintainer Month for open source maintainers to gather, share, and be celebrated (maintainermonth.github.com)

Man admitted to Japan's 2025 World Expo with 85-year-old ticket (theguardian.com)

The Protection of Information in Computer Systems (1974) (cs.virginia.edu)

We built an AI envoy, you can too (posthog.com)

Cringe! How millennials became uncool (theguardian.com)

Why It's Easier to Get a Payrise by Switching Jobs (theartofmachinery.com)

Google's Race to Lose? (nick.cloud)

Message to the Internet

Nobody Codes Here Anymore (ghiculescu.substack.com)

Show HN: AI tool to turn articles into social media posts (quickpostai.online)

Yggdrasil Linux/GNU/X (en.wikipedia.org)

Mycoria is an open and secure overlay network that connects all participants (mycoria.org)

OmniGIRL: A Multilingual and Multimodal Benchmark for GitHub Issue Resolution (arxiv.org)

DSH/Warcoded: Eyes and Ears of the Machine (datascienceathome.com)

Leak and Seek a Go Runtime Mystery (cyolo.io)

Hazardous Attitude Inventory Test (dauntless-soft.com)

Why Intel Deprecated SGX? (hardenedvault.net)

A payments protocol for the internet. Built on HTTP (github.com)

From Haskell to a New Structured Combinator Processor (researchportal.hw.ac.uk)

The Third Annual Scryer Prolog Meetup (github.com)

Gender's influence the price of an oil change in America (research.cobbery.com)

Farewell, Skype: The Pioneering App That Shaped Digital Communication (juumbi.com)

Argentina hopes to attract Big Tech with nuclear-powered AI data centers (restofworld.org)

Understanding Ruby Blocks, Procs and Lambdas (2008) (web.archive.org)

A Year of Synthesizers (2020) (storytotell.org)

Envelope Tracking for Efficient Power Amplifiers (substack.com)

Programming Notes for Professionals Books (books.goalkicker.com)

Ask HN: What engineering trivia earned you the most cred

Comments (2)