Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,015 results
«« first
« previous
page 73 / 101
next »
last »»
TIL
Syntax highlighting Python console examples with GFM
— It turns out [GitHub Flavored Markdown](https://github.github.com/gfm/) can apply syntax highlighting to Python console examples, like this one:
Release
datasette-cluster-map 0.15
— Datasette plugin that shows a map for any data with latitude/longitude columns
TIL
Fixing broken text encodings with sqlite-transform and ftfy
— I was working with a database table that included values that were clearly in the wrong character encoding - values like this:
Release
swarm-to-sqlite 0.3.3
— Create a SQLite database containing your checkin history from Foursquare Swarm
TIL
Bulk fetching repository details with the GitHub GraphQL API
— I wanted to be able to fetch details of a list of different repositories from the GitHub GraphQL API by name in a single operation.
TIL
Recovering data from AWS Lightsail using EC2
— I ran into problems with my AWS Lightsail instance: it exceeded the CPU burst quota for too long and was suspended, and I couldn't figure out how to un-suspend it.
TIL
Identifying column combination patterns in a SQLite table
— Given a large, heterogeneous table I wanted to identify patterns in the rows in terms of which columns were not null.
Release
datasette-export-notebook 0.2
— Datasette plugin providing instructions for exporting data to Jupyter or Observable
Release
datasette-export-notebook 0.1.1
— Datasette plugin providing instructions for exporting data to Jupyter or Observable
Release
datasette-export-notebook 0.1
— Datasette plugin providing instructions for exporting data to Jupyter or Observable
TIL
Packaging a Python app as a standalone binary with PyInstaller
— [PyInstaller](https://www.pyinstaller.org/) can take a Python script and bundle it up as a standalone executable for macOS, Linux and apparently Windows too (I've not tried it on Windows yet).
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
«« first
« previous
page 73 / 101
next »
last »»