Citus vs ClustrixDB vs PostgreSQL

Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Citus
Citus

27
22
+ 1
8
ClustrixDB
ClustrixDB

0
3
+ 1
3
PostgreSQL
PostgreSQL

15.9K
11.8K
+ 1
3.4K
- No public GitHub repository available -

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.

What is ClustrixDB?

ClustrixDB is a scale-out SQL database built from the ground up with a distributed shared nothing architecture, automatic data redistribution (so you never need to shard), with built in fault tolerance, all accessible by a simple SQL interface and support for business critical MySQL features – replication, triggers, stored routines, etc.

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.
Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Why do developers choose Citus?
Why do developers choose ClustrixDB?
Why do developers choose PostgreSQL?

Sign up to add, upvote and see more prosMake informed product decisions

What are the cons of using Citus?
What are the cons of using ClustrixDB?
What are the cons of using PostgreSQL?
    Be the first to leave a con
      Be the first to leave a con
      What companies use Citus?
      What companies use ClustrixDB?
      What companies use PostgreSQL?
        No companies found

        Sign up to get full access to all the companiesMake informed product decisions

        What tools integrate with Citus?
        What tools integrate with ClustrixDB?
        What tools integrate with PostgreSQL?
          No integrations found

          Sign up to get full access to all the tool integrationsMake informed product decisions

          What are some alternatives to Citus, ClustrixDB, and PostgreSQL?
          TimescaleDB
          TimescaleDB is the only open-source time-series database that natively supports full-SQL at scale, combining the power, reliability, and ease-of-use of a relational database with the scalability typically seen in NoSQL databases.
          CockroachDB
          Cockroach Labs is the company building CockroachDB, an open source, survivable, strongly consistent, scale-out SQL database.
          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.
          MongoDB
          MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
          Microsoft SQL Server
          Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.
          See all alternatives
          Decisions about Citus, ClustrixDB, and PostgreSQL
          No stack decisions found
          Interest over time
          Reviews of Citus, ClustrixDB, and PostgreSQL
          No reviews found
          How developers use Citus, ClustrixDB, and PostgreSQL
          Avatar of AngeloR
          AngeloR uses PostgreSQLPostgreSQL

          We use postgresql for the merge between sql/nosql. A lot of our data is unstructured JSON, or JSON that is currently in flux due to some MVP/interation processes that are going on. PostgreSQL gives the capability to do this.

          At the moment PostgreSQL on amazon is only at 9.5 which is one minor version down from support for document fragment updates which is something that we are waiting for. However, that may be some ways away.

          Other than that, we are using PostgreSQL as our main SQL store as a replacement for all the MSSQL databases that we have. Not only does it have great support through RDS (small ops team), but it also has some great ways for us to migrate off RDS to managed EC2 instances down the line if we need to.

          Avatar of Cloudcraft
          Cloudcraft uses PostgreSQLPostgreSQL

          PostgreSQL combines the best aspects of traditional SQL databases such as reliability, consistent performance, transactions, querying power, etc. with the flexibility of schemaless noSQL systems that are all the rage these days. Through the powerful JSON column types and indexes, you can now have your cake and eat it too! PostgreSQL may seem a bit arcane and old fashioned at first, but the developers have clearly shown that they understand databases and the storage trends better than almost anyone else. It definitely deserves to be part of everyone's toolbox; when you find yourself needing rock solid performance, operational simplicity and reliability, reach for PostgresQL.

          Avatar of Brandon Adams
          Brandon Adams uses PostgreSQLPostgreSQL

          Relational data stores solve a lot of problems reasonably well. Postgres has some data types that are really handy such as spatial, json, and a plethora of useful dates and integers. It has good availability of indexing solutions, and is well-supported for both custom modifications as well as hosting options (I like Amazon's Postgres for RDS). I use HoneySQL for Clojure as a composable AST that translates reliably to SQL. I typically use JDBC on Clojure, usually via org.clojure/java.jdbc.

          Avatar of ReviewTrackers
          ReviewTrackers uses PostgreSQLPostgreSQL

          PostgreSQL is responsible for nearly all data storage, validation and integrity. We leverage constraints, functions and custom extensions to ensure we have only one source of truth for our data access rules and that those rules live as close to the data as possible. Call us crazy, but ORMs only lead to ruin and despair.

          Avatar of Jeff Flynn
          Jeff Flynn uses PostgreSQLPostgreSQL

          Tried MongoDB - early euphoria - later dread. Tried MySQL - not bad at all. Found PostgreSQL - will never go back. So much support for this it should be your first choice. Simple local (free) installation, and one-click setup in Heroku - lots of options in terms of pricing/performance combinations.

          How much does Citus cost?
          How much does ClustrixDB cost?
          How much does PostgreSQL cost?
          Pricing unavailable
          Pricing unavailable
          News about ClustrixDB
          More news