Master Using SQL with Python: Lesson 11 – Using JSON with SQLite

In this video, you will learn how to create, store, and retrieve JSON objects using Python and SQLite. JSON is a very popular way to share data and SQLite has powerful features to store and query JSON. In this video, I’ll show you how to get data from a website in JSON format, store it in a SQLite table, retrieve the JSON, and perform queries on it.

Slides and Code available at:
https://github.com/bcafferky/shared/blob/master/PythonSQL/Lesson_11_PythonSQLIteJSON.zip

Download and Unzip the file.

My video on installing and using SQLite Studio
https://www.youtube.com/watch?v=dugUk893gxQ&t=4s