Thread with 4 posts
jump to expanded post
oh my god. SQLite remembers the comment lines of your schema and stores them in the database…
oh my god. the internal representation of the schema in an SQLite database… is the SQL text itself. that's why it contains the CREATE TABLE statement in plaintext… https://www.sqlite.org/lang_altertable.html#why_alter_table_is_such_a_problem_for_sqlite
@hikari if you need to change some properties of a column, you can do it by just UPDATEing the table containing that string; I've shipped code that does this to millions of systems
@rcombs AAAAAAAA