Choosing a database and LC tools

William Prothero prothero at earthednet.org
Mon Aug 10 21:15:07 EDT 2015


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

> On Aug 10, 2015, at 11:01 AM, Peter Haworth <pete at lcsql.com> wrote:
> 
> 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 have the same value in both tables.
> 
> You could also get round it by arrayEncoding them before putting them in
> the database and then arrayDecoding them on the way out.
> 
> It's pretty easy to store images in columns with a data type of BLOB,
> although it requires some slightly different LC coding to SELECT them.
> Also be aware that LC used to encode BLOB data in a proprietary way but
> then removed the encoding in a release which I can't quite remember.  Only
> an issue if you expect to access the database with versions of LC both
> before and after the change.  Plus it's controllable via an sqliteoption
> parameter for revOpenDatabase.
> 
> I will contact you off list re contract work and a couple of other
> suggestions.
> 
> Pete
> 
> 
> On Mon, Aug 10, 2015 at 9:40 AM tbodine <bodine at bodinetraininggames.com>
> wrote:
> 
>> Hi,
>> 
>> I want to add a content library module to a LiveCode-built project. It will
>> enable users to store, tag, sort and retrieve their content. I've read
>> various threads and articles about databases, but I have minimal database
>> experience and I want to get it right the first time. So I'd appreciate
>> answers to these questions and any other insights:
>> 
>> 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 can apply to categorize the various records.) I
>> doubt the number of records would ever exceed 10,000 with an average more
>> like 2,000.
>> 
>> 2) The content of some records may have associated images or audio files. I
>> can store the paths to those, but paths break easily. How much does it
>> bloat
>> or burden a database to store jpgs, pngs, wavs or aifs files in records?
>> 
>> 3) I see there are a few 3rd-party tools for database work with Livecode.
>> (SQLyoga, SQLiteAdmin and SQLMagic). Are there others? Are these current
>> with LC7?
>> 
>> 4) Are there contract developers in the LC community that specialize in
>> setting up databases with LC interfaces?
>> 
>> Thanks!
>> Tom B.
>> 
>> 
>> 
>> --
>> View this message in context:
>> http://runtime-revolution.278305.n4.nabble.com/Choosing-a-database-and-LC-tools-tp4694777.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





More information about the use-livecode mailing list