Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,116 results
«« first
« previous
page 42 / 104
next »
last »»
TIL
Remember to commit when using datasette.execute_write_fn()
— I was writing some code for [datasette-auth-tokens](https://github.com/simonw/datasette-auth-tokens) that used [db.execute_write_fn()](https://docs.datasette.io/en/stable/internals.html#await-db-execute-write-fn-fn-block-true) like this:
Release
datasette-visible-internal-db 0.1.1
— Datasette plugin for making the internal database visible for debugging
Release
datasette-visible-internal-db 0.1
— Datasette plugin for making the internal database visible for debugging
TIL
Streaming output of an indented JSON array
— For [paginate-json]() I wanted to implement streaming output of an indented JSON array to my terminal.
TIL
Downloading partial YouTube videos with ffmpeg
— I spoke [at WordCamp US 2023](), and wanted to grab a copy of the video of my talk. I always try to keep my own copies of these because I've seen some conferences eventually take these offline in the past.
Release
datasette-jellyfish 2.0
— Datasette plugin adding SQL functions for fuzzy text matching powered by Jellyfish
Release
datasette-jellyfish 1.0.2
— Datasette plugin adding SQL functions for fuzzy text matching powered by Jellyfish
Release
datasette-debug-permissions 0.2
— A Datasette plugin that outputs debug information about permission checks
Release
datasette-debug-permissions 0.1
— A Datasette plugin that outputs debug information about permission checks
Release
datasette-configure-fts 1.1.2
— Datasette plugin for enabling full-text search against selected table columns
TIL
Compile and run a new SQLite version with the existing sqlite3 Python library on macOS
— I've been trying to figure this out for years. Previous notes include [Using LD_PRELOAD to run any version of SQLite with Python](https://til.simonwillison.net/sqlite/ld-preload) (Linux only), and [Building a specific version of SQLite with pysqlite on macOS/Linux](https://til.simonwillison.net/sqlite/build-specific-sqlite-pysqlite-macos) and [Using pysqlite3 on macOS](https://til.simonwillison.net/sqlite/pysqlite3-on-macos) (both using the `pysqlite3` package).
TIL
Configuring Django SQL Dashboard for Fly PostgreSQL
— I have a Fly application that uses their PostgreSQL service. I wanted to run [Django SQL Dashboard]() with a read-only user against that database.
Release
datasette-ripgrep 0.8.1
— Web interface for searching your code using ripgrep, built as a Datasette plugin
TIL
Calculating the size of a SQLite database file using SQL
— I learned this trick today while [browsing the code](https://github.com/tersesystems/blacklite/blob/main/blacklite-core/src/main/resources/com/tersesystems/blacklite/resources.properties) of [Blacklite](https://tersesystems.com/blog/2020/11/26/queryable-logging-with-blacklite/), a neat Java library for writing diagnostic logs to a SQLite database.
TIL
Updating stable docs in ReadTheDocs without pushing a release
— I use [ReadTheDocs](https://readthedocs.org/) for several of my projects. It's fantastic: among other things, it makes it easy to publish the documentation for my latest `main` branch at `/latest/` and the documentation for my latest release at `/stable/` (as well as maintain archived tag URLs for every prior release).
TIL
A shell script for running Go one-liners
— [bitfield/script](https://github.com/bitfield/script) is a really neat Go project: it tries to emulate shell scripting using Go chaining primitives, so you can run code like this:
«« first
« previous
page 42 / 104
next »
last »»