MySQL vs. PostgreSQL vs. SQLite



Hacker News, Reddit, Stack Overflow Stats

  • 1.11K
  • 8.53K
  • 547K
  • 8.36K
  • 8.24K
  • 94.5K
  • 3.74K
  • 10.1K
  • 64.4K

GitHub Stats

No public GitHub repository stats available

Description

What is MySQL?

The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.

What is PostgreSQL?

PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.

What is SQLite?

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.

Want advice about which of these to choose?Ask the StackShare community!

Pros

Why do developers choose MySQL?
Why do you like MySQL?

Why do developers choose PostgreSQL?
Why do you like PostgreSQL?

Why do developers choose SQLite?
Why do you like SQLite?

Cons

What are the cons of using MySQL?
Downsides of MySQL?

What are the cons of using PostgreSQL?
No Cons submitted yet for PostgreSQL
Downsides of PostgreSQL?

What are the cons of using SQLite?
Downsides of SQLite?

Companies

What companies use MySQL?
3579 companies on StackShare use MySQL
What companies use PostgreSQL?
3073 companies on StackShare use PostgreSQL
What companies use SQLite?
385 companies on StackShare use SQLite

Integrations

What tools integrate with MySQL?
77 tools on StackShare integrate with MySQL
What tools integrate with PostgreSQL?
88 tools on StackShare integrate with PostgreSQL
What tools integrate with SQLite?
15 tools on StackShare integrate with SQLite

What are some alternatives to MySQL, PostgreSQL, and SQLite?

  • MongoDB - The database for giant ideas
  • Microsoft SQL Server - A relational database management system developed by Microsoft
  • MariaDB - An enhanced, drop-in replacement for MySQL
  • Memcached - High-performance, distributed memory object caching system

See all alternatives to MySQL

Latest News

MySQL @ FOSSASIA, 2018
Using dbdeployer in CI tests
Archiving MySQL Tables in ClickHouse
PostgreSQL rocks, except when it blocks: Understandi...
10.2
9.6.7
orchestrator 3.0.2 GA released: raft consensus, SQLite
Using Active Record migrations beyond SQLite


Interest Over Time