Comment by simonw

1 day ago

There was a UK government GitHub repo that did something interesting with this kind of trick against S3 but I checked just now and the repo is a 404. Here are my notes about what it did: https://simonwillison.net/2025/Feb/7/sqlite-s3vfs/

Looks like it's still on PyPI though: https://pypi.org/project/sqlite-s3vfs/

You can see inside it with my PyPI package explorer: https://tools.simonwillison.net/zip-wheel-explorer?package=s...

12 comments

simonw

Reply
simonw  1 day ago

I recovered it from https://til.simonwillison.net/github/software-archive-recove...

  • QuantumNomad_  1 day ago

    I also have a locally cloned copy of that repo from when it was on GitHub. Same latest commit as your copy of it.

    From what I see in GitHub in your copy of the repo, it looks like you don’t have the tags.

    Do you have the tags locally?

    If you don’t have the tags, I can push a copy of the repo to GitHub too and you can get the tags from my copy.

  • bspammer  21 hours ago

    Doing all this in an hour is such a good example of how absurdly efficient you can be with LLMs.

    • socialcommenter  3 hours ago

      From reading the TIL, it doesn't appear as if Simon used LLM for a large portion of what he did; only the initial suggestion to check the archive, and the web tool to make his process reproducible. Also, if you read the script from his chat with Claude code, the prompt really does the heavy lifting.

      Sure, the LLM fills in all the boilerplate and makes an easy-to-use, reproducible tool with loads of documentation, and credit for that. But is it not more accurate to say that Simon is absurdly efficient, LLM or sans LLM? :)