PostgreSQL vs. Microsoft SQL Server vs. SQLite

Get help choosing one of these Get news updates about these tools


Favorites

405

Favorites

31

Favorites

71

Hacker News, Reddit, Stack Overflow Stats

  • 8.36K
  • 8.07K
  • 92.2K
  • 22K
  • 43K
  • 0
  • 3.74K
  • 8.91K
  • 63.6K

GitHub Stats

No public GitHub repository stats available
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 Microsoft SQL Server?

Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.

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.

Pros

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

    Why do developers choose Microsoft SQL Server?
  • Why do you like Microsoft SQL Server?

    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 Microsoft SQL Server?
    No Cons submitted yet for Microsoft SQL Server
    Downsides of Microsoft SQL Server?

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

    Companies

    What companies use PostgreSQL?
    2248 companies on StackShare use PostgreSQL
    What companies use Microsoft SQL Server?
    393 companies on StackShare use Microsoft SQL Server
    What companies use SQLite?
    258 companies on StackShare use SQLite

    Integrations

    What tools integrate with PostgreSQL?
    88 tools on StackShare integrate with PostgreSQL
    What tools integrate with Microsoft SQL Server?
    23 tools on StackShare integrate with Microsoft SQL Server
    What tools integrate with SQLite?
    15 tools on StackShare integrate with SQLite

    What are some alternatives to PostgreSQL, Microsoft SQL Server, and SQLite?

    • MySQL - The world's most popular open source database
    • MongoDB - The database for giant ideas
    • MariaDB - An enhanced, drop-in replacement for MySQL
    • 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
    9.6.7
    Microsoft SQL Server cookbook release – 5.4.0
    orchestrator 3.0.2 GA released: raft consensus, SQLite
    Using Active Record migrations beyond SQLite


    Interest Over Time


    Get help choosing one of these