News for hackers. Stuff that matters.
Re:JSON and Virtual Columns in SQLite by SPBS on Monday May 16, 2022 @11:56AM (#31399305)
SQLite doesn't support adding generated stored columns to a table once the table has been created, so you basically have to decide upfront which generated columns must be stored, and then you can't touch it anymore (short of dropping it).
Re:JSON and Virtual Columns in SQLite by ComputerGuru on Monday May 16, 2022 @04:26PM (#31402762)
That’s normal DBA for SQLite - you can’t even rename columns without dropping the table. So not such an obstacle.
Re:JSON and Virtual Columns in SQLite by jpcapdevila on Monday May 16, 2022 @04:46PM (#31402946)
You can rename it now, unless I'm missing something

https://www.sqlite.org/lang_altertable.html