Simon Willison

Put docs.md somewhere that's indexed by Google

3

I found out the other day that GitHub blocks access to crawlers to pages in the repo other than the main README - which means https://github.com/asg017/sqlite-lines/blob/main/docs.md is unlikely to be...

Zoom range option for MBTiles only exports a single zoom layer

2

Here's my export: https://export.hotosm.org/en/v3/exports/f269d67d-d273-4c41-97a1-360800a544e4 I requested zoom layers 5-17, using the range slider like this: But the export has just a single tile from level 5 and 3,630 at level...

Serve https://aviary.sh/install with a text/plain content-type

5

https://aviary.sh/install is currently served with a `application/octet-stream` content-type: ``` $ curl -i https://aviary.sh/install HTTP/1.1 200 OK Connection: keep-alive Content-Length: 1266 Server: GitHub.com Content-Type: application/octet-stream ... ``` This means that when...

Scale to zero

64

I have a serious side-project habit - I often have dozens of side projects on the go at once. As such, I really appreciate scale-to-zero services like Google Cloud Run...

Floating point numbers seem to always be recorded as changed

3

In this example: I don't think `latitude` and `longitude` should be populated as they have not changed between records (unlike `units`). This is from a demo database built against https://github.com/simonw/scrape-san-mateo-fire-dispatch...

Prototype: ```diff diff --git a/git_history/cli.py b/git_history/cli.py index f3a4c40..83f988e 100644 --- a/git_history/cli.py +++ b/git_history/cli.py @@ -117,6 +117,11 @@ def cli(): is_flag=True, help="Debug mode", ) [email protected]( + "_pdb", "--pdb", + is_flag=True, +...

More demos

7

Using this thread to collect them - not yet decided if I'll turn these into live demos or just have a piece of documentation suggesting people try these out.

Might be neat to store it in case people forget to note down what they used.

Confirm if this works with repos with branches in the history

2

> I couldn't get this to work, and I have a hunch it may be because that repository uses branches and doesn't have a linear history: ``` git-history file iam.db...

Do something with this column changes query

1

This query shows which columns are most frequently updated, ignoring those for version = 1 ```sql select columns.name, count(*) from item_changed join item_version on item_changed.item_version = item_version._id join columns on...