Re:JSON and Virtual Columns in SQLite
by conradev on Monday May 16, 2022 @02:12PM
(#31401262)
You can choose whether to store the values or to compute them every time in SQLite
But in terms of the overall performance budget, for a mobile app, I don't think the choice matters much. JSON in SQLite is fast and even in the case of "storing every generated column with a lot of user data", I imagine the app binary is going to be larger than the database it produces.
But in terms of the overall performance budget, for a mobile app, I don't think the choice matters much. JSON in SQLite is fast and even in the case of "storing every generated column with a lot of user data", I imagine the app binary is going to be larger than the database it produces.