Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,116 results
«« first
« previous
page 90 / 104
next »
last »»
TIL
List all columns in a SQLite database
— Here's a devious trick for listing ALL columns in a SQLite database, using a SQL query that generates another SQL query.
TIL
Use setup.py to install platform-specific dependencies
— For [photos-to-sqlite](https://github.com/dogsheep/photos-to-sqlite) I needed to install `osxphotos` as a dependency, but only if the platform is macOS - it's not available for Linux.
Release
dogsheep-photos 0.3a
— Upload your photos to S3 and import metadata about them into a SQLite database
TIL
Search across all loaded resources in Firefox
— You can search for a string in any resource loaded by a page (including across HTML, JavaScript and CSS) in the Debugger pane by hitting Command+Shift+F.
TIL
Installing and upgrading Datasette plugins with pipx
— If you installed `datasette` using `pipx install datasette` you can install additional plugins with `pipx inject` like so:
TIL
Constant-time comparison of strings in Node
— When comparing secrets, passwords etc it's important to use a constant-time compare function to avoid timing attacks.
TIL
Accessing repository dependencies in the GitHub GraphQL API
— [Access to a Repositories Dependency Graph](https://developer.github.com/v4/previews/#access-to-a-repositories-dependency-graph) describes a preview API for accessing GitHub repository dependencies.
TIL
Compile a new sqlite3 binary on Ubuntu
— I wanted to try the `vacuum into` backup command that was released in SQLite3 3.27.0 [on 2019-02-07](https://www.sqlite.org/changes.html#version_3_27_0).
TIL
How to mock httpx using pytest-mock
— I wrote this test to exercise some [httpx](https://pypi.org/project/httpx/) code today, using [pytest-mock](https://pypi.org/project/pytest-mock/).
TIL
Generated a summary of nested JSON data
— I was trying to figure out the shape of the JSON object from https://github.com/simonw/coronavirus-data-gov-archive/blob/master/data_latest.json?raw=true - which is 3.2MB and heavily nested, so it's difficult to get a good feel for the shape.
TIL
Session-scoped temporary directories in pytest
— I habitually use the `tmpdir` fixture in pytest to get a temporary directory that will be cleaned up after each test, but that doesn't work with `scope="session"` - which can be used to ensure an expensive fixture is run only once per test session and the generated content is used for multiple tests.
TIL
Fixing "compinit: insecure directories" error
— Every time I opened a terminal on my new Mac running Catalina with zsh I got the following annoying error:
Release
dogsheep-photos 0.2a
— Upload your photos to S3 and import metadata about them into a SQLite database
«« first
« previous
page 90 / 104
next »
last »»