What is Citus?
It's an extension to Postgres that distributes data and queries in a cluster of multiple machines. Its query engine parallelizes incoming SQL queries across these servers to enable human real-time (less than a second) responses on large datasets.
Citus is a tool in the Databases category of a tech stack.
Citus is an open source tool with 7.8K GitHub stars and 542 GitHub forks. Here’s a link to Citus's open source repository on GitHub
Who uses Citus?
18 companies reportedly use Citus in their tech stacks, including Chime, Truebill, and Heap.
32 developers on StackShare have stated that they use Citus.
Java, PostgreSQL, Django, Heroku, and Kafka are some of the popular tools that integrate with Citus. Here's a list of all 14 tools that integrate with Citus.
Pros of Citus
Multi-core Parallel Processing
Drop-in PostgreSQL replacement
Distributed with Auto-Sharding
Jun 14 2018 at 2:23AM
- Multi-Node Scalable PostgreSQL
- Built-in Replication and High Availability
- Real-time Reads/Writes On Multiple Nodes
- Multi-core Parallel Processing of Queries
- Tenant isolation
Citus Alternatives & Comparisons
What are some alternatives to Citus?
See all alternatives
TimescaleDB: An open-source database built for analyzing time-series data with the power and convenience of SQL — on premise, at the edge, or in the cloud.
CockroachDB is distributed SQL database that can be deployed in serverless, dedicated, or on-prem. Elastic scale, multi-active availability for resilience, and low latency performance.
Apache Aurora is a service scheduler that runs on top of Mesos, enabling you to run long-running services that take advantage of Mesos' scalability, fault-tolerance, and resource isolation.
Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL.
It is a database solution for deploying, scaling and managing large clusters of MySQL instances. It’s architected to run as effectively in a public or private cloud architecture as it does on dedicated hardware. It combines and extends many important MySQL features with the scalability of a NoSQL database.