Overview Of SQLite

Introduction

SQLite
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

SQLite

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.

SQLite

Step 2

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

SQLite

Step 3

Go to the Advanced System Settings.

SQLite

Step 4

Click the "Environmental Variables" option.

SQLite

Step 5

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

SQLite

Step 6

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

SQLite

Step 7

Type “sqlite3” and hit Enter.

SQLite

Deliverables

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

SQLite

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