Entries tagged datasette, sqlite in 2020

Filters: Type: entry × Year: 2020 × datasette × sqlite × Sorted by date

12 results

Building a search engine for datasette.io

This week I added a search engine to datasette.io, using the search indexing tool I’ve been building for Dogsheep.

6:12 pm / 19th December 2020 / projects, search, sqlite, datasette, dogsheep, weeknotes, bakeddata

Building an Evernote to SQLite exporter

I’ve been using Evernote for over a decade, and I’ve long wanted to export my data from it so I can do interesting things with it.

[... 1879 words]

8:12 pm / 16th October 2020 / projects, sqlite, xml, datasette, dogsheep, sqliteutils

Weeknotes: software carpentry, compiling modules for SQLite

This week I completed the Software Carpentry instructor training course, added two foundational features to sqlite-utils and learned how to compile modules for SQLite.

[... 805 words]

2:30 am / 26th September 2020 / projects, sqlite, teaching, datasette, weeknotes, sqliteutils

Weeknotes: datasette-dump, sqlite-backup, talks

I spent some time this week digging into Python’s sqlite3 internals. I also gave two talks and recorded a third, due to air at PyGotham in October.

[... 928 words]

4:47 am / 11th September 2020 / fulltextsearch, speaking, sqlite, datasette, weeknotes, sqliteutils

Weeknotes: Installing Datasette with Homebrew, more GraphQL, WAL in SQLite

This week I’ve been working on making Datasette easier to install, plus wide-ranging improvements to the Datasette GraphQL plugin.

[... 1009 words]

7:46 pm / 13th August 2020 / homebrew, plugins, projects, sqlite, graphql, datasette, weeknotes, sqliteutils

GraphQL in Datasette with the new datasette-graphql plugin

This week I’ve mostly been building datasette-graphql, a plugin that adds GraphQL query support to Datasette.

[... 1249 words]

4:24 am / 7th August 2020 / apis, plugins, projects, sqlite, graphql, datasette, weeknotes

Fun with binary data and SQLite

This week I’ve been mainly experimenting with binary data storage in SQLite. sqlite-utils can now insert data from binary files, and datasette-media can serve content over HTTP that originated as binary BLOBs in a database file.

[... 949 words]

11:22 pm / 30th July 2020 / paulford, plugins, projects, sqlite, datasette, weeknotes, sqliteutils

Weeknotes: cookiecutter templates, better plugin documentation, sqlite-generate

I spent this week spreading myself between a bunch of smaller projects, and finally getting familiar with cookiecutter. I wrote about my datasette-plugin cookiecutter template earlier in the week; here’s what else I’ve been working on.

[... 703 words]

1:39 am / 26th June 2020 / git, plugins, projects, robotstxt, sqlite, datasette, weeknotes, cookiecutter

Using SQL to find my best photo of a pelican according to Apple Photos

According to the Apple Photos internal SQLite database, this is the most aesthetically pleasing photograph I have ever taken of a pelican:

[... 1937 words]

7:16 pm / 21st May 2020 / photography, photos, projects, sql, sqlite, datasette, dogsheep, weeknotes, applephotos

Weeknotes: Datasette 0.41, photos breakthroughs

Shorter weeknotes this week, because my main project for the week warrants a detailed write-up on its own (coming soon... update 21st May here it is).

[... 867 words]

5:02 am / 7th May 2020 / projects, sqlite, datasette, observable, dogsheep, weeknotes, applephotos