Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Long tutorial: Data analysis with SQLite and Python #145

Closed
simonw opened this issue Jul 2, 2023 · 5 comments
Closed

Long tutorial: Data analysis with SQLite and Python #145

simonw opened this issue Jul 2, 2023 · 5 comments
Labels
documentation Improvements or additions to documentation tutorials

Comments

@simonw
Copy link
Owner

simonw commented Jul 2, 2023

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

YouTube: https://www.youtube.com/watch?v=5TdIxxBPUSI
@simonw simonw added documentation Improvements or additions to documentation tutorials labels Jul 2, 2023
@simonw
Copy link
Owner Author

simonw commented Jul 2, 2023

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

simonw added a commit that referenced this issue Jul 2, 2023
@simonw
Data analysis with SQLite and Python - refs #145
acadf48
simonw added a commit that referenced this issue Jul 2, 2023
@simonw
Added pygments, refs #145
c370206
@simonw
Copy link
Owner Author

simonw commented Jul 2, 2023

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
Copy link
Owner Author

simonw commented Jul 2, 2023

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

@simonw simonw closed this as completed in 5b4f635 Jul 2, 2023
@simonw
Copy link
Owner Author

simonw commented Jul 2, 2023

image

simonw added a commit that referenced this issue Jul 2, 2023
@simonw
Some cleanup on toc tag, refs #145
76396c1
simonw added a commit that referenced this issue Jul 2, 2023
@simonw
Trying to fix syntax highlighting, refs #145
53159ac
simonw added a commit that referenced this issue Jul 2, 2023
@simonw
overflow-wrap: break-word on new long tutorial page
fbffc8f 
To ensure links properly wrap on mobile, refs #145
simonw added a commit that referenced this issue Jul 2, 2023
@simonw
Run Pygments in production, refs #145
205caea
simonw added a commit that referenced this issue Jul 2, 2023
@simonw
Social card images for new tutorial, refs #145
49e0674
@simonw
Copy link
Owner Author

simonw commented Jul 2, 2023

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

simonw added a commit that referenced this issue Jul 2, 2023
@simonw
News: Data analysis with SQLite and Python
a21a568 
Refs #145
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
documentation Improvements or additions to documentation tutorials
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@simonw