1 |
It is developed by Apache Software Foundation in 1997. |
It is developed by PostgreSQL Global Development Group in 1989. |
2 |
It is written in Java language. |
It is written in C language. |
3 |
The primary database model for Derby is Relational DBMS. |
The primary database model for PostgreSQL is Relational DBMS. |
4 |
Server operating systems for Derby are Windows, macOs, Linux, Unix, BSD and z/OS. |
PostgreSQL server operating systems are FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, OS X, Solaris, Unix and Windows. |
5 |
It support only Java programming language. |
It supports C, .Net, C++, Java, JavaScript, PHP, Python, Ruby. |
6 |
APIs and other access methods used by Derby is JDBC. |
It uses ADO.NET, JDBC, native C library, ODBC, streaming API for large objects as APIs. |
7 |
It provide fine grained access rights according to SQL-standard. |
It provides access rights for users and roles. |
8 |
It has Java Stored Procedures for Server-side scripts. |
It has user defined functions for Server-side scripts. |
9 |
It support in-memory capabilities. |
It do not support in-memory capabilities. |
10 |
It supports Secondary indexes. |
It also supports Secondary indexes. |