Published

All published posts

2493 posts latest post 2026-05-11
Publishing rhythm
Apr 2026 | 47 posts
main.py [1] python import os import arel from fastapi import FastAPI, Request from fastapi.templating import Jinja2Templates app = FastAPI() templates = Jinja2Templates("templates") if _debug := os.getenv("DEBUG"): hot_reload = arel.HotReload(paths=[arel.Path(".")]) app.add_websocket_route("/hot-reload", route=hot_reload, name="hot-reload") app.add_event_handler("startup", hot_reload.startup) app.add_event_handler("shutdown", hot_reload.shutdown) templates.env.globals["DEBUG"] = _debug templates.env.globals["hot_reload"] = hot_reload @app.get("/") def index(request: Request): return templates.TemplateResponse("index.html", context={"request": request}) # run: # DEBUG=true uvicorn main:app --reload I just discovered arel [2] for hot reloading python applications when content changes from this snippet that implements it for fatapi. On app startup add the /hot-reload routes if in DEBUG mode. import os import arel from fastapi import FastAPI, Request from fastapi.templating import Jinja2Templates app = FastAPI() templates = Jinja2Templates("templates") if _debug := os.getenv("DEBUG"): hot_reload = arel.HotReload(paths=[arel.Path(".")]) app.add_websocket_route("...
External Link X (formerly Twitter) Ā· twitter.com [1] I need to learn regex capture groups better. This is so dang powerful. I really like the \v that bob uses here, it really does cut down on the terseness of all the special characters. I wanted to replace all occurrences of: name,[email protected],0,171,,2023-09-21 With: name,[email protected] Easy to do with Python, but what about a bit of > regex in Vim? :%s/\v([^,]+,[^,]+),.*/\1/ Note This post is a thought [2]. It’s a short note that I make about someone else’s content online #thoughts References: [1]: https://twitter.com/bbelderbos/status/1709525676154368055 [2]: /thoughts/
External Link X (formerly Twitter) Ā· twitter.com [1] HATEOAS gonna hate. More and more htmx [2] seems like the js library for backend devs. So rather than making 55 rest calls here, just make an endpoint that does what you want it to do with one, or a few requests. Note This post is a thought [3]. It’s a short note that I make about someone else’s content online #thoughts References: [1]: https://twitter.com/teej_dv/status/1708258701008593173 [2]: /htmx/ [3]: /thoughts/
Open source, not open contribution with Ben Johnson (Changelog Interviews #433) This week we're talking with Ben Johnson. Ben is known for his work on BoltDB, his work in open source, and as a freelance Go developer. Late January when Ben open sourced his newest project Litest... Changelog Ā· changelog.com [1] Ben Johnson was on the Changelog a few years back covering his work on litestream, and talks about why he chose to go open source, but not open contribution. You should have a good reason to move off of sqlite. Note This post is a thought [2]. It’s a short note that I make about someone else’s content online #thoughts References: [1]: https://changelog.com/podcast/433 [2]: /thoughts/
jpillora/installer is the install script generator I have been looking for. It downloads binaries for your machine from GitHub releases and unzips them for you. It grabs the latest release, so you can easily update them. I have tried scripting these installs in the past and struggled to consistently get the latest version for every package and unpack it correctly. Also these pre-compiled binaries install rediculously fast compared to building them from source. Check out some example links. opening in a browser will show metadata https://i.jpillora.com/serve If you pass in script=true it will instead return the install script as it would by default through curl. https://i.jpillora.com/serve?script=true Use it to install neovim # [1] All you need to do to generate an install script is to pass in the GitHub repo slug with the org. curl https://i.jpillora.com/neovim/neovim | bash The shell script that it generates for neovim looks like this. #!/bin/bash if [ "$DEBUG" == "1" ]; then set -x fi TMP_DIR=$(mktemp -d -t jpillora-installer-XXXXXXXXXX) function cleanup { rm -rf $TMP_DIR > /dev/null } function fail { cleanup msg=$1 echo "============" echo "Error: $msg" 1>&2 ...
I wanted to host some static files through fastapi [1]. Typical use cases for this might be some static web content like html [2]/css/js. It could also be images or some data that doesn’t need dynamically rendered. From the Docs # [3] The docs cover how to host static files, and give this solution that is built into fastapi. https://fastapi.tiangolo.com/tutorial/static-files/ from fastapi import FastAPI from fastapi.staticfiles import StaticFiles app = FastAPI() app.mount("/static", StaticFiles(directory="static"), name="static") Authenticated Static Files # [4] Thanks to #858 [5]. OscartGiles [6] posted this solution to add authentication to static files. I tried this out on my thoughts [7] and it worked flawlessly. import typing from pathlib import Path import secrets from fastapi import FastAPI, Request, HTTPException, status from fastapi.staticfiles import StaticFiles from fastapi.security import HTTPBasic, HTTPBasicCredentials PathLike = typing.Union[str, "os.PathLike[str]"] app = FastAPI() security = HTTPBasic() async def verify_username(request: Request) -> HTTPBasicCredentials: credentials = await security(request) correct_username = secrets.compare_diges...
Point-in-time recovery - Wikipedia en.wikipedia.org [1] I just learned that the term PITR means Point In Time Recovery. I have never seen this term, but it is most often referred to in relation to database recoveries. Note This post is a thought [2]. It’s a short note that I make about someone else’s content online #thoughts References: [1]: https://en.wikipedia.org/wiki/Point-in-time_recovery [2]: /thoughts/
I recently se tup minio object storage in my homelab [1] for litestream sqlite backups. The litestream quickstart made it easy to get everything up and running on localhost, but I hit a wall when dns was involved to pull it from a different machine. Here is what I got to work # [2] First I had to configure the Key ID and Secret Access Key generated in the minio ui. āÆ aws configure AWS Access Key ID [****************VZnD]: AWS Secret Access Key [****************xAm8]: Default region name [us-east-1]: Default output format [None]: Then set the the s3 signature_version to s3v4. aws configure set default.s3.signature_version s3v4 Now when I have minio running on https://my-minio-endpoint.com I can use the aws cli to access the bucket. Note that https://my-minio-endpoint.com resolves to the bucket endpoint (default 9000) not the ui (default 9001). aws --endpoint-url https://my-minio-endpoint.com s3 ls my_bucket Now Configuring Litestream # [3] Litestream also accepts the endpoint argument via config. I could not get it to work just with the ui. Note the aws configure step above is not required for litestream, only the aws cli. dbs: - path: /path/to/database.db replicas: -...
GitHub - benbjohnson/litestream: Streaming replication for SQLite. Streaming replication for SQLite. Contribute to benbjohnson/litestream development by creating an account on GitHub. GitHub Ā· github.com [1] `litestream` is a sick cli tool for steaming replicas of sqlite. It automatically does daily snapshots, and streams all of the writes to the replica live. install # [2] Install is fast using installer, no compilation, just copy the binary and run. curl https://i.wayl.one/benbjohnson/litestream Note This post is a thought [3]. It’s a short note that I make about someone else’s content online #thoughts References: [1]: https://github.com/benbjohnson/litestream [2]: #install [3]: /thoughts/

why-is-postgres-default

Serious question. No one ever got fired for choosing PostgreSQL # [1] But, why. It’s the most loved db, right? Right? Maybe it’s time to rethink it. Don’t get me wrong, if I need a relational db as a service, PostgreSQL is going to be my first choice, but why do I need to run a separate application for it? Tutorials use sqlite # [2] Why is that? Because there is nothing else to stand up. Nothing else to maintain. And you probably already have it installed on just about anything that has a battery. SQLite runs in memory # [3] Don’t need, or maybe don’t want to persist state. Run it in memory. This is a nice feature for running tests. Less exposure # [4] SQLite is a file on your filesystem. It’s not a web service. It’s not a cloud service. Not that postgres is insecure, but it is one more endpoint that you have to think about securing. this means that is probably also cheaper šŸ¤‘ SQLite is easy to replicate # [5] Want to run your new feature with prod data? Pull a replica or...
Why I Built Litestream - Litestream Despite an exponential increase in computing power, our applications require more machines than ever because of architectural decisions made 25 years ago. You can eliminate much of your complexity ... litestream.io [1] As applications scale to the edge, to put compute as close to the user as possible, database queries back to the master node get slower and slower. Enter sqlite replication, put the database wtih the application code and replicate from master. Note This post is a thought [2]. It’s a short note that I make about someone else’s content online #thoughts References: [1]: https://litestream.io/blog/why-i-built-litestream/ [2]: /thoughts/
I'm All-In on Server-Side SQLite Ben Johnson has joined Fly.io Fly Ā· fly.io [1] SQLite is the next big database trend. with more horizontal scaling, close to user read heavy applications, having your database in the same application stack makes a lot of sense. Tools like litestream are going to enable global distribution in an impressive way. Note This post is a thought [2]. It’s a short note that I make about someone else’s content online #thoughts References: [1]: https://fly.io/blog/all-in-on-sqlite-litestream/ [2]: /thoughts/
LiteFS Cloud: Distributed SQLite with Managed Backups Documentation and guides from the team at Fly.io. Fly Ā· fly.io [1] Fly.io’s solution to sqlite managed backups.I definitely want to look into this a bit, but moreso the tech under the hook litestream. Note This post is a thought [2]. It’s a short note that I make about someone else’s content online #thoughts References: [1]: https://fly.io/blog/litefs-cloud/ [2]: /thoughts/
If you’re into interesting projects, don’t miss out on litestream [1], created by benbjohnson [2]. Streaming replication for SQLite. References: [1]: https://github.com/benbjohnson/litestream [2]: https://github.com/benbjohnson
I’m impressed by flameshow [1] from laixintao [2]. A terminal Flamegraph viewer. References: [1]: https://github.com/laixintao/flameshow [2]: https://github.com/laixintao
Looking for inspiration? installer [1] by jpillora [2]. One-liner for installing binaries from Github releases References: [1]: https://github.com/jpillora/installer [2]: https://github.com/jpillora
GitHub - jpillora/installer: One-liner for installing binaries from Github releases One-liner for installing binaries from Github releases - jpillora/installer GitHub Ā· github.com [1] This is a sick looking bash script generator for installing binaries off of github releases. it reccomends curl into bash, but you could curl into install.sh and toss that in your dotfiles repo or wherever. Install installer with installer curl -s https://i.jpillora.com/installer | bash Note This post is a thought [2]. It’s a short note that I make about someone else’s content online #thoughts References: [1]: https://github.com/jpillora/installer [2]: /thoughts/
How to run pods as systemd services with Podman Podman is well known for its seamless integration into modern Linux systems, and supporting systemd is a cornerstone in these efforts. Linux commonly uses th... redhat.com [1] podman comes with a nice command for generating systemd service files (units). $ podman pod create --name=my-pod 635bcc5bb5aa0a45af4c2f5a508ebd6a02b93e69324197a06d02a12873b6d1f7 $ podman create --pod=my-pod --name=container-a -t centos top c04be9c4ac1c93473499571f3c2ad74deb3e0c14f4f00e89c7be3643368daf0e $ podman create --pod=my-pod --name=container-b -t centos top b42314b2deff99f5877e76058ac315b97cfb8dc40ed02f9b1b87f21a0cf2fbff $ cd $HOME/.config/systemd/user $ podman generate systemd --new --files --name my-pod /home/vrothberg/.config/systemd/user/pod-my-pod.service /home/vrothberg/.config/systemd/user/container-container-b.service /home/vrothberg/.config/systemd/user/container-container-a.service Note This post is a thought [2]. It’s a short note that I make about someone else’s content online #thoughts References: [1]: https://www.redhat.com/en/blog/podman-run-pods-systemd-services [2]: /thoughts/
I like MordechaiHadad’s [1] project bob [2]. A version manager for neovim References: [1]: https://github.com/MordechaiHadad [2]: https://github.com/MordechaiHadad/bob