Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,116 results
«« first
« previous
page 54 / 104
next »
last »»
TIL
Clone, edit and push files that live in a Gist
— GitHub [Gists](https://gist.github.com/) are full Git repositories, and can be cloned and pushed to.
Release
datasette-upload-csvs 0.8.2
— Datasette plugin for uploading CSV files and converting them to database tables
Release
datasette-upload-csvs 0.8.1
— Datasette plugin for uploading CSV files and converting them to database tables
Release
datasette-upload-csvs 0.8
— Datasette plugin for uploading CSV files and converting them to database tables
TIL
Run pytest against a specific Python version using Docker
— For [datasette issue #1802](https://github.com/simonw/datasette/issues/1802) I needed to run my `pytest` test suite using a specific version of Python 3.7.
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.
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.
«« first
« previous
page 54 / 104
next »
last »»