Complete Unity + Pure Data + OSC game audio project for download
Document Actions
psql
Category: Libraries and externals
—
Other products by this author
Current release
No stable release available yet.
If you are interested in getting the source code of this project, you can get it from the code repository.
Experimental releases
There are no experimental releases available at the moment.
Project Description
- Project resources
Releases
Code repository'psql' allows you to send SQL messages to a PostgreSQL database from Pd and retrieve the results. In order to use the 'psql' external you will need to install PostgreSQL - available from http://www.postgresql.org. As with all applications that connect to a PostgreSQL database, 'psql' requires the 'postmaster' daemon to be running.
'psql' may connect to a database on a local host or on a remote machine via TCP/IP (handled by the external).
If no arguments are specified in 'psql' - messages will be sent to a postmaster via a local UNIX socket and will attempt to connect to the default PostgreSQL 'template1' database. Such a connection may be used to create new database by sending the SQL message: 'CREATE DATABASE databasename'. Before this can be done, you will need to set your username as a PostgreSQL user. This can be done from a PostgreSQL superuser account (not root) generally called 'postgres' which handles database administrative duties including access privileges.
