4 files changed, 115 insertions, 0 deletions
diff --git a/development/pd-psql/README b/development/pd-psql/README
new file mode 100644
index 000000000000..9cf60e6eb8fe
--- /dev/null
+++ b/development/pd-psql/README
@@ -0,0 +1,6 @@
+psql allows you to send SQL messages to a PostgreSQL database from Pd and
+retrieve the results.
+
+Please check the README file after installation.
+
+Untested for 64-bit, please inform on success.
diff --git a/development/pd-psql/pd-psql.SlackBuild b/development/pd-psql/pd-psql.SlackBuild
new file mode 100644
index 000000000000..c5ba9c825ae9
--- /dev/null
+++ b/development/pd-psql/pd-psql.SlackBuild
@@ -0,0 +1,80 @@
+#!/bin/sh
+# Slackware build script for <pd-psql>
+# Written by Michales Michaloudes korgie@gmail.com
+
+# Exit on most errors
+set -e
+
+PRGNAM=pd-psql
+VERSION=${VERSION:-2007}
+BUILD=${BUILD:-1}
+TAG=${TAG:-_SBo}
+if [ -z "$ARCH" ]; then
+  case "$( uname -m )" in
+    i?86) ARCH=i486 ;;
+    arm*) ARCH=arm ;;
+       *) ARCH=$( uname -m ) ;;
+  esac
+fi
+CWD=$(pwd)
+TMP=${TMP:-/tmp/SBo}	
+PKG=$TMP/package-$PRGNAM
+OUTPUT=${OUTPUT:-/tmp}
+SRCNAM=$(echo $PRGNAM | cut -f2 -d-)
+
+if [ "$ARCH" = "i486" ]; then
+  SLKCFLAGS="-O2 -march=i486 -mtune=i686"
+  LIBDIRSUFFIX=""
+elif [ "$ARCH" = "i686" ]; then
+  SLKCFLAGS="-O2 -march=i686 -mtune=i686"
+  LIBDIRSUFFIX=""
+elif [ "$ARCH" = "x86_64" ]; then
+  SLKCFLAGS="-O2 -fPIC"
+  LIBDIRSUFFIX="64"
+else
+  SLKCFLAGS="-O2"
+  LIBDIRSUFFIX=""
+fi
+
+rm -rf $PKG
+mkdir -p $TMP $PKG $OUTPUT
+cd $TMP
+rm -rf $PRGNAM
+tar xvf $CWD/$SRCNAM-$VERSION.tar.gz
+cd $SRCNAM
+
+# patch the Makefile
+sed -i "s|local/lib|lib${LIBDIRSUFFIX}|" Makefile
+
+chown -R root:root .
+find . \
+ \( -perm 777 -o -perm 775 -o -perm 711 -o -perm 555 -o -perm 511 \) \
+ -exec chmod 755 {} \; -o \
+ \( -perm 666 -o -perm 664 -o -perm 600 -o -perm 444 -o -perm 440 -o -perm 400 \) \
+ -exec chmod 644 {} \;
+
+CFLAGS="$SLKCFLAGS" \
+CXXFLAGS="$SLKCFLAGS" \
+make
+
+# manual copy the external
+mkdir -p $PKG/usr/lib${LIBDIRSUFFIX}/pd/extra
+cp -p psql.pd_linux $PKG/usr/lib${LIBDIRSUFFIX}/pd/extra
+
+find $PKG | xargs file | grep -e "executable" -e "shared object" | grep ELF \
+  | cut -f 1 -d : | xargs strip --strip-unneeded 2> /dev/null || true
+
+mkdir -p $PKG/usr/doc/$PRGNAM-$VERSION
+cd $TMP/$SRCNAM
+cp -a \
+   INSTALL LICENCE README \
+   $PKG/usr/doc/$PRGNAM-$VERSION
+mkdir -p $PKG/usr/lib${LIBDIRSUFFIX}/pd/extra/
+cp $TMP/$SRCNAM/help-psql.pd $PKG/usr/lib${LIBDIRSUFFIX}/pd/extra/
+cat $CWD/$PRGNAM.SlackBuild > $PKG/usr/doc/$PRGNAM-$VERSION/$PRGNAM.SlackBuild
+
+mkdir -p $PKG/install
+cat $CWD/slack-desc > $PKG/install/slack-desc
+
+cd $PKG
+/sbin/makepkg -l y -c n $OUTPUT/$PRGNAM-$VERSION-$ARCH-$BUILD$TAG.${PKGTYPE:-tgz}
diff --git a/development/pd-psql/pd-psql.info b/development/pd-psql/pd-psql.info
new file mode 100644
index 000000000000..4f7a0ea36101
--- /dev/null
+++ b/development/pd-psql/pd-psql.info
@@ -0,0 +1,10 @@
+PRGNAM="pd-psql"
+VERSION="2007"
+HOMEPAGE="http://svn.puredata.info/svnroot/pure-data/trunk/externals/postlude/psql/"
+DOWNLOAD="http://users.otenet.gr/~korgman/psql-2007.tar.gz"
+MD5SUM="4898a1dfbaac583d92582d650aa857da"
+DOWNLOAD_x86_64=""
+MD5SUM_x86_64=""
+REQUIRES="pd postgresql"
+MAINTAINER="Michales Michaloudes"
+EMAIL="korgie@gmail.com"
diff --git a/development/pd-psql/slack-desc b/development/pd-psql/slack-desc
new file mode 100644
index 000000000000..371a0e3c8a7b
--- /dev/null
+++ b/development/pd-psql/slack-desc
@@ -0,0 +1,19 @@
+# HOW TO EDIT THIS FILE:
+# The "handy ruler" below makes it easier to edit a package description.  Line
+# up the first '|' above the ':' following the base package name, and the '|'
+# on the right side marks the last column you can put a character in.  You must
+# make exactly 11 lines for the formatting to be correct.  It's also
+# customary to leave one space after the ':'.
+
+        |-----handy-ruler------------------------------------------------------|
+pd-psql: psql allows you to send SQL messages to a PostgreSQL database from
+pd-psql: Pd and retrieve the results.
+pd-psql: 
+pd-psql: Please check the README file after installation.
+pd-psql: 
+pd-psql: 
+pd-psql: 
+pd-psql: 
+pd-psql: 
+pd-psql: 
+pd-psql: