What part of varchar is a “critical optimisation” exactly? If it’s ensuring that the data is never larger than X, then you can use a CHECK constraint. It has n

What part of varchar is a “critical optimisation” exactly? If it’s ensuring that the data is never larger than X, then you can use a CHECK constraint. It has no impact on storage in sqlite, or in postgres for that matter.