Re: [Firebird-devel] Red Database 2.1 released - merge ideas

[Adriano d. S. F. <adr...@uo...>]

Nikolay Samofatov escreveu:
> PSQL debugger for SP/triggers
> ~~~~~~~~~~~~~~~~~~~~~
> Proof of concept implementation, which currently uses CORBA for 
> communication with debugger on the client side, and server-side debugger 
> engine implemented in Java. We have discussed with Eugeny that Y-Valve 
> can be extended to accomodate communication with debugger via the 
> variety of supported protocols (INET, XNET, etc). Server-side Java 
> helper on the server side becomes unnecessary in this case. We're not 
> planning to extend it much further from what is done now, but debugger 
> API works, in can be re-worked and polished by the community and user 
> tools developers.
I've very different ideas of how this feature can be made, and it worth 
discuss benefits and drawbacks.

In the client side, I'd prefer to have set of procedures and functions 
(in a package) and debugger application controls the debugging 
attachment by another attachment. There will be procedures and functions 
to set breakpoints, inspect variables, etc. The debugging connection may 
post events that the debugger could wait for.

In the server side, a new debug (or notification) plugin is created, as 
well as a DEBUG external engine used for the procedure and function 
declarations.

It allows to use the existing infrastructure (SQL, PSQL, events) and 
allow easy use from applications (debuggers).


Adriano