AeroSQL - Web based MySql Manager

[oburlaca]

I found a topic named "A Free phpMyAdmin Alternative" in this forum, and I thought it might be useful to mention another open source alternative to phpMyAdmin:

Homepage: http://www.burlaca.com/aerosql/

AeroSQL is a free web based tool for managing MySql servers written in PHP. The key feature of the product is an intuitive management of the database content. The result of SELECTs is displayed in a grid as in traditional desktop applications. The grid is editable: you can update cells and save the changes to the backend database server. For now, the query browser represents the main functionality. Additional features will be added in the next versions: administration tools (backup, restore), database object management (create tables).

There are a demo, video and screenshots at the homepage.

I hope it will be useful.

[Autoload]

I'm not a IE fanboy, but the demo doesn't work in IE... Loaded okay in Firefox 3.x, but interface seems a little clunky to me..... so far not impressed.

[oburlaca]

I'm not a IE fanboy, but the demo doesn't work in IE... Loaded okay in Firefox 3.x, but interface seems a little clunky to me..... so far not impressed.
Ouch, you right, ... now it's working.
I see that in IE there are some CSS problems: icons for menu items are not displayed ok. This happened after I've started to use a sprite instead of multiple small icons (for performance). I'll investigate this.

What do you mean by "clunky", in respect to what?
Thanks.

[oburlaca]

I wanted to mention that I put the accent on the grid that allows you to manage the content of a table/sql SELECT because this is the missing (not implemented quite well) functionality in existing web based mysql admin tools.
(I forgot to mention that I don't use IE too much :))

[Autoload]

'More better' now that the interface works cross browser. :-)

I see what you mean about the icons being jacked up in IE. I don't use IE that much either, but since IE has 60%-80% market share (depending on who you ask) I would be using it more often in your developement and testing.

By clunky I mean the following:

1. No horizontal scrollbar. When there are more columns in the view than space available it it difficult to move back and forth with a mouse and the data view gets crunched. I see the view stretches to the full width of the window even if I had two columns so I end up with two columns of data to work with and huge amounts of white space.

2. Personally I don't like having to select a table from the left and then have to click something else to view the contents. The extra step is a minor annoyance (to me). I'm not going to be clicking on tables unless I need to work in them... why the extra step?

Both my gripes are personal preference ones. I do have to say the interface looks nicer than phpMyAdmin and I would try it on a host that didn't allow remote DB administration where I would use Toad or MySQL Administrator.

[oburlaca]

I see what you mean about the icons being jacked up in IE. I don't use IE that much either, but since IE has 60%-80% market share (depending on who you ask) I would be using it more often in your developement and testing.
Absolutely!, in the next version of AeroSQL it will work ok in IE.
1. No horizontal scrollbar. When there are more columns in the view than space available it it difficult to move back and forth with a mouse and
Ouch! The behavior is IE specific, in FireFox it works ok: the columns are stretched to adjust to available space. There will be a checkbox for that: allowing you to manually resize the columns and have a horizontal scrollbar.
2. Personally I don't like having to select a table from the left and then have to click something else to view the contents. The extra step is a minor annoyance (to me). I'm not going to be clicking on tables unless I need to work in them... why the extra step?
Viewing the content is just one possible action, there will be more: backup, copy, etc.
I assume by the "extra step" you mean clicking with the right mouse button on a table and press Edit Data?

I do have to say the interface looks nicer than phpMyAdmin and I would try it on a host that didn't allow remote DB administration where I would use Toad or MySQL Administrator.
I saw phpMyAdmin screenshots and installed it recently, but table data editing is not as in desktop application in phpMyAdmin.

My plans are to create a fully functional web based mysql manager similar to existing desktop based tools.