Tutorials - Simon Willison: Data analysis with SQLite and Python

Conference: PyCon US 2023

Year: 2023

SQLite is the world's most widely used database and has been a part of the Python standard library since 2006. It continues to evolve and offer more capabilities every year. This tutorial will transform you into a SQLite power-user. You'll learn to use SQLite with Python, level up your SQL skills and take advantage of libraries such as sqlite-utils and tools such as Datasette to explore and analyze data in all kinds of shapes and sizes. This hands-on tutorial will cover: - The sqlite3 module in the Python standard library - A review of SQL basics, plus advanced SQL features available in SQLite - Using sqlite-utils for advanced manipulation of SQLite databases - Datasette as a tool for exploring, analyzing and publishing data - Applying the Baked Data architectural pattern to build a data application using Datasette and deploy it to the cloud This tutorial is aimed at beginner-to-intermediate Python users with some previous exposure to basic SQL. Attendees will leave this workshop with a powerful new set of tools for productively exploring, analyzing and publishing data.

Discussion (0)

Join the discussion!

Subscribe to post comments and join our community of developers.

No comments yet. Be the first to comment!