Needs advice
on
SQLiteSQLitePostgreSQLPostgreSQL
and
MySQLMySQL

I need to add a DBMS to my stack, but I don't know which. I'm tempted to learn SQLite since it would be useful to me with its focus on local access without concurrency. However, doing so feels like I would be defeating the purpose of trying to expand my skill set since it seems like most enterprise applications have the opposite requirements.

To be able to apply what I learn to more projects, what should I try to learn? MySQL? PostgreSQL? Something else? Is there a comfortable middle ground between high applicability and ease of use?

READ LESS
7 upvotes·229.5K views
Replies (3)
Principal Software Engineer at Tophatter·
Recommends
MySQL

MySQL's very popular, easy to install, is also available as a managed service across most popular cloud offerings. The support/default tooling (such as MySQL Query Workbench) certainly is a little more baked than what you'll find for Postgres.

https://dev.mysql.com/downloads/workbench/

READ MORE
1 upvote·123.1K views
Recommends
SQLite

You can easily start with SQlite. Really easy to startup since it doesn't require you to install any additional software since is self-contained. It has interfaces in almost any language and also GUIs. Start learning SQL basics and simpler data models and structures. There are many tutorials, also available in the official website. From there you will easily migrate to another database. MySQL could be next, sonce it's easier to learn at first and has more resources available. PostgreSQL is less widespread, more challenging and has the fewer resorces, but once you have some experience with MySQL is really easy to learn as well. All these technologies are really widespread and used accross the industry so you won't make a wrong decision with any of these.

READ MORE
8 upvotes·1 comment·133.3K views
Dimelo Waterson
Dimelo Waterson
·
November 10th 2020 at 4:13AM

This was a very reassuring take and I appreciated reading it. One of my biggest concerns (something that Stephen mentioned) is that SQLite might be too simplified to translate into a broader operational experience, but your suggestion of starting somewhere (and somewhere simple) was definitely helpful when deciding how to invest my time.

·
Reply
View all (3)
Avatar of Julien DeFrance

Julien DeFrance

Principal Software Engineer at Tophatter