Simon Willison’s Weblog

Subscribe

Tuesday, 23rd June 2020

sqlite-generate (via) I wrote this tool today to generate arbitrarily large SQLite databases, for testing purposes. You tell it how many tables, columns and rows you want and it will use the Faker Python library to generate random data and populate the tables with it.

# 2:19 am / projects, sqlite

click-app. While working on sqlite-generate today I built a cookiecutter template for building the skeleton for Click command-line utilities. It’s based on datasette-plugin so it automatically sets up GitHub Actions for running tests and deploying packages to PyPI.

# 2:21 am / projects, python, cookiecutter

datasette-block-robots. Another little Datasette plugin: this one adds a /robots.txt page with “Disallow: /” to block all indexing of a Datasette instance from respectable search engine crawlers. I built this in less than ten minutes from idea to deploy to PyPI thanks to the datasette-plugin cookiecutter template.

# 3:28 am / plugins, projects, robots-txt, seo, datasette

2020 » June

MTWTFSS
1234567
891011121314
15161718192021
22232425262728
2930