stackstash

MySQL vs SQLite

MySQL and SQLite are free.

MySQL logo: The relational database behind a huge share of web apps and WordPress.
MySQL logo: The relational database behind a huge share of web apps and WordPress.

MySQL

Free

The relational database behind a huge share of web apps and WordPress.

Try it

Pros of MySQL

  • Easy to find hosting

  • Familiar SQL

  • Free Community edition

Cons of MySQL

  • Fewer advanced features than Postgres

  • Oracle steers the project

SQLite logo: A SQL database stored in one file, with no server to run.
SQLite logo: A SQL database stored in one file, with no server to run.

SQLite

Free

A SQL database stored in one file, with no server to run.

Try it

Pros of SQLite

  • Nothing to install beyond the library

  • Easy to copy, back up, or reset in development

  • Drizzle can use it the same way as Postgres

Cons of SQLite

  • One writer at a time is the comfortable limit

  • You outgrow it once you need hosted auth and storage