Using Google Fusion and SQLite

[nosaj66au]

Hi All,
I have an application running the uses a local SQLlite DB which is working very well and of course I return record sets into Cursor data types. All my code uses this method to filler sort and display data. Now I wish to uses the cloud (Google Fusion) as an additional data source and some times share/ transfer table content between the cloud and SQL lite. I have the Fusion access and fusion query transfer working correctly, the current returned fision data is put into a list.

Q1) is there a way to populate a cusor with returned fusion data?
Q2) whats the best way to cross populate the data?


all the best

Jason

 

[Erel]

I'm not really familiar with Google Fusion.

JSON is usually a good format to transfer data. You can use DBUtils.ExecuteJSON to convert the results to JSON.

 

[keirS]

1. I would do this by creating a temporary table in SQLite DB using ""CREATE TEMP TABLE" and then populating it with the Fusion data. Then query the data in to a cursor in the normal way. Temporary tables and their associated indexes only persist while the connection that created them is open. When the connection is closed they are removed from the DB.