3 ms·
I've been experimenting recently with YAML for this kind of thing, and it's working out really well for me so far. I have a tool called yaml-to-sqlite ( https:
by simonw 7y ago
I've been experimenting recently with YAML for this kind of thing, and it's working out really well for me so far.
I have a tool called yaml-to-sqlite ( https://github.com/simonw/yaml-to-sqlite https://github.com/simonw/yaml-to-sqlite ) which converts a YAML file into a SQLite database, which I can then use with Datasette ( https://github.com/simonw/datasette https://github.com/simonw/datasette )
My biggest project with it so far has been my site https://www.niche-museums.com/ https://www.niche-museums.com/ - a guide to small and niche museums. The museums themselves live in a single ~100KB YAML file in GitHub: https://github.com/simonw/museums/blob/master/museums.yaml https://github.com/simonw/museums/blob/master/museums.yaml
I have a CI script which builds that YAML file into a SQLite database and deploys it + Datasette + custom templates to https://www.niche-museums.com/ https://www.niche-museums.com/
I've been running the site like this for a few months now and I really like it. I love having my content in source control, I find editing the YAML to be reasonably pleasant (I even edit it on my iPhone sometimes using the Working Copy app) and any YAML errors are caught by CI before they are deployed.