Connecting to a postgresql Database on the Local machine

[ted creedon]

Apologies if I irked anyone with my e-mails.

I have a web based Electrical Contractor's inventory control/workorder
system written for IIS/SQL server with many of the attributes I mentioned in
my correspondence. Particularly the data design. The data design is really
important since the system needs to interface with whatever financial system
a customer already has. 

The system is designed and runs on windows CE on up to whatever has a
browser. It was easy to write and an administrative assistant can write
reports using sql queries. No real programming skill required for reports. 

Ease of report writing is what the business world expects.

Along the way, I've discovered all the hidden licensing hooks Microsoft has
built into their software. My system is just not salable due to the
licensing and admin overhead costs my customers would incur. A nice
prototype for internal use only.

I had thought of creating an interface between my system and Gnucash but the
uncertainty in Gnucash's direction makes me reluctant to pursue it. That's
why I proposed a design session or something along that line to insure that
I could always get to a Gnucash relational database of some kind. Or get
Gnucash XML into a relational database... The Gnucash XML to Excel DTD
illustrates this.

My preferred embodiment would be Linux based, rewriting my GUI for my IIS
web based system is no problem. This would allow portable embedded devices
(rfid/barcode/pen) to share the same code base as the workstation/servers.

As a final thought, I'm not sure my web based application is the way to go.

Linux based thin clients/handhelds using KNX/NX (compressed X, etc) look
more attractive than the Microsoft web based alternatives.

I'm busy reading the Gnucash business object definitions, thanks for the
pointers.

tedc