PostgreSQL Query Tool for BeOS BONE.
This is a query tool which allows you to connect to local and remote PostgreSQL databases to execute SQL queries.
It has been tested with a Linux PostgreSQL 7.1.3 server as well as a BeOS PostgreSQL 7.2 server and PostgreSQL 7.1.3 on BeOS.
I spent a lot of time trying to get a dynamically sized column class (Santas Gift Bag) working for the SQL results but decided to release this version which returns the data in a tab-separated text view form which can then be pasted into something nice like a Gobe Productive spreadsheet.
The screenshot above shows that.
This was built with Visual Be++ and the GUI is a little plain, but functional. It saves you from having to use the psql command line utility which ships with PostgreSQL. (not that there's anything wrong with it, i'm used to the command line ;) )
If you have trouble connecting to my site it's because my ISP may have disconnected me :( hopefully i'll be employed soon and be able to restore services :)
KNOWN BUGS:
May hang trying to connect to a server which is NOT running PostgreSQL accepting internet socket connections. (postmaster -i)
Apart from that it works ok. It will use the user name on your BeOS PC as the user to connect to the server, so if the user doesn't exist on your remote PostgreSQL server, then run the createuser command from the server to create it.
TO DO:
Add in userid and password to avoid the above issue.
Figure out how to create a dynamically sized column-list view on the fly.
Spruce it up a bit :)
