LiveCode Forums.

Hi,

I have been using LC for a touch over a year now and have managed to build some small desktop applications, 2 iOS Apps and a few other small widgets/gadgets thingys. (Had 0 coding experience before LC)

One of my iOS Apps is a Scoring System that is currently using several text files to store the competition data in but I have reached a point now where it would be easier to convert it to a SQL Lite DB,
My DB Skills are very limited (one of my Desktop Apps reads and modifies a MS Access DB that already existed) so I was looking for some advice or tools on where to start.

I am a very "visual" learner so if there is a tool I could use the build the SQL Lite DB I imagine I am going to be able to understand it easier?
Am I best to get a DB Add-on to take care of the SQL Commands? dbLib etc??? (remember this needs to work on iOS)
Is there a good tutorial on learning how to structure the DB? best practices etc.

any advice would be greatly appreciated...

Hi Nikia,
Dave posted this great intro:
http://www.vampire-tiger.info/livecode- ... bases.html

For multiple users mysql is the one you want. errrrr... IOS..you can tell me if it works.
And umm... not very visual.

Simon

Thanks Simon,

as the App will only use single user access methodology (DB Stored with App) I ended up going with SQL Lite.
I found the SQL Lite Project Viewer which allows me to get that "Visual" peek at the DB and in fact I built up all the tables and schema's in it as it was so simple to use.

I am now looking at dbLib to simplify the population/query commands as it seems to be a great library.

Cheers
Kia