When you should use columnar databases and not Postgres, MySQL, or MongoDB

• pinot

  15 5,423 9.9 Java

  Apache Pinot - A realtime distributed OLAP datastore

  

  But then you realize there are other databases out there focused specifically on analytical use cases with lots of data and complex queries. Newcomers like ClickHouse, Pinot, and Druid (all open source) respond to a new class of problem: The need to develop applications using endpoints published on analytical queries that were previously confined only to the data warehouse and BI tools.

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• Druid

  25 13,443 9.9 Java

  Apache Druid: a high performance real-time analytics database.

  

  But then you realize there are other databases out there focused specifically on analytical use cases with lots of data and complex queries. Newcomers like ClickHouse, Pinot, and Druid (all open source) respond to a new class of problem: The need to develop applications using endpoints published on analytical queries that were previously confined only to the data warehouse and BI tools.

• PostgreSQL

  458 15,938 10.0 C

  Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch

  

  When you develop an application, your first choice for a database is often one of Postgres, MySQL, or - if NoSQL is more your thing - MongoDB. You can’t go wrong with any of these; they’re great general-purpose databases with huge communities and some excellent features (e.g. transactions) that make developers’ lives easier.

• MySQL

  162 10,757 9.8 C++

  MySQL Server, the world's most popular open source database, and MySQL Cluster, a real-time, open source transactional database.

  

  When you develop an application, your first choice for a database is often one of Postgres, MySQL, or - if NoSQL is more your thing - MongoDB. You can’t go wrong with any of these; they’re great general-purpose databases with huge communities and some excellent features (e.g. transactions) that make developers’ lives easier.

• MongoDB

  275 26,175 10.0 C++

  The MongoDB Database

  

  When you develop an application, your first choice for a database is often one of Postgres, MySQL, or - if NoSQL is more your thing - MongoDB. You can’t go wrong with any of these; they’re great general-purpose databases with huge communities and some excellent features (e.g. transactions) that make developers’ lives easier.

Suggest a related project