Postgres and Processing

Programming Questions

readywater

in Programming Questions • 3 years ago

Was wondering if there was anything in the processing community for working with postgres SQL servers? I've never done any SQL work in Java before (I've done a lot with mySQL and PHP though), but looking at the Postgres JDBC javadocs, I was kind of hoping to find something simpler here.

Context wise: I'm building up a set of data visualizers for GPS data generated from physical outdoor games. Hopefully I'll be able to release all my code at the end, but take a look: http://redrover.normativelabs.com/

Replies(1)

PhiLho

Re: Postgres and Processing

3 years ago

If you search the old forum, you will find several topics about using Processing with databases, mostly with MySQL. Thanks to JDBC, the base interface to all databases is the same, providing you supply the right driver for your database, and the right connection string.

Actually, there is a SQL library, listed in the Libraries page of Processing. It is named SQLibrary by Florian Jenett and despite its description, I see it is shipped with a driver for PostgreSQL, so it should work out of the box.

Top Reply