Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,015 results
«« first
« previous
page 66 / 101
next »
last »»
TIL
Using nginx to proxy to a Unix domain socket
— I figured this out while adding `--uds` support to Datasette in [#1388](https://github.com/simonw/datasette/issues/1388). Save the following in `nginx.conf`:
TIL
Using pysqlite3 on macOS
— While trying to use [pysqlite3](https://github.com/coleifer/pysqlite3) on macOS I got the following error:
TIL
Increasing the time limit for a Google Cloud Scheduler task
— In [VIAL issue 724](https://github.com/CAVaccineInventory/vial/issues/724) a Cloud Scheduler job which triggered a Cloud Run hosted export script - by sending an HTTP POST to an endpoint - was returning an error. The logs showed the error happened exactly three minutes after the task started executing.
TIL
Preventing double form submissions with JavaScript
— I needed this for [VIAL issue 722](https://github.com/CAVaccineInventory/vial/issues/722). I decided to disable form submissions for two seconds after they are submitted, to protect against accidental double submissions without risk of unexpected issues that could cause the form to be permanently disabled even though it should still be able to submit it.
TIL
Installing different PostgreSQL server versions in GitHub Actions
— The GitHub Actions `ubuntu-latest` default runner currently includes an installation of PostgreSQL 13. The server is not running by default but you can interact with it like this:
TIL
Scraping Reddit via their JSON API
— Reddit have long had an unofficial (I think) API where you can add `.json` to the end of any URL to get back the data for that page as JSON.
TIL
Mouse support in vim
— Today I learned that if you hit `Esc` in vim and then type `:set mouse=a` and hit enter... vim grows mouse support! In your terminal!
Release
dogsheep-beta 0.10.2
— Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release
db-to-sqlite 1.4
— CLI tool for exporting tables or queries from any SQL database to a SQLite file
Release
xml-analyser 1.2
— Simple command line tool for quickly analysing the structure of an arbitrary XML file
Release
datasette-upload-csvs 0.6.1
— Datasette plugin for uploading CSV files and converting them to database tables
Release
xml-analyser 1.1
— Simple command line tool for quickly analysing the structure of an arbitrary XML file
TIL
Exporting Amplitude events to SQLite
— [Amplitude](https://amplitude.com/) offers an "Export Data" button in the project settings page. This can export up to 365 days of events (up to 4GB per export), where the export is a zip file containing `*.json.gz` gzipped newline-delimited JSON.
«« first
« previous
page 66 / 101
next »
last »»