PostgreSQL vs. MariaDB vs. SQLite



Hacker News, Reddit, Stack Overflow Stats

  • 8.36K
  • 8.16K
  • 93.4K
  • 43
  • 398
  • 5.69K
  • 3.74K
  • 10K
  • 64K

GitHub Stats

No public GitHub repository stats available

Description

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 MariaDB?

Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry. MariaDB is designed as a drop-in replacement of MySQL(R) with more features, new storage engines, fewer bugs, and better performance.

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!

Ask a Question

Pros

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

Why do developers choose MariaDB?
Why do you like MariaDB?

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

Cons

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

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

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

Companies

What companies use PostgreSQL?
3017 companies on StackShare use PostgreSQL
What companies use MariaDB?
574 companies on StackShare use MariaDB
What companies use SQLite?
374 companies on StackShare use SQLite

Integrations

What tools integrate with PostgreSQL?
87 tools on StackShare integrate with PostgreSQL
What tools integrate with MariaDB?
9 tools on StackShare integrate with MariaDB
What tools integrate with SQLite?
15 tools on StackShare integrate with SQLite

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

  • MySQL - The world's most popular open source database
  • MongoDB - The database for giant ideas
  • Microsoft SQL Server - A relational database management system developed by Microsoft
  • Memcached - High-performance, distributed memory object caching system

See all alternatives to PostgreSQL

Latest News

PostgreSQL rocks, except when it blocks: Understandi...
9.5.11
10.2
Bitten by MariaDB 10.2 Incompatibile Change
MariaDB 10.2.13, MariaDB Connector/ODBC 3.0.3 and Ma...
MariaDB Server 10.2.13 now available
orchestrator 3.0.2 GA released: raft consensus, SQLite
Using Active Record migrations beyond SQLite


Interest Over Time


Get help choosing one of these