LiveCode Forums.

Hello,

i am just looking for some advice on a app that i want to build.

i need to pull data from a file that contains

Name, email, phone number

the data then populates a field
the user can then select the records that he wants and can move them to another field ( filter)
then the user can save that field

any advice is welcome, my real question is

i have started it and i can populate the field with a txt file, but should i be using a database such as SQL?

Hi,

You should be using MySQL if you think that a text file is or will be too slow, too big, or otherwise impratical. If your app only needs a way to store data locally then a text file may be sufficient. A text file would be Impractical if e.g. you want to share the same data with many LiveCode-based client apps, if you want to share the data with other software and if you want to use the data in a website.

Kind regards,

Mark

mark,

thanks thats really helpful, i am hoping to build a ios based app that will capture the data, send it back to the database then make lists from it.. and send the data back out....

i think its going to be tough but if i plan it well enough then i think i can do it.

Mark-- would it be simpler if he used liveCode's built in database, SQLite?
That is if he doesn't need to share the db with other users.

Hi,

SQLite isn't simple, but it would be an option.

Kind regards,

Mark