Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,116 results
«« first
« previous
page 77 / 104
next »
last »»
TIL
Using Prettier to check JavaScript code style in GitHub Actions
— I [decided](https://github.com/simonw/datasette/issues/1166) to adopt [Prettier](https://prettier.io/) as the JavaScript code style for Datasette, based on my success with [Black](https://github.com/psf/black) for Python code.
TIL
Using Jest without a package.json
— I wanted to try out [Jest](https://jestjs.io/) for writing JavaScript unit tests, in a project that wasn't set up with `package.json` and other NPM related things.
TIL
Relinquishing control in Python asyncio
— `asyncio` in Python is a form of co-operative multitasking, where everything runs in a single thread but asynchronous tasks can yield to other tasks to allow them to execute.
TIL
Replicating SQLite with rqlite
— I tried out [rqlite](https://github.com/rqlite/rqlite) today, a "lightweight, distributed relational database, which uses SQLite as its storage engine". It uses the Raft consensus algorithm to allow multiple SQLite instances to elect a leader and replicate changes amongst themselves.
Release
dogsheep-beta 0.10.1
— Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release
dogsheep-beta 0.10
— Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
TIL
Skipping CSV rows with odd numbers of quotes using ripgrep
— I'm working with several huge CSV files - over 5 million rows total - and I ran into a problem: it turned out there were a few lines in those files that imported incorrectly because they were not correctly escaped.
Release
datasette-pretty-json 0.2.1
— Datasette plugin that pretty-prints any column values that are valid JSON objects or arrays
TIL
Escaping a SQL query to use with curl and Datasette
— I used this pattern to pass a SQL query to Datasette's CSV export via curl and output the results, stripping off the first row (the header row) using `tail -n +2`.
TIL
Controlling the style of dumped YAML using PyYAML
— I had a list of Python dictionaries I wanted to output as YAML, but I wanted to control the style of the output.
TIL
Using custom Sphinx templates on Read the Docs
— I wanted to make a small customization to one of my documentation templates on Read the Docs.
TIL
Running Python code in a subprocess with a time limit
— I figured out how to run a subprocess with a time limit for [datasette-ripgrep](https://github.com/simonw/datasette-ripgrep), using the `asyncio.create_subprocess_exec()` method. The pattern looks like this:
«« first
« previous
page 77 / 104
next »
last »»