PostgreSQL vs. Citus vs. CrateIO



Hacker News, Reddit, Stack Overflow Stats

  • 8.36K
  • 8.16K
  • 93.4K
  • 3.65K
  • 2.84K
  • 39
  • 763
  • 1.28K
  • 0

GitHub Stats

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

Citus is worry-free Postgres for SaaS. Made to scale out, Citus is an extension to Postgres that distributes queries across any number of servers. Citus is available as open source, as on-prem software, and as a fully-managed service.

What is CrateIO?

Crate is a distributed data store. Simply install Crate directly on your application servers and make the big centralized database a thing of the past. Crate takes care of synchronization, sharding, scaling, and replication even for mammoth data sets.

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 Citus?
Why do you like Citus?

Why do developers choose CrateIO?
Why do you like CrateIO?

Cons

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

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

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

Pricing

How much does PostgreSQL cost?
How much does Citus cost?
Citus Pricing
How much does CrateIO cost?

Companies

What companies use PostgreSQL?
3021 companies on StackShare use PostgreSQL
What companies use Citus?
15 companies on StackShare use Citus
What companies use CrateIO?
0 companies on StackShare use CrateIO

Integrations

What tools integrate with PostgreSQL?
87 tools on StackShare integrate with PostgreSQL
What tools integrate with Citus?
14 tools on StackShare integrate with Citus
What tools integrate with CrateIO?
2 tools on StackShare integrate with CrateIO

What are some alternatives to PostgreSQL, Citus, and CrateIO?

  • 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
  • MariaDB - An enhanced, drop-in replacement for MySQL

See all alternatives to PostgreSQL

Latest News

PostgreSQL rocks, except when it blocks: Understandi...
9.3.21
9.4.16
How the Citus distributed database rebalances your data
Citus 7.2: Distributed Postgres w/ CTEs, complex sub...
Citus and pg_partman: Creating a scalable time serie...


Interest Over Time


Get help choosing one of these