Archive for the ‘software reviews’ Category

Debugging MySQL stored procedures

May 2, 2008

possible tools:

  1. MyDeveloper Studio (windows only, 30 day free trial) — Looks very promising, had some problems with a DO … WHILE … loop. Investigating.
  2. Toad for MySQL (windows only, freeware) — haven’t tried it.
  3. Eclipse plugin — there are several database plugins, not sure if any of them would be suitable.
  4. Hand-written SELECT statements to track variables — a reasonable alternative for projects with only a few stored procedures. Would quickly become slow, tedious and inefficient on bigger projects.
  5. MyProcDebugger
  6. gdb

Posted in databases, development, software reviews | Leave a Comment »