Getting started with sqlite3 in Python

Intro

SQLite is a user friendly, file-based SQL database. It comes bundled with Python and can be used in any of your Python apps without having to install any additional software.

In this post we’ll walk through the sqlite3 module in Python. We’ll create a connection to a SQLite database, add a table, insert data into that table, and read data in that table.

1. Connecting to the database

We can connect to a SQLite database using the Python sqlite3 …

apps database install intro python software sql sql database sqlite table through