SQLite is a C library that provides a lightweight disk-based database that doesn’t require a separate server process and allows accessing the database using a nonstandard variant of the SQL query language. sqlite3 is a Python package that provides a SQL interface.
To program in an object-oriented style:
When an object is instantiated, it is connected to the database. db is the database file name, such as “stock_quotes.db”. If the file does not exist, a new database file will be created.