Entries tagged projects, dogsheep

Filters: Type: entry × projects × dogsheep × Sorted by date

13 results

Google Drive to SQLite

I released a new tool this week: google-drive-to-sqlite. It’s a CLI utility for fetching metadata about files in your Google Drive and writing them to a local SQLite database.

[... 1221 words]

10:47 pm / 20th February 2022 / googledocs, projects, datasette, dogsheep, weeknotes, sqliteutils

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.

[... 1391 words]

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

Weeknotes: github-to-sqlite workflows, datasette-ripgrep enhancements, Datasette 0.52

This week: Improvements to datasette-ripgrep, github-to-sqlite and datasette-graphql, plus Datasette 0.52 and a flurry of dot-releases.

[... 1123 words]

5:46 am / 6th December 2020 / projects, graphql, datasette, dogsheep, weeknotes, ripgrep

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: airtable-export, generating screenshots in GitHub Actions, Dogsheep!

This week I figured out how to populate Datasette from Airtable, wrote code to generate social media preview card page screenshots using Puppeteer, and made a big breakthrough with my Dogsheep project.

[... 1461 words]

11:28 pm / 3rd September 2020 / projects, yaml, markdown, dogsheep, weeknotes, githubactions, airtable, puppeteer

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

Weeknotes: Datasette 0.40, various projects, Dogsheep photos

A new release of Datasette, two new projects and progress towards a Dogsheep photos solution.

[... 826 words]

11:09 pm / 22nd April 2020 / github, projects, twitter, datasette, jsk, dogsheep, weeknotes, sqliteutils

Weeknotes: Hacking on 23 different projects

I wrote a lot of code this week: 184 commits over 23 repositories! I’ve also started falling for Zeit Now v2, having found workarounds for some of my biggest problems with it.

[... 901 words]

5:03 am / 16th April 2020 / projects, zeitnow, datasette, dogsheep, weeknotes, datasettecloud

Weeknotes: Covid-19, First Python Notebook, more Dogsheep, Tailscale

My covid-19.datasettes.com project publishes information on COVID-19 cases around the world. The project started out using data from Johns Hopkins CSSE, but last week the New York Times started publishing high quality USA county- and state-level daily numbers to their own repository. Here’s the change that added the NY Times data.

[... 993 words]

8:29 pm / 1st April 2020 / bradfitzpatrick, datajournalism, projects, python, teaching, datasette, dogsheep, weeknotes, tailscale, covid19, benwelsh

Weeknotes: Datasette 0.39 and many other projects

This week’s theme: Well, I’m not going anywhere. So a ton of progress to report on various projects.

[... 806 words]

5:33 am / 25th March 2020 / github, projects, sqlite, markdown, jupyter, datasette, dogsheep, weeknotes, fly

Weeknotes: PG&E outages, and Open Source works!

My big focus this week was the PG&E outages project. I’m really pleased with how this turned out: the San Francisco Chronicle used data from it for their excellent PG&E outage interactive (mixing in data on wind conditions) and it earned a bunch of interest on Twitter and some discussion on Hacker News.

[... 452 words]

5 pm / 14th October 2019 / opensource, projects, datasette, dogsheep, weeknotes