Chive, SQL management in Gentoo
8/04/2011Chive is a newer, lightweight SQL database manager comparable to phpMyAdmin. In essence, it is a web gui that allows you to complete all of your SQL needs without the hassle of dealing with the terminal. I can’t remember what I was doing, but I stumbled across Chive while I was playing around with Arch Linux, and really started liking its simplicity and speed. In fact, Chive was so much faster than phpMyAdmin that I canned it and started using Chive regularly.
There isn’t an ebuild in portage (or one of its overlays) yet, but it really isn’t that hard to install it either. I installed it in my webapps folder and created an additional alias in my http.conf, and it worked like a charn in Gentoo.
First things, make sure that your dev-lang/php has (at least) these use flags; apache2 curl gd gdbm json mysql pdo. If not, then re-emerge.
Next, as root, navigate to /usr/share/webapps and run the following command:
wget -O - http://launchpad.net/chive/0.4/0.4.0/+download/chive_0.4.1.tar.gz|tar -xzp
Lasly, add this to the end of /etc/apache2/httpd.conf:
Alias /chive "/usr/share/webapps/chive"
<directory "/usr/share/webapps/chive">
Options Indexes MultiViews
AllowOverride None
Order allow,deny
Allow from all
</directory>
To read more about Chive, check out their home page.