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
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
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