[lomnakkus]

Those optimizations also apply to PostgreSQL.

[Programmatic]

It would still allow you to use a simpler solution and not paint yourself in a corner if you optimized on sqlite; no preemptive optimization necessary wrt choice of dbms if you can perform the work on the simpler solution.

[lomnakkus]

Optimizing in SQLite is just as much of a sunk cost as optimizing in PostgreSQL if you switch away to another database.