Re:AJAX PHPMyAdmin Alternative
by ErrantX on Friday October 23, 2009 @02:49PM
(#899389)
Not bad.
I just gave it a shot - 3 things occured to me.
Firstly despite their claims it is fairly similar to PHPMyAdmin but with some Ajaxy stuff and a different layout (not a bad thing - though it is not as "friendly" feeling at times).
Secondly I dont like the login with DB details thing; anyone sensible has long, secure, passwords and I certainly cant recall all my database IP addresses :P
Thirdly I dont like the idea of installing it directly into a website subdirectory like that. Having MySQL administration accessible from my hosts control panel (i.e. unrelated to my domain) feels safer. I can see this becoming a decent alternative to PHPMyAdmin if hosts pick it up as an option!
I have to admit I LOVE the simplicity of the install. Kudos for that - it was as simple as they promise.
Re:AJAX PHPMyAdmin Alternative
by vaporstun on Friday October 23, 2009 @02:57PM
(#899400)
I actually liked that it was similar to PHPMyAdmin. I was looking for an alternative because I was tired of how heavy it was and came upon this. I was also tired of constantly refreshing PHPMyAdmin which, due to its heft, took quite awhile. SQLBuddy had neither of those issues.
Re:AJAX PHPMyAdmin Alternative
by vaporstun on Friday October 23, 2009 @03:07PM
(#899420)
Hah yeah, they are a bit grandiose and set up unreasonable expectations. I sincerely hope no one takes their claim that this will "change the way people think about MySQL" too seriously.
Re:AJAX PHPMyAdmin Alternative
by mwexler on Friday October 23, 2009 @06:24PM
(#899744)
Nice, but since it's not being developed anymore, might be useful to mention their referral to http://www.gosu.pl/dbkiss/ which is also 1 file, easy to install, and pretty easy to use... and supports both MySQL and PostgreSQL.
Re:AJAX PHPMyAdmin Alternative
by timdorr on Friday October 23, 2009 @07:29PM
(#899813)
While we're on the single file, lightweight bandwagon, there's also Adminer: http://www.adminer.org/en/ Works pretty well and still looks halfway decent.
Re:AJAX PHPMyAdmin Alternative
by wenbert on Saturday October 24, 2009 @01:00AM
(#900132)
I tried the GUI tools. But what I love about the web interface is the ability to CTRL + F anything on the page. And I can also "copy" any text I want in it.
I know, I know, I could do it with SQL but I have noted a remarkable ability at the day job to forget to include the where clause after a week of crunch. That can have remarkably negative consequences, particularly since the Rails DB doesn't have any particular constraints on it. (It has ActiveRecord validations and, beyond that, you typically have to type more stuff, rather than less stuff, to cause massive screwups.)
Re:AJAX PHPMyAdmin Alternative
by FalcorTheDog on Saturday October 24, 2009 @02:24AM
(#900192)
Very cool alternative to PHPMyAdmin. They'd have to add support for foreign keys for me to make the switch though. Also, I'm not sure it actually uses any AJAX at all (at least not that I've noticed). Lots of pretty JavaScript though. shrugs
I just gave it a shot - 3 things occured to me.
Firstly despite their claims it is fairly similar to PHPMyAdmin but with some Ajaxy stuff and a different layout (not a bad thing - though it is not as "friendly" feeling at times).
Secondly I dont like the login with DB details thing; anyone sensible has long, secure, passwords and I certainly cant recall all my database IP addresses :P
Thirdly I dont like the idea of installing it directly into a website subdirectory like that. Having MySQL administration accessible from my hosts control panel (i.e. unrelated to my domain) feels safer. I can see this becoming a decent alternative to PHPMyAdmin if hosts pick it up as an option!
I have to admit I LOVE the simplicity of the install. Kudos for that - it was as simple as they promise.
http://dev.mysql.com/downloads/gui-tools/5.0.html
c = Customer.find_by_username "[email protected]"
c.username = "[email protected]"
c.save!
I know, I know, I could do it with SQL but I have noted a remarkable ability at the day job to forget to include the where clause after a week of crunch. That can have remarkably negative consequences, particularly since the Rails DB doesn't have any particular constraints on it. (It has ActiveRecord validations and, beyond that, you typically have to type more stuff, rather than less stuff, to cause massive screwups.)