Re: Choosing a database and LC tools

If you use mySQL, (and perhaps others) there is an attribute for binary data. You should be able to safely store image data in such a column. Bob S On Aug 10, 2015, at 20:44 , PystCat mailto:pyst...@gmail.com>> wrote: I read that storage of images in a mySQL database isn’t recommended. But, I

Re: Choosing a database and LC tools

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

Re: Choosing a database and LC tools

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 This link won’t last forever, so I’ll plan on keeping it

Re: Choosing a database and LC tools

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 on

Re: Choosing a database and LC tools

Thanks guys for the information on this! Very helpful. Tom Bodine -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Choosing-a-database-and-LC-tools-tp4694777p4694818.html Sent from the Revolution - User mailing list archive at Nabble.com.

Re: Choosing a database and LC tools

Hi Bill, If you wouldn't mind... I would love to see some of those PHP scripts... I've always used MySQL locally but I was thinking of branching out to use it on the web. I have a Founders account but never really use the MySQL from there... I never did like the (lack of) security. Thanks Pau

Re: Choosing a database and LC tools

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

Re: Choosing a database and LC tools

Hi Tom, SQLite should do what you need but a few notes for you. SQLite doesn't have an array datatype. The usual way of handling this type of data in any SQL database is to store each key and value of the array in a separate table that is linked to your main table by an id of some sort that would

Re: Choosing a database and LC tools

> On Aug 10, 2015, at 9:36 AM, tbodine wrote: > > 1) Is SQLite the best choice for local database file with a Livecode > interface? (Each database record will need to hold a few sentences of > Unicode text, 1 or 2 small arrays, the text contents of a few cprops, and a > field for tags the user c