News for hackers. Stuff that matters.

A comment on Ask HN: What Technologies to Learn in 2020?. Parent comment

Re:Ask HN: What Technologies to Learn in 2020? by OkGoDoIt on Sunday January 05, 2020 @02:44PM (#21963501)
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.
[ Parent | on HN ]
Re:Ask HN: What Technologies to Learn in 2020? by mongol on Sunday January 05, 2020 @03:43PM (#21963938)
I recommend watching Markus Winand on youtube. Eye-opening for me
[ Parent | on HN ]
Re:Ask HN: What Technologies to Learn in 2020? by dvko on Sunday January 05, 2020 @04:42PM (#21964332)
Seconded. His book and blog (which is called something like “use the index, Luke”) are really good too.
[ Parent | on HN ]
Re:Ask HN: What Technologies to Learn in 2020? by chirau on Sunday January 05, 2020 @03:49PM (#21963975)
Database Systems Concepts 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_...

[ Parent | on HN ]
Re:Ask HN: What Technologies to Learn in 2020? by DudeWhoCode on Sunday January 05, 2020 @11:45PM (#21966511)
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/

[ Parent | on HN ]
Re:Ask HN: What Technologies to Learn in 2020? by LiamPa on Sunday January 05, 2020 @02:48PM (#21963534)
Recommend ‘Designing data intensive applications’

https://www.oreilly.com/library/view/designing-data-intensiv...

[ Parent | on HN ]
Re:Ask HN: What Technologies to Learn in 2020? by james_s_tayler on Sunday January 05, 2020 @02:51PM (#21963560)
This is a great book, but it's not a book on SQL.
[ Parent | on HN ]
Re:Ask HN: What Technologies to Learn in 2020? by throw1234651234 on Sunday January 05, 2020 @02:49PM (#21963537)
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.
[ Parent | on HN ]
Re:Ask HN: What Technologies to Learn in 2020? by rapphil on Sunday January 05, 2020 @02:56PM (#21963597)
This presentation will answer all your questions.

https://youtu.be/0cLIhoXjgDE

I love Postgres.

[ Parent | on HN ]
Re:Ask HN: What Technologies to Learn in 2020? by inimino on Sunday January 05, 2020 @03:12PM (#21963711)
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.
[ Parent | on HN ]