phpMSAdmin

What the heck is QB and DE you ask? Why Query Builder and Database Export of course. This release (0.18) feature enhancements to both the database export and query builder features. The database export is now capable of exporting stored procedures, views and functions. The query builder is now capable of “LIKE” comparisons and can now utilize and “ORDER BY” selection. There were also two small bugs fixed on the query builder. Enjoy, and see you next week.

Hot on the trails of the last user feedback release, here is 0.17 including another user requested feature, a query builder. It’s not very advanced as of yet, but it works. Also included is the ability to import databases as opposed to the last release which could just export. The export function was slightly tweaked but no major functionality was added. Also numerous bugs were fixed which you can read about in the SourceForge changelog if your so inclined. Enjoy, and see you next time.

This release (0.16) includes a major new feature that was requested by a user in the forum, database exporting. Also included is an updated manual. Numerous bugs and notices were cleaned up and some minor layout/design tweaks were implemented. Full changelog is available via the “note” on the SourceForge releases page. I know what your saying, “Only one new feature?”, yep, this one was a tall-order and it still is not as inclusive as I would have liked. Enjoy, and stay tuned till next week.

This (0.15) is primarily another user-feedback release. Thanks to all those in the forums who had constructive suggestions on how to improve the software. First, added the ability to edit rows from both the table select and table browse modes (assuming an identity column is present). Also, support was added for manual connection specification. Dangerous table operations via the context (right-click) menu now prompt you by default to confirm the operations unless you turn this off in the configuration file. Also the context menu for databases was modified to include a create table link. For the first time ever, a work in progress manual is included. It is availabe in the “docs” directory in “Open Office”, “Microsoft Word”, “PDF”, and “HTML” formats. Numerous bugs were fixed including broken windows detection on the login page, incorrect title on database drop page, table insertion not enforcing maximum length restriction, and an odbc.ini “present but empty” error. Also a large number of notices were fixed throughout the software if you had notices turned on. There were also a number of small cosmetic changes. Added messages stating when there are no Stored Procedures, Views or Functions on the database properties page. Fixed IE incorrectly displaying a number of table borders.

Just released 0.14 to the wild wild net. I’m pretty happy with this one. This is a mid-level feature/bugfix release. First, it includes the ability to rename tables and you can now also toggle databases into and out of READ-ONLY mode (both available via the right-click context menu). Also added was the ability to assign database roles to new users. A bug preventing user account creation and a bug causing your selected username not to follow database selection have both been fixed. A password requirement was added for user account creation. Security has been enhanced by the addition of user IP and browser checks. The universal header, login, database drop, and database detach pages have all received slight color scheme changes. Also the table context menu (right click) has been cleaned up and reorganized.

I just released 0.13. This release features much improved error handling on the table select, table modify, and table creation functions. What do I mean by “much improved”? Well basically when an error happens it doesn’t just die and tell you what SQL Server responded with. It now shows what you were attempting to do so you don’t have to fill back in all your information and it shows the query it attempted to execute (in most places). Also added was the ability to rename columns. Also some smaller things were included like a link to insert rows from the table properties page and the function, procedure, and view modification functions will now search and replace to replace each objects definition from “CREATE” to “ALTER”. A small change but a handy one. This releases focus is a direct response to feedback by a user in the forums. Got an idea? Post a message, I’d love to hear it. Enjoy and see you next time.

Just dropped 0.12 to the mirrors. It’s a decent release. This release includes something I frankly should have thought about a long time ago, automatic parsing of your DSN list on Windows. There might be a bug or two, but give it a shot. Worse case scenario, it doesn’t work and you just set “detectionoff” in the config file. Also added to this release was better error handling functions. The only place the new functions have really been implemented is in the error handling for the addition of columns to tables, but they’ll slowly filter in to the other areas of the software. Also in the area of table modification, a bug was fixed where causing an error would cause a PHP parsing error … never a good thing. Finally, this release back-fills triggers into the mobile version of the client. Enjoy, and remember, if you have any problems/feedback/suggestions or praise =), the forum is available via the link on the right side of the homepage.

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.