charlesleifer.com

If you listen real close you can hear the type whispers in there.

A todo list full of secrets.

The one great principle of the English law is, to make business for itself.

Who is he that hideth counsel without knowledge?

A year ago, as I was going through a mound of keepsakes my Mom transferred to my custody (I have reached that age, yes), I came across a little book I made in kindergarten describing my first bicycle crash, which I attributed to rolling over a pine-cone.

And they said, Go to, let us build us a city and a tower, whose top may reach unto heaven; and let us make us a name, lest we be scattered abroad upon the face of the whole earth.

Back in the spring of 2019, I began working on cysqlite, a from-scratch DB-API compatible SQLite driver.

A man's at odds to know his mind cause his mind is aught he has to know it with.

I feel that it is high time that Peewee had an assyncio story.

Edit 2026-01: peewee now supports asyncio, and a bit more detail here.

I'd like to share a simple trick I use to reduce roundtrips pulling data from a cache server (like Redis or Kyoto Tycoon.

I'm pleased to announce that Peewee now supports CockroachDB (CRDB), the distributed, horizontally-scalable SQL database.

With the release of Python 3.8 coming soon, the core development team has asked me to summarize our latest discussions on the new features planned for Python 4.0, codename "ouroboros: the snake will eat itself".

I recently wrote about Kyoto Tycoon (KT), a fast key/value database server.

I saw an excellent article recently describing how to implement the fire effect seen in the trailer for the N64/PlayStation ports of the DooM game.

I've been interested in using Kyoto Tycoon for some time.

In this post I'll present a short code snippet demonstrating how to use Redis streams to implement a multi-process task queue with Python.

Redis 5.0 contains, among lots of fixes and improvements, a new data-type and set of commands for working with persistent, append-only streams.

In this post I'll provide instructions for building a standalone Python sqlite3-compatible module which is powered by BerkeleyDB.

I began an unlikely adventure into Python packaging this week when I made what I thought were some innocuous modifications to the source distribution and setup.py script for the peewee database library.

The upcoming SQLite 3.25.0 release adds support for one of my favorite SQL language features: window functions.

I recently open-sourced a Python library for working with the networked key/value databases Kyoto Tycoon and Tokyo Tyrant.

On Monday of this week I merged in the 3.0a branch of peewee, a lightweight Python ORM, marking the official 3.0.0 release of the project.

The Python standard library sqlite3 driver comes with a barely-documented hook for implementing basic authorization for SQLite databases.

The other day the idea occurred to me that it would be neat to write a simple Redis-like database server.

Several months ago I was delighted to see significant progress on a relatively new extension in the SQLite source tree.

Task queues are frequently deployed alongside websites to do background processing outside the normal request/response cycle.

In this post I'd like to share with you some techniques for effectively working with SQLite using Python.