Farshid/Ashouri

Notes on software engineering

Archive / page 3

41–60 of 550 posts, newest first.

  1. 2025

  2. Clone, edit and push files that live in a Gist

    GitHub Gists are full Git repositories, and can be cloned and pushed to. You can clone them anonymously (read-only) just using their URL: git clone…

    github gist git cli
    1 min read

  3. Installing lxml for Python on an M1/M2 Mac

    I ran into this error while trying to run on an M2 Mac, inside a virtual environment I had intitially created using : I eventually realized that this was using the system Python - - which doesn't have…

    TIL python
    1 min read

  4. Recursively fetching metadata for all files in a Google Drive folder

    For google-drive-to-sqlite I wanted a mechanism to recursively return metadata on every file in a specified Goole Drive folder.

    TIL googlecloud
    2 min read

  5. Open a debugging shell in GitHub Actions with tmate

    :warning: 17 Feb 2022: There have been reports of running tmate causing account suspensions . See this issue for details. Continue with caution.

    TIL github-actions
    1 min read

  6. Geopoly in SQLite

    I noticed this morning that one of my Datasette installations had the Geopoly SQLite extension enabled.

    sqlite geopoly gis geojson database
    4 min read

  7. Running a Python ASGI app on Vercel

    Vercel really wants you to deploy static assets with serverless functions tucked away in a separate folder.

    TIL zeit-now
    1 min read

  8. Exporting and editing a Twitter Spaces recording

    I hosted a Twitter Spaces conversation the other day. The recording is only available for 30 days afterwards, and I wanted to publish it elsewhere.

    twitter audio video downloading ffmpeg
    1 min read

  9. SQLite BLOB literals

    I wanted to construct a string of SQL that would return a blob value: This was while writing a unit test for - for issue 19. I used it in the test here.

    TIL sqlite
    1 min read

  10. Understanding option names in Click

    I hit a bug today where I had defined a Click option called but in doing so I replaced the Python bulit-in function: This inspired me to finally figure out how Click function argument names work.

    TIL python
    1 min read

  11. Programmatically comparing Python version strings

    I found myself wanting to compare the version numbers , and the in Python code, in order to mark a test as skipped if the installed version of Datasette was pre-1.0.

    TIL python
    1 min read

  12. Publishing to a public Google Cloud bucket with gsutil

    I decided to publish static CSV files to accompany my https://cdc-vaccination-history.datasette.io/ project, using a Google Cloud bucket (see cdc-vaccination-history issue 9).

    TIL googlecloud
    1 min read

  13. Checking if something is callable or async callable in Python

    I wanted a mechanism to check if a given Python object was "callable" - could be called like a function - or "async callable" - could be called using .

    python asyncio introspection callable testing
    1 min read

  14. Password hashing in Python with pbkdf2

    I was researching password hashing for datasette-auth-passwords. I wanted very secure defaults that would work using the Python standard library without any extra dependencies.

    TIL python
    1 min read

  15. Subqueries in select expressions in SQLite - also window functions

    I figured out a single SQL query for the following today. Given a table of GitHub repositories, for each repository return: 1. The repository name 2.

    TIL sqlite
    5 min read

  16. A shell script for running Go one-liners

    bitfield/script is a really neat Go project: it tries to emulate shell scripting using Go chaining primitives, so you can run code like this: To achieve the same thing as: A comment from on Hacker…

    go bash shell scripting cli
    2 min read

  17. Using lsof on macOS

    stands for "list open files". Here are some very basic usage notes for the version that ships with macOS.

    TIL macos
    1 min read

  18. Configuring GitHub Codespaces using devcontainers

    GitHub Codespaces provides full development environments in your browser, and is free to use with anyone with a GitHub account.

    github codespaces devcontainers python vscode
    3 min read

  19. Logging users out of Auth0

    If you implement Auth0 for login, you may be tempted to skip implementing logout. I started out just with a page that cleared my own site's cookies, ignoring the Auth0 side of it.

    TIL auth0
    1 min read

  20. Serving a custom vector web map using PMTiles and maplibre-gl

    Protomaps is "an open source map of the world, deployable as a single static file on cloud storage". It involves some very clever technology, rooted in the PMTiles file format which lets you create a…

    TIL gis
    5 min read

  21. Using fs_usage to see what files a process is using

    Today I wanted to figure out where the CLI tool on my Mac kept its authentication tokens. I solved the problem using the macOS command, which traces filesystem activity for everything or for a…

    TIL macos
    2 min read