← Back to team overview

maria-discuss team mailing list archive

Re: R: Stored Procedure debugger from Peter Gulutzan and Trudy Pelzer

 

Hi Federico,

On 03/10/2015 04:17 PM, Federico Razzoli wrote:
I don't want to show critisism against projects like this - I hope that this is clear. There are many debuggers, and they are more than welcome. Even Oracle has a debugger, if you use Windows and Visual Studio (sigh).



The debugger supports the things you mention. At least during my 10
minute trial I experimented with breakpoints and context inspection,
everything worked like a charm. I don't know about inspecting the
call stack, didn't try to. But it seems it does.


But I still think that MariaDB needs a native debug API, which fully supports checkpoints/flow control, context inspection and exposes the call stack. I doubt that an external debugger that transparently adds debug code could possibly replace it, especially if your business logic is complex. I've tried to write a debug library in SQL - the problems I've found make me seriously doubt on the possibility to follow this path.

Regards
Federico



--------------------------------------------
Mar 10/3/15, Alexander Barkov <bar@xxxxxxxxxxx> ha scritto:

  Oggetto: [Maria-discuss] Stored Procedure debugger from Peter Gulutzan and	Trudy Pelzer
  A: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
  Data: Martedì 10 marzo 2015, 11:42

  Hi,

  Peter Gulutzan and Trudy Pelzer announced their GUI debugger
  for stored
  procedures.

  Sources, binaries and a demo are available here:

  http://ocelot.ca/blog/blog/2015/03/02/the-ocelotgui-debugger/

  This is a great news.

  Greetings.

  _______________________________________________
  Mailing list: https://launchpad.net/~maria-discuss
  Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
  Unsubscribe : https://launchpad.net/~maria-discuss
  More help   : https://help.launchpad.net/ListHelp




Follow ups

References