Close all open databases --> Why exists API way

[William Humphrey]

I can see a good logical way in the plan you outlined below. I like it. 

Brevity and errors in this email probably the result of being sent by a mobile device. 

> On Oct 15, 2013, at 1:30 PM, Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com> wrote:
> 
> On 10/15/13 1:49 AM, "Mark Schonewille" <m.schonewille at economy-x-talk.com>
> wrote:
> 
> Hi Mark,
> 
>> That's isn't really the problem, though. I don't quite understand why
>> there is a complicated API, if there is already a SQL language. Yes,
>> using the API has an advantage, because LiveCode's SQL commands are very
>> limited, but we don't need that extensive API.
>> 
>> When using databases, I always compare the front-end languages with PHP.
>> If PHP doesn't have it, then it is not necessary. LiveCode lacks a lot
>> that PHP has, but Valentina has a lot that PHP proofs to be unnecessary.
> 
> Well, I think something is explained in Valentina WIKI / Articles
> 
> In short:
> 
> 1) Valentina was born to be Object-Relational db,
> db, which have links, which have classes, inheritance.
> 
> This was yet 1993, when C++ have start raise instead of C.
> 
> 
> 2) Up to 2000 year, Valentina did not have SQL at all.
> 
> 
> 3) So its SQL is a special engine, built over lower level engine of
> Valentina.
> 
> 
> 4) SQL engine internally uses same API level.
> 
> 5) API level can be greatly used for local dbs only ...
> it can give you easy x10 - x100 times speed ups comparing to SQL way.
> 
> Good reason yes?
> 
> 
> 6) For such high-level languages scripting as PHP and LiveCode,
> API level looks to be not very comfortable. Yes we see that.
> 
> In VPHP there is no still full Valentina API public ...
> But we already have it in beta in SVN ...
> 
> 
> 7) I think you know about non-SQL dbs boom ...
> 
> But Valentina by its nature IS such non-SQL db :-)
> And yes SQL db.
> 
> 
> 8) for Macromedia Director, we did have just ONE function,
> which could do all job over db.
> 
> DISCLAIMER: This was not our idea, we have copied it.
> 
> 
> For Livecode, such 1-main-function can be that
>    VDatabase_SqlSelectRecords()
> 
> You have see it ...
> 
> 
> May be even we need split docs to 2-3 parts
> 
>    a) simplest  1 function
> 
>   b) like others db - SQL way:
>      only DB + cursor here
> 
>  c) Advance -- API level ...
> 
> 
> -- 
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
> 
> [I feel the need: the need for speed]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina