4 ms·
SQLite with the open source toolchain I've been building over the past five years: https://datasette.io https://datasette.io as the interface for running queri
by simonw 4y ago
SQLite with the open source toolchain I've been building over the past five years:
https://datasette.io https://datasette.io as the interface for running queries against (and visualizing) my data.
https://sqlite-utils.datasette.io/ https://sqlite-utils.datasette.io/ as a set of tools for creating and modifying my databases (inserting JSON or CSV data, enabling full text search text)
https://dogsheep.github.io https://dogsheep.github.io as a suite of tools for importing my personal data - see also this talk I gave about that project: https://simonwillison.net/2020/Nov/14/personal-data-warehouses/ https://simonwillison.net/2020/Nov/14/personal-data-warehous...
I'm also using GitHub issues and the new GitHub projects for a bunch of personal data - my notes and TODO items specifically - much of which I can then suck into my own SQLite databases using https://datasette.io/tools/github-to-sqlite https://datasette.io/tools/github-to-sqlite
- codazoda 4y agoYup, I’m using mostly SQLite and tools I wrote using it these days, at least for personal data management. I use this simple tool for most my notes now: https://github.com/codazoda/nolific https://github.com/codazoda/nolific For temporary notes I use my Ponder web app (it just uses the browsers DB) and is partially inspired by old AlphaSmart word processing machines: https://github.com/codazoda/ponder https://github.com/codazoda/ponder