3 ms·
I actually think the most important thing you can do is learn SQL and specifically how to make things fast/clever enough with just Postgres. Topics include dif
by andy_ppp 8y ago
I actually think the most important thing you can do is learn SQL and specifically how to make things fast/clever enough with just Postgres.
Topics include different joins, relationship types, full text search, indexing, JSONB, amongst many others!
- vp8989 8y agoThis is the correct answer but no one wants to hear this in 2019.
- chrisdsaldivar 8y agoPostgres has been my go to DB for my projects. It's fast, simple and has decades of research and battle tested systems to pull knowledge from. Your comment reminds me of a PyCon 2017 talk by Raymond Hettinger where he details the improvements in Python dictionaries from 2.7 to 3.6 which effectively amounted to rediscovering and re-implementing what was standard in databases decades ago. "Modern Python Dictionaries A confluence of a dozen great ideas" https://www.youtube.com/watch?v=npw4s1QTmPg&ab_channel=PyCon2017 https://www.youtube.com/watch?v=npw4s1QTmPg&ab_channel=PyCon...
- lcfcjs2 8y agoLOL NoSQL databases are taking over.
- MisterOctober 8y agoAs a friend said to me a couple weeks ago -- "Either use Postgres, or have a darn good reason why you don't!"
- labster 8y agoI have a lot of reasons not to use Postgres, and they're all historical reasons.
- C1sc0cat 8y agoI would add Sproc's and PL/SQL (or what ever postgress calls it)