I think that's a thing rarely any developer admits to themselves and yet an area where (most likely) 90% or more of us could and should improve in. I just had to touch partitioning and was way out of my league.
Disclaimer: I mean developers who deal with databases and data storage on a regular basis.
How did you over some this?
With pain, a lot of pain. Haha kidding.
I always write an experiment version of the task, then i get deep into documentations and foruns, ORMs, tools. But is like study, im doing my best to get the task done and learning something new becomes a plus. Is not something that i get along easily. But is not something that im always doing too, to be honest im always forgetting what i did in this field.
love the POC method. I like to mock something out quickly first as well before I get to heavy in to it.
Think youre right, i think thats a gap that most developers dont admit because you can do a lot even with basic skills. I mean, i can build an app from scratch, up a database, configure it, define the relations, and all those everyday things
But man, dont ask me to optimize the databases, to debug big data, to migrate huge dbs with no pain (is that possible?), to apply rules to increase the response time, to reduce relational complexibility, i must recognize that im not the best person to do it :/
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.