maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

Support for local SQLite datasources

That looks great...

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

Support for local SQLite datasources

Thanks!

Ravi Wayne
Posts: 0
Joined: Sat Jul 20, 2013 7:20 pm

Support for local SQLite datasources

Rutger,

Is the word document you have put together still available for sharing? The link indicates the download is no longer available.

Thank you,

Ravi

Toblerone
Posts: 0
Joined: Wed Aug 07, 2013 5:08 pm

Support for local SQLite datasources

That tutorial still requires us to create an appery database, is there a tutorial at all on a purely local db for apps which may not have connectivity when run?

Rutger van Dijk5994263
Posts: 0
Joined: Thu Jun 27, 2013 5:29 pm

Support for local SQLite datasources

Hi Toby,
The tutorial describes more than you need. But the part about storing and retrieving data from local db are there.
But you need to use the code for instance to store data from some form in your app. I think you have all needed to make a full app.

Toblerone
Posts: 0
Joined: Wed Aug 07, 2013 5:08 pm

Support for local SQLite datasources

Hi Rutger,

Thank you for your reply, i'm just wondering how do you get your actual local .db file into your project without first using the remote db to map to a local variable? I see no way to add anything but image files to a project?

Thank you

Rutger van Dijk5994263
Posts: 0
Joined: Thu Jun 27, 2013 5:29 pm

Support for local SQLite datasources

Hi Toby,

Everything should be done from javascript. There is no out-of-the-box solution at the moment in apperyio.
So you need to create db in JS. Create table in JS. Add items in JS. Retrieve data in JS,.....

Code examples are in tutorial.

Toblerone
Posts: 0
Joined: Wed Aug 07, 2013 5:08 pm

Support for local SQLite datasources

That's what I feared, so either way i'd need a connection to populate the database :( I was hoping I could just attach a .db file instead.

Thanks for your help

Return to “Issues”