2 ms·
Sure - that's what I did with my PG&E outages project (https://simonwillison.net/2019/Oct/10/pge-outages/ https://simonwillison.net/2019/Oct/10/pge-outages/). I
by simonw 6y ago
Sure - that's what I did with my PG&E outages project (https://simonwillison.net/2019/Oct/10/pge-outages/ https://simonwillison.net/2019/Oct/10/pge-outages/). I wrote a Python script that iterated through the git commits and used them to create a SQLite database so I could run queries.
Essentially I was using the commit log as the point of truth for the data, and building a database as an ephemeral asset derived from that data.
- baby 6y agoso full cycle, back to a database :)
- simonw 6y agoWhat's different here is what you treat as the point of truth. If the point of truth is the git repository and its history, then the SQLite database that you build from it is essentially a fancy caching layer - just like if you were to populate a memcached or redis instance or build an Elasticsearch index.