They recently released version 13. It's not going away any time soon. You can get a solid understanding of relational database management systems which will also be useful to know when not to use them.
I know I'm biased towards PostgreSQL but that's because I've used it for a long time and it has never let me down really :) True that there are situations were a relational DB is not the best idea but that's mostly a generic software engineering type of consideration, I don't think it's related to the specific tool, I would say the same if I were more familiar with MySQL than I am with Postgres.
If you view picking up PostgreSQL skills as a gateway to learn relational DBs better I think you might get to your goal of learning databases better. I guess it's the same if you decide to spend more time on MongoDB or an alternative to learn the pros and cons of NoSQL.
Keep the "theory" in mind while you explore those goals, this way your skills will be more transferable between one and the other
That's in my list for 2021 for sure 😉 I believe most of the businesses are CRUD based (especially in corporate businesses), so being a master of at least one database per its type is essential 😉
I've worked in various types of software companies before joining Forem and I've never seen one not use a relational DB so I totally agree. A lot use multiple types of DBs (we do as well, by using PostgreSQL and Redis, though we don't do anything advanced on Redis yet) but the relational ones are always there somewhere
My suggestion is PostgreSQL :-)
They recently released version 13. It's not going away any time soon. You can get a solid understanding of relational database management systems which will also be useful to know when not to use them.
Awesome to see you participating, too 😉 First thing that comes to mind is the great job you do in the Forem repo 👌💯
ahah thanks Madza!
I know I'm biased towards PostgreSQL but that's because I've used it for a long time and it has never let me down really :) True that there are situations were a relational DB is not the best idea but that's mostly a generic software engineering type of consideration, I don't think it's related to the specific tool, I would say the same if I were more familiar with MySQL than I am with Postgres.
If you view picking up PostgreSQL skills as a gateway to learn relational DBs better I think you might get to your goal of learning databases better. I guess it's the same if you decide to spend more time on MongoDB or an alternative to learn the pros and cons of NoSQL.
Keep the "theory" in mind while you explore those goals, this way your skills will be more transferable between one and the other
Maybe do one at a time?
That's in my list for 2021 for sure 😉 I believe most of the businesses are CRUD based (especially in corporate businesses), so being a master of at least one database per its type is essential 😉
I've worked in various types of software companies before joining Forem and I've never seen one not use a relational DB so I totally agree. A lot use multiple types of DBs (we do as well, by using PostgreSQL and Redis, though we don't do anything advanced on Redis yet) but the relational ones are always there somewhere
Second postgres! I've been working through tutorials at postgresqltutorial.com/. A brilliant resource.
Also i think supabase.io is going to make postgres more accessible than ever.
Thanks for your input, valuable resources 🙏❤