[mtzet]

> One nice thing that sqlite being dynamicly typed allows for, is having a key-value table for storing singleton objects, like project config (as opposed to having a well defined table with a single row).

If you need to store singleton objects, wouldn't you just serialize manually to a string representation and store them as TEXT? A fancier solution would be something like the JSON type in Postgres.

I fail to see how sqlite's dynamic types are helping at all in this scenario.

[scns]

No need to serialize first?

(edit) And deserialize again on read.

(edit) Storing project config in Postgres, even though i like it very much, sounds like overkill, excuse the strong words.