Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,116 results
«« first
« previous
page 49 / 104
next »
last »»
TIL
Avoiding "length" errors in Apache Bench with the -l option
— I was using the Apache Bench `ab` command to exercise some new code I'm writing in Datasette and I noticed I was getting a lot of errors:
Release
db-to-sqlite 1.5
— CLI tool for exporting tables or queries from any SQL database to a SQLite file
TIL
The SQLite now argument is stable within the same query
— I stumbled across an interesting little detail of SQLite today, running the following query:
TIL
Building Mastodon bots with GitHub Actions and toot
— Twitter [announced today](https://twitter.com/TwitterDev/status/1621026986784337922) that they'll be ending free API access for bots.
TIL
Run Python code in a WebAssembly sandbox
— I've been trying to figure this out for ages. Tim Bart responded to [my call for help on Hacker News](https://news.ycombinator.com/item?id=34598024) with [this extremely useful code example](https://gist.github.com/pims/711549577759ad1341f1a90860f1f3a5) showing how to run Python code in WebAssembly inside Python, using [wasmtime-py](https://github.com/bytecodealliance/wasmtime-py) and the new Python WASM build [released by VMware Wasm Labs](https://wasmlabs.dev/articles/python-wasm32-wasi/).
TIL
Running nanoGPT on a MacBook M2 to generate terrible Shakespeare
— [nanoGPT](https://github.com/karpathy/nanoGPT) is Andrej Karpathy's "simplest, fastest repository for training/finetuning medium-sized GPTs".
TIL
Calculating embeddings with gtr-t5-large in Python
— I've long wanted to run some kind of large language model on my own computer. Now that I have a M2 MacBook Pro I'm even more keen to find interesting ways to keep all of those CPU cores busy.
TIL
Using recursive CTEs to explore hierarchical Twitter threads
— This TIL adapted from [a Gist](https://gist.github.com/simonw/656a8c6e4688f720773c474080abe1b0) I put together in 2019, before I started tracking TILs here.
TIL
Combining CTEs and VALUES in SQLite
— Here's how to use SQLite's `VALUES` syntax with a CTE to create a temporary table that you can then perform joins against in a query:
TIL
Installing lxml for Python on an M1/M2 Mac
— I ran into this error while trying to run `pip install lxml` on an M2 Mac, inside a virtual environment I had intitially created using `pipenv shell`:
TIL
SQLite pragma_function_list()
— The SQLite `pragma_function_list()` table-valued function returns a list of functions that have been registered with SQLite, including functions that were added by extensions.
TIL
Rewriting a Git repo to remove secrets from the history
— I decided to make a GitHub repository public today that had previously been private. Unfortunately the revision history of that repository included some secret values, one of which I could not figure out a way to revoke.
Release
datasette-cookies-for-magic-parameters 0.1.2
— UI for setting cookies to populate magic parameters
Release
datasette-cookies-for-magic-parameters 0.1.1
— UI for setting cookies to populate magic parameters
Release
datasette-cookies-for-magic-parameters 0.1
— UI for setting cookies to populate magic parameters
TIL
Upgrading a pipx application to an alpha version
— I wanted to upgrade my [git-history](https://datasette.io/tools/git-history) installation to a new alpha version.
TIL
Scraping the Sky News Westminster Accounts, a Flourish application
— Sky News in partnership with [Tortoise](https://www.tortoisemedia.com/) published a fantastic piece of investigative data reporting: [the Westminster Accounts](https://news.sky.com/story/westminster-accounts-methodology-12764656), a database of money in UK politics that brought together data from three different sources and make it explorable.
«« first
« previous
page 49 / 104
next »
last »»