I rebuild my timeline thing to use files as the database instead of PostgreSQL.
Having everything as CSV, markdown, GPX etc means that I can use all the excellent software in the world to manipulate data... Or just a text editor. It's a lot easier than writing my own software to manipulate my own database.
It also means that my data will outlive my software without any effort.
And it means that backups are handled by my existing backup software.
I also moved my website to a static site generator earlier. Same reasons. I edit that website for a living, and using Sublime Text instead of a CMS WYSIWYG editor sped up my work dramatically. I can't overstate how much better it made batch edits.
Comments
I rebuild my timeline thing to use files as the database instead of PostgreSQL.
Having everything as CSV, markdown, GPX etc means that I can use all the excellent software in the world to manipulate data... Or just a text editor. It's a lot easier than writing my own software to manipulate my own database.
It also means that my data will outlive my software without any effort.
And it means that backups are handled by my existing backup software.
I also moved my website to a static site generator earlier. Same reasons. I edit that website for a living, and using Sublime Text instead of a CMS WYSIWYG editor sped up my work dramatically. I can't overstate how much better it made batch edits.
https://github.com/nicbou/timeline