Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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



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.


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

I agree this is quite unexpected for anyone used to PostgreSQL :)




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: