Entries tagged sqlite, datajournalism

Filters: Type: entry × sqlite × datajournalism × Sorted by date

5 results

Measuring traffic during the Half Moon Bay Pumpkin Festival

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

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

git-history: a tool for analyzing scraped data collected using Git and SQLite

I described Git scraping last year: a technique for writing scrapers where you periodically snapshot a source of data to a Git repository in order to record changes to that source over time.

[... 2002 words]

10:32 pm / 7th December 2021 / datajournalism, git, projects, scraping, sqlite, datasette, githistory

Weeknotes: sqlite-transform 1.1, Datasette 0.58.1, datasette-graphql 1.5

Work on Project Pelican inspires new features and improvements across a number of different projects.

[... 1419 words]

9:29 pm / 21st July 2021 / datajournalism, projects, sqlite, graphql, datasette, weeknotes

Tracking PG&E outages by scraping to a git repo

PG&E have cut off power to several million people in northern California, supposedly as a precaution against wildfires.

[... 833 words]

11:32 pm / 10th October 2019 / datajournalism, projects, scraping, sqlite, datasette, gitscraping, digitalocean, sqliteutils

Notes from my appearance on the Changelog podcast

After I spoke at Zeit Day SF last weekend I sat down with Adam Stacoviak to record a 25 minute segment for episode 296 of the Changelog podcast, talking about Datasette. We covered a lot of ground!

[... 536 words]

6:03 pm / 9th May 2018 / datajournalism, podcasts, speaking, sqlite, datasette

Simon Willison’s Weblog