Farshid's Weblog

# Title Date Author
178
Trying out free-threaded Python on macOS
TIL python
2024-02-03 Online Source
177
Finding duplicate records by matching name and nearby distance
sql gis database duplicates spatialite
2024-01-28 Farshid Ashouri
176
WebAuthn browser support
TIL webauthn
2024-01-27 Online Source
175
Editing an iPhone home screen using macOS
iphone macos productivity tips apple
2024-01-21 Online Source
174
Export a Mastodon timeline to SQLite
mastodon api sqlite sqlite-utils cli json pagination
2024-01-21 Online Source
173
Figuring out if a text value in SQLite is a valid integer or float
sqlite sql data-types validation database
2024-01-21 Online Source
172
Run pytest against a specific Python version using Docker
TIL docker
2024-01-21 Online Source
171
Deploying Python web apps as AWS Lambda functions
aws lambda python serverless deployment cli docker asgi
2024-01-20 Online Source
170
Skipping a GitHub Actions step without failing
TIL github-actions
2024-01-20 Online Source
169
Transcribing MP3s with whisper-cpp on macOS
TIL macos
2024-01-20 Online Source
168
Using a Tailscale exit node with GitHub Actions
TIL tailscale
2024-01-20 Online Source
167
Using unnest() to use a comma-separated string as the input to an IN query
TIL postgresql
2024-01-13 Online Source
166
Workaround for google-github-actions/setup-gcloud errors
TIL googlecloud
2024-01-07 Online Source
165
Configuring Dependabot for a Python project
github dependabot python dependencies automation ci/cd
2024-01-06 Online Source
164
The SQLite now argument is stable within the same query
TIL sqlite
2024-01-06 Online Source
163
Display EC2 instance costs per month
aws ec2 javascript browser productivity cost-management
2023-12-31 Farshid Ashouri
162
Formatting thousands in Jinja
jinja templating python formatting tips
2023-12-31 Farshid Ashouri
161
Using namedtuple for pytest parameterized tests
TIL pytest
2023-12-31 Farshid Ashouri
160
Packaging a Python app as a standalone binary with PyInstaller
TIL python
2023-12-30 Online Source
159
Constructing GeoJSON in PostgreSQL
postgresql sql geojson gis json database
2023-12-24 Farshid Ashouri