SQLiteDB Introduction:

SQLite is free RDBMS database for any commercial or private purposes. It is the most widely deployed database in the world with several applications.

SQlite is an embedded SQL database engine which does not have a separate server process. It contains an in-process library that provides a self-contained, serverless, transactional, zero-configuration database engine.

SQLite communicate directly with application without any server as middle man. Hence it reads and writes directly to ordinary disk files.

Let’s quickly learn SQLiteDB and explore!!!

How to Install SQLiteDB?

Installation of SQLite Database on Windows, It is very simple installation. Just follow the below steps.First, download the latest version of SQLite database software for your windows operation system. Learn more..

What are the features of SQLiteDB?

SQLite does not work as like client/server architecture. As it does not require any server to run. It is bind with application that access the database with in the same application server. Hence SQLite is server-less architecture. Learn more..

Understanding datatypes in SQLiteDB:

SQLite is a dynamic type system which is backward compatible with many static type systems of other database engines.Each value stored in SQLite database will have one of the below storage classes. Learn more..

How to create commands in SQLiteDB?

In SQLite, the below command allows us to create the SQLite database.Verify the database that created with the below command.To exit from the SQLite prompt, you need to give the below quit command. Learn more..

How to attach DB in SQLiteDB?

You created multiple databases in SQLite and how to connect only the database you want. That can be achieved by using the command attach database. Learn more..

How to Detach DB in SQLiteDB?

In SQLite, we need to use the below command to detach the database that was attached .you cannot DETACH the main and temp Databases. Learn more..

How to create a table in SQLiteDB?

In SQLite, you can create a new table using the command CREATE TABLE. Please find the syntax as below.Let’s create a table called customers in the SQLite Database customer. Learn more..

How to Alter table in SQLiteDB?

In SQLite, altering table can be done in 2 ways. Rename the table, Add a new column is not possible to rename or delete the existing column.You cannot add or remove the constraints too. So be careful when you adding a new column make sure that you are not mentioning the constraints. Learn more..

How to Drop table in SQLiteDB?

In SQLite, you can drop a table using the DROP TABLE command. Please make note that once the table is dropped, the associated data, indexes, triggers everything will be deleted from the database. Learn more..

How to Insert Query in SQLiteDB?

SQLite INSERT can be used to insert the data into the tables in different ways like inserting a single row or multiple rows or a default values in the table. Learn more..