Chive: phpMyAdmin alternative?

Update: It was announced in July 2014 that Chive is no longer actively developed and maintained.

I recently discovered Chive from Yii‘s home page, one of my most frequently visited site recently since I’m currently working on a project based on Yii Framework.

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.

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.

User Interface

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.

Database Manipulation

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

phpMyAdmin is well documented (even in several different languages) and has quite a few supports and forums.

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.

The verdict?

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.

3 thoughts on “Chive: phpMyAdmin alternative?

  1. Richard Gaskin Reply

    I found this very helpful and i find that with phpmyadmin you can only login using localhost but iv not used it enough to say it’s fact.
    thanks for the information on both of these database managers it helped a lot

Leave a Reply

Your email address will not be published. Required fields are marked *