PSPMyAdmin changelog

If you've tried out JustChris' PSPMyAdmin application back in May and found it useful enough for on-the-go test querying, then you'd be delighted to know that the developer just updated PSPMyAdmin with a new graphical user interface (thanks to a modified version of OldSchool Lib). And just like the the previous version, you still have CSV file support.

The developer does remind you all that running the included test file would output a text file that uses Unix-style newlines or endlines. In this regard, you might want to use an alternative to the trusty Notepad in Windows if that's what you site/server admins are used to. NotePad++ is a sound choice, but then that's this writer's preference.

You're free to use your own test file, and to use your own database, you've got to export it to text file. If you particularly like using special inserts when exporting, don't do so when you export your own test file. The normal SQL dump will suffice. Also, await JustChris' major update to PSPMyAdmin: a manager application for all your SQL/CSV needs, especially if it's aligned in the PHPMyAdmin and MySQL Server department.

There bundled file does not come with a Readme, but copying the PSPMyAdmin folder to the GAME folder under PSP would set you in the right direction. For more input and inquiry towards the application, feel free to visit the author's thread at QJ.NET's PSP Development Forums and forward your comments there.

Homebrew developer JustChris is currently working on an organizer/database application for all PlayStation Portable (PSP) users. He dropped by QJ.Net Forums and released an early version of the program. It's called PSPMyAdmin and is actually based on the popular app phpMyAdmin.

If you're not familiar with the latter, take note that it is actually a popular organizer as it can be found in most web hosts that support MySQL. What it does is make updating MySQL databases easier with the use of a PHP-driven front end. PSPMyAdmind, now, does exactly the same with minor diffrences.

For one, the homebrew application is a stand alone program and utilizes external files for storage. JustChris also mentioned that PSPMyAdmin works with MySQL scripts and not the encoded database files themselves. However, that shouldn't be a problem because the scripts are just commands to edit databases, meaning they can be transferred to any MySQL host.

Like we said earlier, this is an early version and as such, the program only allows users to browse through the table names of the database as well as some of the "insert" command associated with the rows in the tables. Currently, it just reads files named "test.sql" that must be placed in the same folder as the EBOOT itself.

PSPMyAdmin was tested on Fw 2.7 but JustChris noted that it should work on most firmwares but not on FW 1.5. Proposed features for the next release include:

• Read from any compatible file in the directory
• Export/import phpMyAdmin SQL dump, so scripts are transferrable to host
• Read and edit following file formats: SQL script, CSV files, (maybe) XML
• Work with all files in a spreadsheet like format
• New GUI, with a clean look, visual effects and presentation
• Search feature, probably simple at first