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:

Download and Unzip the file.

My video on installing and using SQLite Studio

Рекомендации по теме

Комментарии

Definitely would like more videos working with both JSON and REGEX in SQL

lglexrs

Thanks for making this video, Bryan. It's the clearest example of working with JSON in SQLite using Python I've seen! Much appreciated!

danmisener

i definitely like to see more about the json usage in sqlite/postgres with python. especially using twitter api v2. thanks for the series. it really helps. best.

notterboutuyer

Thank you very much. Your explanations are very good

OrigamOx

Thanks Bryan! Add my vote to doing more sessions with Python/JSON --> into SQL Server, SQLite, & even Snowflake if you have the time!!! Thanks again for your great series!

michaeleidson

i get this issue when i try the panda lib
Execution failed on sql '
select json_extract(data, '$.id') as id,
order by id,
limit 5;': near "order": syntax error

izthed

Would these efforts be this straightforward using JavaScript?

Imaginativeone_DF

Hi. Thanks for your great content.

I use sqlite3 version 3.34 with python 3.8.

I get error when using json extract:
cursor.execute('''select json_extract(data, '$.name', '$.iso2Code', '$.id') from countries;''').fetchmany(8)

OperationalError: no such function: json_extract

SAliGhasempouri

thank you. How can we json_extract a nested variable?

jiweihe

Why I'm getting "OperationalError: no such function: json_extract
" without doing anything on the code! Getting mad:)

paolorussi

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

Master Using SQL with Python: Lesson 1 - Using SQL with Pandas

SQL + Python: Master Data Analysis and Create PDF Reports

SQL With Python | Python Database Connectivity Tutorial | SQL Tutorial For Beginners | Simplilearn

Master Using SQL with Python: Lesson 4 - Using SQLite for Data Analysis

#73 Python Database Connection | MySQL

SQL Databases with Pandas and Python - A Complete Guide

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

Master Using SQL with Python: Lesson 3 - Using Enterprise Databases with ODBC

Session - 4 : Python Data Types | Azure Data Engineering

Python or MySQL?? #python #sql

SQL Tutorial - Full Database Course for Beginners

Master Using SQL with Python: Lesson 2 - Using SQLite

Master Using SQL with Python: Lesson 8 - Introducing PostgreSQL

Using Python to query a SQL database in less than 60 seconds! #python #datascience #pandas #sql

Master Using SQL with Python: Lesson 7.2 - Using the SQLite Upsert

you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)

Master Using SQL with Python: Lesson 5 - Using SQLite Studio

SQL Tutorial for Beginners [Full Course]

Master SQL with Python: Lesson 14 - Maintaining Data in Oracle using Merge

Practice SQL and Python | How to Practice Programming | Using LeetCode

How I use SQL as a Data Analyst

Master Using SQL with Python: Lesson 6 - Create a Data Warehouse with SQLite

How To Master SQL In 2023 And ACTUALLY Get A JOB Done

Master Using SQL with Python: Lesson 9 - Using PostgreSQL for Data Analysis