Difference between SQLite and IBM DB2

1. SQLite :
SQLite is a software library that provides a relational database management system (RDBMS). It was designed by D. Richard Hipp on August 2000. The design goals of SQLite were to allow the program to be operated without installing a database management system (DBMS) or requiring a database administrator. The lite in SQLite means light weight in terms of setup, database administration, and required resource.

2. IBM Db2 :
IBM Db2 is a family of data management products, including database servers, developed by IBM. It is a Relational Database Management System (RDBMS) which supports object-oriented features and non relational structure with XML. Db2 is designed to store, analyze and retrieve the data efficiently. It was initially released in 1983 and is written in C, C++, Java and Assembly language.



Difference between SQLite and IBM Db2 :

SR.NO SQLite IBM Db2
1. It is developed by D. Richard Hipp in 2000. It is developed by IBM in 1983.
2 SQLite server operating systems are server-less. Db2 server operating systems are AIX, HP-UX, Linux, Solaris, Windows and z/OS.
3 The primary database model for SQLite is Relational DBMS. The primary database model for IBM Db2 is Relational DBMS.
4 It is written in C language. It is written in C, C++, Assembly language, Java languages.
5 Famous companies like Adobe, Google, Bosch, Facebook, Dropbox, etc uses SQLite. Famous companies like JPMorgan Chase, Bank of America, Scotiabank, Citi, etc use Db2.
6 It provide in-memory capabilities. It do not provide in-memory capabilities .
7 It is a open source software framework. It is a commercial databases.
8 It supports Secondary indexes. It supports the secondary indexes without any restrictions.
9 It supports C, C#, C++, Matlab info, ColdFusion info, R info, Dart info, Delphi info, Erlang, Java, JavaScript, PHP, Python, Ruby. It supports C, C++, Cobol, Java, Perl, PL/1, Python, R, Ruby.
10 It do not provides access rights for users and roles. It provide fine grained access rights according to SQL-standard.

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.