7 ms·
Yep! The schema storage is kinda wild. They store the DDL for the creation of the objects as the raw SQL which is quite a bit different than how something like
by benbjohnson 4y ago
Yep! The schema storage is kinda wild. They store the DDL for the creation of the objects as the raw SQL which is quite a bit different than how something like Postgres has a bunch of tables in the pg_catalog to specify the database structure.
- ngrilly 4y agoYes, and that’s what makes ALTER TABLE a bit difficult to implement in SQLite, but that’s also simplifying the implementation: https://sqlite.org/lang_altertable.html https://sqlite.org/lang_altertable.html I agree this is quite unexpected for anyone used to PostgreSQL :)