sqlite

4 min read 2022-10-24 02:58:00

Weeknotes: DjangoCon, SQLite in Django, datasette-gunicorn

I spent most of this week at DjangoCon in San Diego - my first outside-of-the-Bay-Area conference since the before-times. It was a most excellent

9 min read 2022-10-19 22:41:09

This weekend was the 50th annual Half Moon Bay Pumpkin Festival. We live in El Granada, a tiny town 8 minutes drive from Half Moon Bay. There is a

5 min read 2022-02-15 09:17:28

A few weeks ago, Fly announced Free Postgres Databases as part of the free tier of their hosting product. Their announcement included this

9 min read 2022-01-12 01:19:17

sqlite-utils is my combined CLI tool and Python library for manipulating SQLite databases. Consider this the annotated release notes for sqlite-utils

2 min read 2022-01-01 22:40:00

Shotizam Shotizam analyzes the size of Go binaries and outputs SQL with size info for analysis in SQLite3. $ shotizam --sqlite

8 min read 2021-12-08 05:32:55

I described Git scraping last year: a technique for writing scrapers where you periodically snapshot a source of data to a Git repository in order to

1 min read 2021-12-07 22:48:00

zombiezen.com/go/sqlite This package provides a low-level Go interface to SQLite 3. It is a fork of crawshaw.io/sqlite that uses

1 min read 2021-11-26 10:08:00

upper/db upper/db is a productive data access layer (DAL) for Go that provides agnostic tools to work with different data sources, such

1 min read 2021-10-26 16:00:00

spooktrol is another UHC championship box created by IppSec. It’s all about attacking a malware C2 server, which have a long history of

7 min read 2021-08-14 11:57:12

This week I broke my streak of not sending out the Datasette newsletter, figured out how to use Sphinx for Python class documentation, worked out how

7 min read 2021-08-06 13:05:15

Earlier this week I released sqlite-utils 3.14 with a powerful new command-line tool: sqlite-utils convert, which applies a conversion function to

2 min read 2021-07-30 02:32:45

I mentioned Project Pelican (still a codename until the end of the embargo) last week. This week it inspired a new plugin,

7 min read 2021-07-29 03:23:44

I've been exploring an architectural pattern for publishing websites over the past few years that I call the "Baked Data" pattern. It

1 min read 2021-07-25 03:10:00

The other week, I stumbled on the post Inserting One Billion Rows in SQLite Under A Minute, which was a funny coincidence, as I was just in the

16 min read 2021-07-23 01:13:40

This is the transcript and video from a talk I gave at PyGotham 2020 about using SQLite, Datasette and Dogsheep to work with small data. I really