Ask HN: What engineering trivia earned you the most cred

3 points by porkbrain 20 hours 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 ^^

austin-cheney 4 hours ago

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

catlover76 20 hours ago

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

Damn really lol

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

  • porkbrain 20 hours ago

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