Choosing a database and LC tools

[William Prothero]

Tom and Peter:
Here is a link to a working stack, that includes the php scripts, so you can see what’s involved. 
https://www.dropbox.com/s/zeldbpafcnno3x5/Db Access.zip?dl=0 <https://www.dropbox.com/s/zeldbpafcnno3x5/Db%20Access.zip?dl=0>
This link won’t last forever, so I’ll plan on keeping it active for a week.
Good luck,
Bill

> On Aug 11, 2015, at 11:24 AM, tbodine <bodine at bodinetraininggames.com> wrote:
> 
> Hi Bill.
> 
> Thanks for those insights. I'm not sure which route I'll take yet, but I 
> would welcome access to your php script collection.
> 
> Thanks,
> Tom Bodine
> 
> 
> On 8/10/2015 8:12 PM, Wprothero [via Runtime Revolution] wrote:
>> Tom:
>> I use Navicat to manage my databases. It will access a variety of online
>> databases, and works with SQLite too. I use it all the time.
>> In my app work, I use livecode with POST commands to php that talks to
>> an online mySQL database. PHP is totally robust and won’t fail on you,
>> and it’s built into most Apache installations. On Mac, there is also a
>> great free tool called MAMP, which allows you to run a complete web
>> server with php on your local machine, for debugging. Again, Navicat is
>> your friend and will save you hours of wondering whether your data
>> actually got into the db or not.
>> 
>> I read that storage of images in a mySQL database isn’t recommended.
>> But, I have stored them in SQLite db’s and it worked fine. Haven’t tried
>> it on mySQL.
>> 
>> I will send you some php scripts, if you are interested. Contact me
>> offline.
>> Best,
>> Bill
> =============================================
> 
> *Bodine Training Games LLC*
> 
> 8417 Hallet St., Lenexa, KS 66215 USA
> 
> www.bodinetraininggames.com / 913-492-7709
> 
> 
> 
> 
> 
> --
> View this message in context: http://runtime-revolution.278305.n4.nabble.com/Choosing-a-database-and-LC-tools-tp4694777p4694819.html
> Sent from the Revolution - User mailing list archive at Nabble.com.
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode