Hacker News Reader

I found Dimitri Fontaine's https://theartofpostgresql.com/ advanced. Learned lots of new tricks out of it.

Looks nice and it's on discount because of Black Friday. Thanks!

Probably not what you're asking, but this book is fantastic: https://sql-performance-explained.com/

Edit: and topically, free for the weekend! https://twitter.com/MarkusWinand/status/1199982940471607297

Not what I were asking about but definitely something that I need. Thanks a lot for the reference and wow, lucky timing!

As someone who spent the past week working on database abstractions, I'm pretty sure this is impossible - you can find Basic SQL books, and you can find Advanced Postgres / Advanced MySQL / Advanced Oracle :P

The basic book would pretty much just cover "select * from table". Everything beyond that, for instance "select * from table limit 10", is implementation-specific...

(I'm not even exaggerating: https://en.wikibooks.org/wiki/SQL_Dialects_Reference/Select_... )

That's what I was afraid of but still asked if there is Advanced ANSI SQL book.

Thanks!