3 ms·

I am a database newbie, what are it's pros and cons over postgres?

• knz42 9y ago
  https://www.cockroachlabs.com/docs/cockroachdb-in-comparison.html https://www.cockroachlabs.com/docs/cockroachdb-in-comparison...
  • deleted 9y ago
    [deleted]
  • subsidd 9y ago
    Thank you!
• misterbowfinger 9y ago
  On a similar note, how does this compare against Citus?
  • manigandham 9y ago
    Citus is offered as a Postgres extension, primarily allowing you to run a cluster of postgres servers together as a single logical database with tables automatically sharded by a key of your choosing. Slightly limited but distributed SQL queries can run across all nodes to speed up access or scan lots of data - or you can choose something like a customer_id to shard all the tables the same way so that all data for that customer would be on the same node, allowing for full SQL syntax and features on data of that node (because it would just be a regular postgres server). For a data-warehouse/fast-realtime scenario, I would also recommend MemSQL although it is proprietary.