What are the limitation of SQLite you have faced? Is it okay to use SQLite for local storage of data and are there any other options? A few limitations I faced are
Unable to update columns of a table once it has been altered or a new table declared. How do I update that on client's side once the app has been installed since the only way I know to refresh any table change is by re-installing the complete app.
Another problem which is specific to FlutterFlow and SQLite combo is that there is no way to manually refresh SQLite database. API calls and other backend queries can be manually called for an update but not SQLite queries.