Simon Willison’s Weblog

Subscribe
Atom feed for datasette Random

1,520 posts tagged “datasette”

Datasette is an open source tool for exploring and publishing data.

2022

Datasette is 5 today: a call for birthday presents

Visit Datasette is 5 today: a call for birthday presents

Five years ago today I published the first release of Datasette, in Datasette: instantly create and publish an API for your SQLite databases.

[... 548 words]

Release datasette 0.63.1 — An open source multi-tool for exploring and publishing data

Designing a write API for Datasette

Building out Datasette Cloud has made one thing clear to me: Datasette needs a write API for ingesting new data into its attached SQLite databases.

[... 1,493 words]

Release datasette-edit-templates 0.1 — Plugin allowing Datasette templates to be edited within Datasette

Datasette 0.63: The annotated release notes

Visit Datasette 0.63: The annotated release notes

I released Datasette 0.63 today. These are the annotated release notes.

[... 1,531 words]

Release datasette 0.63 — An open source multi-tool for exploring and publishing data
Release datasette-indieauth 1.2.1 — Datasette authentication using IndieAuth and RelMeAuth
Release datasette 0.63a1 — An open source multi-tool for exploring and publishing data

Weeknotes: DjangoCon, SQLite in Django, datasette-gunicorn

I spent most of this week at DjangoCon in San Diego—my first outside-of-the-Bay-Area conference since the before-times.

[... 1,184 words]

Release datasette-gunicorn 0.1 — Plugin for running Datasette using Gunicorn

Measuring traffic during the Half Moon Bay Pumpkin Festival

Visit Measuring traffic during the Half Moon Bay Pumpkin Festival

This weekend was the 50th annual Half Moon Bay Pumpkin Festival.

[... 2,693 words]

Automating screenshots for the Datasette documentation using shot-scraper

Visit Automating screenshots for the Datasette documentation using shot-scraper

I released shot-scraper back in March as a tool for keeping screenshots in documentation up-to-date.

[... 1,810 words]

Release datasette-screenshots 0.62 — Screenshots of Datasette, taken using shot-scraper

Weeknotes: Publishing data using Datasette Cloud

My initial preview releases of Datasette Cloud (the SaaS version of my Datasette open source project) have focused on private data collaboration.

[... 582 words]

Release datasette-public 0.2 — Make selected Datasette databases and tables visible to the public
Release datasette-sentry 0.3 — Datasette plugin for configuring Sentry
Release datasette-search-all 1.1 — Datasette plugin for searching all searchable tables at once
Release datasette-public 0.1 — Make selected Datasette databases and tables visible to the public

Figure out how to serve an AWS Lambda function with a Function URL from a custom subdomain (via) This took me five hours and 77 issue comments to figure out, but I finally managed to serve an AWS Lambda function running Datasette on a custom subdomain with an HTTPS certificate. I was going to write this up as a TIL but I’m exhausted so I decided to share my private notes thread instead.

# 3rd October 2022, 12:29 am / aws, lambda, datasette

Weeknotes: Datasette Cloud preview invitations

Visit Weeknotes: Datasette Cloud preview invitations

This week I finally started sending out invitations for people to try out the preview of the new Datasette Cloud, my SaaS offering for Datasette.

[... 713 words]

Exploring 10m scraped Shutterstock videos used to train Meta’s Make-A-Video text-to-video model

Visit Exploring 10m scraped Shutterstock videos used to train Meta's Make-A-Video text-to-video model

Make-A-Video is a new “state-of-the-art AI system that generates videos from text” from Meta AI. It looks incredible—it really is DALL-E / Stable Diffusion for video. And it appears to have been trained on 10m video preview clips scraped from Shutterstock.

[... 923 words]

Release datasette-publish-fly 1.2 — Datasette plugin for publishing data using Fly
Release datasette-pretty-json 0.2.2 — Datasette plugin that pretty-prints any column values that are valid JSON objects or arrays
Release datasette 0.63a0 — An open source multi-tool for exploring and publishing data

Deploying Python web apps as AWS Lambda functions. After literally years of failed half-hearted attempts, I finally managed to deploy an ASGI Python web application (Datasette) to an AWS Lambda function! Here are my extensive notes.

# 19th September 2022, 4:05 am / aws, lambda, python, serverless, datasette, asgi

Release datasette-sandstorm-support 0.2 — Authentication and permissions for Datasette on Sandstorm

Weeknotes: Datasette Lite, s3-credentials, shot-scraper, datasette-edit-templates and more

Visit Weeknotes: Datasette Lite, s3-credentials, shot-scraper, datasette-edit-templates and more

Despite distractions from AI I managed to make progress on a bunch of different projects this week, including new releases of s3-credentials and shot-scraper, a new datasette-edit-templates plugin and a small but neat improvement to Datasette Lite.

[... 1,562 words]

Release datasette-edit-templates 0.1a0 — Plugin allowing Datasette templates to be edited within Datasette
Release datasette-sandstorm-support 0.1 — Authentication and permissions for Datasette on Sandstorm
Release datasette-upload-dbs 0.1.2 — Upload SQLite database files to Datasette