The new version is available from the project page: AeroSQL. Here is the change log.
Continue reading →

I’ve developed a MySql manager back in 2000 for MySql 3.23 using Borland Delphi. The software was used internally in a company. I’ve decided to switch completely to web based application development. I found ExtJS and I was amazed! … Then I thought what application to develop in order to get some ExtJS experience, so I recalled my intention to create a GUI for MySql. Here is how AeroSQL was born.

Continue reading →

A month ago I’ve written HTML2GDL script that creates the graph of a html file/url for aiSee graph layout software. Recently I found another graph package GraphViz, and I decided to add support for DOT language into HTML2GDL. GraphViz and aiSee have different layout algorithms. I wanted to compare the graphs produced by similar layouts offered by both packages and try the new ones available to GraphViz only (the radial and circular layouts).

Continue reading →

Being a Delphi programmer for many years (desktop applications for Win32), now I’m shifting to the web medium: AJAX, CSS. After some research, I’ve chosen the jQuery framework as the base for my future web applications. I was amazed by the number of plugins available for jQuery! I needed a plugin that was able to display the remote filesystem as an expandable/collapsible tree. I found jQuery File Tree to be exactly what I’ve needed.

Continue reading →

Existing utilities for monitoring apache logs didn’t suit me, so I’ve decided to create a tool for monitoring apache log files remotely via a browser. The aim was to create a very small application that just do the job: show the last visits to a website and nothing more. The tool is called ALiveLog (Apache Live Log): you can monitor multiple websites hosted on the same server through a single ALiveLog installation. Regarding security, the script performs only read operations (reading the last N entries from access.log files). The server side script is written in Perl, but can be easily ported to PHP as well.

Continue reading →

Information visualization, besides being a science field, can be fun. The ever challenging problem of converting text and numbers into something viewable that is self explanatory makes information visualization an interesting toy to play with. Some time ago I saw an applet that displays the hierarchical structure of HTML files called HtmlGraph. I really liked the idea: you don’t have to ramble through the woods of html trees in order to figure out its structural pattern. I wondered how aiSee will display html graphs and created a simple application for this purpose. Continue reading →

Understanding what are visitors doing on a website and how they are browsing that site is crucial for information architecture specialists. I’m using AWStats and Google Analytics to monitor websites. Nevertheless, I always felt that I didn’t see the whole picture. Recently I found how to view the stats from another perspective: graphs!

Continue reading →