Page 6 of 7

Support for local SQLite datasources

Posted: Thu Jun 27, 2013 6:41 pm
by maxkatz

That looks great...


Support for local SQLite datasources

Posted: Thu Jun 27, 2013 6:44 pm
by Rutger van Dijk5994263

Support for local SQLite datasources

Posted: Thu Jun 27, 2013 7:31 pm
by maxkatz

Thanks!


Support for local SQLite datasources

Posted: Wed Aug 07, 2013 2:54 pm
by Ravi Wayne

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


Support for local SQLite datasources

Posted: Wed Aug 07, 2013 3:32 pm
by Oleg Danchenkov

Hi, Ravi.
Try this tutorial http://docs.appery.io/tutorials/build...


Support for local SQLite datasources

Posted: Fri Aug 16, 2013 1:38 pm
by Toblerone

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?


Support for local SQLite datasources

Posted: Fri Aug 16, 2013 1:44 pm
by Rutger van Dijk5994263

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.


Support for local SQLite datasources

Posted: Fri Aug 16, 2013 1:50 pm
by Toblerone

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


Support for local SQLite datasources

Posted: Fri Aug 16, 2013 1:57 pm
by Rutger van Dijk5994263

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.


Support for local SQLite datasources

Posted: Fri Aug 16, 2013 2:03 pm
by Toblerone

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