Bookmarks (3) clear filters

Personal Data Warehouses: Reclaiming Your Data — Simon, one of Django’s co-creators, is becoming increasingly well known for his work on SQLite-based data management tools like Datasette. In this talk (coupled with a written summary you can follow without watching the video) he covered the topic of ‘personal data warehouses’ and why you might want to build them for yourself. Fantastic!

Using SQL to Find The Best Photo of a Pelican (According to Apple Photos) — Apple Photos stores photo metadata in an SQLite database – nothing odd about that. But what is odd is that Photos calculates numerous types of ‘aesthetic score’ for your photographs.. meaning you can find out which photos of yours it thinks are best!

datasette-atom: Define An Atom Feed using a Custom SQL Query — Datasette is a nifty tool for exploring and publishing data (it’s basically a front-end for SQLite datasets). This extension brings feed support.