Page 1 of 1
Recommended way to save data on harddrive?
Posted: Mon Nov 18, 2013 11:20 pm
by trenatos
I'm working on an app that will need to save data in records to a file, and I'm trying to figure out the best way to approach it.
I think the best idea would be to use SQLite since the app will have many records that the user should be able to flip between, but since I haven't done anything like this before I wanted to ask for input from you guys.
Re: Recommended way to save data on harddrive?
Posted: Mon Nov 18, 2013 11:27 pm
by Simon
Hi trenatos,
Here is the lesson:
http://lessons.runrev.com/s/lessons/m/4 ... e-database
Pretty cool that if the db does not exists liveCode will just make it for you. Makes it very easy to implement.
Simon
Re: Recommended way to save data on harddrive?
Posted: Mon Nov 18, 2013 11:39 pm
by trenatos
Hi Simon,
Yep seen that one, the only thing missing from it is showing how to move between record-sets, but otherwise that's an excellent tutorial.
I was thinking more along the lines of "Maybe SQLite is overkill" but I'm thinking it's perfect.
Re: Recommended way to save data on harddrive?
Posted: Tue Nov 19, 2013 12:47 am
by Simon
Hi trenatos,
I'm a big believer in keeping things simple and using a text file is just about as simple as it gets.
I just did a test with loading a text file of 1000 contacts and it takes no time.
i mean
Code: Select all
put the millisecs into t
put url("file:100Contact.txt) into temp
put the millisecs - t into tResult
tResults is 0. Once in a var you can do anything.
Simon