Farshid/Ashouri

Notes on software engineering

Archive / page 28

541–546 of 546 posts, newest first.

  1. 2023

  2. Browse files (including SQLite databases) on your iPhone with ifuse

    I spotted an intriguing note in the release notes for osxphotos 0.51.7: Added ability to read Photos.sqlite from iPhone This lead me to osxphotos issue 745 which lead me to How to access iPhone files…

    iphone macos sqlite cli debugging
    1 min read

  3. Updating a Markdown table of contents with a GitHub Action

    markdown-toc is a Node script that parses a Markdown file and generates a table of contents for it, based on the headings.

    TIL github-actions
    1 min read

  4. Running OpenAI's large context models using llm

    OpenAI announced new models today. Of particular interest to me is the new model, which provides GPT 3.5 with a 16,000 token context window (up from 4,000) priced at 1/10th of GPT-4 - $0.003 per 1K…

    TIL llms
    2 min read

  5. Unix timestamp in milliseconds in SQLite

    I wanted to retrieve the time in milliseconds since the Unix epoch in SQLite. Fetching seconds since the epoch is easy: Prior to SQLite 3.42.0 (released in May 2023) milliseconds were much more…

    TIL sqlite
    2 min read

  6. Use labels on Cloud Run services for a billing breakdown

    Thanks to @glasnt for the tip on this one. If you want a per-service breakdown of pricing on your Google Cloud Run services within a project (each service is a different deployed application) the…

    TIL cloudrun
    1 min read

  7. Talking to a PostgreSQL service container from inside a Docker container

    I have a Django application which uses PostgreSQL. I build the Django application into its own Docker container, push that built container to the GitHub package registery and then deploy that…

    TIL github-actions
    1 min read