SQL and other databases

[Peter Haworth]

Ditto to all that.

The Rev manual section 2.2.8 talks about when to use a database.  Their rule of thumb is to go database when you have more than 2000 records or need to allow multiple users to access/update information at the same time.

Pete Haworth


On Mar 20, 2011, at 1:57 PM, Kee Nethery wrote:

>> So, I am really interested to know why so many folk seem interested in using
>> Livecode to write database front-ends rather than using Livecode for the
>> database as such.
> 
> 
> 1. We already have a multiuser database and several other light client systems that access it via web browsers. 
> 
> I have a heavy client in Livecode that we use internally to access and manipulate the data in ways that would be difficult in a browser.
> 
> 2. If I anticipated 100000 records, a real SQL database is probably going to be faster as the database grows.
> 
> 3. If I anticipated the need to do joins between multiple tables, a real SQL query mechanism is probably going to be faster than Livecode. For example: imagine four stacks; one with product records, one with customer records, one with transaction records, one that ties countries to areas. Now envision selecting all transactions by customers who live in europe that contain products that are blue. 
> 
> In Livecode you could grab a list of all products that are blue, then see what transactions contain those products. Grab a list of countries that are in europe. For that list of transactions, look up every customer to see what country they live in. Toss out transactions from countries that are not in Europe. A SQL database does this very quickly. Livecode could do this but wow it would probably take a long time.
> 
> Those are three reasons I would not use Livecode as the database.
> 
> Kee Nethery
> _______________________________________________
> 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
>