QJ.net Game Discussion - PSP, Xbox, Wii, PS3, PSP Homebrew, and PSP Guides

**JustChris** · 07-09-2007, 09:29 PM

With PSPMyAdmin it will be possible to take your database or spreadsheet on the go, read from them and edit them. Currently I'm only interested in MySQL support but being able to read CSV files will be *much* easier to do.

Screen

Download

PSPMyAdmin

Instructions
- Unzip and move folder into PSP/GAME folder. Notice the test.sql file in it.
- Launch the program.
- It will tell you to press square, so go ahead and do it.
- The program will read test.sql and produce a new file called out.txt
- You will see the table and column names from the file that it read
- Exit the program by pressing start.
- Go back into the PSP/GAME/pspmyadmin folder. The new out.txt file should be there.
- Open the file, and you'll see that the queries were re-ordered as showing how many of each there are. There's also an easter egg

(the program writes *nix style newlines, so the text might appear bunched together in Notepad. Use something besides Notepad to open it)

For webmasters that want to test their own SQL files
This is for website owners running MySQL and PHPMyAdmin.

You should know the basics of exporting a database, so just select the SQL option and do not check any of the special inserts (complete, extended, delayed or ignore). PSPMyAdmin will only read normal insert queries. Copy and paste the text of your SQL dump and save it in a new file called test.sql. Just use this instead of the test.sql that came with the program.

PSPMyAdmin is made with a slightly modified OldSchool Lib to handle the graphics and input. The changes I made to OSLib were replacing some C library includes with their C++ counterparts. The code that parses MySQL syntax is written by myself.

**FaT3oYCG** · 07-09-2007, 09:59 PM

this is a nice app is it the one ur useing for the compo 2007 if u change the name and stuff

**Glynnder** · 07-10-2007, 01:47 AM

great name

Good looking program too, i might download in the future

**JustChris** · 09-25-2007, 10:30 PM

I'm back as well, and now doing some more work on the program. There's a test program if you want to check it out!

**CodesRCool** · 09-29-2007, 08:31 AM

yay, I like it!

**Greyone** · 09-29-2007, 08:41 AM

spreadsheets on the go! that's sexy.lol.

anyways nice idea

DDragonz · 09-29-2007, 02:34 PM

You cant do anything in the program itself. You only press once squire and thats it?

**JustChris** · 10-01-2007, 09:08 PM

Yeah, that's it for now. All it does now is re-arrange the query syntax and save it in a new file, so it's only proof of concept for parsing SQL files. Changing the data will be a little harder, since I need to come up with a good interface to type text on the PSP.

**Josh1billion** · 11-03-2007, 10:47 PM

Interesting concept you have there. I use phpMyAdmin on a daily basis.

**JustChris** · 11-04-2007, 02:44 PM

Sorry, I have been too busy working on school programming projects, and my own PSP game to continue with this much. Finding the best data structures for representing a MySQL database was a bit tough.

I would probably use oldrider's PSP Framework so that I can focus less on programming and getting results faster, since it uses OSLib.

07-09-2007, 09:29 PM	#1
JustChris Developer Join Date: Oct 2005 Posts: 206 Trader Feedback: 0	pspMyAdmin - database administration tool With PSPMyAdmin it will be possible to take your database or spreadsheet on the go, read from them and edit them. Currently I'm only interested in MySQL support but being able to read CSV files will be much easier to do. Screen Download PSPMyAdmin Instructions - Unzip and move folder into PSP/GAME folder. Notice the test.sql file in it. - Launch the program. - It will tell you to press square, so go ahead and do it. - The program will read test.sql and produce a new file called out.txt - You will see the table and column names from the file that it read - Exit the program by pressing start. - Go back into the PSP/GAME/pspmyadmin folder. The new out.txt file should be there. - Open the file, and you'll see that the queries were re-ordered as showing how many of each there are. There's also an easter egg (the program writes nix style newlines, so the text might appear bunched together in Notepad. Use something besides Notepad to open it) For webmasters that want to test their own SQL files* This is for website owners running MySQL and PHPMyAdmin. You should know the basics of exporting a database, so just select the SQL option and do not check any of the special inserts (complete, extended, delayed or ignore). PSPMyAdmin will only read normal insert queries. Copy and paste the text of your SQL dump and save it in a new file called test.sql. Just use this instead of the test.sql that came with the program. PSPMyAdmin is made with a slightly modified OldSchool Lib to handle the graphics and input. The changes I made to OSLib were replacing some C library includes with their C++ counterparts. The code that parses MySQL syntax is written by myself. __________________ GameSnooper - Random drawing of gaming news The 32 Bit Shell - My development blog (also includes gaming oddities) Last edited by JustChris; 09-25-2007 at 10:29 PM..

09-25-2007, 10:30 PM	#4
JustChris Developer Join Date: Oct 2005 Posts: 206 Trader Feedback: 0	I'm back as well, and now doing some more work on the program. There's a test program if you want to check it out! __________________ GameSnooper - Random drawing of gaming news The 32 Bit Shell - My development blog (also includes gaming oddities)

09-29-2007, 08:41 AM	#6
Greyone Join Date: Jul 2007 Location: with my companion Posts: 2,151 Trader Feedback: 0	spreadsheets on the go! that's sexy.lol. anyways nice idea __________________ PSN: Greyone16

10-01-2007, 09:08 PM	#8
JustChris Developer Join Date: Oct 2005 Posts: 206 Trader Feedback: 0	Yeah, that's it for now. All it does now is re-arrange the query syntax and save it in a new file, so it's only proof of concept for parsing SQL files. Changing the data will be a little harder, since I need to come up with a good interface to type text on the PSP. __________________ GameSnooper - Random drawing of gaming news The 32 Bit Shell - My development blog (also includes gaming oddities)

11-03-2007, 10:47 PM	#9
Josh1billion Join Date: May 2005 Location: Wisconsin Posts: 295 Trader Feedback: 0	Interesting concept you have there. I use phpMyAdmin on a daily basis. __________________ Original PSPHacker.com member :: Game programmer/designer/director

07-09-2007, 09:59 PM	#2
FaT3oYCG Developer and Tutor. My Mood: Join Date: Jul 2007 Real First Name: Craig Location: Widnes, England Just Played: Life. Posts: 1,646 Trader Feedback: 0	this is a nice app is it the one ur useing for the compo 2007 if u change the name and stuff

09-29-2007, 08:31 AM	#5
CodesRCool Join Date: Oct 2006 Location: The Netherlands Posts: 248 Trader Feedback: 0	yay, I like it!

09-29-2007, 02:34 PM	#7
DDragonz Join Date: Jun 2007 Posts: 21 Trader Feedback: 0	You cant do anything in the program itself. You only press once squire and thats it?

11-04-2007, 02:44 PM	#10
JustChris Developer Join Date: Oct 2005 Posts: 206 Trader Feedback: 0	Sorry, I have been too busy working on school programming projects, and my own PSP game to continue with this much. Finding the best data structures for representing a MySQL database was a bit tough. I would probably use oldrider's PSP Framework so that I can focus less on programming and getting results faster, since it uses OSLib. __________________ GameSnooper - Random drawing of gaming news The 32 Bit Shell - My development blog (also includes gaming oddities)

QJ.net Game Discussion - PSP, Xbox, Wii, PS3, PSP Homebrew, and PSP Guides

pspMyAdmin - database administration tool