3 ms·
All the talk here and everywhere have convinced me that: - MySql is the choice for niche workloads and to be used by experts not only in DB but in MySql Quirks
by mamcx 10y ago
All the talk here and everywhere have convinced me that:
- MySql is the choice for niche workloads and to be used by experts not only in DB but in MySql Quirks.
- PG is the sane choice for everyone. Experts benefit more, but inexperienced developers will be better served from a more solid foundation, and still PG is so good that will be along your side for years to come.
PG maybe will not shine in some niche workloads but we are talking about problems that most DO NOT HAVE.
---
Years before, I have read (and believed!) that "PHP, MySql, JS" was "better" for inexperienced (or new) developers, because are more "easy" to learn and use.
Then eventually is show how facebook and others used them.
However, after +18 years on the field, I become more and more convinced that is totally the reverse:
- PHP, JS, MySql, etc are tools for experts.
- More strict tools are better for everyone.
- Only expert will use correctly any tool, even if have quirks.
- This is even more notorious if the tool is more dynamic than static, or provide more "freedom"/less "safety", like C VS. Pascal.
- More well designed or strict tools provide equal benefits to experts, but sometimes a tool with not safety-protection allow to do hacky things easier (or possible).
- ben_jones 10y agoIt's funny to me because on one hand you have specialization where larger companies will typically abstract database work to the DBAs and application work to the developers creating some sane interface for interop and edge cases. And then on the other hand you have things like "full stack developers" who leverage new tech like kubernetes to essentially stay "that one guy who does everything". "Jack of all trades master of none" and all that. What's the natural conclusion to this or does it stay this way forever?