tutorial on creating interface for sqlite database

#Tutorial on creating interface for sqlite database how to

Note: It is also possible to connect to a SQLite database that resides strictly in memory (and not in a file) by passing the special string ':memory:' into nnect(). If, at any time, we find we want to start this tutorial again, we can delete the aquarium.db file from our computer. Since we have not executed any SQL commands yet, 0 total_changes is correct.

We can connect to a SQLite database using the Python sqlite3 module:Ĭonnection.total_changes is the total number of database rows that have been changed by connection. For now, we’ll consider a database that tracks the inventory of fish at a fictional aquarium. SQLite databases are fully featured SQL engines that can be used for many purposes. When we connect to a SQLite database, we are accessing data that ultimately resides in a file on our computer. Step 1 - Creating a Connection to a SQLite Database You can review these tutorials for the necessary background information:

To get the most out of this tutorial, it is recommended to have some familiarity with programming in Python and some basic background with SQL. We’ll create a connection to a SQLite database, add a table to that database, insert data into that table, and read and modify data in that table.įor this tutorial, we’ll be working primarily with an inventory of fish that we need to modify as fish are added to or removed from a fictional aquarium. In this tutorial, we’ll go through the sqlite3 module in Python 3. SQLite comes bundled with Python and can be used in any of your Python applications without having to install any additional software. SQLite is a self-contained, file-based SQL database. It has been reproduced here with some minor edits. This article was originally published in DigitalOcean’s public knowledge base.

#Tutorial on creating interface for sqlite database how to

David Muller My book: Intuitive Python ↗ How To Use the sqlite3 Module in Python 3