Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,116 results
«« first
« previous
page 69 / 104
next »
last »»
TIL
Using the tesseract CLI tool
— Tesseract OCR has a command-line utility which is woefully under-documented. Thanks to [Alexandru Nedelcu](https://alexn.org/blog/2020/11/11/organize-index-screenshots-ocr-macos.html) I figured out how to use it today.
Release
datasette-export-notebook 1.0
— Datasette plugin providing instructions for exporting data to Jupyter or Observable
Release
datasette-graphql 1.5
— Datasette plugin providing an automatic GraphQL API for your SQLite databases
TIL
Importing CSV data into SQLite with .import
— I usually use my `sqlite-utils insert blah.db tablename file.csv --csv` command to import CSV data into SQLite, but for large CSV files (like a 750MB one) this can take quite a long time - over half an hour in this case.
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
«« first
« previous
page 69 / 104
next »
last »»