Thursday, December 04, 2008

PostgreSQL and Netbeans 6.5

With the release of JavaFX 1.0, a new version of Netbeans 6.5 is now also available. Let's quickly look at its current PostgreSQL Support.


The JDBC driver for PostgreSQL is integrated in Netbeans 6.5. It is  located at:


netbeans-6.5/ide10/modules/ext/postgresql-8.3-603.jdbc3.jar


As you can see it is pretty much upto sync to the latest (about a rev back since the latest is 604 build).  Clicking the Services tab of Netbeans shows Database where a new entry can be created using using the "Direct URL Entry" using the format as follows:


jdbc:postgresql://hostname/databasename


providing the user name and password for the connection and then the schema name (hint: public schema) in the Advanced Tab and press OK to create a new connection to PostgreSQL database.


Once connected clicking the expand sign which looks like  o- can  be expanded to see the Tables/Views/Procedures and more expansions can be done on Tables to see  data either using menu  options or using the SQL Editor.


With the PostgreSQL setup in place now it should be easier to program with your favorite language be it Java  or JavaFX , Python, PHP, Ruby, etc using PostgreSQL database as the backend.


( Note for myself:  Try out Greg Smith's pgtune project which uses Python with the new Netbeans's Python editor.)






Post a Comment