Is a remote connection to Postgres DB using SQLibrary possible?
in
Contributed Library Questions
•
1 year ago
In the PostgreSQL example for the SQLibrary (
http://bezier.de/processing/libs/sql/ ), it says that the example only works if the DB is on the local network. I can't seem to find anything in the documentation that suggests a way to differentiate the code to facilitate a remote-connection away from the local network.
Does anyone know if this can be done, or how?
PostgreSQL Example:
- // updated fjenett 20081129
- import de.bezier.data.sql.*;
- PostgreSQL pgsql;
- void setup()
- {
- size( 100, 100 );
- // this example assumes that you are running the
- // postgresql server locally (on "localhost").
- //
- // replace with your own postgresql-account.
- //
- String user = "fjenett";
- String pass = "fjenett";
- // name of the database to use
- //
- String database = "test";
- // connect to database on "localhost"
- //
- pgsql = new PostgreSQL( this, "localhost", database, user, pass );
- // connected?
- if ( pgsql.connect() )
- {
- // query the number of entries in table "weather"
- pgsql.query( "SELECT COUNT(*) FROM weather" );
- // results found?
- if ( pgsql.next() )
- {
- // nice, then let's report them back
- println( "number of rows in table weather: " + pgsql.getInt(1) );
- }
- // now let's query for last 10 entries in "weather"
- pgsql.query( "SELECT * FROM weather LIMIT 10" );
- // anything found?
- while( pgsql.next() )
- {
- // splendid, here's what we've found ..
- println( pgsql.getString("city") );
- }
- }
- else
- {
- // yay, connection failed !
- }
- }
1
