Learn Python with Talk Python's Python courses

Personal search engine with datasette and dogsheep

Episode #299, published Sun, Jan 17, 2021, recorded Wed, Nov 18, 2020.

This episode is carbon neutral.
In this episode, we'll be discussing two powerful tools for data reporting and exploration: Datasette and Dogsheep.

Datasette helps people take data of any shape or size, analyze and explore it, and publish it as an interactive website and accompanying API.

Dogsheep is a collection of tools for personal analytics using SQLite and Datasette. Imagine a unified search engine for everything personal in your life such as twitter, photos, google docs, todoist, goodreads, and more, all in once place and outside of cloud companies.

On this episode we talk with Simon Willison who created both of these projects. He's also one of the co-creators of Django and we'll discuss some early Django history!

Links from the show

Datasette: datasette.io
Dogsheep: dogsheep.github.io
Datasheet newsletter: datasette.substack.com
Video: Build your own data warehouse for personal analytics with SQLite and Datasette: youtube.com

Examples
List: github.com
Personal data warehouses: github.com
Global power plants: datasettes.com
SF data: datasettes.com
FiveThirtyEight: fivethirtyeight.datasettes.com
Lahman’s Baseball Database: baseballdb.lawlesst.net
Live demo of current main: datasette.io

Want to go deeper? Check out our courses

Simon Willison
Simon Willison
Simon is the creator of Datasette, an open source tool for exploring and publishing data. Datasette is based on Simon's experiences working as a data journalist at the UK's Guardian newspaper. Simon is also a co-creator of the Django web framework. He recently completed the JSK Fellowship program at Stanford.
Episode sponsored by
Ads served ethically
Click to show comments


Individuals can support this podcast directly via Patreon. Corporate sponsorship opportunities available here.
X
Become a friend of the show
Stay in the know and get a chance to win our contests.
See our privacy statement about email communications.