The future of LiveCode

[Bob Sneidar]

Welcome to the world of database disconnect. Products like Filemaker have a proprietary database mechanism built in. If fact thew Filemaker product is really some stuff running on top of a database engine. Products, any products that use SQL are in the same boat as Livecode, in that they allow you to use a number of kinds of SQL, but it is up to you to learn how to work with the database engine of your choice. 

I used to work in Foxpro which is a similar kind of product to Filemaker in the sense I described above. At first I was completely lost. I had hoped that the information about how to create and interact with databases were built into Livecode (Revolution at the time) and I was discouraged at the time to learn that I had to learn SQL, at least the basics of it, before I could proceed. Again I stress, this is not the fault of Livecode, it is the nature of any SQL based development. 

What has helped me greatly is a product called sqlYoga by Blue Mango. Once you connect to a database, all the calls are to the sqlYoga library, and you don't really need to know SQL or how to form a query to use it. It standardizes the calls if you will into what you can think of as an extension to Livecode. If it had been Runrev that had done it, then it would be the missing link you are thinking of. 

Bob


On Jul 20, 2012, at 1:31 PM, Potts Jeff wrote:

> For instance, anyone coming
> from Filemaker is instantly unable to create a basic functioning
> relational database. Sure SQLite is a great product, however, trying
> to create lookup/relational join is nearly impossible since the
> required knowledge is buried so deep in the forums that it took me
> over a month to find it, and then, not even an example of how to make
> it work.