Farshid's Weblog

Posts tagged "til"

# Title Date Author
320
Castle vs. Moat
docker til
2025-11-21 Farshid A.
319
Circuit breakers needs durable state
circut-breaker distributed-systems til
2025-11-16 Farshid A.
318
Critical lessons from implementing a highly complex workflow system
til distributed-systems psycopg3 postgresql postgres
2025-11-14 Farshid A.
317
Installing lxml for Python on an M1/M2 Mac
TIL python
2025-10-18 Farshid Ashouri
316
Recursively fetching metadata for all files in a Google Drive folder
TIL googlecloud
2025-10-11 Online Source
315
Open a debugging shell in GitHub Actions with tmate
TIL github-actions
2025-09-28 Farshid Ashouri
314
Running a Python ASGI app on Vercel
TIL zeit-now
2025-09-27 Online Source
313
SQLite BLOB literals
TIL sqlite
2025-09-21 Online Source
312
Understanding option names in Click
TIL python
2025-09-21 Online Source
311
Programmatically comparing Python version strings
TIL python
2025-09-20 Farshid Ashouri
310
Publishing to a public Google Cloud bucket with gsutil
TIL googlecloud
2025-09-20 Online Source
309
Password hashing in Python with pbkdf2
TIL python
2025-09-14 Online Source
308
Subqueries in select expressions in SQLite - also window functions
TIL sqlite
2025-09-14 Online Source
307
Using lsof on macOS
TIL macos
2025-09-13 Farshid Ashouri
306
Logging users out of Auth0
TIL auth0
2025-09-07 Online Source
305
Serving a custom vector web map using PMTiles and maplibre-gl
TIL gis
2025-09-07 Online Source
304
Using fs_usage to see what files a process is using
TIL macos
2025-09-06 Online Source
303
Using heroku pg:pull to restore a backup to a macOS laptop
TIL heroku
2025-09-06 Online Source
302
Protocols in Python
TIL python
2025-08-31 Farshid Ashouri
301
Installing Selenium for Python on macOS with ChromeDriver
TIL selenium
2025-08-24 Farshid Ashouri
300
Packaging a Python CLI tool for Homebrew
TIL homebrew
2025-08-24 Online Source
299
struct endianness in Python
TIL python
2025-08-23 Online Source
298
Using tree-sitter with Python
TIL python
2025-08-23 Farshid Ashouri
297
Identifying column combination patterns in a SQLite table
TIL sqlite
2025-08-16 Farshid Ashouri
296
Using macOS stickies to display a workshop link on the screen
TIL presenting
2025-08-16 Online Source
295
Reformatting text with Copilot
TIL gpt3
2025-08-10 Online Source
294
Snapshot testing with Syrupy
TIL pytest
2025-08-10 Farshid Ashouri
293
Testing a Click app with streaming input
TIL pytest
2025-07-27 Online Source
292
Running Varnish on Fly
TIL fly
2025-07-26 Farshid Ashouri
291
Open external links in an Electron app using the system browser
TIL electron
2025-07-20 Online Source
290
Ignoring errors in a section of a Bash script
TIL bash
2025-07-19 Online Source
289
Mocking a Textract LimitExceededException with boto
TIL pytest
2025-07-05 Online Source
288
Upgrading a Heroku PostgreSQL database with pg:copy
TIL heroku
2025-06-21 Online Source
287
Using llama-cpp-python grammars to generate JSON
TIL llms
2025-06-21 Online Source
286
Redirecting a whole domain with Cloudflare
TIL cloudflare
2025-06-15 Online Source
285
Using io.BufferedReader to peek against a non-peekable stream
TIL python
2025-06-01 Online Source
284
Using custom Sphinx templates on Read the Docs
TIL readthedocs
2025-05-31 Online Source
283
Publishing a simple client-side JavaScript package to npm with GitHub Actions
TIL npm
2025-05-25 Online Source
282
Streaming output of an indented JSON array
TIL json
2025-05-25 Online Source
281
Testing against Python 3.11 preview using GitHub Actions
TIL github-actions
2025-05-18 Online Source
280
Rate limiting by IP using Cloudflare's rate limiting rules
TIL cloudflare
2025-05-10 Online Source
279
Training nanoGPT entirely on content from my blog
TIL llms
2025-05-10 Online Source
278
Whisky sour
TIL cocktails
2025-05-04 Online Source
277
Minifying JavaScript with npx uglify-js
TIL javascript
2025-05-03 Online Source
276
Replicating SQLite with rqlite
TIL sqlite
2025-05-03 Farshid Ashouri
275
Running self-hosted QuickJS in a browser
TIL npm
2025-05-03 Online Source
274
Simple load testing with Locust
TIL python
2025-05-03 Online Source
273
Running tests against multiple versions of a Python dependency in GitHub Actions
TIL github-actions
2025-04-27 Online Source
272
Lazy loading images in HTML
TIL html
2025-04-26 Online Source
271
Using boto3 from the command line
TIL aws
2025-04-26 Farshid Ashouri
270
Manipulating query strings with URLSearchParams
TIL javascript
2025-04-20 Online Source
269
macOS Catalina sort-of includes Python 3
TIL python
2025-04-19 Farshid Ashouri
268
Serving a JavaScript project built using Vite from GitHub Pages
TIL github-actions
2025-04-19 Online Source
267
Using the gcloud run services list command
TIL cloudrun
2025-04-19 Online Source
266
Paginating through the GitHub GraphQL API with Python
TIL github
2025-04-13 Online Source
265
Pausing traffic and retrying in Caddy
TIL caddy
2025-04-06 Farshid Ashouri
264
Syntax highlighting Python console examples with GFM
TIL github
2025-04-06 Farshid Ashouri
263
impaste: pasting images to piped commands on macOS
TIL macos
2025-03-30 Online Source
262
Trying out Quarto on macOS
TIL quarto
2025-03-30 Farshid Ashouri
261
Turning on Jinja autoescaping when using Template() directly
TIL jinja
2025-03-30 Farshid Ashouri
260
Running Python code in a Pyodide sandbox via Deno
TIL deno
2025-03-29 Online Source
259
Run Python code in a WebAssembly sandbox
TIL webassembly
2025-03-22 Farshid Ashouri
258
Trying out the facebook/musicgen-small sound generation model
TIL machinelearning llm huggingface audio Stable Diffusion
2025-03-22 Online Source
257
Trying out the facebook/musicgen-small sound generation model
TIL machinelearning
2025-03-22 Online Source
256
Using the Fly Docker registry
TIL fly
2025-03-22 Farshid Ashouri
255
Syncing slide images and audio in iMovie
TIL macos
2025-03-16 Online Source
254
Using cog to update --help in a Markdown README file
TIL python
2025-03-16 Online Source
253
Using sphinx.ext.extlinks for issue links
TIL sphinx
2025-03-08 Online Source
252
Wider tooltip areas for Observable Plot
TIL observable-plot
2025-03-01 Online Source
251
Trying out SQLite extensions on macOS
TIL sqlite
2025-02-23 Online Source
250
Outputting JSON with reduced floating point precision
TIL python
2025-02-22 Online Source
249
Publishing a Docker container for Microsoft Edit to the GitHub Container Registry
TIL github
2025-02-15 Online Source
248
Wildcard DNS and SSL on Fly
TIL fly
2025-02-15 Farshid Ashouri
247
Running OCR against a PDF file with AWS Textract
TIL aws
2025-02-09 Online Source
246
Using DuckDB in Python to access Parquet data
TIL duckdb
2025-02-08 Farshid Ashouri
245
Using VCR and pytest with pytest-recording
TIL pytest
2025-01-26 Online Source
244
Installing flash-attn without compiling it
TIL python
2025-01-25 Farshid Ashouri
243
Using GPT-3 to figure out jq recipes
TIL gpt3
2025-01-25 Online Source
242
Using pprint() to print dictionaries while preserving their key order
TIL python
2025-01-25 Farshid Ashouri
241
Session-scoped temporary directories in pytest
TIL pytest
2025-01-18 Online Source
240
SQLite pragma_function_list()
TIL sqlite
2025-01-18 Online Source
239
Vega-Lite bar charts in the same order as the data
TIL vega
2025-01-18 Farshid Ashouri
238
Introspecting Python function parameters
TIL python
2025-01-12 Online Source
237
Recovering data from AWS Lightsail using EC2
TIL aws
2025-01-11 Farshid Ashouri
236
Testing things in Fedora using Docker
TIL docker
2025-01-05 Farshid Ashouri
235
Querying the GitHub archive with the ClickHouse playground
TIL clickhouse
2024-12-22 Online Source
234
Running multiple servers in a single Bash script
TIL bash
2024-12-22 Online Source
233
Signing and notarizing an Electron app for distribution using GitHub Actions
TIL electron
2024-12-22 Online Source
232
Using build-arg variables with Cloud Run deployments
TIL cloudrun
2024-12-22 Online Source
231
Treating warnings as errors in pytest
TIL pytest
2024-12-14 Farshid Ashouri
230
Using jq in an Observable notebook
TIL observable
2024-12-14 Online Source
229
SQLite triggers
TIL sqlite
2024-12-08 Online Source
228
Storing and serving related documents with openai-to-sqlite and embeddings
TIL llms
2024-12-07 Online Source
227
mlc-chat - RedPajama-INCITE-Chat-3B on macOS
TIL llms
2024-12-01 Farshid Ashouri
226
Upgrade Postgres.app on macOS
TIL postgresql
2024-12-01 Online Source
225
Using Jest without a package.json
TIL javascript
2024-12-01 Farshid Ashouri
224
Looping over comma-separated values in Bash
TIL bash
2024-11-23 Online Source
223
Pisco sour
TIL cocktails
2024-11-17 Online Source
222
Search and replace with regular expressions in VS Code
TIL vscode
2024-11-16 Online Source
221
migrations.RunSQL.noop for reversible SQL migrations
TIL django
2024-11-03 Farshid Ashouri
220
Running gdb against a Python process in a running Docker container
TIL docker
2024-11-03 Online Source
219
Using the tesseract CLI tool
TIL tesseract
2024-11-03 Farshid Ashouri
218
kubectl proxy
TIL kubernetes
2024-11-02 Farshid Ashouri
217
Removing a git commit and force pushing to remove it from history
TIL git
2024-10-26 Online Source
216
Reading thermometer temperatures over time from a video
TIL googlecloud
2024-10-20 Online Source
215
Testing cookiecutter templates with pytest
TIL cookiecutter
2024-10-13 Online Source
214
Importing CSV data into SQLite with .import
TIL sqlite
2024-10-12 Farshid Ashouri
213
Increasing the time limit for a Google Cloud Scheduler task
TIL cloudrun
2024-10-12 Farshid Ashouri
212
Using C_INCLUDE_PATH to install Python packages
TIL python
2024-10-12 Online Source
211
Using psutil to investigate "Too many open files"
TIL python
2024-10-12 Online Source
210
Lag window function in SQLite
TIL sqlite
2024-10-06 Online Source
209
One-liner for running queries against CSV files with SQLite
TIL sqlite
2024-10-06 Farshid Ashouri
208
Running Docker on an M1 Mac
TIL macos
2024-10-06 Online Source
207
Tracing every executed Python statement
TIL python
2024-10-06 Farshid Ashouri
206
Using nginx to proxy to a Unix domain socket
TIL nginx
2024-10-06 Online Source
205
Writing JavaScript that responds to media queries
TIL javascript
2024-10-06 Online Source
204
Mocking Stripe signature checks in a pytest fixture
TIL pytest
2024-10-05 Farshid Ashouri
203
Using git-filter-repo to set commit dates to author dates
TIL git
2024-10-05 Farshid Ashouri
202
Using the sqlite3 Python module in Pyodide - Python WebAssembly
TIL python
2024-10-05 Farshid Ashouri
201
Intercepting fetch in a service worker
TIL service-workers
2024-09-29 Farshid Ashouri
200
Installing tools written in Go
TIL go
2024-09-28 Farshid Ashouri
199
Rewriting a repo to contain the history of just specific files
TIL git
2024-09-28 Online Source
198
Upgrading a pipx application to an alpha version
TIL python
2024-09-28 Farshid Ashouri
197
Using SQL with GDAL
TIL gis
2024-09-28 Farshid Ashouri
196
Running pytest against a specific Python version with uv run
TIL pytest
2024-09-22 Online Source
195
Streaming indented output of a JSON array
TIL python
2024-09-22 Online Source
194
Reusing an existing Click tool with register_commands
TIL datasette
2024-09-21 Online Source
193
Running a gpt-oss eval suite against LM Studio on a Mac
TIL llms
2024-09-21 Online Source
192
Saving an in-memory SQLite database to a file in Python
TIL sqlite
2024-09-15 Farshid Ashouri
191
Using awk to add a prefix
TIL bash
2024-09-14 Online Source
190
Skipping CSV rows with odd numbers of quotes using ripgrep
TIL bash
2024-08-31 Farshid Ashouri
189
Start, test, then stop a localhost web server in a Bash script
TIL bash
2024-08-31 Online Source
188
Loading radio.garden into SQLite using jq
TIL jq
2024-08-25 Farshid Ashouri
187
Switching between gcloud accounts
TIL cloudrun
2024-08-18 Farshid Ashouri
186
Writing Fly logs to S3
TIL fly
2024-08-18 Online Source
185
__init_subclass__
TIL python
2024-08-17 Online Source
184
Social media cards generated with shot-scraper
TIL shot-scraper
2024-08-17 Online Source
183
The simplest recursive CTE
TIL sqlite
2024-08-17 Farshid Ashouri
182
Making HTTP calls using IPv6
TIL networking
2024-08-04 Farshid Ashouri
181
Updating stable docs in ReadTheDocs without pushing a release
TIL readthedocs
2024-08-04 Online Source
180
Working around the size limit for nodeValue in the DOM
TIL javascript
2024-08-04 Online Source
179
KNN queries with SpatiaLite
TIL spatialite
2024-08-03 Online Source
178
Pointing a custom subdomain at Read the Docs
TIL readthedocs
2024-08-03 Farshid Ashouri
177
The location of the pip cache directory
TIL python
2024-08-03 Farshid Ashouri
176
Upgrading Homebrew and avoiding the failed to verify attestation error
TIL homebrew
2024-08-03 Farshid Ashouri
175
Using recursive CTEs to explore hierarchical Twitter threads
TIL sql
2024-07-28 Online Source
174
pytest coverage with context
TIL pytest
2024-07-21 Online Source
173
Transferring a GitHub issue from a private to a public repository
TIL github
2024-07-21 Online Source
172
SQLite VACUUM: database or disk is full
TIL sqlite
2024-07-20 Farshid Ashouri
171
Running jupyterlab via uv tool install
TIL jupyter
2024-07-14 Farshid Ashouri
170
Installing different PostgreSQL server versions in GitHub Actions
TIL github-actions
2024-07-13 Online Source
169
Publishing a Web Component to npm
TIL npm
2024-07-13 Online Source
168
Implementing a "copy to clipboard" button
TIL javascript
2024-07-06 Online Source
167
Quickly testing code in a different Python version using pyenv
TIL python
2024-07-06 Online Source
166
Limited JSON API for Google searches using Programmable Search Engine
TIL google
2024-06-30 Online Source
165
Start a server in a subprocess during a pytest session
TIL pytest
2024-06-29 Online Source
164
Using async/await in JavaScript in Selenium
TIL selenium
2024-06-29 Farshid Ashouri
163
Using OpenAI functions and their Python library for data extraction
TIL gpt3
2024-06-29 Online Source
162
Using Prettier to check JavaScript code style in GitHub Actions
TIL github-actions
2024-06-23 Online Source
161
Installing packages from Debian unstable in a Docker image based on stable
TIL docker
2024-06-22 Online Source
160
Redirecting all paths on a Vercel instance
TIL zeit-now
2024-06-22 Online Source
159
Testing different Python versions with uv with-editable and uv-test
TIL python
2024-06-16 Online Source
158
Migrating a GitHub wiki from one repository to another
TIL github
2024-06-15 Farshid Ashouri
157
Processing a stream of chunks of JSON with ijson
TIL json
2024-06-09 Online Source
156
Upgrading packages with npm
TIL npm
2024-06-09 Online Source
155
Registering the same Pluggy hook multiple times in a single file
TIL pluggy
2024-06-08 Farshid Ashouri
154
Running cog automatically against GitHub pull requests
TIL github-actions
2024-06-08 Online Source
153
Safely outputting JSON
TIL python
2024-06-08 Farshid Ashouri
152
Livestreaming a community election event on YouTube
TIL youtube
2024-06-02 Online Source
151
Registering temporary pluggy plugins inside tests
TIL pytest
2024-06-01 Online Source
150
Summarizing Hacker News discussion themes with Claude and LLM
TIL llms
2024-06-01 Online Source
149
Trick Apple Photos into letting you access your video files
TIL macos
2024-05-25 Farshid Ashouri
148
Useful Markdown extensions in Python
TIL markdown
2024-05-19 Farshid Ashouri
147
Named Entity Resolution with dslim/distilbert-NER
TIL llms
2024-05-18 Farshid Ashouri
146
Setting cache-control: max-age=31536000 with a Cloudflare Transform Rule
TIL cloudflare
2024-05-12 Online Source
145
The pdb interact command
TIL python
2024-05-12 Farshid Ashouri
144
Using ChatGPT to write AppleScript
TIL gpt3
2024-05-12 Farshid Ashouri
143
Restricting SSH connections to devices within a Tailscale network
TIL tailscale
2024-05-11 Online Source
142
Using grep to write tests in CI
TIL github-actions
2024-05-11 Farshid Ashouri
141
Sort by number of JSON intersections
TIL sqlite
2024-05-05 Online Source
140
Running pip install -e .[test] in zsh on macOS Catalina
TIL macos
2024-05-04 Farshid Ashouri
139
Seeing files opened by a process using opensnoop
TIL macos
2024-05-04 Online Source
138
Using Tesseract.js to OCR every image on a page
TIL javascript
2024-05-04 Farshid Ashouri
137
Mocking subprocess with pytest-subprocess
TIL pytest
2024-04-28 Farshid Ashouri
136
Using the undocumented Fly GraphQL API
TIL fly
2024-04-28 Farshid Ashouri
135
sips: Scriptable image processing system
TIL macos
2024-04-20 Farshid Ashouri
134
Piping echo to a file owned by root using sudo and tee
TIL linux
2024-04-14 Farshid Ashouri
133
Publish releases to PyPI from GitHub Actions without a password or token
TIL pypi
2024-04-14 Online Source
132
SQLite aggregate filter clauses
TIL sqlite
2024-04-14 Farshid Ashouri
131
Turning an array of arrays into objects with jq
TIL jq
2024-04-14 Farshid Ashouri
130
JSON Pointer
TIL json
2024-04-13 Online Source
129
Listen to a web page in Mobile Safari
TIL ios
2024-04-13 Online Source
128
Running different steps on a schedule
TIL github-actions
2024-04-13 Online Source
127
Summing columns in remote Parquet files using DuckDB
TIL duckdb
2024-04-13 Online Source
126
TOML in Python
TIL python
2024-04-13 Farshid Ashouri
125
Running pip install '.[docs]' on ReadTheDocs
TIL readthedocs
2024-04-07 Farshid Ashouri
124
Show files opened by pytest tests
TIL pytest
2024-04-07 Online Source
123
Simplest possible OAuth authentication with Auth0
TIL auth0
2024-04-06 Online Source
122
Set a GIF to loop using ImageMagick
TIL imagemagick
2024-03-30 Online Source
121
Piping from rg to llm to answer questions about code
TIL llms
2024-03-24 Online Source
120
SQLite can use more than one index for a query
TIL sqlite
2024-03-10 Farshid Ashouri
119
Loading lit from Skypack
TIL javascript
2024-03-09 Online Source
118
Using iconv to convert the text encoding of a file
TIL linux
2024-03-09 Online Source
117
SQLite timestamps with floating point seconds
TIL sqlite
2024-03-03 Farshid Ashouri
116
Promoting the stable version of the documentation using rel=canonical
TIL readthedocs
2024-03-02 Online Source
115
Querying for GitHub issues open for less than 60 seconds
TIL datasette
2024-03-02 Online Source
114
Using S3 triggers to maintain a list of files in DynamoDB
TIL aws
2024-03-02 Online Source
113
The most basic possible Hugo site
TIL hugo
2024-02-25 Online Source
112
Listing files uploaded to Cloud Build
TIL cloudrun
2024-02-24 Farshid Ashouri
111
Show the SQL schema for a PostgreSQL database
TIL postgresql
2024-02-24 Farshid Ashouri
110
Using the ChatGPT streaming API from Python
TIL gpt3
2024-02-24 Farshid Ashouri
109
JavaScript date objects
TIL javascript
2024-02-17 Online Source
108
Python packages with pyproject.toml and nothing else
TIL python
2024-02-17 Online Source
107
Tailing Google Cloud Run request logs and importing them into SQLite
TIL cloudrun
2024-02-17 Online Source
106
Trying out Python packages with ipython and uvx
TIL python
2024-02-17 Online Source
105
os.remove() on Windows fails if the file is already open
TIL python
2024-02-11 Online Source
104
Verifying your GitHub profile on Mastodon
TIL mastodon
2024-02-11 Online Source
103
Querying for items stored in UTC that were created on a Thursday in PST
TIL sqlite
2024-02-04 Farshid Ashouri
102
Running Dolly 2.0 on Paperspace
TIL llms
2024-02-04 Farshid Ashouri
101
Trying out free-threaded Python on macOS
TIL python
2024-02-03 Online Source
100
WebAuthn browser support
TIL webauthn
2024-01-27 Online Source
99
Run pytest against a specific Python version using Docker
TIL docker
2024-01-21 Online Source
98
Skipping a GitHub Actions step without failing
TIL github-actions
2024-01-20 Online Source
97
Transcribing MP3s with whisper-cpp on macOS
TIL macos
2024-01-20 Online Source
96
Using a Tailscale exit node with GitHub Actions
TIL tailscale
2024-01-20 Online Source
95
Using unnest() to use a comma-separated string as the input to an IN query
TIL postgresql
2024-01-13 Online Source
94
Workaround for google-github-actions/setup-gcloud errors
TIL googlecloud
2024-01-07 Online Source
93
The SQLite now argument is stable within the same query
TIL sqlite
2024-01-06 Online Source
92
Using namedtuple for pytest parameterized tests
TIL pytest
2023-12-31 Farshid Ashouri
91
Packaging a Python app as a standalone binary with PyInstaller
TIL python
2023-12-30 Online Source
90
Providing a "subscribe in Google Calendar" link for an ics feed
TIL ics
2023-12-23 Farshid Ashouri
89
The Wikipedia page stats API
TIL wikipedia
2023-12-17 Farshid Ashouri
88
Read the Docs Search API
TIL readthedocs
2023-12-10 Farshid Ashouri
87
Reporting bugs in GitHub to GitHub
TIL github
2023-12-10 Farshid Ashouri
86
Splitting on commas in SQLite
TIL sqlite
2023-12-10 Farshid Ashouri
85
Using curl to run GraphQL queries from the command line
TIL graphql
2023-12-03 Online Source
84
Installing Python on macOS with the official Python installer
TIL macos
2023-11-26 Farshid Ashouri
83
Testing the Access-Control-Max-Age CORS header
TIL http
2023-11-26 Online Source
82
Writing an Azure Function that serves all traffic to a subdomain
TIL azure
2023-11-26 Online Source
81
Only run GitHub Action on push to master / main
TIL github-actions
2023-11-25 Online Source
80
Quick and dirty mock testing with mock_calls
TIL pytest
2023-11-19 Online Source
79
Running Ethernet over existing coaxial cable
TIL networking
2023-11-19 Online Source
78
Using Playwright MCP with Claude Code
TIL claude-code
2023-11-19 Farshid Ashouri
77
Scroll page to form if there are errors
TIL javascript
2023-11-18 Online Source
76
Styling an HTML dialog modal to take the full height of the viewport
TIL css
2023-11-18 Online Source
75
Writing pytest tests against tools written with argparse
TIL pytest
2023-11-18 Online Source
74
Running PyPy on macOS using Homebrew
TIL python
2023-11-05 Farshid Ashouri
73
Scraping the Sky News Westminster Accounts, a Flourish application
TIL shot-scraper
2023-11-05 Online Source
72
Understanding the CSS auto-resizing textarea trick
TIL css
2023-11-05 Online Source
71
Track timestamped changes to a SQLite table using triggers
TIL sqlite
2023-10-28 Farshid Ashouri
70
Rewriting a Git repo to remove secrets from the history
TIL git
2023-10-15 Online Source
69
Search across all loaded resources in Firefox
TIL firefox
2023-10-14 Online Source
68
Using Fabric with an SSH public key
TIL python
2023-10-14 Online Source
67
Scroll to text fragments
TIL html
2023-10-01 Online Source
66
Planning parallel downloads with TopologicalSorter
TIL python
2023-09-30 Online Source
65
literalinclude with markers for showing code in documentation
TIL sphinx
2023-09-24 Online Source
64
Understanding Kristofer Joseph's Single File Web Component
TIL web-components
2023-09-24 Farshid Ashouri
63
Searching for repositories by topic using the GitHub GraphQL API
TIL github
2023-09-23 Farshid Ashouri
62
List all columns in a SQLite database
TIL sqlite
2023-09-17 Farshid Ashouri
61
Null case comparisons in SQLite
TIL sqlite
2023-09-17 Online Source
60
Storing files in an S3 bucket between GitHub Actions runs
TIL github-actions
2023-09-17 Online Source
59
Local wildcard DNS on macOS with dnsmasq
TIL macos
2023-09-09 Online Source
58
Using json_extract_path in PostgreSQL
TIL postgresql
2023-09-09 Farshid Ashouri
57
Upgrading Python Homebrew packages using pip
TIL homebrew
2023-09-03 Farshid Ashouri
56
Using the GitHub Actions cache with npx and no package.json
TIL github-actions
2023-09-03 Online Source
55
Returning related rows in a single SQL query using JSON
TIL sqlite
2023-08-20 Online Source
54
Mouse support in vim
TIL vim
2023-08-19 Online Source
53
Pixel editing a favicon with Pixelmator
TIL pixelmator
2023-08-13 Online Source
52
Logging OpenAI API requests and responses using HTTPX
TIL httpx
2023-08-12 Online Source
51
Testing Electron apps with Playwright and GitHub Actions
TIL electron
2023-08-06 Online Source
50
shot-scraper for a subset of table columns
TIL shot-scraper
2023-08-05 Online Source
49
Opt-in integration tests with pytest --integration
TIL pytest
2023-07-29 Online Source
48
Using ChatGPT Browse to name a Python package
TIL gpt3
2023-07-23 Online Source
47
Rendering Markdown with the GitHub Markdown API
TIL markdown
2023-07-22 Online Source
46
Redirecting a domain using Cloudflare Pages
TIL cloudflare
2023-07-16 Online Source
45
Trying out cr-sqlite on macOS
TIL sqlite
2023-07-15 Farshid Ashouri
44
Setting up a custom subdomain for a GitHub Pages site
TIL github
2023-07-09 Online Source
43
Scraping Reddit via their JSON API
TIL reddit
2023-07-08 Online Source
42
Optimizing PNGs in GitHub Actions using Oxipng
TIL github-actions
2023-07-02 Online Source
41
Using LD_PRELOAD to run any version of SQLite with Python
TIL sqlite
2023-07-01 Online Source
40
Passing command arguments using heredoc syntax
TIL zsh
2023-06-18 Farshid Ashouri
39
Loading SQLite extensions in Python on macOS
TIL sqlite
2023-06-17 Farshid Ashouri
38
Using packages from JSR with esbuild
TIL javascript
2023-06-17 Online Source
37
Interpreting photo orientation and locations in EXIF data
TIL exif
2023-06-11 Online Source
36
Relinquishing control in Python asyncio
TIL python
2023-05-28 Farshid Ashouri
35
Shrinking PNG files with pngquant and oxipng
TIL macos
2023-05-20 Farshid Ashouri
34
Using the Chrome DevTools console as a REPL for an Electron app
TIL electron
2023-05-07 Farshid Ashouri
33
Using pysqlite3 on macOS
TIL sqlite
2023-05-06 Farshid Ashouri
32
Ignoring a line in both flake8 and mypy
TIL python
2023-04-30 Online Source
31
Using pipenv and Docker
TIL docker
2023-04-23 Farshid Ashouri
30
Programatically accessing Heroku PostgreSQL from GitHub Actions
TIL heroku
2023-04-22 Online Source
29
Testing HTML tables with Playwright Python
TIL playwright
2023-04-22 Online Source
28
Use setup.py to install platform-specific dependencies
TIL python
2023-04-16 Farshid Ashouri
27
Running nanoGPT on a MacBook M2 to generate terrible Shakespeare
TIL llms
2023-04-09 Online Source
26
Running tests against PostgreSQL in a service container
TIL github-actions
2023-04-09 Online Source
25
Tommy's Margarita
TIL cocktails
2023-04-09 Online Source
24
nullglob in bash
TIL bash
2023-04-02 Online Source
23
Language-specific indentation settings in VS Code
TIL vscode
2023-04-01 Farshid Ashouri
22
Writing tests with Copilot
TIL gpt3
2023-04-01 Online Source
21
Running prompts against images, PDFs, audio and video with Google Gemini
TIL llms
2023-03-19 Online Source
20
Linking from /latest/ to /stable/ on Read The Docs
TIL readthedocs
2023-03-18 Online Source
19
Running a MySQL server using Homebrew
TIL homebrew
2023-03-18 Farshid Ashouri
18
Using expect() to wait for a selector to match multiple items
TIL playwright
2023-03-05 Online Source
17
Running Python code in a subprocess with a time limit
TIL python
2023-02-26 Online Source
16
Tracking SQLite table history using a JSON audit log
TIL sqlite
2023-02-25 Online Source
15
Very basic tsc usage
TIL typescript
2023-02-25 Online Source
14
Ordered group_concat() in SQLite
TIL sqlite
2023-02-18 Farshid Ashouri
13
Querying newline-delimited JSON logs using AWS Athena
TIL aws
2023-02-05 Online Source
12
Set environment variables for all steps in a GitHub Action
TIL github-actions
2023-02-05 Online Source
11
Using uv to develop Python command-line applications
TIL python
2023-02-05 Online Source
10
Using pytest and Playwright to test a JavaScript web application
TIL pytest
2023-02-04 Online Source
9
Preventing double form submissions with JavaScript
TIL javascript
2023-01-28 Farshid Ashouri
8
Writing tests for the ASGI lifespan protocol with HTTPX
TIL asgi
2023-01-28 Online Source
7
Running LLaMA 7B and 13B on a 64GB M2 MacBook Pro with llama.cpp
TIL llms
2023-01-22 Farshid Ashouri
6
Reviewing your history of public GitHub repositories using ClickHouse
TIL clickhouse
2023-01-21 Online Source
5
Updating a Markdown table of contents with a GitHub Action
TIL github-actions
2023-01-15 Farshid Ashouri
4
Running OpenAI's large context models using llm
TIL llms
2023-01-08 Farshid Ashouri
3
Unix timestamp in milliseconds in SQLite
TIL sqlite
2023-01-08 Online Source
2
Use labels on Cloud Run services for a billing breakdown
TIL cloudrun
2023-01-08 Online Source
1
Talking to a PostgreSQL service container from inside a Docker container
TIL github-actions
2023-01-01 Farshid Ashouri