phpMSAdmin

I’ve just released 0.11 to the great SourceForge mirror network. This is another decent sized release which includes another much promised feature. Triggers can now be listed, modified, created, or deleted using phpMSAdmin. You can access this feature by either using the table context menu (right clicking on a table in the menu) or by clicking on the “Triggers” link next to each table on the database properties page. Note however that triggers have not yet been added to the mobile version which will most likely happen in 0.12. Thanks, and enjoy.

Just pushed out 0.10. This release has basically only one major change, the introduction of the capability to create and manage user defined functions. As with stored procedures and views, you can access functions from the database context menu (right click) or by scrolling to the bottom of the database properties page. Also, the software is at a sufficient state where I no longer deem it to be “Alpha” quality. Therefore the software is now officially classified as “Beta”. Enjoy, and have a good memorial day.

Just released 0.9 which includes a number of bug fixes with a very minor feature enhancement. Included are fixes for a table creation bug, row insertion bug, and a function library logic bug. Also added was the ability to add new stored procedures and views as opposed to the previous releases which had edit-only functionality.

The new version (0.8) was just released. It includes medium sized functionality (tables, procedures, views) and layout fixes for the mobile client as well as a small feature enhancment in both versions in relation to functions available during table row insertion (namely the SHA1 function was added).

After releasing two major features in a row, I thought 0.9 might be a good release for a feature which couldn’t really be called critical. In fact, it is probably considered more of a perk or luxury feature then anything else in phpMSAdmin. This release includes a new mobile version of phpMSAdmin designed to run on either a Windows Mobile or Palm powered smartphone or PDA. Only basic functionality is there, including connecting to the server, viewing databases and tables, and selecting and browsing tables. You can try it out by adding “/mobile” to the end of your normal phpMSAdmin URL. Check it out.

I just released 0.6 to the great un-seen sourceforge distribution network. As I type it’s flying across the internet, under the ocean via intercontinental communication pipes and maybe even into space as it’s beamed to the mirrors in eastern Europe. For some reason I always get the image in my head that there is a giant printing press printing out every line of source code I commit, which is then promptly fed into a scanner which OCR’s it and then shreds the original while the OCR’d version is stored in subversion. Who knows, it could work that way. =) Anyway, back to the topic at hand. This release includes another much promised feature, views. You can select against, modify and delete views with this release. Also this release includes a number of important fixes for stored procedures, basically it now makes stored procedures with an assigned schema work where as before they didn’t. There were also a number of miscellaneous formatting, syntax, and logic bugs that were fixed. As with stored procedures, you can get to views by right clicking on the database in the menu or left-clicking and scrolling to the bottom of the database properties page.

I’m pretty happy with 0.5. It adds one of the core features listed as a goal of this project, which is Stored Procedures. You can now view, modify, and delete stored procedures. They’re are a few kinks to be worked out like the fact that certain rare procedures refuse to be viewed/modified but can be executed. One cool feature is that procedures that have values being passed into them can auto-parse, so when you go to execute them it knows what you could/should be sending in. This feature needs a little more work to make allowances for all the ways procedures are written, but it’s there at a basic level and it works. Stored procedures are available at the bottom of the database properties page, or by right clicking on the database itself in the menu. The tables in the menu all have a context menu as well so give them a right click and see what you think.

I installed Wordpress and was quite smitten with it, so as Emeril would say: BAM! Hope you like the new software as much as I do.

Hot off the keyboard, I just released 0.4 including fun new features like beginning context menu integration (right clicking). Also the detach database function was completely broken so that was fixed. A confirmation dialog was added to both the database drop and detach database pages. Other then that it was mainly just code cleanup in both display and logic centers. I’m really getting sick of this webpage layout, so don’t be surprised if on your next visit you see some type of CMS or blog software or something similar. See you next time (7 days).

Welcome back to the land of the living, oh little project of mine. Anyway, this is a minor release that includes changes to the export system so that the system is aware of what format your outputting in (CSV or SQL). Also added is a global font setting to the config file that should take effect everywhere and let you get rid of the ghastly default font your browser may or may not use. Apologies for so few changes but I spent the better part of my free nights this week trying to make VMWare Server work on Ubuntu. I finally did it, but it took quite a few manual re-reads, forum trawls, google searches and re-installs before it worked. Far too much work for an officially supported host OS, but I digress. Download the juicy goodness that is 0.3.