Farshid's Weblog

Posts tagged “TIL”

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