Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,015 results
«« first
« previous
page 51 / 101
next »
last »»
TIL
SQLite VACUUM: database or disk is full
— I was trying to run `VACUUM` against a large SQLite database file (~7GB) using `sqlite-utils vacuum data.db` and I got this error:
TIL
Seeing which functions are unique to a specific SQLite / Datasette instance
— In reading [Scraping JSON, HTML, and ZIP Files with Pure SQLite](https://observablehq.com/@asg017/scrape-json-html-zip-with-sqlite) by Alex Garcia I got curious to see a full list of functions he had registered in his [sqlite-extension-examples.fly.dev](https://sqlite-extension-examples.fly.dev) Datasette instance that weren't available in a regular Datasette.
Release
sqlite-diffable 0.5
— Tools for dumping/loading a SQLite database to diffable directory structure
TIL
Trying out Quarto on macOS
— I decided to try out [Quarto](https://quarto.org/), the new notebook/markdown/publishing system built on Pandoc.
TIL
Sort by number of JSON intersections
— This [post on Reddit](https://www.reddit.com/r/sqlite/comments/wr0wp0/i_have_a_sqlite_database_of_recipes_i_would_like/) asked how to run a query that takes a list of items (in this case ingredients) as the input and returns all rows with at least one of those items in a JSON list, ordered by the most matches.
TIL
Analyzing Google Cloud spend with Datasette
— Google Cloud provide extremely finely grained billing, but you need to access it through BigQuery which I find quite inconvenient.
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:
«« first
« previous
page 51 / 101
next »
last »»