Introduction to Python SQL libraries

Click for: original source

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]

Tags python mysql database software-architecture