3 ms·

Do you have any examples of a good book that will take me from intermediate to advanced? Most of the guides I’ve found online either assume you’re an absolute b

Do you have any examples of a good book that will take me from intermediate to advanced? Most of the guides I’ve found online either assume you’re an absolute beginner or already quite advanced. I’m quite competent with SQL and relational databases, but nearly all of my experience is on Microsoft SQL server. I’ve heard postgresql has a lot of really cool functionality but I would really love a nice, professional, in-depth book that will help me get fully up to speed.

LiamPa 7y ago
Recommend ‘Designing data intensive applications’ https://www.oreilly.com/library/view/designing-data-intensive-applications/9781491903063/ https://www.oreilly.com/library/view/designing-data-intensiv...
- james_s_tayler 7y ago
  This is a great book, but it's not a book on SQL.
throw1234651234 7y ago
My first day of Postgres experience is that the first query to fetch 1 record takes 5 seconds and subsequent queries take 50ms. There are a 1000 explanations as to why, but I have no idea which is correct. I hate Postgres. I heard it does JSON or something well.
- rapphil 7y ago
  This presentation will answer all your questions. https://youtu.be/0cLIhoXjgDE https://youtu.be/0cLIhoXjgDE I love Postgres.
- inimino 7y ago
  Some power tools take more than a day to learn. Deal with it if you need the power. If you don't need an RDBMS, don't use one.
mongol 7y ago
I recommend watching Markus Winand on youtube. Eye-opening for me
- dvko 7y ago
  Seconded. His book and blog (which is called something like “use the index, Luke”) are really good too.
chirau 7y ago
Database Systems Concepts https://www.db-book.com/db7/index.html https://www.db-book.com/db7/index.html Great book, that's the one that is also used in the reputable CMU Database Systems course, which you can also find on Youtube. https://www.youtube.com/playlist?list=PLSE8ODhjZXjbohkNBWQs_otTrBTrjyohi https://www.youtube.com/playlist?list=PLSE8ODhjZXjbohkNBWQs_...
DudeWhoCode 7y ago
I'll highly recommend "A Curious Moon" by Rob Conery [0]. In this book you'll load Cassini space mission data from NASA into Postgres and analyze one of the Saturn's moon. I learnt a lot about Postgres and also about satellite data. [0] https://bigmachine.io/products/a-curious-moon/ https://bigmachine.io/products/a-curious-moon/

LiamPa 7y ago

Recommend ‘Designing data intensive applications’ https://www.oreilly.com/library/view/designing-data-intensive-applications/9781491903063/ https://www.oreilly.com/library/view/designing-data-intensiv...

james_s_tayler 7y ago
This is a great book, but it's not a book on SQL.

throw1234651234 7y ago

My first day of Postgres experience is that the first query to fetch 1 record takes 5 seconds and subsequent queries take 50ms. There are a 1000 explanations as to why, but I have no idea which is correct. I hate Postgres. I heard it does JSON or something well.

rapphil 7y ago
This presentation will answer all your questions. https://youtu.be/0cLIhoXjgDE https://youtu.be/0cLIhoXjgDE I love Postgres.
inimino 7y ago
Some power tools take more than a day to learn. Deal with it if you need the power. If you don't need an RDBMS, don't use one.

mongol 7y ago

I recommend watching Markus Winand on youtube. Eye-opening for me

dvko 7y ago
Seconded. His book and blog (which is called something like “use the index, Luke”) are really good too.

chirau 7y ago

Database Systems Concepts https://www.db-book.com/db7/index.html https://www.db-book.com/db7/index.html Great book, that's the one that is also used in the reputable CMU Database Systems course, which you can also find on Youtube. https://www.youtube.com/playlist?list=PLSE8ODhjZXjbohkNBWQs_otTrBTrjyohi https://www.youtube.com/playlist?list=PLSE8ODhjZXjbohkNBWQs_...

DudeWhoCode 7y ago

I'll highly recommend "A Curious Moon" by Rob Conery [0]. In this book you'll load Cassini space mission data from NASA into Postgres and analyze one of the Saturn's moon. I learnt a lot about Postgres and also about satellite data. [0] https://bigmachine.io/products/a-curious-moon/ https://bigmachine.io/products/a-curious-moon/