NKTableView, NKFile, NKNKFileDownloader

[mouts13]

Hello, I have an idea but I do not know if it's possible to store a sqlite database on a server and every time you open the application it would be an update of this database is to download directly the web server. Once the database to download and binds tableview to the given database using itʼs table as datasource. With NKTableView, NKFile and NKNKFileDownloader ????

[Big-O]

I don't see why that wouldn't work, but depending on the size of the dataset you might be better off fetching it with ajax and json and just running an update on the database.

[mouts13]

Thank you for your quick response, but I do not see how you have an example project?

[thedjmixman]

I have some code I can give you but there are a few different things you need to do, so I will list what I did & you can tell me what bits you need.

1. My JSON download is on my main page, so I use a button for the user to trigger it. That way the App doesnt take ages to load and you can offer a progress bar so they can see what is happening.

2. Send an Ajax request to your server for the JSON

3. eval() the JSON. You pretty much treat it as an array after that, even though it's not.

4. Empty any tables from the app's existing DB that you wish to re-populate with the JSON data

5. Work through each table, inserting each row in WHILE loop.

I have a progress bar and a label that updates when each table is completed. Once it is all done, i load up main2.html and then set the tabs & nav controller. That initial page is never viewed again until the app is re-launched.

[mouts13]

Can you send me your code so that I look please.

is my email: mouts_123@hotmail.com

[ian92484]

I've actually been having the same issue of updating when the app is opened. I'd love to have a look at that example code too, if you wouldn't mind? imaegrisomnian@gmail.com. Thanks!

[thedjmixman]

No problem, I'll send it over to you later.

For speeding up the App at launch, I tried a couple of method that were mentioned but they didnt work, so I just put the first part of my sequence in a function that is linked to an onclick event. With that, the 1st page only has to draw a small piece of text, the background image and the button before showing the that page on the screen.

After that, the rest of the app / code displays as it runs. This is my experience in the simulator anyway.

[mouts13]

I send you something because I have received nothing?

No problem, I'll send it over to you later.

For speeding up the App at launch, I tried a couple of method that were mentioned but they didnt work, so I just put the first part of my sequence in a function that is linked to an onclick event. With that, the 1st page only has to draw a small piece of text, the background image and the button before showing the that page on the screen.

After that, the rest of the app / code displays as it runs. This is my experience in the simulator anyway.

[thedjmixman]

I've been busy today, but I will get it over to you in a bit.

[mouts13]

ok thank you I wait