Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Stored Procedure Debugger

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Stored Procedure Debugger

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • March 20, 2007 at 2:48 pm #10249
      dazzknowles
      Member

      Hi,

      Would anyone else out there like to see a Stored Procedure Debugger added to sqlyog. So far I have only found one on the market and I haven't had any success using it.

      Thanks,

      Dazz.

    • March 20, 2007 at 2:53 pm #23635
      Rohit
      Member

      MySQL AB does not provide any debugging APIs at this point in time. Unless debugging support is provided by the server itself, SQLyog wont we able to set breakpoints, inspect variables, etc while the proc is getting executed.

      Can you point me to some other tool that supports debugging of MySQL Stored Procs?

    • March 20, 2007 at 3:04 pm #23636
      dazzknowles
      Member

      Hi Rohit,

      Sure, the one I have been trying is StepIn By Illatis. It's an Eclipse plug-in but also thankfully available as a standalone application as I am not a fan of Eclipse. I've also found a few Stored procedure based methods for debugging, the best of which appears to be here, though this method and others like it require you to edit the sproc itself which is something I would ideally like to avoid as is just clutters the code and can obviously introduce bugs itself 🙁

      Rohit wrote on Mar 20 2007, 02:53 PM:
      MySQL AB does not provide any debugging APIs at this point in time. Unless debugging support is provided by the server itself, SQLyog wont we able to set breakpoints, inspect variables, etc while the proc is getting executed.

      Can you point me to some other tool that supports debugging of MySQL Stored Procs?

    • March 21, 2007 at 6:49 am #23637
      Rohit
      Member

      We have looked at the techniques used in http://forge.mysql.com/wiki/DebuggingStoredProcedures. However, we didnt find them very convenient for the end user – specially the requirement of editing the SP before debugging.

      I will have a look at the other link in your post and get back soon!

    • April 11, 2007 at 2:29 pm #23638
      Murdoc
      Member
      Rohit wrote on Mar 20 2007, 02:53 PM:
      MySQL AB does not provide any debugging APIs at this point in time. Unless debugging support is provided by the server itself, SQLyog wont we able to set breakpoints, inspect variables, etc while the proc is getting executed.

      Can you point me to some other tool that supports debugging of MySQL Stored Procs?

      MySql Developer Studio 2.0 http://crlab.com/mysqldev/ has an integrated debugger for MySql stored routines and scripts. May be it can help you. It's a developer-oriented solution for MySql dbms

    • April 12, 2007 at 12:46 pm #23639
      Rohit
      Member

      Thank you for the links. We will try them and keep you updated.

  • Author
    Posts
Viewing 5 reply threads
  • You must be logged in to reply to this topic.