Geopoly in SQLite
I noticed this morning that one of my Datasette installations had the Geopoly SQLite extension enabled.
datasette
16 posts tagged “datasette”.
- 2025
-
4 min read
-
axe-core and shot-scraper for accessibility audits
I just watched a talk by Pamela Fox at North Bay Python on Automated accessibility audits. The video should be up within 24 hours.
1 min read -
How to run MediaWiki with SQLite on a macOS laptop
Today I got curious about how MediaWiki records page history, so I started digging around and in the process figured out how to run it against a SQLite database on my macOS laptop!
2 min read - 2024
-
Exploring OpenAI's deep research API model o4-mini-deep-research
I was reviewing some older PRs and landed this one by Manuel Solorzano adding pricing for o4-mini-deep-research and o3-deep-research to my llm-prices.com site.
1 min read -
GUnion to combine geometries in SpatiaLite
I was playing around with datanews/amtrak-geojson, which provides GeoJSON for Amtrak stations and track segments.
1 min read -
How to deploy a folder with a Dockerfile to Cloud Run
I deployed https://metmusem.datasettes.com/ by creating a folder on my computer containing a Dockerfile and then shipping that folder up to Google Cloud Run.
1 min read -
Reusing an existing Click tool with register_commands
The register commands plugin hook lets you add extra sub-commands to the CLI tool. I have a lot of existing tools that I'd like to also make available as plugins.
1 min read -
How to read Hacker News threads with most recent comments first
Hacker News displays comments in a tree. This can be frustrating if you want to keep track of a particular conversation, as you constantly have to seek through the tree to find the latest comment.
3 min read -
Calculating embeddings with gtr-t5-large in Python
I've long wanted to run some kind of large language model on my own computer. Now that I have a M2 MacBook Pro I'm even more keen to find interesting ways to keep all of those CPU cores busy.
4 min read -
Custom Jinja template tags with attributes
I decided to implement a custom Jinja template block tag for my datasette-render-markdown plugin. I wanted the tag to work like this: A basic Jinja extension After some fiddling around with GitHub…
2 min read -
Querying for GitHub issues open for less than 60 seconds
While writing this thread about my habit of opening issues and closing them a few seconds later just so I could link to them in a commit message I decided to answer the question "How many of my issues…
1 min read - 2023
-
Compile and run a new SQLite version with the existing sqlite3 Python library on macOS
I've been trying to figure this out for years. Previous notes include Using LD PRELOAD to run any version of SQLite with Python (Linux only), and Building a specific version of SQLite with pysqlite on…
1 min read -
Compiling the SQLite spellfix.c module on macOS
I wanted to browse a backup copy of my Plex database, which is a SQLite file. I tried this: The module is an optional module for SQLite.
1 min read -
Finding uses of an API with the new GitHub Code Search
The GitHub Code Search beta is really powerful - it allows advanced search - including regular expression matches - against every public repo on GitHub.
1 min read -
How I studied for my Ham radio general exam
I scraped a pass on my Ham radio general exam today, on the second attempt (you can retake on the same day for an extra $15, thankfully).
4 min read -
Deploying the CLIP embedding model on Fly
I ended up deploying a Datasette instance to Fly.io using my llm-clip and datasette-llm-embed plugins.
2 min read