Farshid/Ashouri

debugging

11 posts tagged “debugging”.

  1. 2025

  2. Finding the SQLite version used by Web SQL in Chrome

    Google Chrome still includes support for Web SQL, the long since abandoned proposed standard for shipping a SQL engine in browser JavaScript.

    sqlite chrome web-sql javascript browser
    1 min read

  3. Debugging a Click application using pdb

    This tip is for when you are working on a Python command-line application that runs using that program's name, as opposed to typing .

    python debugging cli click pdb
    1 min read
  4. 2024

  5. hexdump and hexdump -C

    While exploring null bytes in this issue I learned that the command on macOS (and presumably other Unix systems) has a confusing default output.

    hexdump cli bash debugging binary
    1 min read
  6. 2023

  7. Athena error: The specified key does not exist

    I was trying to run Athena queries against compressed JSON log files stored in an S3 bucket. No matter what I tried, I got the following error: The specified key does not exist.

    aws athena s3 debugging logs
    1 min read

  8. Basic strace to see what a process is doing

    I had a long-running process and I wanted to check that it was at least doing something . I know its PID (32425 in this case) - here's how to use to see what it's doing right now.

    linux debugging cli strace system-calls
    1 min read

  9. Counting SQLite virtual machine operations

    When SQLite executes a query, it does so by executing a sequence of virtual machine operations. There are mechanisms for cancelling a query after a specific number of these operations, to protect…

    sqlite database performance cli python
    1 min read

  10. Find local variables in the traceback for an exception

    For sqlite-utils issue 309 I had an error that looked like this: And I wanted to display the values of the and variables as part of a custom error message.

    python debugging exceptions traceback programming
    1 min read

  11. git bisect

    I fixed two bugs in Datasette using - a tool which lets you run an automated binary search against a commit log to find the source of a bug.

    git debugging cli automation python
    1 min read

  12. Dump out all GitHub Actions context

    Useful for seeing what's available for conditions (see context and expression syntax). I copied this example action from here and deployed it here. Here's an example run.

    github-actions debugging ci/cd yaml automation
    1 min read

  13. A tip for debugging pytest-httpx

    I use pytest-httpx in a bunch of my projects. Occasionally I run into test failures like this one, which can sometimes be really hard to figure out: Today I figured out a pattern for investigating…

    pytest httpx debugging python testing
    1 min read

  14. 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