3 ms·

Thanks Ben! I wasn’t sure if SQLite was storing metadata using the same B-Tree and WAL. As usual with SQLite the documentation about this is excellent: https:/

Thanks Ben! I wasn’t sure if SQLite was storing metadata using the same B-Tree and WAL. As usual with SQLite the documentation about this is excellent: https://sqlite.org/schematab.html https://sqlite.org/schematab.html

benbjohnson 5y 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 5y ago
  Yes, 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 :)