sqlite writable_schema pragma

Created: Oct 16, 2022 by Pradeep Gowda Updated: Oct 16, 2022 Tagged: sqlite

While attempting to backup twitter data to sqlite using twitter-to-sqlite, I ran into this error:

sqlite3.OperationalError: table sqlite_master may not be modified

After googling the error message, I found out, I had to set pragma writable_schema = 1

$ sqlite3 twitter.db
SQLite version 3.32.3 2020-06-18 14:16:19
Enter ".help" for usage hints.
sqlite> pragma writable_schema;
0
sqlite> pragma writable_schema = 1;
sqlite> pragma writable_schema;
1
sqlite> ^D