Trent’s Blog

I ran across Navicat’s Postgres Administration tool the other day and just out of curiosity I decided to install it on Ubuntu (the lite version). Uhho, there’s no linux version! Well as any linux fanatic would do I grabbed the Windows version and tried to install with Wine, and well,.. it worked. After clicking around a bit I don’t foresee myself switching from pgAdmin(it actually looks a lot like pgAdmin III), but it does have a few pro’s and con’s. They also have a MySQL counterpart, but there is a linux version available for it.

Of all the database admin tools I’ve used however I’ve found none as nice as.. yes, I’m going to say it.. Microsoft’s SQL Server Management Studio. I think the biggest thing Management Studio has going for it is the very clean interface, and the fact that every button doesn’t pop open a new window and it’s a one stop shop for user administrator as well as data manager. MySQL has the two separate applications, other than that I love their query browser as well. Are there any other great database admin tools out there that are reasonably price??

It’s been a long time in the making but aedPHP is finally here. aedPHP is the little brother of aedCFC, which in a few months has gone from nonexistant to nearly 800 downloads. Knowing that plus the fact that half of my development is in php I knew it was time for aedPHP.

aedPHP is a small class that creates a clean add/edit/delete interface for intranets(no, not a cms, this makes individual files). You could call it a “crud” but it seems to be a little more worthy than that. Its great for adding on to existing intranets or creating your own custom cms in minutes. After doing one or two it will take you longer to create your table in the database than having an interface for it. Templates and tinymce make the interface extremely easy to customize and add elegance. Documentation isn’t out just yet but it should be extremely similar to that of aedCFC!

Its database capabilities are limited to mysql since thats the only environment I have to work with, BUT the class is set up where all you need is to create your own database class(I already have the template needed, just fill in the db specific code). At that point aedPHP can do everything from reordering database entries to hierarchial database tables!

I’ve been working for a while on the aedCFC with the optional tree view.  This uses an old database technique described on sitepoint.com .. however the tree.cfc I created was very basic as in only adding, deleting, and printing nodes which sortof holds back the possibility to making this a real fun, dynamic cfc with drag and drop for tree nodes(soon to come to the aedCFC).  Finally I have added more to this tree functionality by successfully creating a function to move nodes(including child nodes) in the tree.cfc.  I dont have any documentation just yet,.. but you can see its pretty straight forward to use.  In the download there is an index.cfm  which is  a  small form controller for the treecfc.  All of the sql is basic so it is pretty likely it will work on most db’s(tested on mysql and mssql).  DB table fields are specified in the comments.  Maybe I will get some time to whip up some docs on this little tool.
Download Source

Finally many of the features we have been working towards made it in the aedCFC. Our long time debated XML config file finally made it in as an option(mainly for backwards compatibility). The biggest downfall to the config before was the function calls with many parameters. I’ve read a few other postings on the great XML config debate and I come to the conclusion that the aed wasnt in the situation where XML would kill it. The XML may slow it down a little,.. but is it enough to really matter?