I thought I'd be clever by making my new site generator work off SQL queries. It has many advantages, but I'm getting annoyed and frustrated with having to fit everythign into simple SQL output (rows of simple columns). πŸ˜–

OK the PostgreSQL support for JSON (i.e. `json_agg(…)` & `json_build_object(…)`) is actually pretty easy to use and cool. Slightly smiling face

@ebel what is the benefit of a database over files for a site?

@dennisguse I'm making something based on data, which I'm storing in Postgresql with the standard osm2pgsql tool.

SQL also allows me ot write queries for my data, to filter and process it

Sign in to participate in the conversation

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!