3 ms·
> To delete a column, SQLite have to completely overwrite the table - so the operation is not fast. But it’s still nice. Yet another reason why column stores a
by moonchild 6y ago
> To delete a column, SQLite have to completely overwrite the table - so the operation is not fast. But it’s still nice.
Yet another reason why column stores are superior to row stores.
- wayneftw 6y agoThis is not a problem for "row stores" though, it's specific to SQLite. As a matter of fact, any classical RDBMS can effectively store columns off-page and and most of them do just that in the case of large TEXT/JSON/BLOB columns. Column stores like Redshift, Snowflake, etc. are optimized for a much narrower set of use cases. The more widely used databases could do the same optimizations internally but that would make them much less useful.