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 <bod...@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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode