The [MBTiles](https://github.com/mapbox/mbtiles-spec) format uses SQLite to bundle map tiles for use with libraries such as Leaflet.

Amazon S3 buckets that are configured to work as public websites can support CORS, allowing assets such as JavaScript modules to be loaded by JavaS...

I wanted to ensure that when [this template repository](https://github.com/simonw/action-transcription) was used to create a new repo that repo wou...

I'm experimenting with a Datasette plugin that itself adds new plugin hooks which other plugins can then interact with.

Derek Willis has [a Datasette instance full of political campaign emails](https://political-emails.herokuapp.com/) running on Heroku.

I figured out how to run a SQL query directly against a CSV file using the `sqlite3` command-line utility:

[Purple Air](https://www.purpleair.com/) sensors have an API at `https://www.purpleair.com/map.json?show=SENSOR-ID-HERE`, which returns JSON that l...

While parsing a CSV file using `csv.DictReader` today I noticed the following surprising result:

This is _almost_ really simple. I used [electron/update-electron-app](https://github.com/electron/update-electron-app) for it, the instructions for...

This tip is for when you are working on a Python command-line application that runs using that program's name, as opposed to typing `python my_scri...

I was trying to use `group_concat()` to glue together some column values into a stiched together Markdown document. My first attempt looked like this:

Carelessly including the output of `json.dumps()` in an HTML page can lead to an XSS hole, thanks to the following:

I tried out [rqlite](https://github.com/rqlite/rqlite) today, a "lightweight, distributed relational database, which uses SQLite as its storage eng...

I ran https://simonwillison.net/ through [PageSpeed Insights](https://pagespeed.web.dev/) and it warned me that my static assets were not being ser...

When comparing secrets, passwords etc it's important to use a constant-time compare function to avoid timing attacks.

I wanted to redirect https://global-power-plants.datasettes.com/ to https://datasette.io/ - I decided to spin up a Cloudflare Pages site to do the ...

I figured out how to use a JSON API to run a very limited Google search today in a legit, non-screen-scraper way.

[Lit 2](https://lit.dev/blog/2021-09-21-announcing-lit-2/) stable was released today, offering a tiny, feature-full framework for constructing web ...

GitHub Projects has a mechanism for bulk updating the status of items, but it's pretty difficult to figure out how to do it.

I was messing around in Python with an in-memory SQLite database, when I decided I actually wanted to save my experimental database to a file so I ...

[Azure Functions](https://docs.microsoft.com/en-us/azure/azure-functions/) default to serving traffic from a path like `/api/FunctionName` - for ex...

I was writing some code for [datasette-auth-tokens](https://github.com/simonw/datasette-auth-tokens) that used [db.execute_write_fn()](https://docs...

For [Datasette issue #1844](https://github.com/simonw/datasette/issues/1844) I wanted to create the following screenshot:

[GitHub Pages](https://pages.github.com/) is an excellent free hosting platform, but the documentation is missing out on some crucial details.