Open In App

Difference between SQLite and IBM DB2

Last Updated : 29 Jun, 2020
Like Article

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 :

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.

Like Article
Suggest improvement
Share your thoughts in the comments

Similar Reads