Arch Linux

lanrat

Member

From: Poland

Registered: 2003-10-28

Posts: 1,274

kpogre pkgbuild: kde gui for browsing and quering postgresql

Another finding in my quest for a perfect sql application.
BTW weird name for a package, isn't it?

This application seems to be almost untouched by a human feet so far (for unknown reason) but it's quite nice, I think. This means you will not find to many postings and docs about it :-) But give it a try...

kpogre PKGBUILD

pkgname=kpogre
pkgver=0.99
pkgrel=1
pkgdesc="Postgresql GUI frontend for KDE"
url="http://kpogre.sourceforge.net/"
depends=('kdelibs' 'libpqxx' 'postgresql')
source=(http://dl.sourceforge.net/sourceforge/kpogre/$pkgname-$pkgver.tar.gz)
md5sums=('8795d50585553b0262faad90495761b4')

build() {
  cd $startdir/src/$pkgname-$pkgver
  ./configure --prefix=/opt/kde 
        --with-extra-includes="/usr/include/pgxx -I /usr/include/postgresql"
  make || return 1
  make prefix=$startdir/pkg/opt/kde install
}

It would be better to have (at least) postgresql in makedepends instead of depends but I have to test if it's going to work (ldd says kpogre binary is linked to psql libraries). Feel free to test it yourself.

libpqxx PKGBUILD

pkgname=libpqxx
pkgver=2.2.7
pkgrel=1
pkgdesc="C++ client API library for Postgresql"
url="http://gborg.postgresql.org/project/libpqxx/projdisplay.php"
makedepends=('postgresql' 'openssl')
depends=('bash')
source=(ftp://gborg.postgresql.org/pub/libpqxx/stable/$pkgname-$pkgver.tar.gz)
md5sums=('1027218388f64f62213c6c7e4111c3e9')

build() {
  cd $startdir/src/$pkgname-$pkgver
  ./configure --prefix=/usr
  make || return 1
  make prefix=$startdir/pkg/usr install
}