SQLite
SQLite
SQLite is an open-source relational database engine designed to be embedded in numerous applications. The database can be used in management of different structured data or as a back-end database for desktop, web, and mobile apps. SQLite is a C-language library that implements a SQL database engine which is relatively fast, reliable, serverless and self-contained. The sqlite3 python module provides an easy interface to interact and work with SQLite database. Below are projects where I have used python sqlite3 modules and other packages to interact with the SQL database.
Topics
Use python to create Sql database within a specified directory, create a table within the specified database, and insert data within the created table.
Part 2: Writing Query Statements
Write query statements using python to query the sql database, update contents within the database, and also create index for the sql table.