Choosing a database and LC tools

[William Prothero]

Tom and Peter:
Also, please note that:
Best practice involves NOT sending a complete query, which I use in the demo. It’s not so bad, since I require a password as a sent parameter, and since it is intended that the query be generated by livecode in a protected script (not in an input field that anybody can access). It’s not a horrible security issue, but easily breakable by someone monitoring wifi or other network traffic or using a keylogger, etc. But, for critical information, you should modify the php code to use placeholders for the sql parameters and use ssh protocols to send the commands. I will implement this at some time soon, but don’t have it now. 

Glad to share when I get it done.

Best,
Bill

> On Aug 11, 2015, at 11:54 AM, William Prothero <prothero at earthednet.org> wrote:
> 
> 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
> 
> _______________________________________________
> 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