Long tutorial: Data analysis with SQLite and Python

[simonw]

From my PyCon 2h45m workshop: https://github.com/simonw/sqlite-tutorial-pycon-2023

YouTube: https://www.youtube.com/watch?v=5TdIxxBPUSI

[simonw]

Working on this inspired me to add a {% markdown %} tag:

• https://github.com/simonw/datasette-render-markdown/issues/14
• https://til.simonwillison.net/jinja/custom-jinja-tags-with-attributes

[simonw]

I really want an inline table-of-contents on that page.

I'm going to see if I can get that working using a custom template tag.

[simonw]

I used ChatGPT code interpreter to write the recursive tree functions: https://chat.openai.com/share/e41efb6d-eae7-454d-9aa2-5284683ba9f9

[simonw]

[simonw]

TIL: https://til.simonwillison.net/datasette/syntax-highlighted-code-examples