Hacker News new | ask | show | jobs
by abhishekjha 800 days ago
Is there a more general reading for software engineers?

Seems like jumping right into the code can be a bit overwhelming if you have no background on the topic.

4 comments

Always worth a mention:

https://use-the-index-luke.com/

Markus Winand (the website's author) has also written a book on the subject targeted at software developers which is decent for non-DBA level knowledge.

Not exactly reading but I would recommend the database engineering courses by Andy Pavlo that are freely available on YouTube.
PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, by Henrietta Dombrovskaya and Boris Novikov Anna Bailliekova, published by Apress in 2021.
You may discover this if you go to the Apress site, but there is a second edition [1] out.

[1] https://hdombrovskaya.wordpress.com/2024/01/11/the-optimizat...