Simon Willison’s Weblog

Subscribe

Saturday, 25th November 2017

Release csvs-to-sqlite 0.6.1 — Convert CSV files into a SQLite database
Release datasette Datasette 0.13: foreign key, search and filters — An open source multi-tool for exploring and publishing data

What is the plural of blitz? Wow, WordHippo is a straight up masterclass in keyword SEO tactics. Everything from the page URL to the keyword-crammed content to the enormous quantity of related links.

# 5:42 pm / seo

harelba/q (via) q is a neat command-line utility that lets you run SQL queries directly against CSV and TSV files. Internally it works by firing up an in-memory SQLite database, and as of the latest release (1.7.1) you can use the new --save-db-to-disk option to save that in-memory database to disk.

# 5:49 pm / csv, sqlite

New in Datasette: filters, foreign keys and search

I’ve released Datasette 0.13 with a number of exciting new features (Datasette previously).

[... 1,143 words]

Friday, 24th November 2017
Sunday, 26th November 2017