Databases in practice
Choose SQLite, PostgreSQL, or MySQL
Choose a relational database based on deployment, concurrency, operational needs, and the environment that will run it.
8 minute lesson
~~~
SQLite stores a database in one file and runs inside your application process. It is excellent for local tools, prototypes, and many small applications.
PostgreSQL and MySQL run as database servers. They are a better fit when several application instances or users need concurrent network access and stronger operational tooling.
All three are capable relational databases. Prefer the simplest one that satisfies the real requirements.
Lesson completed