Home

#	Title	Date	Author
529	A new Article about what I am doing articles	2025-11-10	Farshid A.
528	A comparison of advanced workflow engines dbos highway workflow-engine durable-executions	2025-11-08	Farshid A.
527	A complete workflow domain-specific language - Highway DSL highway-dsl pypi workflow-engine dsl spec rfc	2025-11-08	Farshid A.
526	How to run processes in with limited resources in Linux (no Docker needed) cgroups isolation namespaces	2025-11-08	Farshid A.
525	Running fully isolated commands in Linux isolation linux chroot unshare	2025-11-08	Farshid A.
524	Thundering herd problem thundering-herd processes threads cache-stampede iitter	2025-11-08	Farshid A.
523	TOCTOU (Time-of-Check to Time-of-Use) vulnerability toc toctou Time-of-Check Time-of-Use vulnerability	2025-11-08	Farshid A.
522	Durable Workflow Engines - Ridiculously Absurd! highway-dsl domain-specific-language dsl absurd postgres durable-executions agents	2025-11-06	Farshid A.
521	Integrating `highway_dsl` and `Absurd` for a Durable Workflow Engine highway-dsl domain-specific-language dsl absurd postgres durable-executions agents	2025-11-06	Farshid A.
520	Highway-DSL: A Pydantic-Native DSL for Defining Complex Workflows dsl domain-specific-language highway workflow workflow-engine	2025-11-01	Farshid A.
519	reTunnel is Amazing retunnel ngrok	2025-11-01	Farshid A.
518	what is derivative of A in respect to B? math calculus	2025-10-30	Farshid A.
517	What is derivative of A with respect to B? math calculus	2025-10-30	Farshid A.
516	Learn Neural Networks nn neural_networks ai ml machine_learning	2025-10-29	Farshid A.
515	PySpark Style Guide pyspark spark	2025-10-28	Farshid A.
514	ySpark Style Guide pyspark spark	2025-10-28	Farshid A.
513	Math cheatsheets math cheatsheet	2025-10-24	Farshid A.
512	The Bill of Materials sbom	2025-10-24	Farshid A.
511	Flattening nested JSON objects with jq jq json data-transformation cli sqlite-utils	2025-10-19	Farshid Ashouri
510	Clone, edit and push files that live in a Gist github gist git cli	2025-10-18	Online Source
509	Installing lxml for Python on an M1/M2 Mac TIL python	2025-10-18	Farshid Ashouri
508	Recursively fetching metadata for all files in a Google Drive folder TIL googlecloud	2025-10-11	Online Source
507	Open a debugging shell in GitHub Actions with tmate TIL github-actions	2025-09-28	Farshid Ashouri
506	Geopoly in SQLite sqlite geopoly gis geojson database datasette spatial	2025-09-27	Online Source
505	Running a Python ASGI app on Vercel TIL zeit-now	2025-09-27	Online Source
504	Exporting and editing a Twitter Spaces recording twitter audio video downloading ffmpeg youtube-dl macos cli	2025-09-21	Online Source
503	SQLite BLOB literals TIL sqlite	2025-09-21	Online Source
502	Understanding option names in Click TIL python	2025-09-21	Online Source
501	Programmatically comparing Python version strings TIL python	2025-09-20	Farshid Ashouri
500	Publishing to a public Google Cloud bucket with gsutil TIL googlecloud	2025-09-20	Online Source
499	Checking if something is callable or async callable in Python python asyncio introspection callable testing pytest	2025-09-14	Online Source
498	Password hashing in Python with pbkdf2 TIL python	2025-09-14	Online Source
497	Subqueries in select expressions in SQLite - also window functions TIL sqlite	2025-09-14	Online Source
496	A shell script for running Go one-liners go bash shell scripting cli gpt-4 ai	2025-09-13	Online Source
495	Using lsof on macOS TIL macos	2025-09-13	Farshid Ashouri
494	Configuring GitHub Codespaces using devcontainers github codespaces devcontainers python vscode cli automation llm ai	2025-09-07	Online Source
493	Logging users out of Auth0 TIL auth0	2025-09-07	Online Source
492	Serving a custom vector web map using PMTiles and maplibre-gl TIL gis	2025-09-07	Online Source
491	Using fs_usage to see what files a process is using TIL macos	2025-09-06	Online Source
490	Using heroku pg:pull to restore a backup to a macOS laptop TIL heroku	2025-09-06	Online Source
489	Creating a minimal SpatiaLite database with Python spatialite sqlite python gis database geospatial	2025-08-31	Online Source
488	Protocols in Python TIL python	2025-08-31	Farshid Ashouri
487	HTML video with subtitles html video subtitles webvtt web-development accessibility	2025-08-30	Online Source
486	Installing Selenium for Python on macOS with ChromeDriver TIL selenium	2025-08-24	Farshid Ashouri
485	Packaging a Python CLI tool for Homebrew TIL homebrew	2025-08-24	Online Source
484	struct endianness in Python TIL python	2025-08-23	Online Source
483	Using tree-sitter with Python TIL python	2025-08-23	Farshid Ashouri
482	Identifying column combination patterns in a SQLite table TIL sqlite	2025-08-16	Farshid Ashouri
481	Using macOS stickies to display a workshop link on the screen TIL presenting	2025-08-16	Online Source
480	Automatically maintaining Homebrew formulas using GitHub Actions homebrew github-actions python cli packaging ci/cd git	2025-08-10	Online Source
479	Finding CSV files that start with a BOM using ripgrep ripgrep cli bash encoding csv regex	2025-08-10	Online Source
478	Reformatting text with Copilot TIL gpt3	2025-08-10	Online Source
477	Snapshot testing with Syrupy TIL pytest	2025-08-10	Farshid Ashouri
476	Asserting a dictionary is a subset of another dictionary python testing dictionaries pytest	2025-08-02	Online Source
475	Creating a tiled zoomable image with OpenSeadragon and vips image-processing web-development javascript vips openseadragon cli	2025-08-02	Farshid Ashouri
474	Testing a Click app with streaming input TIL pytest	2025-07-27	Online Source
473	Converting ORF raw files to JPEG on macOS macos image-processing cli bash dcraw imagemagick	2025-07-26	Farshid Ashouri
472	Finding the SQLite version used by Web SQL in Chrome sqlite chrome web-sql javascript browser debugging	2025-07-26	Farshid Ashouri
471	Running Varnish on Fly TIL fly	2025-07-26	Farshid Ashouri
470	actions/setup-python caching for setup.py projects github-actions python caching ci/cd setup.py	2025-07-20	Online Source
469	Open external links in an Electron app using the system browser TIL electron	2025-07-20	Online Source
468	Ignoring errors in a section of a Bash script TIL bash	2025-07-19	Online Source
467	Compiling and running sqlite3-rsync sqlite compilation cli database synchronization wal	2025-07-12	Farshid Ashouri
466	Assigning a custom subdomain to a Fly app fly.io dns ssl subdomain web-hosting cli	2025-07-05	Online Source
465	Efficiently copying a file python file-io performance shutil starlette	2025-07-05	Farshid Ashouri
464	Mocking a Textract LimitExceededException with boto TIL pytest	2025-07-05	Online Source
463	Compiling to WASM with llvm on macOS webassembly wasm llvm clang macos compilation c++ web-development	2025-06-28	Online Source
462	My Professional Journey and Passions ['data-engineering' 'distributed-systems' 'python' 'crime-docs' 'piano' 'london' 'italian-food']	2025-06-28	Farshid Ashouri
461	Auto-formatting YAML files with yamlfmt yaml formatting cli go ci/cd	2025-06-22	Farshid Ashouri
460	Bundling Python inside an Electron app electron python packaging macos desktop-app javascript ci/cd	2025-06-21	Online Source
459	Format code examples in documentation with blacken-docs python documentation formatting black ci/cd sphinx	2025-06-21	Online Source
458	Upgrading a Heroku PostgreSQL database with pg:copy TIL heroku	2025-06-21	Online Source
457	Using llama-cpp-python grammars to generate JSON TIL llms	2025-06-21	Online Source
456	Redirecting a whole domain with Cloudflare TIL cloudflare	2025-06-15	Online Source
455	Customizing my zsh prompt zsh macos cli productivity shell	2025-06-14	Farshid Ashouri
454	Fixing "compinit: insecure directories" error macos zsh cli troubleshooting permissions	2025-06-08	Farshid Ashouri
453	Embedding JavaScript in a Jupyter notebook jupyter javascript python cryptography notebooks web-development	2025-06-07	Farshid Ashouri
452	Using io.BufferedReader to peek against a non-peekable stream TIL python	2025-06-01	Online Source
451	axe-core and shot-scraper for accessibility audits accessibility web-development testing javascript cli shot-scraper axe-core jq sqlite-utils datasette	2025-05-31	Online Source
450	Using custom Sphinx templates on Read the Docs TIL readthedocs	2025-05-31	Online Source
449	GraphQL fragments graphql api optimization programming	2025-05-25	Online Source
448	Publishing a simple client-side JavaScript package to npm with GitHub Actions TIL npm	2025-05-25	Online Source
447	Streaming output of an indented JSON array TIL json	2025-05-25	Online Source
446	Testing against Python 3.11 preview using GitHub Actions TIL github-actions	2025-05-18	Online Source
445	How to get credentials for a new Twitter bot twitter api oauth bots credentials automation	2025-05-10	Online Source
444	Rate limiting by IP using Cloudflare's rate limiting rules TIL cloudflare	2025-05-10	Online Source
443	Training nanoGPT entirely on content from my blog TIL llms	2025-05-10	Online Source
442	--- python sqlite cli	2025-05-04	Online Source
441	Google Oauth2 is awesome oauth2 google authentication security web-development	2025-05-04	Farshid A.
440	Whisky sour TIL cocktails	2025-05-04	Online Source
439	Minifying JavaScript with npx uglify-js TIL javascript	2025-05-03	Online Source
438	Replicating SQLite with rqlite TIL sqlite	2025-05-03	Farshid Ashouri
437	Running self-hosted QuickJS in a browser TIL npm	2025-05-03	Online Source
436	Simple load testing with Locust TIL python	2025-05-03	Online Source
435	Generated a summary of nested JSON data python json data-analysis data-structures recursion	2025-04-27	Online Source
434	Granting a PostgreSQL user read-only access to some tables postgresql sql permissions database security	2025-04-27	Farshid Ashouri
433	Running tests against multiple versions of a Python dependency in GitHub Actions TIL github-actions	2025-04-27	Online Source
432	Lazy loading images in HTML TIL html	2025-04-26	Online Source
431	Using boto3 from the command line TIL aws	2025-04-26	Farshid Ashouri
430	Manipulating query strings with URLSearchParams TIL javascript	2025-04-20	Online Source
429	macOS Catalina sort-of includes Python 3 TIL python	2025-04-19	Farshid Ashouri
428	Serving a JavaScript project built using Vite from GitHub Pages TIL github-actions	2025-04-19	Online Source
427	Using the gcloud run services list command TIL cloudrun	2025-04-19	Online Source
426	Paginating through the GitHub GraphQL API with Python TIL github	2025-04-13	Online Source
425	Embedding paragraphs from my blog with E5-large-v2 llm embeddings ai nlp python cli sqlite postgresql data-analysis	2025-04-06	Online Source
424	Pausing traffic and retrying in Caddy TIL caddy	2025-04-06	Farshid Ashouri
423	Syntax highlighting Python console examples with GFM TIL github	2025-04-06	Farshid Ashouri
422	Extracting web page content using Readability.js and shot-scraper web-scraping javascript shot-scraper readability.js cli json sqlite-utils	2025-04-05	Online Source
421	impaste: pasting images to piped commands on macOS TIL macos	2025-03-30	Online Source
420	Trying out Quarto on macOS TIL quarto	2025-03-30	Farshid Ashouri
419	Turning on Jinja autoescaping when using Template() directly TIL jinja	2025-03-30	Farshid Ashouri
418	Running Python code in a Pyodide sandbox via Deno TIL deno	2025-03-29	Online Source
417	How to mock httpx using pytest-mock python testing mocking httpx pytest pytest-mock	2025-03-22	Online Source
416	Run Python code in a WebAssembly sandbox TIL webassembly	2025-03-22	Farshid Ashouri
415	Trying out the facebook/musicgen-small sound generation model TIL machinelearning llm huggingface audio Stable Diffusion	2025-03-22	Online Source
414	Trying out the facebook/musicgen-small sound generation model TIL machinelearning	2025-03-22	Online Source
413	Using the Fly Docker registry TIL fly	2025-03-22	Farshid Ashouri
412	A simple two column CSS grid css grid html web-development gpt-4 ai	2025-03-16	Online Source
411	Closest locations to a point postgresql sql gis django orm geospatial	2025-03-16	Farshid Ashouri
410	Learn Data Engineering topics using Flash Cards flash-cards data-engineering iceberg trino	2025-03-16	Farshid A.
409	Syncing slide images and audio in iMovie TIL macos	2025-03-16	Online Source
408	Using cog to update --help in a Markdown README file TIL python	2025-03-16	Online Source
407	Convert git log output to JSON using jq git jq cli json bash automation	2025-03-08	Online Source
406	Using sphinx.ext.extlinks for issue links TIL sphinx	2025-03-08	Online Source
405	Debugging a Click application using pdb python debugging cli click pdb	2025-03-02	Online Source
404	Wider tooltip areas for Observable Plot TIL observable-plot	2025-03-01	Online Source
403	Trying out SQLite extensions on macOS TIL sqlite	2025-02-23	Online Source
402	Outputting JSON with reduced floating point precision TIL python	2025-02-22	Online Source
401	Publishing a Docker container for Microsoft Edit to the GitHub Container Registry TIL github	2025-02-15	Online Source
400	Wildcard DNS and SSL on Fly TIL fly	2025-02-15	Farshid Ashouri
399	Ensure labels exist in a GitHub repository github github-actions automation labels ci/cd	2025-02-09	Online Source
398	Running OCR against a PDF file with AWS Textract TIL aws	2025-02-09	Online Source
397	Geocoding from Python on macOS using pyobjc-framework-CoreLocation python macos geocoding core-location pyobjc cli	2025-02-08	Online Source
396	Using DuckDB in Python to access Parquet data TIL duckdb	2025-02-08	Farshid Ashouri
395	Combined release notes from GitHub with jq and paginate-json github api release-notes jq cli bash automation llm ai	2025-02-01	Online Source
394	Conditionally creating directories in cookiecutter cookiecutter python templating automation project-generation	2025-02-01	Online Source
393	Using VCR and pytest with pytest-recording TIL pytest	2025-01-26	Online Source
392	Installing flash-attn without compiling it TIL python	2025-01-25	Farshid Ashouri
391	Tech Blogs and Podcasts blog good-read reads tech	2025-01-25	Online Source
390	Using GPT-3 to figure out jq recipes TIL gpt3	2025-01-25	Online Source
389	Using pprint() to print dictionaries while preserving their key order TIL python	2025-01-25	Farshid Ashouri
388	Build the official Python documentation locally python documentation sphinx git cli	2025-01-18	Farshid Ashouri
387	Session-scoped temporary directories in pytest TIL pytest	2025-01-18	Online Source
386	SQLite pragma_function_list() TIL sqlite	2025-01-18	Online Source
385	Vega-Lite bar charts in the same order as the data TIL vega	2025-01-18	Farshid Ashouri
384	Generating OpenAPI specifications using GPT-3 openapi api gpt-3 ai code-generation json	2025-01-12	Farshid Ashouri
383	How to run MediaWiki with SQLite on a macOS laptop mediawiki sqlite macos php web-server datasette	2025-01-12	Online Source
382	Introspecting Python function parameters TIL python	2025-01-12	Online Source
381	Recovering data from AWS Lightsail using EC2 TIL aws	2025-01-11	Farshid Ashouri
380	Async fixtures with pytest-asyncio pytest asyncio python testing fixtures	2025-01-05	Farshid Ashouri
379	Downloading MapZen elevation tiles gis elevation tiles data-download cli mapzen	2025-01-05	Online Source
378	Testing things in Fedora using Docker TIL docker	2025-01-05	Farshid Ashouri
377	How streaming LLM APIs work llm api streaming openai anthropic google-gemini curl python javascript web-development	2025-01-04	Online Source
376	Combining CTEs and VALUES in SQLite sqlite sql cte database	2024-12-29	Farshid Ashouri
375	Adding project links to PyPI pypi python packaging setup.py web-development	2024-12-28	Online Source
374	Calculating the size of a SQLite database file using SQL sqlite sql database cli bash awk gpt-4	2024-12-28	Farshid Ashouri
373	Attaching a bash shell to a running Docker container docker cli bash containers	2024-12-22	Farshid Ashouri
372	Bulk fetching repository details with the GitHub GraphQL API github graphql api repositories cli	2024-12-22	Online Source
371	Convert a datetime object to UTC without using pytz python datetime utc timezone git	2024-12-22	Farshid Ashouri
370	Querying the GitHub archive with the ClickHouse playground TIL clickhouse	2024-12-22	Online Source
369	Running multiple servers in a single Bash script TIL bash	2024-12-22	Online Source
368	Signing and notarizing an Electron app for distribution using GitHub Actions TIL electron	2024-12-22	Online Source
367	Using build-arg variables with Cloud Run deployments TIL cloudrun	2024-12-22	Online Source
366	Copy rich text to the clipboard javascript clipboard html web-development observable productivity	2024-12-21	Farshid Ashouri
365	Cumulative total over time in SQL sql database data-analysis cumulative-sum github	2024-12-15	Farshid Ashouri
364	Exporting Amplitude events to SQLite amplitude sqlite sqlite-utils data-export data-import cli json	2024-12-15	Farshid Ashouri
363	Exploring OpenAI's deep research API model o4-mini-deep-research openai llm api research ai cli json datasette	2024-12-14	Online Source
362	Google OAuth for a CLI application google oauth cli python api security	2024-12-14	Online Source
361	Treating warnings as errors in pytest TIL pytest	2024-12-14	Farshid Ashouri
360	Using jq in an Observable notebook TIL observable	2024-12-14	Online Source
359	SQLite triggers TIL sqlite	2024-12-08	Online Source
358	Storing and serving related documents with openai-to-sqlite and embeddings TIL llms	2024-12-07	Online Source
357	mlc-chat - RedPajama-INCITE-Chat-3B on macOS TIL llms	2024-12-01	Farshid Ashouri
356	Upgrade Postgres.app on macOS TIL postgresql	2024-12-01	Online Source
355	Using Jest without a package.json TIL javascript	2024-12-01	Farshid Ashouri
354	Looping over comma-separated values in Bash TIL bash	2024-11-23	Online Source
353	Adding Sphinx autodoc to a project, and configuring Read The Docs to build it sphinx autodoc read-the-docs python documentation ci/cd	2024-11-17	Online Source
352	Pisco sour TIL cocktails	2024-11-17	Online Source
351	Search and replace with regular expressions in VS Code TIL vscode	2024-11-16	Online Source
350	GUnion to combine geometries in SpatiaLite spatialite sqlite gis geojson datasette sql geospatial	2024-11-09	Farshid Ashouri
349	How to ask questions communication community etiquette troubleshooting open-source	2024-11-09	Farshid A.
348	Calculating the size of all LFS files in a repo git git-lfs cli bash awk huggingface ai	2024-11-03	Online Source
347	migrations.RunSQL.noop for reversible SQL migrations TIL django	2024-11-03	Farshid Ashouri
346	Running gdb against a Python process in a running Docker container TIL docker	2024-11-03	Online Source
345	Using the tesseract CLI tool TIL tesseract	2024-11-03	Farshid Ashouri
344	Adding a robots.txt using Cloudflare workers cloudflare workers robots.txt seo web-development serverless	2024-11-02	Online Source
343	kubectl proxy TIL kubernetes	2024-11-02	Farshid Ashouri
342	Combining substr and instr to extract text sqlite sql string-manipulation database	2024-10-27	Farshid Ashouri
341	Removing a git commit and force pushing to remove it from history TIL git	2024-10-26	Online Source
340	Creating a dynamic line chart with SVG svg data-visualization web-development sql python frontend	2024-10-20	Farshid Ashouri
339	Reading thermometer temperatures over time from a video TIL googlecloud	2024-10-20	Online Source
338	Avoiding "length" errors in Apache Bench with the -l option apache-bench ab load-testing performance cli http	2024-10-19	Farshid Ashouri
337	How to deploy a folder with a Dockerfile to Cloud Run cloud-run docker deployment datasette google-cloud cli	2024-10-13	Online Source
336	Testing cookiecutter templates with pytest TIL cookiecutter	2024-10-13	Online Source
335	Collecting replies to tweets using JavaScript twitter javascript scraping dom llm ai cli	2024-10-12	Online Source
334	Importing CSV data into SQLite with .import TIL sqlite	2024-10-12	Farshid Ashouri
333	Increasing the time limit for a Google Cloud Scheduler task TIL cloudrun	2024-10-12	Farshid Ashouri
332	Using C_INCLUDE_PATH to install Python packages TIL python	2024-10-12	Online Source
331	Using psutil to investigate "Too many open files" TIL python	2024-10-12	Online Source
330	Lag window function in SQLite TIL sqlite	2024-10-06	Online Source
329	One-liner for running queries against CSV files with SQLite TIL sqlite	2024-10-06	Farshid Ashouri
328	Running Docker on an M1 Mac TIL macos	2024-10-06	Online Source
327	Tracing every executed Python statement TIL python	2024-10-06	Farshid Ashouri
326	Using nginx to proxy to a Unix domain socket TIL nginx	2024-10-06	Online Source
325	Writing JavaScript that responds to media queries TIL javascript	2024-10-06	Online Source
324	get-graphql-schema graphql cli schema api npm introspection	2024-10-05	Farshid Ashouri
323	Mocking Stripe signature checks in a pytest fixture TIL pytest	2024-10-05	Farshid Ashouri
322	Using git-filter-repo to set commit dates to author dates TIL git	2024-10-05	Farshid Ashouri
321	Using the sqlite3 Python module in Pyodide - Python WebAssembly TIL python	2024-10-05	Farshid Ashouri
320	Intercepting fetch in a service worker TIL service-workers	2024-09-29	Farshid Ashouri
319	Dynamically loading multiple assets with a callback javascript web-development asynchronous promises frontend	2024-09-28	Online Source
318	Installing tools written in Go TIL go	2024-09-28	Farshid Ashouri
317	Rewriting a repo to contain the history of just specific files TIL git	2024-09-28	Online Source
316	Upgrading a pipx application to an alpha version TIL python	2024-09-28	Farshid Ashouri
315	Using SQL with GDAL TIL gis	2024-09-28	Farshid Ashouri
314	Constant-time comparison of strings in Node node.js security javascript cryptography web-development	2024-09-22	Farshid Ashouri
313	Running pytest against a specific Python version with uv run TIL pytest	2024-09-22	Online Source
312	Streaming indented output of a JSON array TIL python	2024-09-22	Online Source
311	Exploring ColBERT with RAGatouille llm colbert ragatouille embeddings ai nlp python semantic-search	2024-09-21	Online Source
310	Reusing an existing Click tool with register_commands TIL datasette	2024-09-21	Online Source
309	Running a gpt-oss eval suite against LM Studio on a Mac TIL llms	2024-09-21	Online Source
308	Compressing an animated GIF with gifsicle or ImageMagick mogrify gif compression image-processing cli gifsicle imagemagick	2024-09-15	Online Source
307	Learn Something New Every Day self-improvement learning personal-development productivity time-management life-hacks	2024-09-15	Farshid Ashouri
306	Saving an in-memory SQLite database to a file in Python TIL sqlite	2024-09-15	Farshid Ashouri
305	Handling CSV files with wide columns in Python python csv file-io error-handling data-processing	2024-09-14	Online Source
304	Using awk to add a prefix TIL bash	2024-09-14	Online Source
303	hexdump and hexdump -C hexdump cli bash debugging binary encoding	2024-09-08	Online Source
302	HTML video that loads when the user clicks play html video web-development performance ux	2024-09-08	Farshid Ashouri
301	How to read Hacker News threads with most recent comments first hacker-news api json datasette sqlite cli web-scraping	2024-09-07	Farshid Ashouri
300	Attaching a generated file to a GitHub release using Actions github-actions github releases ci/cd javascript api	2024-09-01	Online Source
299	Skipping CSV rows with odd numbers of quotes using ripgrep TIL bash	2024-08-31	Farshid Ashouri
298	Start, test, then stop a localhost web server in a Bash script TIL bash	2024-08-31	Online Source
297	Comparing database rows before and after with SQLite JSON functions sqlite sql json database data-analysis	2024-08-25	Online Source
296	Loading radio.garden into SQLite using jq TIL jq	2024-08-25	Farshid Ashouri
295	Get Skitch working on Catalina macos skitch screenshots productivity troubleshooting	2024-08-24	Online Source
294	Getting Python MD5 to work with FIPS systems python fips md5 security compatibility docker testing	2024-08-24	Online Source
293	Switching between gcloud accounts TIL cloudrun	2024-08-18	Farshid Ashouri
292	Writing Fly logs to S3 TIL fly	2024-08-18	Online Source
291	Fixes for datetime UTC warnings in Python python datetime utc deprecation compatibility	2024-08-17	Online Source
290	__init_subclass__ TIL python	2024-08-17	Online Source
289	Social media cards generated with shot-scraper TIL shot-scraper	2024-08-17	Online Source
288	The simplest recursive CTE TIL sqlite	2024-08-17	Farshid Ashouri
287	Calculating embeddings with gtr-t5-large in Python python embeddings llm ai nlp datasette faiss sentence-transformers	2024-08-11	Online Source
286	Back-dating Git commits based on file modification dates git cli python automation history github ai	2024-08-04	Online Source
285	GitHub Actions, Issues and Pages to build a daily planner github github-actions github-pages issues javascript automation productivity	2024-08-04	Online Source
284	Making HTTP calls using IPv6 TIL networking	2024-08-04	Farshid Ashouri
283	Updating stable docs in ReadTheDocs without pushing a release TIL readthedocs	2024-08-04	Online Source
282	Working around the size limit for nodeValue in the DOM TIL javascript	2024-08-04	Online Source
281	KNN queries with SpatiaLite TIL spatialite	2024-08-03	Online Source
280	Pointing a custom subdomain at Read the Docs TIL readthedocs	2024-08-03	Farshid Ashouri
279	The location of the pip cache directory TIL python	2024-08-03	Farshid Ashouri
278	Upgrading Homebrew and avoiding the failed to verify attestation error TIL homebrew	2024-08-03	Farshid Ashouri
277	Using recursive CTEs to explore hierarchical Twitter threads TIL sql	2024-07-28	Online Source
276	A script to capture frames from a QuickTime video quicktime video ffmpeg zsh applescript screenshots cli ai	2024-07-21	Online Source
275	pytest coverage with context TIL pytest	2024-07-21	Online Source
274	Transferring a GitHub issue from a private to a public repository TIL github	2024-07-21	Online Source
273	Grabbing a transcript of a short snippet of a YouTube video with MacWhisper macos youtube transcription whisper audio productivity	2024-07-20	Online Source
272	SQLite VACUUM: database or disk is full TIL sqlite	2024-07-20	Farshid Ashouri
271	Browsing your local git checkout of homebrew-core homebrew git cli macos	2024-07-14	Farshid Ashouri
270	Running jupyterlab via uv tool install TIL jupyter	2024-07-14	Farshid Ashouri
269	Installing different PostgreSQL server versions in GitHub Actions TIL github-actions	2024-07-13	Online Source
268	Publishing a Web Component to npm TIL npm	2024-07-13	Online Source
267	A simple Python wrapper for the ChatGPT API python openai chatgpt api wrapper ai openai	2024-07-06	Farshid Ashouri
266	Implementing a "copy to clipboard" button TIL javascript	2024-07-06	Online Source
265	Quickly testing code in a different Python version using pyenv TIL python	2024-07-06	Online Source
264	Limited JSON API for Google searches using Programmable Search Engine TIL google	2024-06-30	Online Source
263	Start a server in a subprocess during a pytest session TIL pytest	2024-06-29	Online Source
262	Using async/await in JavaScript in Selenium TIL selenium	2024-06-29	Farshid Ashouri
261	Using OpenAI functions and their Python library for data extraction TIL gpt3	2024-06-29	Online Source
260	Using Prettier to check JavaScript code style in GitHub Actions TIL github-actions	2024-06-23	Online Source
259	Installing packages from Debian unstable in a Docker image based on stable TIL docker	2024-06-22	Online Source
258	Redirecting all paths on a Vercel instance TIL zeit-now	2024-06-22	Online Source
257	Testing different Python versions with uv with-editable and uv-test TIL python	2024-06-16	Online Source
256	Migrating a GitHub wiki from one repository to another TIL github	2024-06-15	Farshid Ashouri
255	Processing a stream of chunks of JSON with ijson TIL json	2024-06-09	Online Source
254	Upgrading packages with npm TIL npm	2024-06-09	Online Source
253	Registering the same Pluggy hook multiple times in a single file TIL pluggy	2024-06-08	Farshid Ashouri
252	Running cog automatically against GitHub pull requests TIL github-actions	2024-06-08	Online Source
251	Safely outputting JSON TIL python	2024-06-08	Farshid Ashouri
250	Livestreaming a community election event on YouTube TIL youtube	2024-06-02	Online Source
249	Registering temporary pluggy plugins inside tests TIL pytest	2024-06-01	Online Source
248	Summarizing Hacker News discussion themes with Claude and LLM TIL llms	2024-06-01	Online Source
247	Trick Apple Photos into letting you access your video files TIL macos	2024-05-25	Farshid Ashouri
246	Dropdown menu with details summary html css javascript web-development ui accessibility	2024-05-19	Online Source
245	Useful Markdown extensions in Python TIL markdown	2024-05-19	Farshid Ashouri
244	Enabling WAL mode for SQLite database files sqlite database wal performance cli bash	2024-05-18	Farshid Ashouri
243	Error 153 Video player configuration error on YouTube embeds youtube embed html web-development troubleshooting	2024-05-18	Farshid Ashouri
242	Named Entity Resolution with dslim/distilbert-NER TIL llms	2024-05-18	Farshid Ashouri
241	Conditionally running a second job in a GitHub Actions workflow github-actions ci/cd automation workflow yaml git	2024-05-12	Online Source
240	Setting cache-control: max-age=31536000 with a Cloudflare Transform Rule TIL cloudflare	2024-05-12	Online Source
239	The pdb interact command TIL python	2024-05-12	Farshid Ashouri
238	Using ChatGPT to write AppleScript TIL gpt3	2024-05-12	Farshid Ashouri
237	Custom Jinja template tags with attributes jinja python templating web-development markdown datasette	2024-05-11	Online Source
236	Restricting SSH connections to devices within a Tailscale network TIL tailscale	2024-05-11	Online Source
235	Using grep to write tests in CI TIL github-actions	2024-05-11	Farshid Ashouri
234	Adding a CORS policy to an S3 bucket aws s3 cors cloud web-development cli	2024-05-05	Online Source
233	Sort by number of JSON intersections TIL sqlite	2024-05-05	Online Source
232	Running pip install -e .[test] in zsh on macOS Catalina TIL macos	2024-05-04	Farshid Ashouri
231	Seeing files opened by a process using opensnoop TIL macos	2024-05-04	Online Source
230	Using Tesseract.js to OCR every image on a page TIL javascript	2024-05-04	Farshid Ashouri
229	RAFT Consensus Explained raft consensus distributed-systems	2024-05-03	Farshid A.
228	Calculating the AQI based on the Purple Air API for a sensor purpleair api aqi javascript web-development air-quality	2024-04-28	Online Source
227	Mocking subprocess with pytest-subprocess TIL pytest	2024-04-28	Farshid Ashouri
226	Using the undocumented Fly GraphQL API TIL fly	2024-04-28	Farshid Ashouri
225	sips: Scriptable image processing system TIL macos	2024-04-20	Farshid Ashouri
224	Controlling the style of dumped YAML using PyYAML python yaml pyyaml serialization data-formats	2024-04-14	Farshid Ashouri
223	Piping echo to a file owned by root using sudo and tee TIL linux	2024-04-14	Farshid Ashouri
222	Publish releases to PyPI from GitHub Actions without a password or token TIL pypi	2024-04-14	Online Source
221	SQLite aggregate filter clauses TIL sqlite	2024-04-14	Farshid Ashouri
220	Turning an array of arrays into objects with jq TIL jq	2024-04-14	Farshid Ashouri
219	Assistance with release notes using GitHub Issues github release-notes git cli llm ai	2024-04-13	Online Source
218	JSON Pointer TIL json	2024-04-13	Online Source
217	Listen to a web page in Mobile Safari TIL ios	2024-04-13	Online Source
216	Running different steps on a schedule TIL github-actions	2024-04-13	Online Source
215	Summing columns in remote Parquet files using DuckDB TIL duckdb	2024-04-13	Online Source
214	TOML in Python TIL python	2024-04-13	Farshid Ashouri
213	Running pip install '.[docs]' on ReadTheDocs TIL readthedocs	2024-04-07	Farshid Ashouri
212	Show files opened by pytest tests TIL pytest	2024-04-07	Online Source
211	Guessing Amazon image URLs using GitHub Copilot github-copilot ai amazon image-urls productivity tips	2024-04-06	Farshid Ashouri
210	Simplest possible OAuth authentication with Auth0 TIL auth0	2024-04-06	Online Source
209	Set a GIF to loop using ImageMagick TIL imagemagick	2024-03-30	Online Source
208	Close terminal window on Ctrl+D for macOS macos terminal productivity tips	2024-03-24	Online Source
207	Generating a calendar week grid with the Python Calendar module python calendar datetime standard-library productivity	2024-03-24	Farshid Ashouri
206	Getting Mastodon running on a custom domain mastodon fediverse custom-domain dns web-hosting social-media	2024-03-24	Online Source
205	Piping from rg to llm to answer questions about code TIL llms	2024-03-24	Online Source
204	Creating desktop backgrounds using Midjourney midjourney ai generative-art image-generation desktop macos	2024-03-17	Online Source
203	Escaping strings in Bash using !:q bash cli shell escaping tips	2024-03-10	Farshid Ashouri
202	SQLite can use more than one index for a query TIL sqlite	2024-03-10	Farshid Ashouri
201	How to scp files to and from Fly fly.io scp ssh cli networking wireguard	2024-03-09	Farshid Ashouri
200	Loading lit from Skypack TIL javascript	2024-03-09	Online Source
199	Using iconv to convert the text encoding of a file TIL linux	2024-03-09	Online Source
198	SQLite timestamps with floating point seconds TIL sqlite	2024-03-03	Farshid Ashouri
197	Emulating a big-endian s390x with QEMU qemu docker s390x big-endian emulation python github-actions testing	2024-03-02	Online Source
196	Promoting the stable version of the documentation using rel=canonical TIL readthedocs	2024-03-02	Online Source
195	Querying for GitHub issues open for less than 60 seconds TIL datasette	2024-03-02	Online Source
194	Using S3 triggers to maintain a list of files in DynamoDB TIL aws	2024-03-02	Online Source
193	The most basic possible Hugo site TIL hugo	2024-02-25	Online Source
192	Listing files uploaded to Cloud Build TIL cloudrun	2024-02-24	Farshid Ashouri
191	Show the SQL schema for a PostgreSQL database TIL postgresql	2024-02-24	Farshid Ashouri
190	Using the ChatGPT streaming API from Python TIL gpt3	2024-02-24	Farshid Ashouri
189	Converting HTML and rich-text to Markdown markdown html conversion javascript tools github	2024-02-18	Online Source
188	JavaScript date objects TIL javascript	2024-02-17	Online Source
187	Python packages with pyproject.toml and nothing else TIL python	2024-02-17	Online Source
186	Tailing Google Cloud Run request logs and importing them into SQLite TIL cloudrun	2024-02-17	Online Source
185	Trying out Python packages with ipython and uvx TIL python	2024-02-17	Online Source
184	os.remove() on Windows fails if the file is already open TIL python	2024-02-11	Online Source
183	Verifying your GitHub profile on Mastodon TIL mastodon	2024-02-11	Online Source
182	Deploying a redbean app to Fly redbean fly.io docker deployment web-hosting containers	2024-02-10	Online Source
181	Querying for items stored in UTC that were created on a Thursday in PST TIL sqlite	2024-02-04	Farshid Ashouri
180	Running Dolly 2.0 on Paperspace TIL llms	2024-02-04	Farshid Ashouri
179	How to get Cloudflare to cache HTML cloudflare caching web-performance web-development cdn	2024-02-03	Online Source
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
158	Providing a "subscribe in Google Calendar" link for an ics feed TIL ics	2023-12-23	Farshid Ashouri
157	Compile a new sqlite3 binary on Ubuntu sqlite ubuntu linux compilation cli database	2023-12-17	Farshid Ashouri
156	The Wikipedia page stats API TIL wikipedia	2023-12-17	Farshid Ashouri
155	Read the Docs Search API TIL readthedocs	2023-12-10	Farshid Ashouri
154	Reporting bugs in GitHub to GitHub TIL github	2023-12-10	Farshid Ashouri
153	Splitting on commas in SQLite TIL sqlite	2023-12-10	Farshid Ashouri
152	Athena error: The specified key does not exist aws athena s3 debugging logs cli	2023-12-03	Online Source
151	Using curl to run GraphQL queries from the command line TIL graphql	2023-12-03	Online Source
150	Atuin for zsh shell history in SQLite zsh shell history sqlite atuin cli macos	2023-11-26	Online Source
149	Installing Python on macOS with the official Python installer TIL macos	2023-11-26	Farshid Ashouri
148	Testing the Access-Control-Max-Age CORS header TIL http	2023-11-26	Online Source
147	Writing an Azure Function that serves all traffic to a subdomain TIL azure	2023-11-26	Online Source
146	Cloudflare redirect rules with dynamic expressions cloudflare redirects dns web-development networking	2023-11-25	Online Source
145	Commit a file if it changed git github-actions automation ci/cd bash	2023-11-25	Online Source
144	Only run GitHub Action on push to master / main TIL github-actions	2023-11-25	Online Source
143	Quick and dirty mock testing with mock_calls TIL pytest	2023-11-19	Online Source
142	Running Ethernet over existing coaxial cable TIL networking	2023-11-19	Online Source
141	Using Playwright MCP with Claude Code TIL claude-code	2023-11-19	Farshid Ashouri
140	Scroll page to form if there are errors TIL javascript	2023-11-18	Online Source
139	Styling an HTML dialog modal to take the full height of the viewport TIL css	2023-11-18	Online Source
138	Writing pytest tests against tools written with argparse TIL pytest	2023-11-18	Online Source
137	Bulk editing status in GitHub Projects github project-management ui tips	2023-11-12	Online Source
136	Freezing requirements with pip-tools python pip dependency-management pip-tools virtualenv	2023-11-12	Farshid Ashouri
135	HTML datalist html web-development forms autocomplete javascript	2023-11-11	Online Source
134	Running PyPy on macOS using Homebrew TIL python	2023-11-05	Farshid Ashouri
133	Scraping the Sky News Westminster Accounts, a Flourish application TIL shot-scraper	2023-11-05	Online Source
132	Understanding the CSS auto-resizing textarea trick TIL css	2023-11-05	Online Source
131	Annotated code for a demo of WebSocket chat in Deno Deploy deno websocket chat deno-deploy typescript javascript web-development serverless	2023-10-28	Farshid Ashouri
130	Track timestamped changes to a SQLite table using triggers TIL sqlite	2023-10-28	Farshid Ashouri
129	Compile and run a new SQLite version with the existing sqlite3 Python library on macOS sqlite python macos compilation environment-variables cli datasette	2023-10-22	Online Source
128	GitHub OAuth for a static site using Cloudflare Workers github oauth cloudflare workers javascript web-development security ai	2023-10-15	Online Source
127	Rewriting a Git repo to remove secrets from the history TIL git	2023-10-15	Online Source
126	Search across all loaded resources in Firefox TIL firefox	2023-10-14	Online Source
125	Using Fabric with an SSH public key TIL python	2023-10-14	Online Source
124	Compiling the SQLite spellfix.c module on macOS sqlite compilation macos datasette extensions cli	2023-10-01	Farshid Ashouri
123	Enabling a gin index for faster LIKE queries django postgresql database performance indexing migrations	2023-10-01	Farshid Ashouri
122	Scroll to text fragments TIL html	2023-10-01	Online Source
121	Planning parallel downloads with TopologicalSorter TIL python	2023-09-30	Online Source
120	Finding uses of an API with the new GitHub Code Search github code-search api programming cli datasette	2023-09-24	Online Source
119	literalinclude with markers for showing code in documentation TIL sphinx	2023-09-24	Online Source
118	Understanding Kristofer Joseph's Single File Web Component TIL web-components	2023-09-24	Farshid Ashouri
117	Searching for repositories by topic using the GitHub GraphQL API TIL github	2023-09-23	Farshid Ashouri
116	Annotated explanation of David Beazley's dataklasses python dataclasses code-generation performance metaprogramming	2023-09-17	Farshid Ashouri
115	Basic strace to see what a process is doing linux debugging cli strace system-calls	2023-09-17	Farshid Ashouri
114	List all columns in a SQLite database TIL sqlite	2023-09-17	Farshid Ashouri
113	Null case comparisons in SQLite TIL sqlite	2023-09-17	Online Source
112	Storing files in an S3 bucket between GitHub Actions runs TIL github-actions	2023-09-17	Online Source
111	Copy tables between SQLite databases sqlite database cli bash data-transfer	2023-09-16	Online Source
110	Check spelling using codespell spelling codespell python ci/cd documentation github-actions	2023-09-10	Online Source
109	Free API Gateway to expose localhost (ngrok alternative) api-gateway ngrok raspberry-pi cli networking tools retunnel	2023-09-10	Farshid A.
108	GPT-4 for API design research gpt-4 ai api-design web-frameworks programming research	2023-09-10	Online Source
107	Downloading partial YouTube videos with ffmpeg youtube video downloading ffmpeg yt-dlp cli bash	2023-09-09	Farshid Ashouri
106	Local wildcard DNS on macOS with dnsmasq TIL macos	2023-09-09	Online Source
105	Using json_extract_path in PostgreSQL TIL postgresql	2023-09-09	Farshid Ashouri
104	Upgrading Python Homebrew packages using pip TIL homebrew	2023-09-03	Farshid Ashouri
103	Using the GitHub Actions cache with npx and no package.json TIL github-actions	2023-09-03	Online Source
102	CLI tools hidden in the Python standard library python cli standard-library tools bash ripgrep	2023-08-26	Online Source
101	Cybersecurity Diary: Reflections on Recent Retail Breaches cybersecurity ransomware data-breach retail security NCSC	2023-08-26	Farshid Ashouri
100	Returning related rows in a single SQL query using JSON TIL sqlite	2023-08-20	Online Source
99	Mouse support in vim TIL vim	2023-08-19	Online Source
98	Counting SQLite virtual machine operations sqlite database performance cli python debugging	2023-08-13	Farshid Ashouri
97	Histogram with tooltips in Observable Plot observable-plot javascript data-visualization d3 frontend	2023-08-13	Online Source
96	Pixel editing a favicon with Pixelmator TIL pixelmator	2023-08-13	Online Source
95	Google Chrome --headless mode chrome headless cli web-automation screenshots pdf	2023-08-12	Online Source
94	Logging OpenAI API requests and responses using HTTPX TIL httpx	2023-08-12	Online Source
93	Testing Electron apps with Playwright and GitHub Actions TIL electron	2023-08-06	Online Source
92	Building and deploying a custom site using GitHub Actions and GitHub Pages github-actions github-pages ci/cd web-development automation yaml	2023-08-05	Online Source
91	shot-scraper for a subset of table columns TIL shot-scraper	2023-08-05	Online Source
90	Fixing broken text encodings with sqlite-transform and ftfy sqlite encoding data-cleaning python cli ftfy	2023-07-29	Online Source
89	Opt-in integration tests with pytest --integration TIL pytest	2023-07-29	Online Source
88	Accessing 1Password items from the terminal 1password cli security macos bash jq api-keys	2023-07-23	Online Source
87	Using ChatGPT Browse to name a Python package TIL gpt3	2023-07-23	Online Source
86	Rendering Markdown with the GitHub Markdown API TIL markdown	2023-07-22	Online Source
85	A simple pattern for inlining binary content in a Python script python binary scripting pprint shell cli	2023-07-16	Online Source
84	Redirecting a domain using Cloudflare Pages TIL cloudflare	2023-07-16	Online Source
83	Concatenating strings and newlines in Google Sheets google-sheets formulas yaml string-manipulation productivity	2023-07-15	Online Source
82	Trying out cr-sqlite on macOS TIL sqlite	2023-07-15	Farshid Ashouri
81	Setting up a custom subdomain for a GitHub Pages site TIL github	2023-07-09	Online Source
80	Scraping Reddit via their JSON API TIL reddit	2023-07-08	Online Source
79	Explicit file encodings using click.File python click cli encoding file-io	2023-07-02	Online Source
78	Optimizing PNGs in GitHub Actions using Oxipng TIL github-actions	2023-07-02	Online Source
77	Using LD_PRELOAD to run any version of SQLite with Python TIL sqlite	2023-07-01	Online Source
76	Extracting objects recursively with jq jq json data-transformation cli recursion	2023-06-25	Farshid Ashouri
75	Converting Airtable JSON for use with sqlite-utils using jq airtable json jq sqlite-utils cli data-transformation	2023-06-24	Farshid Ashouri
74	Passing command arguments using heredoc syntax TIL zsh	2023-06-18	Farshid Ashouri
73	Deno KV deno deno-kv sqlite database key-value-store cloud serverless javascript typescript	2023-06-17	Farshid Ashouri
72	Loading SQLite extensions in Python on macOS TIL sqlite	2023-06-17	Farshid Ashouri
71	Using packages from JSR with esbuild TIL javascript	2023-06-17	Online Source
70	Interpreting photo orientation and locations in EXIF data TIL exif	2023-06-11	Online Source
69	Accessing repository dependencies in the GitHub GraphQL API github graphql api dependencies graphiql cli	2023-06-04	Online Source
68	Building Mastodon bots with GitHub Actions and toot mastodon bots github-actions cli shot-scraper automation ci/cd python	2023-06-04	Online Source
67	Consecutive groups in SQL using window functions sql window-functions database data-analysis sqlite	2023-05-28	Online Source
66	Finding the largest SQLite files on a Mac macos sqlite cli filesystem productivity	2023-05-28	Farshid Ashouri
65	Relinquishing control in Python asyncio TIL python	2023-05-28	Farshid Ashouri
64	Generating documentation from tests using files-to-prompt and LLM llm ai documentation code-generation python cli testing	2023-05-20	Online Source
63	Generating URLs to a Gmail compose window gmail url email productivity web-development tips	2023-05-20	Online Source
62	Shrinking PNG files with pngquant and oxipng TIL macos	2023-05-20	Farshid Ashouri
61	Downloading every video for a TikTok account tiktok video downloading yt-dlp javascript web-scraping bash python cli	2023-05-13	Online Source
60	Using the Chrome DevTools console as a REPL for an Electron app TIL electron	2023-05-07	Farshid Ashouri
59	Using pysqlite3 on macOS TIL sqlite	2023-05-06	Farshid Ashouri
58	Ignoring a line in both flake8 and mypy TIL python	2023-04-30	Online Source
57	Annotated package.json for idb-keyval npm package.json javascript web-development packaging indexeddb	2023-04-29	Farshid Ashouri
56	How to call pip programatically from Python python pip cli programming testing	2023-04-23	Online Source
55	Using pipenv and Docker TIL docker	2023-04-23	Farshid Ashouri
54	Driving an external display from a Mac laptop macos display productivity settings tips	2023-04-22	Farshid Ashouri
53	Helper function for pagination using AWS boto3 aws boto3 python pagination api utility	2023-04-22	Online Source
52	Programatically accessing Heroku PostgreSQL from GitHub Actions TIL heroku	2023-04-22	Online Source
51	Testing HTML tables with Playwright Python TIL playwright	2023-04-22	Online Source
50	GitHub Actions job summaries github-actions ci/cd automation markdown git	2023-04-16	Online Source
49	Use setup.py to install platform-specific dependencies TIL python	2023-04-16	Farshid Ashouri
48	Cryptography in Pyodide python pyodide webassembly cryptography packaging wasm	2023-04-15	Online Source
47	Expanding ChatGPT Code Interpreter with Python packages, Deno and Lua chatgpt code-interpreter python deno lua php docker cli ai	2023-04-15	Online Source
46	How to create a tarball of a git repository using "git archive" git cli archive bash version-control	2023-04-15	Online Source
45	Running nanoGPT on a MacBook M2 to generate terrible Shakespeare TIL llms	2023-04-09	Online Source
44	Running tests against PostgreSQL in a service container TIL github-actions	2023-04-09	Online Source
43	Tommy's Margarita TIL cocktails	2023-04-09	Online Source
42	How I studied for my Ham radio general exam ham-radio study exam education datasette json	2023-04-08	Online Source
41	Creating GitHub repository labels with an Actions workflow github github-actions automation labels ci/cd api	2023-04-02	Online Source
40	Enabling a user to execute a specific command as root without a password linux sudo security cli ubuntu systemd	2023-04-02	Farshid Ashouri
39	nullglob in bash TIL bash	2023-04-02	Online Source
38	Language-specific indentation settings in VS Code TIL vscode	2023-04-01	Farshid Ashouri
37	Writing tests with Copilot TIL gpt3	2023-04-01	Online Source
36	Code coverage using pytest and codecov.io pytest code-coverage python ci/cd testing github-actions	2023-03-26	Online Source
35	Running prompts against images, PDFs, audio and video with Google Gemini TIL llms	2023-03-19	Online Source
34	Linking from /latest/ to /stable/ on Read The Docs TIL readthedocs	2023-03-18	Online Source
33	Running a MySQL server using Homebrew TIL homebrew	2023-03-18	Farshid Ashouri
32	Deploying the CLIP embedding model on Fly fly.io datasette clip embeddings ai docker deployment python pytorch	2023-03-11	Online Source
31	Using expect() to wait for a selector to match multiple items TIL playwright	2023-03-05	Online Source
30	Running Python code in a subprocess with a time limit TIL python	2023-02-26	Online Source
29	Allowing a container in Docker Desktop for Mac to talk to a PostgreSQL server on the host machine docker postgresql macos networking database	2023-02-25	Farshid Ashouri
28	Find local variables in the traceback for an exception python debugging exceptions traceback programming	2023-02-25	Online Source
27	git bisect git debugging cli automation python	2023-02-25	Online Source
26	Tracking SQLite table history using a JSON audit log TIL sqlite	2023-02-25	Online Source
25	Very basic tsc usage TIL typescript	2023-02-25	Online Source
24	Defining setup.py dependencies using a URL python packaging setup.py dependencies pip github	2023-02-19	Online Source
23	Decorators with optional arguments python decorators programming design-patterns	2023-02-18	Online Source
22	Ordered group_concat() in SQLite TIL sqlite	2023-02-18	Farshid Ashouri
21	Dump out all GitHub Actions context github-actions debugging ci/cd yaml automation	2023-02-12	Online Source
20	Building a specific version of SQLite with pysqlite on macOS/Linux sqlite python macos linux compilation pysqlite3 packaging	2023-02-11	Farshid Ashouri
19	Querying newline-delimited JSON logs using AWS Athena TIL aws	2023-02-05	Online Source
18	Set environment variables for all steps in a GitHub Action TIL github-actions	2023-02-05	Online Source
17	Using uv to develop Python command-line applications TIL python	2023-02-05	Online Source
16	A tip for debugging pytest-httpx pytest httpx debugging python testing	2023-02-04	Farshid Ashouri
15	Using pytest and Playwright to test a JavaScript web application TIL pytest	2023-02-04	Online Source
14	A simple Python implementation of the ReAct pattern for LLMs python llm react-pattern openai api wikipedia ai	2023-01-28	Online Source
13	Comparing two training datasets using sqlite-utils llm ai data-analysis sqlite sqlite-utils json cli huggingface	2023-01-28	Online Source
12	Preventing double form submissions with JavaScript TIL javascript	2023-01-28	Farshid Ashouri
11	Writing tests for the ASGI lifespan protocol with HTTPX TIL asgi	2023-01-28	Online Source
10	Configuring auto-update for an Electron app electron auto-update github-releases packaging desktop-app javascript	2023-01-22	Online Source
9	Running LLaMA 7B and 13B on a 64GB M2 MacBook Pro with llama.cpp TIL llms	2023-01-22	Farshid Ashouri
8	Converting no-decimal-point latitudes and longitudes using jq jq json data-transformation cli geospatial	2023-01-21	Online Source
7	Reviewing your history of public GitHub repositories using ClickHouse TIL clickhouse	2023-01-21	Online Source
6	Browse files (including SQLite databases) on your iPhone with ifuse iphone macos sqlite cli debugging homebrew filesystem	2023-01-15	Farshid Ashouri
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