Memetastic!

These are the commands I’m running. Great idea!

 

$ history | awk {'print $2'} | sort | uniq -c | sort -rn | head
    184 ls
    118 cd
    117 vi
    116 less
     54 tail
     43 ps
     41 perl
     31 rm
     27 for
     23 grep

Debugging MySQL stored procedures

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

Textpad

I’ve foundout Textpad can actually do a lot of stuff I need. I’ve changed the tab stop from 8 to 4 characters, installed some add-ons from the Textpad site that let me syntax check against xampp’s php.exe and upload with an ftp batch script just by pressing ctrl-4 and ctrl-5. And I’ve found an add-on for ctags, which is kind of a little bit like a ’code overview’.

IDEs

I’ve been trying to write a PHP/MySQL site for someone…. Big mistake.

Textpad is pretty lame as a PHP editor. I spend more time scrolling down the file than I do writing code.

To debug PHP it’s confusing trying to get the right quotes and escape the right characters in a one-liner under either windows, cygwin on windows, or even linux.

So maybe I need a better IDE?

I install UltraEDIT, but can’t get past the registration phase, even if I give it all my personal details. Really! It says something about a SOAP parameter being incorrect. Guys, next time don’t bother with the ‘Rugby world cup special edition’ ffs, just make your software work.

I tried Eclipse, supposed to be really good. Added EPIC to it for Perl management. Couldn’t even get the debugger to work! The error: “File does not exist” Which bloody file?!!?

I’d call is a success though, just being able to see my subroutines in a list in the sidebar, and be taken to the with a click. Except it doesn’t work for existing files, you have to copy and paste the code into a new file. For *every file*. Also the completion of functions in packages (pop-up like visual studio) is useful.