Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,116 results
«« first
« previous
page 73 / 104
next »
last »»
Release
hacker-news-to-sqlite 0.4
— Create a SQLite database containing data pulled from Hacker News
TIL
Querying for items stored in UTC that were created on a Thursday in PST
— This came up as [a question](https://news.ycombinator.com/item?id=26443148) on Hacker News. How can you query a SQLite database for items that were created on a Thursday in PST, when the data is stored in UTC?
TIL
Querying for GitHub issues open for less than 60 seconds
— While [writing this thread](https://twitter.com/simonw/status/1370390336514658310) about my habit of opening issues and closing them a few seconds later just so I could link to them in a commit message I decided to answer the question "How many of my issues were open for less than 60 seconds?"
TIL
How to almost get facet counts in the Django admin
— For a tantalizing moment today I thought I'd found a recipe for adding facet counts to the Django admin.
Release
datasette-ripgrep 0.7
— Web interface for searching your code using ripgrep, built as a Datasette plugin
TIL
Converting no-decimal-point latitudes and longitudes using jq
— I had some data with weird co-ordinates in it:
TIL
Flattening nested JSON objects with jq
— I wanted to take a nested set of JSON objects and import them into a SQLite database using `sqlite-utils insert` - but I wanted to "flatten" some of the nested rows.
TIL
Pretty-printing all read-only JSON in the Django admin
— I have a bunch of models with JSON fields that are marked as read-only in the Django admin - usually because they're recording the raw JSON that was imported from an API somewhere to create an object, for debugging purposes.
TIL
How to run MediaWiki with SQLite on a macOS laptop
— Today I [got curious](https://twitter.com/simonw/status/1368414296888070146) about how MediaWiki records page history, so I started digging around and in the process figured out how to run it against a SQLite database on my macOS laptop!
TIL
Show the timezone for datetimes in the Django admin
— Django supports storing dates in a database as UTC but displaying them in some other timezone - which is good. But... by default datetimes are shown in the Django admin interface without any clue as to what timezone they are being displayed in.
TIL
Writing tests for the Django admin with pytest-django
— I'm using [pytest-django](https://pytest-django.readthedocs.io/) on a project and I wanted to write a test for a Django admin create form submission. Here's the pattern I came up with:
TIL
Granting a PostgreSQL user read-only access to some tables
— I wanted to grant a PostgreSQL user (or role) read-only access to a specific list of tables.
TIL
Adding extra read-only information to a Django admin change page
— I figured out this pattern today for adding templated extra blocks of information to the Django admin change page for an object.
Release
flatten-single-item-arrays 0.1
— Given a JSON list of objects, flatten any keys which always contain single item arrays to just a single value
TIL
Running tests against PostgreSQL in a service container
— I wanted to run some Django tests - using `pytest-django` and with Django configured to pick up the `DATABASE_URL` environment variable via [dj-database-url](https://github.com/jacobian/dj-database-url) - against a PostgreSQL server running in GitHub Actions.
TIL
Show the SQL schema for a PostgreSQL database
— This took me longer to figure out than I care to admit.
«« first
« previous
page 73 / 104
next »
last »»