Support for local SQLite datasources

[maxkatz]

That looks great...

[Rutger van Dijk5994263]

http://we.tl/JeV5Vc2t7o

[maxkatz]

Thanks!

[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

[Oleg Danchenkov]

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

[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?

[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.

[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

[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.

[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