Efficiently copying a file
TLDR: Use I'm writing a Datasette plugin that handles an uploaded file, borrowing the Starlette mechanism for handling file uploads, documented here.
performance
7 posts tagged “performance”.
- 2025
-
1 min read
- 2024
-
Avoiding "length" errors in Apache Bench with the -l option
I was using the Apache Bench command to exercise some new code I'm writing in Datasette and I noticed I was getting a lot of errors: Truncated output: What's with the 953 failed requests?
1 min read -
HTML video that loads when the user clicks play
Today I figured out how to use the tag to show a static thumbnail that gets replaced by the loaded video only when the user clicks play.
1 min read -
Enabling WAL mode for SQLite database files
I was getting occasional messages from a Datasette instance that was running against a bunch of different SQLite files that were updated by cron scripts (my personal Dogsheep).
1 min read - 2023
-
Enabling a gin index for faster LIKE queries
I tried using a gin index to speed up queries against a column. PostgreSQL: More performance for LIKE and ILIKE statements provided useful background.
1 min read -
Annotated explanation of David Beazley's dataklasses
David Beazley on Twitter: So, I just published this deliciously evil spin on dataclasses. It's tiny and the resulting classes import about 15-20 faster than dataclasses.
1 min read -
Counting SQLite virtual machine operations
When SQLite executes a query, it does so by executing a sequence of virtual machine operations. There are mechanisms for cancelling a query after a specific number of these operations, to protect…
1 min read