Skip to content
Related Articles
Open in App
Not now

Related Articles

Difference between SQLite and IBM DB2

Improve Article
Save Article
  • Last Updated : 29 Jun, 2020
Improve Article
Save 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.
2SQLite server operating systems are server-less.Db2 server operating systems are AIX, HP-UX, Linux, Solaris, Windows and z/OS.
3The primary database model for SQLite is Relational DBMS.The primary database model for IBM Db2 is Relational DBMS.
4It is written in C language.It is written in C, C++, Assembly language, Java languages.
5Famous companies like Adobe, Google, Bosch, Facebook, Dropbox, etc uses SQLite.Famous companies like JPMorgan Chase, Bank of America, Scotiabank, Citi, etc use Db2.
6It provide in-memory capabilities.It do not provide in-memory capabilities .
7It is a open source software framework.It is a commercial databases.
8It supports Secondary indexes.It supports the secondary indexes without any restrictions.
9It 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.
10It do not provides access rights for users and roles.It provide fine grained access rights according to SQL-standard.

My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!