Category: Language

Choose posts by language.

[Imp] VSQL: SHOW commands now can accept variables instead of e.g. db_name

To support our own development of admin task for vserver, we have extend SHOW commands to accept variables instead of db_name, tbl_name and so on.

When variable starts with @ or @@ symbols, engine easy can recognize this. But you can also use a local variable of Stored Procedure. Algorithm at first checks if IDENT is the name of a local variable. If no,  then consider this as db_name or tbl_name according to grammar of a SHOW command.

Example:

Some_Stored_Procedure_Text()
…
set CurrentDbName = ‘accounting’
execute ‘SHOW EVENTS FROM CurrentDbName’
…
end

[Imp] VSERVER – now works with SNMP parallel

Valentina Server was improved to work with SNMP protocol using absolutely independent parallel thread(s). This means that on modern 2+ CPU computers, SNMP queries practically will not delay the main job of VServer.

Also  added 2 new SNMP params:

  • “1.3.6.1.2.1.1.8.0.0.0.1” – port for regular TCP connections
  • “1.3.6.1.2.1.1.8.0.0.0.2” – port for SSL TCP connections.

[NEW] Youtube channel for Valentina (DB + REPORTS)

We have setup channel on Youtube for Valentina related movies http://www.youtube.com/user/paradigmasoftware

First of all here was moved existed video-tutorials about Valentina reports, and was added some new about Valentina Studio. We going now extend this channel a lots in the nearest time.

Into Valentina WIKI for v5 we have installed also plugin to show movies from youtube. So we will integrate movies into docs about Valentina products.

Valentina Studio gets redesigned Server Admin tool

This tool now can work with Valentina Server, PostgreSQL and mySQL.

This is the central place where you can:

  • manage databases: create, drop; register/unregister, …
  • manage valentina projects: create/drop, register/unregister, …
  • manage users, groups and roles
  • view server-side log files
  • view and edit ini-file parameters of a server

[NEW] Valentina Studio – Postgre plugin – now can dump/load using pg_dump engine

We was able embed into Valentina Studio plugin the pg_dump engine to dump a database into different formats of text files  and load these text files back into database.

You can access these dump/load commands from the File menu of Valentina Studio application or from the contextual menu of a database object.

Continue reading [NEW] Valentina Studio – Postgre plugin – now can dump/load using pg_dump engine

VStudio now can show warnings from operation

Valentina Engine far ago produce warnings in the ‘Warning.log’ for Import of Text operation. For example, record is not added if the primary key is not unique.

This warning.log is created near to application. And if this is a remote Valentina Server then user of Valentina Studio cannot easy see that warnings. Now this is improved. In Valentina engine, in Valentina Server and in Valentina Studio. Snapshot below demonstrate this.

VStudio – QueryBuilder make up and improvements

In 5.0b30 we have return back QueryBulder after few months.

* new – it works now for all supported engines: Valentina, PostgreSQL, mySQL, SQLite.

* new – we have simplify interface removing few visible areas, replacing them on TAB panels. Note that you can switch by main panels using such shortcuts as cmd+1 and cmd+2.

* new – you can specify expressions to be used in the SELECT clause.

* note that you can specify inner and left/right/full outer joins using right-click on a link on the diagram.

* note that if you will click SQL panel and then continue develop diagramm then you will see live changes in the generated SQL.

[NEW] SHOW [VSERVER] LOG command

We have added a new SQL command that works with VServer only to show tail of VServer.log file. (5.0b30)

TODO Valentina Studio now have a special panel where user can easy see this log using new command.

All together this simplify a lots work with remote VServer, especially if you do not have SSH access to its file system.

[NEW] VServer + VStudio now can show NOT registered dbs

We have extend SHOW DATABASES command to show also not registered databases located in the VServer/databases folder. To implement this VServer now is able iterate this folder to see files with .vdb extension.

Valentina Studio now take this in attention and show such not registered databases with a special icon. Also you get contextual menu with command “Register database”.

Refresh button of VStudio is able issue SHOW DATABASE command to check folder for new files if needed.

Join speed improved

After some benches we have discover that loop on small joins (when only one record on the left and few on the right) is not fast enough.

We have two major algorithms internally and we have discover that the first takes only 50 seconds on 10000 loops, while the second takes hundreds of seconds…So problem presents in the second algorithm.

Improved.

Now the second algorithm takes 120 second. And we can add yet choice condition to choose the first for such case of small joins…

I think we will be able to improve the second alg yet to 70-80 sec. And may be with more complex changes it is possible to speed both after that …

VClient and VServer now can analyze network

After some benches we have discover that it is not a good idea to use ZIP compression of data if VServer is on localhost or on fast LAN.

To resolve this we have specify 3 possible steps and made the first one without changes in API. As result, now VClient and VServer automatically can do raw analyze of network and define if to use ZIP.

Future we will add even special VClient function VConnection.Tune(), which your app can call on start, and later each 30 min for example to measure and analyze network state more accurately.