Overview Of SQLite

Introduction


SQLite is an open source project and an embedded relational database engine which is used to manipulate the data in the database. SQLite is more efficient than other database engines in Android applications. SQLite is written in C programming language and it contains the C programming library. it is not a client–server database engine; rather, SQLite is embedded into the end program. It implements SQL-92 standard. Lots of software programs use SQLite internally, such as Android apps, Google Chrome, Firefox etc.

In this article, I will show you how to use SQLite in Android Studio to create the Android database.

Details of SQLite

Developer - D. Richard Hipp



Release date - August 17, 2000

Operating system - cross-platform

License - public domain

Current version - SQLite 3.19.3

Type - Relational database management system (embedded)

Repository - https -//www.sqlite.org/src/doc/trunk/README.md

Website - https -//sqlite.org/

Steps to be followed

Carefully follow the below steps to use SQLite in Android Studio to create Android database.

Step 1

Open Android Studio and click SDK Manager.



Step 2

Copy your SDK location path and add the "/platform-tools" phrase at the end of the SDK location.



Step 3

Go to the Advanced System Settings.



Step 4

Click the "Environmental Variables" option.



Step 5

Click New >>  add variable name as path >> add variable value as your SDK location path. After that, click OK.



Step 6

Press Windows+R and type cmd followed by a hit on Enter button. Type “adb” in your command prompt.



Step 7

Type “sqlite3” and hit Enter.



Deliverables

Here, we have successfully established the connection between SQLite to Android Studio.



Don’t forgot to like and follow me. If you have any doubts, just comment below.