1 |
It is developed by Apache Software Foundation in 1997 |
It is developed By D. Richard Hipp in 2000. |
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 SQLite is Relational DBMS. |
4 |
Server operating systems for Derby are Windows, macOs, Linux, Unix, BSD and z/OS. |
SQLite does not require a server to run. Hence, it is serverless. |
5 |
It has Java Stored Procedures for Server-side scripts. |
It does not support Server-side scripting. |
6 |
It support Master-Slave Replication methods. |
It does not support any replication methods. |
7 |
APIs and other access methods used by Derby is JDBC. |
APIs and other access methods used by SQLite are ADO.NET, JDBC and ODBC. |
8 |
It support only Java programming language. |
It support C, C#, C++, D, Delphi, Java, JavaScript, Lua, MatLab, Objective-C, Perl, PHP, PL/SQL, Python, R, Ruby, Scala, etc. |
9 |
It provide XML support. |
It do not provide XML support. |
10 |
It support fine grained access rights according to SQL-standard. |
It do not support access rights for user. |