Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,116 results
«« first
« previous
page 55 / 104
next »
last »»
TIL
Defining setup.py dependencies using a URL
— For [sqlite-utils issue 464](https://github.com/simonw/sqlite-utils/issues/464) I implemented a fix to a tiny bug in a dependency in [my own fork](https://github.com/simonw/beanbag-docutils/tree/bytes-in-url) on GitHub.
TIL
Creating a tiled zoomable image with OpenSeadragon and vips
— The San Francisco Microscopical Society has some extremely high resolution scanned images - one of them is a 1.67GB PNG file with a 25,088 × 17,283 pixel resolution.
TIL
Using GPT-3 to figure out jq recipes
— I like [jq](https://stedolan.github.io/jq/), but I always have to think pretty hard about how to construct the right syntax for it.
TIL
Mocking a Textract LimitExceededException with boto
— For [s3-ocr issue #21](https://github.com/simonw/s3-ocr/issues/21) I needed to write a test that simulates what happens when Amazon Textract returns a "LimitExceededException". When using boto this error presents itself as an exception:
Release
datasette-scale-to-zero 0.2
— Quit Datasette if it has not received traffic for a specified time period
TIL
Trying out SQLite extensions on macOS
— Alex Garcia has been building some really cool new custom extensions for SQLite, working in C and Go. So far he's released two:
TIL
Using boto3 from the command line
— I found a useful pattern today for automating more complex AWS processes as pastable command line snippets, using [Boto3](https://aws.amazon.com/sdk-for-python/).
TIL
Related content with SQLite FTS and a Datasette template function
— Today I added "related TILs" to this TIL website - so each TIL now shows five related TILs at the bottom of the page.
Release
datasette-sqlite-fts4 0.3.2
— Datasette plugin that adds custom SQL functions for working with SQLite FTS4
TIL
Emulating a big-endian s390x with QEMU
— I got [a bug report](https://github.com/simonw/sqlite-fts4/issues/6) concerning my [sqlite-fts4](https://github.com/simonw/sqlite-fts4) project running on PPC64 and s390x architectures.
TIL
Migrating a GitHub wiki from one repository to another
— I figured out how to migrate a [GitHub wiki](https://docs.github.com/en/communities/documenting-your-project-with-wikis/about-wikis) (public or private) from one repository to another while preserving all history.
Release
datasette-sqlite-fts4 0.3.1
— Datasette plugin that adds custom SQL functions for working with SQLite FTS4
TIL
struct endianness in Python
— TIL the Python standard library [struct](https://docs.python.org/3/library/struct.html) module defaults to interpreting binary strings using the endianness of your machine.
TIL
Testing things in Fedora using Docker
— I got [a report](https://twitter.com/peterjanes/status/1552407491819884544) of a bug with my [s3-ocr tool](https://simonwillison.net/2022/Jun/30/s3-ocr/) running on Fedora.
TIL
Deploying a redbean app to Fly
— [redbean](https://redbean.dev/) is a fascinating project - it provides a web server in a self-contained executable which you can add assets (or dynamic Lua code) to just by zipping them into the same binary package.
TIL
Using pytest and Playwright to test a JavaScript web application
— I [decided to add](https://github.com/simonw/datasette-lite/issues/35) automated tests to my [Datasette Lite](https://simonwillison.net/2022/May/4/datasette-lite/) project. Datasette Lite bundles my Datasette Python web application as a client-side application running inside WebAssembly using Pyodide.
Release
datasette-graphql 2.1.1
— Datasette plugin providing an automatic GraphQL API for your SQLite databases
«« first
« previous
page 55 / 104
next »
last »»