Elsewhere
Release TIL Research Tool Museum Sighting Comment
Filters: Sorted by date
3,491 results
«« first
« previous
page 61 / 117
next »
last »»
Release
datasette-render-image-tags 0.1
— Turn any URLs ending in .jpg/.png/.gif into img tags with width 200
TIL
Loading Twitter Birdwatch into SQLite for analysis with Datasette
— [Twitter Birdwatch](https://twitter.github.io/birdwatch/) is "a collaborative way to add helpful context to Tweets and keep people better informed".
TIL
How to scp files to and from Fly
— I have a Fly instance with a 20GB volume, and I wanted to copy files to and from the instance from my computer using `scp`.
Release
datasette-block-robots 1.1
— Datasette plugin that blocks robots and crawlers using robots.txt
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.
Sighting
7:00 PM – 7:00 PM
— California Brown Pelican, Willet, in Monterey Bay National Marine Sanctuary, CA, US, CA
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.
«« first
« previous
page 61 / 117
next »
last »»