Farshid's Weblog

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