is very good, its fast & reliable, and skinned with a custom skin it looks not that bad; i've tried several other tools, even commercial one and i rate PHPmyAdmin as one of the best when it comes down to "performance-for-price".
Sure, it's a command-line interface -- but given that I do most of my Drupal work via drush these days, I'm more likely to just dive into the mySQL database directly from my ssh session than to bother opening another browser tab for most garden-variety db tasks. Then again, I'm not averse to typing SQL queries by hand.
Typically, I'm looking for something relatively simple, like this:
SELECT * FROM `node` WHERE nid IN (SELECT entity_id AS nid FROM `field_data_body` WHERE body_format = 'php_code');
I understand why many people prefer to use a web-based frontend with a graphical query builder, and that's fine for them. I just find that it slows me down.
Comments
Lelala (not verified)
23 October 2012 - 8:06am
Permalink
Altogether, PHPmyAdmin
is very good, its fast & reliable, and skinned with a custom skin it looks not that bad; i've tried several other tools, even commercial one and i rate PHPmyAdmin as one of the best when it comes down to "performance-for-price".
Barcodes (not verified)
29 January 2013 - 1:38pm
Permalink
PHPmyAdmin
We use PHPmyAdmin, and it works well for us - fast and reliable
hotwebmatter (not verified)
12 April 2013 - 11:39am
Permalink
I prefer "drush sqlc"
Sure, it's a command-line interface -- but given that I do most of my Drupal work via drush these days, I'm more likely to just dive into the mySQL database directly from my ssh session than to bother opening another browser tab for most garden-variety db tasks. Then again, I'm not averse to typing SQL queries by hand.
Typically, I'm looking for something relatively simple, like this:
SELECT * FROM `node` WHERE nid IN (SELECT entity_id AS nid FROM `field_data_body` WHERE body_format = 'php_code');I understand why many people prefer to use a web-based frontend with a graphical query builder, and that's fine for them. I just find that it slows me down.
Add new comment