mia (developer mode) (@mia)

@navi @SRAZKVT idk as soon as you need specialized indexing postgres will be much better than sqlite in my experience

like, if you have something with tag collections then postgres is already a better fit because it has array types that you can use a GIN index on, and that saves you 1) lots of disk space 2) the hassle of maintaining a separate table to manage tag associations 3) performance overhead of using said table

so if anything i’d say such software should offer a way to manage its own cluster directory and perform version upgrades on its own