Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Bike - phpMyAdmin replacement for geeks

webcheatsheet.com

Post reply on HN
Print view View original

1–10 of 47 posts

Re: Bike - phpMyAdmin replacement for geeks

#4

Post by jlogsdon »

drivebyacct2 wrote: post #2

I'm not sure which, but Bike either selling itself short, or overexaggerating it's abilities by comparing it to phpMyAdmin like this.

It looks like Bike is a simple query interface whereas phpMyAdmin is a whole suite of tools akin to the desktop Workbench for mysql (at least, the administrative side).

Re: Bike - phpMyAdmin replacement for geeks

#5

Post by charliesome »

verisimilitude wrote: post #3

I realize that this is a totally different strategy to solve the mySQL admin thing, but WOW is Sequel Pro great if you're on a Mac: http://www.sequelpro.com/ I used phpMyAdmin for 10 _years_, and switched after using Sequel Pro for 5 minutes.

For Windows users, HeidiSQL is also pretty damn good: http://www.heidisql.com/

Re: Bike - phpMyAdmin replacement for geeks

#6

Post by pilif »

The issue behind phpMyAdmin IMHO neither is the fact that it's written in PHP nor that it looks unsexy. The problem is that it exists.

It's too tempting to leave it running on some server and promptly forget it. Or get it installed without knowing by some third-party CMS.

Even if it had a spotless security track record (it doesn't), this is just too big an attack surface.

MySQL and especially Postgres have really good command line utilities you can use over SSH which will have the additional advantage of you learning DDL syntax for emergencies. And of course GUIs exist too (use SSH port forwarding).

About Bike: I didn't install it, but this looks like a pure frontend to type in queries and get back results. This provides the security problems of phpMyAdmin minus the specialized GUI to save you from learning DDL or server internals.

As such it provides the worst of both worlds. I wouldn't call that "phpMyAdmin for geeks". CLI mysql is phpMyAdmin for geeks.

Re: Bike - phpMyAdmin replacement for geeks

#8

Post by perssontm »

drivebyacct2 wrote: post #2

I'm not sure which, but Bike either selling itself short, or overexaggerating it's abilities by comparing it to phpMyAdmin like this.

I couldnt agree more, setting up Bike on every other server gives you the same maintenance headache(perhaps a little simpler) as having a version of phpMyAdmin on each.

I just yesterday wrote a blogpost about tunneling mysql and using a locally hosted phpMyAdmin for those needs. That will give you the benefit of having phpMyAdmin at one place and you'll be motivated to keep that updated and properly configured. http://text.krona.tm/post/25982176151/using-phpmyadmin-witho...

Re: Bike - phpMyAdmin replacement for geeks

#10

Post by shellox »

perssontm wrote: post #8
drivebyacct2 wrote: post #2

I'm not sure which, but Bike either selling itself short, or overexaggerating it's abilities by comparing it to phpMyAdmin like this.

I couldnt agree more, setting up Bike on every other server gives you the same maintenance headache(perhaps a little simpler) as having a version of phpMyAdmin on each. I just yesterday wrote a blogpost about tunneling mysql and using a locally hosted phpMyAdmin for those needs. That will give you the benefit of having phpMyAdmin at one place and you'll be motivated to keep that updated and properly configured. http:…

A bit of topic, but wasn't tm the expensive tld which you need to register for 10 years? When no can you tell me where you registered yours?
Post reply on HN