filmov
tv
Tutorials - Simon Willison: Data analysis with SQLite and Python

Показать описание
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.
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.
Tutorials - Simon Willison: Data analysis with SQLite and Python
Extracting unstructured text and images into database tables with GPT-4 Turbo and Datasette Extract
Introduction to Datasette and sqlite-utils
How to Instantly Publish Data to the Internet with Datasette | Simon Willison @ PyBay2018
Joining CSV and JSON data using the 'sqlite-utils memory' command
Simon Willison- Using Datasette with Jupyter to publish your data | JupyterCon 2020
Simon Willison - Datasette - publish an instant JSON API for a SQLite database
Simon Willison: My career in side projects and open source
'Embeddings: What they are and why they matter' - Simon Willison (PyBay 2023)
'Catching up on the weird world of LLMs' - Simon Willison (North Bay Python 2023)
Datasette Desktop initial demo
Language models on the command-line w/ Simon Willison
Datasette: a big bag of tricks for solving interesting problems using SQLite
E27 - History of Django, Open Source and LLM Security with Simon Willison
Datasette - an ecosystem of tools for working with small data
Django SQL Dashboard
OCTO Speaker Series #4 Simon Willison
Open Questions for AI Engineering: Simon Willison
July 22, 2020: Simon Willison, Datasette and Dogsheep
Datasette Enrichments
AI tools for software engineers, but without the hype – with Simon Willison (Co-Creator of Django)
Simon Willison - Instant serverless APIs, powered by SQLite - PyCon 2019
Expert Share: Simon Willison - Using AI for journalism
DjangoCon US 2017 - The denormalized query engine design pattern by Simon WIllison
Комментарии