One word in PostgreSQL unlocked a 9x performance improvement

Re:One word in PostgreSQL unlocked a 9x performance improvement by aaomidi on Sunday June 14, 2020 @03:04PM (#23520362)

What SQL Textbook should I read?

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by sgk284 on Sunday June 14, 2020 @04:04PM (#23520847)

The Postgres docs are some of the best reading you can do. Super digestible, great examples, and all around excellent for learning.

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by ant6n on Sunday June 14, 2020 @03:08PM (#23520405)

"Become a Select St*r!" (https://wizardzines.com/zines/sql/)

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by wiml on Sunday June 14, 2020 @04:49PM (#23521237)

Once you have a basic understanding of SQL, I found it really informative to go closer to the source, e.g. C. J. Date and Hugh Darwen's "A Guide to the SQL Standard", or perhaps other books by them.

There's a lot of incomplete and misunderstood information floating around in blog tutorials or potboiler textbooks.

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by aaomidi on Monday June 15, 2020 @04:33PM (#23532632)

This sounds great!

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by 3pt14159 on Sunday June 14, 2020 @03:51PM (#23520763)

I found reading the postgres documentation and playing around with each of the examples useful.

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by jmalicki on Monday June 15, 2020 @12:54AM (#23523918)

I highly recommend SQL for Smarties.

https://www.amazon.com/Joe-Celkos-SQL-Smarties-Programming/d...

[ Parent | on HN ]