Archive for the 'Tools' Category

[Hint] Reading STDERR output in PHP

Published
by
Filip Tepper
on November 9, 2008
in Hints and Tools
. 2 Comments

Recently I was working on a command line PHP script. I know that there are better ways to do things, but I didn’t want to use any other language, since most developers in our company know mainly PHP.

The script exec’s MySQL command to execute a batch of SQL queries. I also wanted the script to mail the error messages. mysql redirects error messages to STDERR - but STDERR is by default not available in exec’s output argument.

Walkaround is simple:

exec('your_command 2>&1');

Works!

[Tool] SQLite Manager

Published
by
Filip Tepper
on September 17, 2008
in Tools
. 0 Comments

For a couple of months I’ve been developing some Adobe AIR applications - all of them require local SQLite databases. To get the job done I needed an application that would ease SQLite DB management.

After some googling SQLite Manager poped up. It’s a pretty easy yet powerful tool - can be run both a Firefox extension or a stand-alone application (via XULRunner).

My only wish so far - a decent-looking interface.

SQLite Manager

SQLite Manager