Hadoop vs HBase vs PostgreSQL

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

Hadoop

2.5K
2.3K
+ 1
56
HBase

453
492
+ 1
15
PostgreSQL

95.6K
80K
+ 1
3.5K
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Hadoop
Pros of HBase
Pros of PostgreSQL
  • 39
    Great ecosystem
  • 11
    One stack to rule them all
  • 4
    Great load balancer
  • 1
    Amazon aws
  • 1
    Java syntax
  • 9
    Performance
  • 5
    OLTP
  • 1
    Fast Point Queries
  • 762
    Relational database
  • 510
    High availability
  • 439
    Enterprise class database
  • 383
    Sql
  • 304
    Sql + nosql
  • 173
    Great community
  • 147
    Easy to setup
  • 131
    Heroku
  • 130
    Secure by default
  • 113
    Postgis
  • 50
    Supports Key-Value
  • 48
    Great JSON support
  • 34
    Cross platform
  • 32
    Extensible
  • 28
    Replication
  • 26
    Triggers
  • 23
    Rollback
  • 22
    Multiversion concurrency control
  • 21
    Open source
  • 18
    Heroku Add-on
  • 17
    Stable, Simple and Good Performance
  • 15
    Powerful
  • 13
    Lets be serious, what other SQL DB would you go for?
  • 11
    Good documentation
  • 8
    Intelligent optimizer
  • 8
    Free
  • 8
    Scalable
  • 8
    Reliable
  • 7
    Transactional DDL
  • 7
    Modern
  • 6
    One stop solution for all things sql no matter the os
  • 5
    Relational database with MVCC
  • 5
    Faster Development
  • 4
    Developer friendly
  • 4
    Full-Text Search
  • 3
    Free version
  • 3
    Great DB for Transactional system or Application
  • 3
    Relational datanbase
  • 3
    search
  • 3
    Open-source
  • 3
    Excellent source code
  • 2
    Full-text
  • 2
    Text
  • 0
    Native

Sign up to add or upvote prosMake informed product decisions

Cons of Hadoop
Cons of HBase
Cons of PostgreSQL
    Be the first to leave a con
      Be the first to leave a con
      • 10
        Table/index bloatings

      Sign up to add or upvote consMake informed product decisions

      What is Hadoop?

      The Apache Hadoop software library is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models. It is designed to scale up from single servers to thousands of machines, each offering local computation and storage.

      What is HBase?

      Apache HBase is an open-source, distributed, versioned, column-oriented store modeled after Google' Bigtable: A Distributed Storage System for Structured Data by Chang et al. Just as Bigtable leverages the distributed data storage provided by the Google File System, HBase provides Bigtable-like capabilities on top of Apache Hadoop.

      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.

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

      What companies use Hadoop?
      What companies use HBase?
      What companies use PostgreSQL?

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

      What tools integrate with Hadoop?
      What tools integrate with HBase?
      What tools integrate with PostgreSQL?

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

      Blog Posts

      Dec 8 2020 at 5:50PM

      DigitalOcean

      GitHubMySQLPostgreSQL+11
      2
      2354
      Jun 24 2020 at 4:42PM

      Pinterest

      Amazon S3KafkaHBase+4
      4
      1209
      MySQLKafkaApache Spark+6
      2
      2003
      What are some alternatives to Hadoop, HBase, and PostgreSQL?
      Cassandra
      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.
      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.
      Elasticsearch
      Elasticsearch is a distributed, RESTful search and analytics engine capable of storing data and searching it in near real time. Elasticsearch, Kibana, Beats and Logstash are the Elastic Stack (sometimes called the ELK Stack).
      Splunk
      It provides the leading platform for Operational Intelligence. Customers use it to search, monitor, analyze and visualize machine data.
      Snowflake
      Snowflake eliminates the administration and management demands of traditional data warehouses and big data platforms. Snowflake is a true data warehouse as a service running on Amazon Web Services (AWS)—no infrastructure to manage and no knobs to turn.
      See all alternatives