Farshid's Weblog

# Title Date Author
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