Compiling and running sqlite3-rsync
Today I heard about the sqlite3-rsync command, currently available in a branch in the SQLite code repository.
Notes on software engineering
81–100 of 547 posts, newest first.
Today I heard about the sqlite3-rsync command, currently available in a branch in the SQLite code repository.
I deployed an app to Fly and decided to point a custom subdomain to it. My fly app is https://datasette-apache-proxy-demo.fly.dev/ I wanted the URL to be…
TLDR: Use I'm writing a Datasette plugin that handles an uploaded file, borrowing the Starlette mechanism for handling file uploads, documented here.
For s3-ocr issue 21 I needed to write a test that simulates what happens when Amazon Textract returns a "LimitExceededException".
howto-wasm-minimal by Zalka Ernő (my fork here) is a neat demo of a minimal WASM module. It uses C++ to define functions for simple image manipulation including blurring an image, compiles it to WASM…
admin only: false Introduction Hello! I’m Farshid Ashouri, Head of Data Engineering at JPMorgan Chase, with over 20 years of experience designing and operating large-scale distributed systems across…
I decided to see if there was an equivalent of Black or Prettier for YAML files. I found yamlfmt from Google. Update : It turns out Prettier can format YAML too.
I used python-build-standalone for this, which provides a version of Python that is designed for easy of bundling - it's also used by PyOxidize.
I decided to enforce that all code examples in the Datasette documentation be formatted using Black. Here's issue 1718 where I researched the options for doing this. I found the blacken-docs tool.
Figured this out in https://github.com/simonw/simonwillisonblog/issues/132 - I was running PostgreSQL 9.x and I wanted 11.x in order to use the new option in Django 3.1.
llama.cpp recently added the ability to control the output of any model using a grammar. This is an incredibly powerful technique for working with a Large Language Model.
I had to run this site on for 24 hours due to a domain registration mistake I made. Once I got working again I wanted to permanently redirect the URLs on the temporary site to their equivalent on the…
I got fed up of the default macOS prompt: simon@Simons-MacBook-Pro % Mainly because I like copying and pasting terminal examples into GitHub issues.
Every time I opened a terminal on my new Mac running Catalina with zsh I got the following annoying error: Based on a tip in https://github.com/zsh-users/zsh-completions/issues/680 I fixed it by doing…
I recently found out modern browsers include a JavaScript API for creating public/private keys for cryptography.
When building the –sniff option for (which attempts to detect the correct CSV delimiter and quote character by looking at the first 2048 bytes of a CSV file) I had the need to peek ahead in an…
I just watched a talk by Pamela Fox at North Bay Python on Automated accessibility audits. The video should be up within 24 hours.
I wanted to make a small customization to one of my documentation templates on Read the Docs. It turns out you can over-ride the default templates by creating a directory in your documentation folder…
One of the scripts that builds and deploys datasette.io uses a GraphQL query to retrieve information from GitHub about the repositories used for the various Datasette tools and plugins.
The code is in simonw/prompts-js on GitHub. The NPM package is prompts-js. A simple single file client-side package For this project, I wanted to create an old-fashioned JavaScript file that you could…