Items tagged weeknotes in 2019

Filters: Year: 2019 × weeknotes × Sorted by date

16 results

sqlite-utils 2.0: real upserts

I just released version 2.0 of my sqlite-utils library/CLI tool to PyPI.

6:48 am / 30th December 2019 / museums, projects, sql, sqlite, upsert, weeknotes, sqliteutils

Weeknotes: Datasette 0.33

I released Datasette 0.33 yesterday. The release represents an accumulation of small changes and features since Datasette 0.32 back in November. Duplicating the release notes:

[... 678 words]

9:38 pm / 23rd December 2019 / datasette, weeknotes

Logging to SQLite using ASGI middleware

I had some fun playing around with ASGI middleware and logging during our flight back to England for the holidays.

[... 2535 words]

10:30 pm / 16th December 2019 / django, logging, projects, sqlite, datasette, asgi, weeknotes, sqliteutils

Better presentations through storytelling and STAR moments

Last week I completed GSBGEN 315: Strategic Communication at the Stanford Graduate School of Business.

[... 643 words]

12 am / 10th December 2019 / speaking, datasette, jsk, weeknotes

datasette-atom: Define an Atom feed using a custom SQL query

I’ve been having a ton of fun iterating on www.niche-museums.com. I put together some notes on how the site works last week, and I’ve been taking advantage of the Thanksgiving break to continue exploring ways in which Datasette can be used to quickly build database-backed static websites.

[... 1084 words]

12:20 am / 3rd December 2019 / atom, projects, syndication, datasette, weeknotes

niche-museums.com, powered by Datasette

I just released a major upgrade to my www.niche-museums.com website (launched last month).

[... 1154 words]

10:27 pm / 25th November 2019 / museums, projects, yaml, datasette, weeknotes, bakeddata

Weeknotes: datasette-template-sql

Last week I talked about wanting to take ona a larger Datasette project, and listed some candidates. I ended up pushing a big project that I hadn’t listed there: the upgrade of Datasette to Python 3.8, which meant dropping support for Python 3.5 (thanks to incompatible dependencies).

[... 521 words]

10:29 pm / 18th November 2019 / projects, sql, datasette, weeknotes

Weeknotes: Python 3.7 on Glitch, datasette-render-markdown

Streaks is really working well for me. I’m at 12 days of commits to Datasette, 16 posting a daily Niche Museum, 19 of actually reviewing my email inbox and 14 of guitar practice. I rewarded myself for that last one by purchasing an actual classical (as opposed to acoustic) guitar.

[... 1141 words]

11:26 pm / 11th November 2019 / glitch, museums, markdown, datasette, weeknotes, sqliteutils

Weeknotes: More releases, more museums

Lots of small releases this week.

[... 538 words]

8:35 pm / 4th November 2019 / museums, projects, weeknotes

Weeknotes: Niche Museums, Kepler, Trees and Streaks

Every now and then someone will ask “so when are you going to build Museums Near Me then?”, based on my obsession with niche museums and websites like www.owlsnearme.com.

[... 872 words]

10:42 pm / 28th October 2019 / museums, productivity, projects, visualization, weeknotes, bakeddata

Weeknotes: The Squirrel Census, Genome SQL query

This week was mostly about incremental improvements. And squirrels.

[... 911 words]

6:42 pm / 21st October 2019 / genetics, projects, squirrels, weeknotes

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

Weeknotes: Dogsheep

Having figured out my Stanford schedule, this week I started getting back into the habit of writing some code.

[... 1367 words]

7:33 pm / 7th October 2019 / projects, sqlite, dogsheep, weeknotes

Weeknotes: first week of Stanford classes

One of the benefits of the JSK fellowship is that I can take classes and lectures at Stanford, on a somewhat ad-hoc basis (I don’t take exams or earn credits).

[... 544 words]

4:28 pm / 30th September 2019 / music, reading, speaking, stanford, jsk, weeknotes

Weeknotes: Design thinking for journalists, genome-to-sqlite, datasette-atom

I haven’t had much time for code this week: we’ve had a full five day workshop at JSK with Tran Ha (a JSK alumni) learning how to apply Design Thinking to our fellowship projects and generally to challenges facing journalism.

[... 870 words]

8:13 pm / 20th September 2019 / genetics, projects, reading, sqlite, datasette, jsk, weeknotes, designthinking