Recommended way to save data on harddrive?

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

[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

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

[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