SQLite is simple, small and effective SQL database engine which doesn't need a seperate server to run. It's a simple library which can run along with the running process and once can use the SQL database without communicating over the networks or sockets

This video is all about using sqlite database. The working of the sqlite database is explained using python programming language, but sqlite can be used in the relatively similar way in most of the popular programming languages of the world.

This video explains the working of sqlite database, creation of sqlite databases, both disk database as well as in memory databases.

How sqlite connections and sqlite cursors are used for adding data as well as foe retrieving data from the database tables.

Finally, this video also explains the sqlite master table and for what purpose it is used in the sqlite. so basically, you'll get a fair idea about the sqlite database and its usage after watching this video. I do hope and believe that you'll like this video

Thanks for watching

0:00: Simplicity in software development
0:44: SQLite a simple SQL database
01:19 : What is Sqlite ? A simple SQL engine
02:21 : The SQLite Library
03:07 : Using Sqlite with Python Programming Language
04:15 : SQLite connection and cursor
06:00 : SQLite Master Table
06:56 : Columns of sqlite master table
08:20 : Inserting records in sqlite database tables
08:44 : Commit the data in sqlite database tables
09:24 : Inserting multiple records at once in sqlite database
10:24 : Inserting into sqlite with rollbacks
11:49 : Inserting bulk data in the sqlite database
12:47 : Sqlite Commit for null inserts - considerations
14:07 : Sqlite in memory database table
14:31 : Comparison between Sqlite in memory vs disk tables
15:26 : Sqlite database using python

#sqlite #SQL #database

#CognitiveProgrammer