4 ms·
A shortcut that I use for learning new technologies is to learn their pitfalls and tips. For example: I want to learn the PostGIS PostgreSQL extension. I insta
by jakevoytko 4y ago
A shortcut that I use for learning new technologies is to learn their pitfalls and tips.
For example: I want to learn the PostGIS PostgreSQL extension. I install the extension and make a sample database with PostGIS datatypes. Then I will make a bunch of the following searches:
"postgis gotchas", "postgis tips and tricks", "postgis common mistakes", etc. Open everything you find in a new tab.
Then I will edit the sample database to try to reproduce each of the bugs or tips, and understand why they were problems and what the correct thing should have been.
I learned this when I was learning C++ in college from the book "Effective C++", which is basically a list of common pitfalls paired with a discussion of how to avoid them. This hones the parts of my mental model that were wrong or underbaked.
- jjice 4y agoRelated to studying the pitfalls and how to avoid them, I really enjoyed SQL Antipatterns by Karwin. Sounds like the same format, but for RDBMSs.
- elliekelly 4y agoThis is what I really liked about Paul Hegarty’s iOS dev course. His projects sort of deliberately walk students into the common pitfalls so that you can try to figure out a fix on your own and then he explains what/why/how Swift behaves that way. He doesn’t deliberately teach you incorrectly but he’ll set up the project in such a way that when he asks you to add X he expects the vast majority will think “oh I just do this” which doesn’t work because the real answer is a bit more involved. Bonus: when you start spotting the pitfalls ahead of time it’s super motivating!
- bad_username 4y ago"Postgres interview questions"