Update: It was announced in July 2014 that Chive is no longer actively developed and maintained.
What is Chive? from the site:
Chive is a free, open source, web-based database management tool, designed to bring joy to web developers – with easy administration, super fast UI and state of the art web technologies.
I downloaded a copy (v102) and have been using it for a few weeks.
I’ve been using phpmyadmin for many years to manage MySQL databases. I rely on it so much I’ve forgotten most SQL commands. It provides a nice interface for most of my needs.
Please note that this is not going to be thorough comparision. Just a simple comparison based on my usage.
both are free, open source and web-based database management tools.
Installation and Configuration
Both are installed by uncompressing the downloaded file and copying to selected server directory. Once web server is configured both can be accessed via browser.
phpMyAdmin requires configuration before using it (and requires some understanding of various configurations). Chive runs out of the box.
Both have similar user interface, but I like the default look for chive. It looks more modern and fresh.
phpMyAdmin look dated but can be themed. There are also options to change certain appearances. chive doesn’t have such option.
Chive can only manipulate one databases on the same server at any one time.
phpMyAdmin, once configured, can access many databases on different servers from the same interface.
Chive does not have the ‘operations’ functions like phpMyAdmin. There are no interfaces to copy / rename database / tables. There are interfaces to run commands for such operations, but as I said, I’ve forgotten most of those commands and syntax. It’s doable but inconvenient.
Chive has interface to create store procedures and triggers with function template.
Documentation and Help
There are not documentation for chive (yet?) but there is a forum.
I don’t used both forums much so I can’t comment how helpful or friendly they are.
I like the look and feel of Chive. It can do most basic database and table manipulations, but lacking the ‘operations’ functions makes it inconvenient, as there are many changes I need to do throughout project development.
Chive is still new and has potential to grow. I’m looking forward to more improvements.
At this stage I will continue to use phpMyAdmin. Mainly because i work on serveral databases and several servers. It provides an easy interface to switch servers. I can’t live without the ‘operations’ functions.