AeroSQL - Web based MySql Manager

[oburlaca]

Hi all,

I've decided to develop an open source MySql Manager. It's called AeroSQL.

Go to http://www.burlaca.com/aerosql/, I've setup a demo and provided screenshots and a video (Video is best viewed in HD + Fullscreen).

My intention is to make AeroSQL a full featured MySql manager with functionality found in existing software products like MySQL Query Browser, EMS SQL Manager for MySQL, SQLyog, PhpMyAdmin. I'll see if I'll have the time, but it's really a pleasure to work with ExtJS

I wish to thank all the people who offer support on this forum. I was able to find a solution to almost all of my problems by just searching the forum.

The demo has two servers, the "Production Server" is under "read-only" privileges. The second one is writable ... just don't delete the existing tables
Anyway, I'll put in crontab a script that will "reset" the database once a day/week.

P.S. I've started to learn ExtJS and PHP a month ago, so I'll be glad to hear from literary critics that live here

Regards.

[stever]

Nice! I always wondered why someone didn't do that!

[wemerson.januario]

Nice job man.

[oburlaca]

Thank you!

I forgot to mention:
In my application I'm using Ext.ux.IconCombo.js extension by jsakalos.
I think he is software "maniac" (in a good sense obviously). I find Saki's Extensions and Plugins to be very useful especially for newbies.
Thanks all!

[dombroskib]

Impressive tool! Will definitely be looking to give this a try!

[Animal]

I'm loving the madlib movie descriptions!

[oburlaca]

I'm loving the madlib movie descriptions!

The tagline column is a varchar(15). When you enter a longer string and press save, you'll notice the warnings about truncated data.
.... I should not allow the user to even enter a string longer then 15 chars.

[carl23934]

Yeah, it would be a good feature to have constraints on the inputs to match the column type in the database when adding/editing rows

Another idea that I've added to all of my grid and tree context menus is when you open the context menu, select the row / node that the context menu is for. It's a bit strange when you see a context menu in one place, yet another row is selected. This is more of a personal pet peeve, but I also think it's a nice feature.

Otherwise this is fantastic. It's a great start!!!

[oburlaca]

It's a bit strange when you see a context menu in one place, yet another row is selected.

Agree. Absolutely.
When I added selModel: new Ext.tree.MultiSelectionModel() to the tree I didn't want to loose the selected nodes on popup menu so I didn't select() the corresponding node. (You can select multiple nodes and delete them in a single call for ex. i.e. you can perform an action on a group of selected nodes. In the future I think that multiple selection will be more useful than having only one selected node.)
.... I thought a little, and added the following snippet:

        // select the node only if user didn't select multiple nodes
        if (this.getSelectionModel().getSelectedNodes().length < 2) {
            node.select();
        }

No it works as expected ... the node is selected.
I've uploaded the modified version, check now

Yeah, it would be a good feature to have constraints on the inputs to match the column type in the database when adding/editing rows

Yes, it's the way it works now, but not at 100%. You can't enter negative values into an UNSIGNED column for example.
I should add the [min..max] check based on integer data type (tinyint, mediumint, etc), and the maximum length for varchars.

[oburlaca]

Another two cents: when you select a group of nodes and DELETE them from the tree, only successfully deleted objects (database, table, columns etc) at the serverside will be removed from the tree. (The response of the AJAX call contains the list of successfully deleted objects). The other ones will remain selected