Skip to content
Related Articles

Related Articles

Difference between SQLite and dBASE
  • Last Updated : 27 Jul, 2020

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. dBASE :
dBase is a microcomputer database management system (DBMS) that runs on a Windows platform. It is one of the first database system that runs on microcomputer. It was developed by Asthon Tate in 1979 It is designed to manipulate relational databases. Nowdays, it dBASE PLUS 11 version is used.which as released in 2016.



Difference between SQLite and dBASE :-

S.N0.SQLitedBASE
1.Developed By D. Richard Hipp on August 2000.Developed by Asthon Tate in 1979
2.MYSQL is open  source   software, public domain software.dBASE is commercial software only licensed version.
3.SQLite do not have any server operting systemDOS and Windows are server operating system using dBASE.
4.ADO.NET, JDBC, ODBC, e.t.c are used as APIs and other access method.It does not support any APIs and access method.
5.SQLite support SQL(standard query language)dBASE does not support SQL
6.ACID properties (Atomicity, Consistency, Isolation, and Durability) of transaction is followed by SQLite.dBASE does not hold for ACID properties
7.No Access right for users in SQLiteAccess rights for users and roles is in dBASE
8.Triggers can be used in SQLiteTriggers can’t be used in dBASE.

My Personal Notes arrow_drop_up
Recommended Articles
Page :