Start a tutorials section

[simonw]

I'm going to put tutorials here rather than in the official Datasette documentation for a few reasons:

• They will cover more than just Datasette itself - sqlite-utils and such like
• I want to be able to "ship" them without releasing Datasette itself - and without linking people to the /en/latest location

[simonw]

Some tutorial ideas:

• Using an already published Datasette instance to explore some data. Need to pick a good demo here, ideally one that has some foreign-key relationships to explore.
• Installing Datasette with brew install datasette and using it to explore your local SQLite files (found with this tip: https://til.simonwillison.net/macos/find-largest-sqlite)
• Loading data into Datasette on your laptop from an open government portal and exploring it with datasette-cluster-map - this could use sqlite-utils or csvs-to-sqlite or it could wait until datasette insert is ready, see "datasette insert" command and plugin hook datasette#1160
• Building a custom Datasette by writing Python code. A tutorial using the https://github.com/unitedstates/congress-legislators YAML data could be good for this.
• Publishing the result from that last one online using datasette publish cloudrun - including how to get credentials, how to use metadata etc

[simonw]

The first tutorial is based on this workshop I gave: https://docs.google.com/document/d/1KIsqquFCHVy3WpsU7Of1XYu0LHfZo2EP77UfAOzxU7g/edit

[simonw]

I should ensure the tutorials are searchable, which means they probably can't just be a static template with embedded Markdown.

[simonw]

https://datasette.io/tutorials is now live, as is the first tutorial, https://datasette.io/tutorials/explore

[simonw]

Tweeted about it here: https://twitter.com/simonw/status/1497684575551590402

And started a feedback discussion thread:

• Datasette tutorials: "Exploring a database with Datasette" and "Learn SQL with Datasette" - feedback wanted! datasette#1643

[simonw]

Tutorials need Twitter media cards - the link on Twitter wasn't expanded: https://twitter.com/simonw/status/1497684575551590402

[simonw]

And the second tutorial: https://datasette.io/tutorials/learn-sql