All software applications interact with data, most commonly through a database management system (DBMS). Some programming languages come with modules that you can use to interact with a DBMS, while others require the use of third-party packages. In this tutorial, you will explore the different Python SQL libraries that you can use. You will develop a straightforward application to interact with SQLite, MySQL, and PostgreSQL databases. By Usman Malik.
- Understanding the database schema
- Using Python SQL libraries to connect to a database
- Creating tables
- Inserting records
- Selecting records
- Updating table records
- Deleting table records
SQLite is probably the most straightforward database to connect to with a Python application since you don’t need to install any external Python SQL modules to do so. What’s more, SQLite databases are serverless and self-contained, since they read and write data to a file. By default, your Python installation contains a Python SQL library named sqlite3 that you can use to interact with an SQLite database.
Links to further resources also included. Straight forward good tutorial!
[Read More]