Can I add extra columns to sqlt_core?

I’m trying to find ways to improve performance of my app and one of the bottlenecks is searching the sqlt_core table to find the right row to update. I’m wondering if I can add a foreign_key column without messing up the works.

I have a few other things to try first.

You can certainly add a foreign key without messing up the application. You can alter the table however as long as you don’t change column names or data types. Adding columns, indexes, foreign key, etc is ok.

1 Like