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 th

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.