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...
Progressing onto a SQL Lite DB
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: Progressing onto a SQL Lite DB
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
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
I used to be a newbie but then I learned how to spell teh correctly and now I'm a noob!
Re: Progressing onto a SQL Lite DB
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
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