54 open source projects by simonw

CLI tool for exporting tables or queries from any SQL database to a SQLite file

Ultra simple API for geocoding a single string against various web services.

A modern library for integrating OpenID with Django - incomplete, but really nearly there (promise)

A memcached backed rate limiting decorator for Django.

Experimental .transform(fn) method for Django QuerySets, for clever lazily evaluated optimisations.

Syntactic sugar for creating Python command line scripts by introspecting a function definition

Turtles all the way down

Python CLI tool and library for diffing CSV and JSON files

A geographical community site for Django developers.

Request per second / SQLop per second monitoring for Django, using Redis for storage

Script for saving a JSON archive of your tweets.

Integration of jCrop with the Django admin

CSS selector support for BeautifulSoup.

A way of rendering django.forms widgets that differentiates between HTML and XHTML.

Tracking PG&E outages

Datasette plugin for visualizing data using Vega

Scrapers for disaster data - writes to https://github.com/simonw/disaster-data

Python utilities for filtering nasty characters in unicode strings.

Crowdsourcing a directory of cryptids and their range maps.

Tool for running transformations on columns in a SQLite database

Convert CSV files into a SQLite database

An open source multi-tool for exploring and publishing data

Python CLI utility and library for manipulating SQLite databases

https://simonwillison.net/2020/Jul/10/self-updating-profile-readme/

Today I Learned

Utilities functions for node.js that borrow some useful concepts from Django

Tool for generating demo SQLite databases

Signing utilities for Django, to try out an API which is being proposed for inclusion in Django core.

Deploys a Datasette instance of COVID-19 data from Johns Hopkins CSSE and the New York Times

Notes from my presentation on Python packaging at PyGotham 2021

A drop-dead simple image resizing proxy for Google App Engine

Experimental HTTP proxy (using node.js) for avoiding the dog pile effect.

Web interface for searching your code using ripgrep, built as a Datasette plugin

Tracking the history of trees in San Francisco

Experimental replacement for Django's get_absolute_url() method.

Tools for analyzing Git history using SQLite

Datasette plugin that renders binary blob images using data-uris

CLI tool for converting DBF files (dBase, FoxPro etc) to SQLite

Django app for building dashboards using raw SQL queries

The source code behind my blog

A simple comet broadcast server, originally implemented as a demo for Full Frontal 2009.

Data scraped by https://github.com/simonw/disaster-scrapers

The official project website for Datasette

Opinionated cookiecutter template for creating a new Python library

ASGI middleware for protecting against CSRF attacks

CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)

Datasette plugin that shows a map for any data with latitude/longitude columns

A tool for creating credentials for accessing S3 buckets

CSRF protection for Django forms.

A simple Node.js server for queueing and relaying webhook requests