Tutorial based on my HYTRADBOI talk

[simonw]

Will cover refactoring databases using sqlite-utils.

Initial notes and video here: https://gist.github.com/simonw/c61447d866f7f29d368183fb09d9bf41

[simonw]

I'm going to call this "Cleaning data with sqlite-utils and Datasette" - because data cleaning is a relevant term that I see people use all the time.

[simonw]

My copy of the video on YouTube: https://www.youtube.com/watch?v=B55hcKYye_c&t=138s

[simonw]

I need a demo deployment for this, mainly so I can use shot-scraper to take the screenshots for the tutorial.

Creating that in https://github.com/simonw/manatees-datasette

[simonw]

Created a Vercel token for that:

I added it as a secret here: https://github.com/simonw/manatees-datasette/settings/secrets/actions

I didn't save it anywhere else, so if I ever need it again I'll have to create a brand new Vercel token and disable that old one.

[simonw]

Now live at https://manatees.vercel.app/manatees/locations

[simonw]

The screenshot is 666KB which is a bit heavy! https://github.com/simonw/datasette-screenshots/blob/main/tutorials-clean-data-locations-map.png

[simonw]

I turned on GitHub Pages for https://github.com/simonw/datasette-screenshots since that feels like a better way to publish images that I want to link to.

https://simonw.github.io/datasette-screenshots/tutorials-clean-data-locations-map.png

[simonw]

The non-retina one is down to 253KB https://github.com/simonw/datasette-screenshots/blob/main/non-retina/tutorials-clean-data-locations-map.png

https://simonw.github.io/datasette-screenshots/non-retina/tutorials-clean-data-locations-map.png

[simonw]

Now live at https://datasette.io/tutorials/clean-data

[simonw]

New image: