Jump to content


Photo

MySQL Quick Admin... What do you guys think?


  • This topic is locked This topic is locked
24 replies to this topic

#1 Masna

Masna
  • Staff Alumni
  • Advanced Member
  • 288 posts
  • LocationNew York

Posted 30 October 2006 - 03:12 AM

Hey everyone. My buddy Jeff and I have been working on this project for quite some time, really putting in as much effort as possible, and I'd love some reviews!

It's called "MySQL Quick Admin." It's a webscript MySQL database manager (yeah, like phpMyAdmin). The URL to our site is mysqlquickadmin.com. There's a demo on the site if you're willing to give it a try.

I've worked so hard on this, so I really hope I get some decent reviews.

Thanks a lot!
I like LoL.

#2 tomfmason

tomfmason
  • Staff Alumni
  • Advanced Member
  • 1,696 posts
  • Locationstealing your wifi

Posted 30 October 2006 - 07:09 AM

I like the functionality. I also love that it does not use that annoying frame that phpmyadmin does.

Good Job.

Tom

Traveling East in search of instruction, and West to propagate the knowledge I have had gained.

current projects: pokersource

My Blog | My Pastebin | PHP Validation class | Backtrack linux


#3 Masna

Masna
  • Staff Alumni
  • Advanced Member
  • 288 posts
  • LocationNew York

Posted 30 October 2006 - 10:37 PM

I like the functionality. I also love that it does not use that annoying frame that phpmyadmin does.

Good Job.

Tom


Thank you!

Anyone else?
I like LoL.

#4 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 30 October 2006 - 11:06 PM

Very nice, there are a few thing's In my opinion I can point out.
1. The bottom bar, the color could probably be a lot better.
2. That same annoying color can be found throughout the table's when they are highlighted.  The reason I don't like this color ocmbination is because at the bottom you can't see the link's very well, and it's a little hard on the eye's the same for the list of tables you can see.
3. It seem's functionally slow, but it might be my computer.  Maybe you could optimize the coding some.
4. There is a color around the outside of the whole thing, I think a little darker grey would look better.  IT's just a different idea
5.  Most of my idea's would just be messing around with the color's other than blue some, the blue type color is perfect for this type of program.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#5 the_oliver

the_oliver
  • Members
  • PipPipPip
  • Advanced Member
  • 364 posts
  • LocationSurrey, UK

Posted 01 November 2006 - 12:24 AM

Grate!  Couldnt agree more about the previous 'does not use that annoying frame' coment!

#6 Masna

Masna
  • Staff Alumni
  • Advanced Member
  • 288 posts
  • LocationNew York

Posted 01 November 2006 - 12:29 AM

Very nice, there are a few thing's In my opinion I can point out.
1. The bottom bar, the color could probably be a lot better.
2. That same annoying color can be found throughout the table's when they are highlighted.  The reason I don't like this color ocmbination is because at the bottom you can't see the link's very well, and it's a little hard on the eye's the same for the list of tables you can see.
3. It seem's functionally slow, but it might be my computer.  Maybe you could optimize the coding some.
4. There is a color around the outside of the whole thing, I think a little darker grey would look better.  IT's just a different idea
5.  Most of my idea's would just be messing around with the color's other than blue some, the blue type color is perfect for this type of program.


Well, we just implemented a new theme system in which users can submit themes. I suggest you make a few color revisions, and submit your theme!

Thanks for the comments!

Anyone else? Hehe.
I like LoL.

#7 steelmanronald06

steelmanronald06
  • Staff Alumni
  • Advanced Member
  • 2,004 posts
  • LocationOk

Posted 01 November 2006 - 02:53 AM

i hate to sound all Web 2.0 ( I hate that term), but how about some AJAX? There is this guy who works with me in telecommunications who knows php, and he made something similar to phpmyadmin for his personal use that uses AJAX.  It is really awesome.

#8 Masna

Masna
  • Staff Alumni
  • Advanced Member
  • 288 posts
  • LocationNew York

Posted 01 November 2006 - 03:09 AM

i hate to sound all Web 2.0 ( I hate that term), but how about some AJAX? There is this guy who works with me in telecommunications who knows php, and he made something similar to phpmyadmin for his personal use that uses AJAX.  It is really awesome.


AJAX with a webscript this complicated will run very slow. We've considered it.
I like LoL.

#9 jcombs_31

jcombs_31
  • Staff Alumni
  • Advanced Member
  • 2,066 posts
  • LocationFL

Posted 01 November 2006 - 08:04 PM

I didn't go deep into it, but it looks like you've done a good job so far.  But, what is the real advantage to using your software over the proven phpmyadmin?

#10 Masna

Masna
  • Staff Alumni
  • Advanced Member
  • 288 posts
  • LocationNew York

Posted 02 November 2006 - 12:19 AM

I didn't go deep into it, but it looks like you've done a good job so far.  But, what is the real advantage to using your software over the proven phpmyadmin?


Well, it's prettier, simpler (yet not really), and the coding is so much more organized (and blatantly superior to that of phpMyAdmin).

Other than that... I worked really hard, so it'd make me rather gleeful if you use it! :D
I like LoL.

#11 448191

448191
  • Staff Alumni
  • Advanced Member
  • 3,545 posts
  • LocationNetherlands

Posted 02 November 2006 - 12:29 AM

I didn't go deep into it, but it looks like you've done a good job so far.  But, what is the real advantage to using your software over the proven phpmyadmin?


Well, it's prettier, simpler (yet not really), and the coding is so much more organized (and blatantly superior to that of phpMyAdmin).

Other than that... I worked really hard, so it'd make me rather gleeful if you use it! :D


Whahhahaaa.... Well, not that it is relevant for anything of this type, at least it looks better.  :P Personally I've never cared much for phpmyadmin and sorts, what's wrong actually using SQL? Control freak all the way baby... :P

#12 jcombs_31

jcombs_31
  • Staff Alumni
  • Advanced Member
  • 2,066 posts
  • LocationFL

Posted 02 November 2006 - 12:13 PM

I didn't go deep into it, but it looks like you've done a good job so far.  But, what is the real advantage to using your software over the proven phpmyadmin?




Well, it's prettier, simpler (yet not really), and the coding is so much more organized (and blatantly superior to that of phpMyAdmin).

Other than that... I worked really hard, so it'd make me rather gleeful if you use it! :D


Whahhahaaa.... Well, not that it is relevant for anything of this type, at least it looks better.  :P Personally I've never cared much for phpmyadmin and sorts, what's wrong actually using SQL? Control freak all the way baby... :P


I'm not sure every host provides the option to terminal in.  I always use the command line while developing, or sometimes write my sql in notepad and copy and paste wherever I need.  Actually, that's the way I generally do it now because I like to have my building blocks handy whenever I need to replicate the database.

#13 steviewdr

steviewdr
  • Moderators
  • Advanced Member
  • 1,364 posts
  • LocationIreland

Posted 02 November 2006 - 12:25 PM

Quite nice.
How about a Import Database feature?

-steve

#14 Masna

Masna
  • Staff Alumni
  • Advanced Member
  • 288 posts
  • LocationNew York

Posted 02 November 2006 - 11:15 PM

Quite nice.
How about a Import Database feature?

-steve


Already implemented. Just use our Export Database feature to provide you with either a .sql file or a textarea of backup queries, then run all of the SQL as a batch query by clicking Run Query on the left pane. Just cut, paste, click. Done.
I like LoL.

#15 448191

448191
  • Staff Alumni
  • Advanced Member
  • 3,545 posts
  • LocationNetherlands

Posted 02 November 2006 - 11:18 PM

I'm not sure every host provides the option to terminal in.  I always use the command line while developing, or sometimes write my sql in notepad and copy and paste wherever I need.  Actually, that's the way I generally do it now because I like to have my building blocks handy whenever I need to replicate the database.


Definately not, but who needs the command line?

#16 steviewdr

steviewdr
  • Moderators
  • Advanced Member
  • 1,364 posts
  • LocationIreland

Posted 03 November 2006 - 05:27 PM

Definately not, but who needs the command line?

Me and several other people. Going faffing around with phpmyadmin - pfff. Go try and do a load of inner selects and see how far you get using phpmyadmin waiting and clicking for a website.

Already implemented. Just use our Export Database feature to provide you with either a .sql file or a textarea of backup queries, then run all of the SQL as a batch query by clicking Run Query on the left pane. Just cut, paste, click. Done.

Not so bad. It looks to work sound.

Im just worried how scable this is. Like export doesnt gzip the output. a 100mb database could be zipped to ~8mb.
Also - does it handle foreign keys?

Anyways - for a nice easy and quick and handy mysql interface - its quite good.

-steve

#17 448191

448191
  • Staff Alumni
  • Advanced Member
  • 3,545 posts
  • LocationNetherlands

Posted 03 November 2006 - 10:24 PM

Me and several other people. Going faffing around with phpmyadmin - pfff. Go try and do a load of inner selects and see how far you get using phpmyadmin waiting and clicking for a website.


I don't use phpmyadmin, nor the command line (except on my local test server).

#18 obsidian

obsidian
  • Staff Alumni
  • Advanced Member
  • 3,202 posts
  • LocationSeattle, WA

Posted 08 November 2006 - 08:57 PM

Mansa, check your input values in all your fields in your login form. You're open to XSS in your demo. Your "Host" field isn't doing any checking against HTML input, and apparently, there is no maxlength check, either. I was able to insert a javascript and output the cookie from your session to the screen. Double check your input fields, but overall, it seems very sturdy. Impressive.

Keep up the good work. I look forward to seeing more of it.
You can't win, you can't lose, you can't break even... you can't even get out of the game.

<?php
while (count($life->getQuestions()) > 0)
{   $life->study(); } ?>
  LINKS: PHP: Manual MySQL: Manual PostgreSQL: Manual (X)HTML: Validate It! CSS: A List Apart | IE bug fixes | Zen Garden | Validate It! JavaScript: Reference Cards RegEx: Everything RegEx

#19 Masna

Masna
  • Staff Alumni
  • Advanced Member
  • 288 posts
  • LocationNew York

Posted 10 November 2006 - 01:25 AM

Mansa, check your input values in all your fields in your login form. You're open to XSS in your demo. Your "Host" field isn't doing any checking against HTML input, and apparently, there is no maxlength check, either. I was able to insert a javascript and output the cookie from your session to the screen. Double check your input fields, but overall, it seems very sturdy. Impressive.

Keep up the good work. I look forward to seeing more of it.


I will look into that. Anyhow, thank you!
I like LoL.

#20 Zane

Zane
  • Administrators
  • Advanced Member
  • 4,134 posts

Posted 10 November 2006 - 01:43 AM

reallly looks great....good job

one little glitch I noticed is that on your Search feature
you have Filter and Order switched.....

I don't quite know what Filter is for but I'm pretty sure you can ORDER by (1|2|3|4)

btn_donate_SM.gif Want to thank me? Contribute to my PayPal piggy-bank
 

172938.png




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users