Introduction to Python SQL Libraries

 By realpython - 2020-12-28

Description

In this step-by-step tutorial, you'll learn how to connect to different database management systems by using various Python SQL libraries. You'll interact with SQLite, MySQL, and PostgreSQL databases ...

Summary

  • All software applications interact with data, most commonly through a database management system (DBMS).
  • Just like with SQLite, you need to pass your query to cursor.execute(), which is returned by calling .cursor() on the connection object.
  • The process for creating the likes table is the same.
  • SQLite To insert records into your SQLite database, you can use the same execute_query() function that you used to create tables.

 

Topics

  1. Database (0.3)
  2. Coding (0.15)
  3. UX (0.05)

Similar Articles

Python and MySQL Database: A Practical Introduction

By realpython - 2021-01-22

In this tutorial, you'll learn how to connect your Python application with a MySQL database. You'll design a movie rating system and perform some common queries on it. You'll also see best practices a ...

How to Create an Index in Django Without Downtime

By realpython - 2020-12-06

In this step-by-step Python tutorial, you'll get a solid understanding of the limitations of Django migrations by tackling a well known problem: creating an index in Django with no downtime.

Dump and load a database in Neo4j Desktop

By Graph people - 2020-11-11

Have you ever wanted to share a database you created in Neo4j Desktop with your colleague but not sure exactly how to go about it? Maybe you want to clone the database locally to perform various write ...

How to use IndexedDB to build Progressive Web Apps

By Medium - 2020-09-01

In this previous post, I talked about implementation of IndexedDB inside Service Workers. If you don’t understand that part, please read that article to clear up some concepts about service workers…