Progressing onto a SQL Lite DB

[Nakia]

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

[Simon]

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

[Nakia]

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