[aerogear-dev] [iOS] SQLite store implementation

[Corinne Krych]

Hello Guys,

Working on initial shot of AGIOS-25 [1] (Implementing SQLite Store), I’m wondering how to deal with KeyValue (ie. Schema-less) vs Schema Database (SQLite and same discussion for Core Data [2])?

- how to handle dynamic changes of schema?
My first thought is to it as limitation with SQLite storage.
Or could we have a more flexible approach (with of course a cost), if there is extra columns, update the table schema, if less columns put null values.

- embedded relation?
Just store them as ‘blob’ like values or create another table?

SQLite imlemetation work in progress can be found [3]
And if you think of other topics KV/Schemaless impedance, please bring them on.

++
Corinne

[1] https://issues.jboss.org/browse/AGIOS-25
[2] https://issues.jboss.org/browse/AGIOS-14
[3] https://github.com/corinnekrych/aerogear-ios/tree/AGIOS-25