Ask HN: What engineering trivia earned you the most cred

5•porkbrain•9mo ago

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

catlover76•9mo ago

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

Damn really lol

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

porkbrain•9mo ago

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

austin-cheney•9mo ago

Deeper internal knowledge of WebSockets and HTTP got me my current job.

deanmoriarty•9mo ago

Every time I start doing some network packet-based troubleshooting, for example firing up tcpdump to debug a tcp window size improperly tuned that caused a performance degradation over a high latency link (this is a random example I did last week), coworkers look at me like I pulled off some sort of wizardry. I feel it’s knowledge that most SWEs working on distributed systems should have acquired early and routinely use, but clearly that’s not the case.

Ask HN: Anyone Using a Mac Studio for Local AI/LLM?

Ask HN: Who wants to be hired? (February 2026)

Ask HN: Ideas for small ways to make the world a better place

Ask HN: Who is hiring? (February 2026)

Ask HN: 10 months since the Llama-4 release: what happened to Meta AI?

Ask HN: Non AI-obsessed tech forums

Ask HN: Opus 4.6 ignoring instructions, how to use 4.5 in Claude Code instead?

Tell HN: Another round of Zendesk email spam

LLMs are powerful, but enterprises are deterministic by nature

Ask HN: Is Connecting via SSH Risky?

Ask HN: Has your whole engineering team gone big into AI coding? How's it going?

AI Regex Scientist: A self-improving regex solver

Ask HN: Non-profit, volunteers run org needs CRM. Is Odoo Community a good sol.?

Ask HN: Is it just me or are most businesses insane?

Ask HN: Is there anyone here who still uses slide rules?

Kernighan on Programming

Ask HN: Mem0 stores memories, but doesn't learn user patterns

Ask HN: How does ChatGPT decide which websites to recommend?

Ask HN: Why LLM providers sell access instead of consulting services?

Ask HN: What is the most complicated Algorithm you came up with yourself?

Ask HN: Have you been fired because of AI?

Ask HN: Does a good "read it later" app exist?

We built a serverless GPU inference platform with predictable latency

Ask HN: Anyone have a "sovereign" solution for phone calls?

Ask HN: Cheap laptop for Linux without GUI (for writing)

Ask HN: Anyone Seeing YT ads related to chats on ChatGPT?

Ask HN: Does global decoupling from the USA signal comeback of the desktop app?

GitHub Actions Have "Major Outage"

Ask HN: Has anybody moved their local community off of Facebook groups?

Ask HN: OpenClaw users, what is your token spend?