Simon Willison’s Weblog

Subscribe
Atom feed for datasette Random

1,455 posts tagged “datasette”

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

2022

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 / serverless, lambda, datasette, python, aws, 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
Release datasette-upload-csvs 0.8.2 — Datasette plugin for uploading CSV files and converting them to database tables
Release datasette-upload-csvs 0.8.1 — Datasette plugin for uploading CSV files and converting them to database tables
Release datasette-upload-csvs 0.8 — Datasette plugin for uploading CSV files and converting them to database tables

Spevktator: OSINT analysis tool for VK. This is a really cool project that came out of a recent Bellingcat hackathon. Spevktator takes 67,000 posts from five popular Russian news channels on VK (a popular Russian social media platform) and makes them available in Datasette, along with automated translations to English, post sharing metrics and sentiment analysis scores. This README includes some detailed analysis of the data, plus a link to an Observable notebook that implements custom visualizations against queries run directly against the Datasette instance.

# 5th September 2022, 8:48 pm / political-hacking, bellingcat, datasette, observable

Exploring the training data behind Stable Diffusion

Visit Exploring the training data behind Stable Diffusion

Two weeks ago, the Stable Diffusion image generation model was released to the public. I wrote about this last week, in Stable Diffusion is a really big deal—a post which has since become one of the top ten results for “stable diffusion” on Google and shown up in all sorts of different places online.

[... 2,897 words]