Entries tagged sqlite in 2022

Filters: Type: entry × Year: 2022 × sqlite × Sorted by date

8 results

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.

[... 1184 words]

7:58 pm / 23rd October 2022 / django, djangocon, projects, sqlite, talks, gunicorn, datasette, weeknotes, shotscraper

Measuring traffic during the Half Moon Bay Pumpkin Festival

This weekend was the 50th annual Half Moon Bay Pumpkin Festival.

[... 2693 words]

3:41 pm / 19th October 2022 / datajournalism, projects, sqlite, datasette, gitscraping, githistory, datasettelite, halfmoonbay

Notes on the SQLite DuckDB paper

SQLite: Past, Present, and Future is a newly published paper authored by Kevin P. Gaffney, Martin Prammer and Jignesh M. Patel from the University of Wisconsin-Madison and D. Richard Hipp, Larry Brasfield and Dan Kennedy from the core SQLite engineering team.

[... 1021 words]

5:33 pm / 1st September 2022 / databases, sqlite, duckdb, drichardhipp

Weeknotes: Joining the board of the Python Software Foundation

A few weeks ago I was elected to the board of directors for the Python Software Foundation.

[... 2081 words]

7:02 pm / 30th July 2022 / python, sqlite, datasette, weeknotes, sqliteutils, datasettelite, psf

sqlite-comprehend: run AWS entity extraction against content in a SQLite database

I built a new tool this week: sqlite-comprehend, which passes text from a SQLite database through the AWS Comprehend entity extraction service and stores the returned entities.

[... 1146 words]

9:31 pm / 11th July 2022 / aws, git, github, projects, sqlite, datasette, weeknotes

SQLite Happy Hour—a Twitter Spaces conversation about three interesting projects building on SQLite

Yesterday I hosted SQLite Happy Hour. my first conversation using Twitter Spaces. The idea was to dig into three different projects that were doing interesting things on top of SQLite. I think it worked pretty well, and I’m curious to explore this format more in the future.

[... 1998 words]

10:01 pm / 23rd March 2022 / sqlite, talks, twitter, datasette, litestream, benjohnson, geoffreylitt

Using SQLite and Datasette with Fly Volumes

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

[... 1463 words]

2:17 am / 15th February 2022 / sqlite, datasette, weeknotes, fly

What’s new in sqlite-utils 3.20 and 3.21: --lines, --text, --convert

sqlite-utils is my combined CLI tool and Python library for manipulating SQLite databases. Consider this the annotated release notes for sqlite-utils 3.20 and 3.21, both released in the past week.

[... 2456 words]

6:19 pm / 11th January 2022 / projects, sqlite, weeknotes, sqliteutils, annotatedreleasenotes

Simon Willison’s Weblog