VStudio 5 -- SQLite plugin

Ruslan Zasukhin ruslan_zasukhin at valentina-db.com
Thu Apr 12 15:47:35 EDT 2012


>> On 4/12/12 5:15 PM, "william humphrey" <bill at bluewatermaritime.com> wrote:

>> It opens SQLite files wonderfully. There is not a menu command to save a
>> SQLite file as a Valentina database.

Click SQLite database --  in contextual menu must be command to convert into
Valentina DB. 


======================
FYI:


SQLite plugin in Valentina Studio was developed more of  year ...

Vstudio constains code by size may be comparable to engine itself :)
related to Lite

=======
One of nasty "feature" of Lite was weak support of ALTERs

Igor and other guys did huge job to support ALTER oeprations in Lite like
for Valentina and Postgre ...

Even if table have records, Vstudio must be able e.g. ADD / DROP column of
table, change types, flags, and other things.

In background this can cause COPY of all records from one table to another.


Using DIAGRAMS SQLite developers can even get into hands that SQL scripts
and use them in own RB / LiveCode apps


DataEditor, which you are used in Valentina Studio also works for Lite and
Postgre. Works even Related Browser, if Foreign Key -- links are defined for
that dbs ..

And so on ... Reports, SQL Diff, ...

-- 
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]






More information about the use-livecode mailing list