DBMS > HyperSQL vs. PostgreSQL vs. Quasardb
System Properties Comparison HyperSQL vs. PostgreSQL vs. Quasardb
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||HyperSQL also known as HSQLDB Xexclude from comparison||PostgreSQL Xexclude from comparison||Quasardb Xexclude from comparison|
|Description||Multithreaded, transactional RDBMS written in Java also known as HSQLDB||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||Distributed, high-performance timeseries database|
|Primary database model||Relational DBMS||Relational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.||Time Series DBMS|
|Secondary database models||Document store|
Graph DBMS with Apache Age
Vector DBMS with pgvector extension
|Developer||PostgreSQL Global Development Group www.postgresql.org/developer||quasardb|
|Initial release||2001||1989 1989: Postgres, 1996: PostgreSQL||2009|
|Current release||2.7.1, October 2022||16.0, September 2023||3.13.3, April 2022|
|License Commercial or Open Source||Open Source based on BSD license||Open Source BSD||commercial Free community edition, Non-profit organizations and non-commercial usage are eligible for free licenses|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Aiven for PostgreSQL: Fully managed and hosted PostgreSQL® with 70+ extensions and orchestration tooling included.|
|Server operating systems||All OS with a Java VM Embedded (into Java applications) and Client-Server operating modes||FreeBSD|
|Typing predefined data types such as float or date||yes||yes||yes integer and binary|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no||yes specific XML-type available, but no XML query functionality.||no|
|Secondary indexes||yes||yes||yes with tags|
|SQL Support of SQL||yes||yes standard with numerous extensions||SQL-like query language|
|APIs and other access methods||HTTP API JDBC via HTTP|
native C library
streaming API for large objects
|Supported programming languages||All languages supporting JDBC/ODBC|
|Server-side scripts Stored procedures||Java, SQL||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||no|
|Partitioning methods Methods for storing different data on different nodes||none||partitioning by range, list and (since PostgreSQL 11) by hash||Sharding consistent hashing|
|Replication methods Methods for redundantly storing data on multiple nodes||none||Source-replica replication other methods possible by using 3rd party extensions||Source-replica replication with selectable replication factor|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||with Hadoop integration|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes by using LevelDB|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||no||yes Transient mode|
|User concepts Access control||fine grained access rights according to SQL-standard||fine grained access rights according to SQL-standard||Cryptographically strong user authentication and audit trail|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Datasentinel: Platform for Monitoring and Analyzing the performance problems of your PostgreSQL Clusters|
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
Instaclustr: Fully Hosted & Managed PostgreSQL
Aiven for PostgreSQL: The familiar open source PostgreSQL® that you know and love, with no proprietary features or add-ons that will lock you in.
Fujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance.
Timescale: Calling all PostgreSQL users – the 2023 State of PostgreSQL survey is now open! Share your favorite extensions, preferred frameworks, community experiences, and more. Take the survey today!
Redgate webinars: A series of key topics for new PostgreSQL users.
pgDash: In-Depth PostgreSQL Monitoring.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|HyperSQL also known as HSQLDB||PostgreSQL||Quasardb|
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2022, defending the title from last year
|Recent citations in the news|
Introduction to JDBC with HSQLDB tutorial
HyperSQL DataBase flaw leaves library vulnerable to RCE
Upcoming ‘critical’ OpenSSL update prompts feverish speculation
SQLite patches 22-year-old code execution, denial of service vulnerability
Open-source DBMS becoming battleground of public cloud
provided by Google News
4 key new features in PostgreSQL 16
PostgreSQL brings more performance, security to open-source ...
PostgreSQL 16: Where enhanced security meets high performance
What is AlloyDB for PostgreSQL?. Read more on | by Govindhtech ...
26 Years Since its Inception, Postgres is Just Getting Started
provided by Google News
Quasar and PTC Establish a Data-Driven Partnership for IoT
Quasar Partners with PTC to Empower IoT Customers with High ...
Time Series Databases Software Market (2023-2030): Emerging Technologies, Business Models, and Future Dev
2023-2031 Cloud-Based Time Series Database Market is Growing Rapidly with Modern Trend
Real-time Analytics News for the Week Ending September 16
provided by Google News
Sr PostgreSQL DBA
PostgreSQL and Oracle Database Administrator with AWS
PostgreSQL & DB2 (Day 1 on-site)
Share this page