[aerogear-dev] [iOS] SQLite store implementation

[Lucas Holmquist]

This sounds similar to what i'm doing for indexedBD and WebSQL.  

I basically made the WebSQL one work like a Key/Value store( IndexedDB ).  I have 2 columns, one is the ID field,  the other just stores the JSON data,   This is actually similar to how pouchDB does it.



On Sep 16, 2013, at 5:34 AM, Corinne Krych <corinnekrych at gmail.com> wrote:

> 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
> _______________________________________________
> aerogear-dev mailing list
> aerogear-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/aerogear-dev