DBMS > Derby vs. PostgreSQL vs. Tibero
System Properties Comparison Derby vs. PostgreSQL vs. Tibero
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Derby often called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDB Xexclude from comparison||PostgreSQL Xexclude from comparison||Tibero Xexclude from comparison|
|Description||Full-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||A secure RDBMS, designed for easy portability from Oracle|
|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.||Relational DBMS|
|Secondary database models||Document store|
|Developer||Apache Software Foundation||PostgreSQL Global Development Group www.postgresql.org/developer||TmaxSoft|
|Initial release||1997||1989 1989: Postgres, 1996: PostgreSQL||2003|
|Current release||10.16.1.1, May 2022||15.1, November 2022||6, April 2015|
|License Commercial or Open Source||Open Source Apache version 2||Open Source BSD||commercial|
|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.
|Implementation language||Java||C||C and Assembler|
|Server operating systems||All OS with a Java VM||FreeBSD|
|Typing predefined data types such as float or date||yes||yes||yes|
|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.||yes||yes specific XML-type available, but no XML query functionality.||yes|
|SQL Support of SQL||yes||yes standard with numerous extensions||yes|
|APIs and other access methods||JDBC||ADO.NET|
native C library
streaming API for large objects
Oracle Call Interface (OCI)
|Supported programming languages||Java||.Net|
|Server-side scripts Stored procedures||Java Stored Procedures||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||Persistent Stored Procedure (PSM)|
|Partitioning methods Methods for storing different data on different nodes||none||partitioning by range, list and (since PostgreSQL 11) by hash||horizontal partitioning by range, hash, list or composite|
|Replication methods Methods for redundantly storing data on multiple nodes||Source-replica replication||Source-replica replication other methods possible by using 3rd party extensions||Multi-source replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes||yes||yes|
|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|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||no||no planned for next version|
|User concepts Access control||fine grained access rights according to SQL-standard||fine grained access rights according to SQL-standard||fine grained access rights according to SQL-standard (SQL 92, SQL 99)|
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||EDB: BigAnimal is fully-managed PostgreSQL in the cloud from the database fanatics at EDB.|
DbVisualizer is equipping database professionals with the tools they need to build, manage and maintain state-of-the-art database technologies. It has sky-high user satisfaction and is the preferred tool for database professionals around the world. Customers include Tesla, Apple, Facebook, Deutsche Bank, NASA, and 25,000 others in 145 countries.
SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
Percona: Database problems? Not on your watch.
Databases run better with Percona.
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
Fujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance.
Instaclustr: Fully Hosted & Managed PostgreSQL
Datasentinel: Platform for Monitoring and Analyzing the performance problems of your PostgreSQL Clusters
The State of PostgreSQL 2022 survey is now open!
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.
pgDash: In-Depth PostgreSQL Monitoring.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Derby often called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDB||PostgreSQL||Tibero|
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2021
|Recent citations in the news|
Six free databases with commercial-quality features
Java News Roundup: JEP Updates, GraalVM Code to OpenJDK, Return of JavaOne
The Ultimate Open Source Database List Profiling 16 Software Tools
Security Bulletin 20 Apr 2022
JDK 9 Is the End of the Road for Some Features
provided by Google News
3 key features in EDB PostgreSQL 15
AWS Brings Trusted Extension Support to Managed Postgres
Why We Built Cloud Native Object Storage for PostgreSQL with Amazon S3
How to Launch a PostgreSQL Database in the Cloud With AWS RDS - MUO
New Features for Azure Database for PostgreSQL Flexible Server
provided by Google News
Open-source DBMS becoming battleground of public cloud
provided by Google News
Database Developer (PostgreSQL)
Share this page