Entries tagged dogsheep in 2020

Filters: Type: entry × Year: 2020 × dogsheep × Sorted by date

11 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

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

Personal Data Warehouses: Reclaiming Your Data

I gave a talk yesterday about personal data warehouses for GitHub’s OCTO Speaker Series, focusing on my Datasette and Dogsheep projects. The video of the talk is now available, and I’m presenting that here along with an annotated summary of the talk, including links to demos and further information.

[... 5166 words]

3:53 am / 14th November 2020 / github, presentations, speaking, talks, datasette, dogsheep, weeknotes, sqliteutils, annotatedtalks

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]