3 ms·
> types are not enforced well in SQL I'm not sure what you mean. Sane RDBMS do enforce types strictly. > language integrations, thus we end up with the quagmi
by jimktrains2 10y ago
> types are not enforced well in SQL
I'm not sure what you mean. Sane RDBMS do enforce types strictly.
> language integrations, thus we end up with the quagmire of static schemas that can not be reliably type checked when you use standard tooling
Languages that don't have static types to begin with maybe.
> tables withh heterogenous schemas that is supported by page/row-level cersioning
Can you give an example of what you mean?
> on line schema alteration.
> Having to rewrite a huge table only because you want to narrow a couple field for future data, it gets old quickly.
Postgres doesn't need to lock the whole table for many types of alterations. It won't rewrite the table for null default fields.