Using DuckDB in Python to access Parquet data
2024-08-20
Did a quick experiment with [DuckDB](https://duckdb.org/) today, inspired by the [bmschmidt/hathi-binary](https://github.com/bmschmidt/hathi-binary...
269 words
|
1 minute
Set environment variables for all steps in a GitHub Action
2024-08-19
From [this example](https://github.com/GoogleCloudPlatform/github-actions/blob/20c294aabd5331f9f7b8a26e6075d41c31ce5e0d/example-workflows/cloud-run...
81 words
|
1 minute
Simplest possible OAuth authentication with Auth0
2024-08-19
[Auth0](https://auth0.com/) provides an authentication API which you can use to avoid having to deal with user accounts in your own web application.
523 words
|
3 minutes
Allowing a container in Docker Desktop for Mac to talk to a PostgreSQL server on the host machine
2024-08-18
I like using [Postgres.app](https://postgresapp.com/) to run PostgreSQL on my macOS laptop. I use it for a bunch of different projects.
271 words
|
1 minute
Using the GitHub Actions cache with npx and no package.json
2024-08-18
Some of my repositories have GitHub Actions workflows that execute commands using `npx`, for example my [graphql-scraper](https://github.com/simonw...
252 words
|
1 minute
Athena error: The specified key does not exist
2024-08-17
I was trying to run Athena queries against compressed JSON log files stored in an S3 bucket.
248 words
|
1 minute
Testing the Access-Control-Max-Age CORS header
2024-08-16
Today I noticed that [Datasette](https://datasette.io/) wasn't serving a `Access-Control-Max-Age` header.
516 words
|
3 minutes
Serving MBTiles with datasette-media
2024-08-15
The [MBTiles](https://github.com/mapbox/mbtiles-spec) format uses SQLite to bundle map tiles for use with libraries such as Leaflet.
153 words
|
1 minute