Re: [HACKERS] PostgreSQL as an application server

2004-08-08 Thread matt nations
[EMAIL PROTECTED] (Ned Lilly) wrote in message news:<[EMAIL PROTECTED]>... > Jonathan, > > This is exactly how my company has built a very robust ERP application. See > www.openmfg.com. > Hi Mr. Lilly: I not sure who to address this question to at your company. I'm a valued added reseller wh

Re: [HACKERS] PostgreSQL as an application server

2004-08-08 Thread Jonathan M. Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 06 August 2004 10:00 am, J. Andrew Rogers wrote: > > The major disadvantage is that the development environment and tools > for in-database languages aren't nearly as rich as your typical > standalone environment, which makes programming a pa

Re: [HACKERS] PostgreSQL as an application server

2004-08-06 Thread J. Andrew Rogers
On Fri, 2004-08-06 at 10:53, Joshua D. Drake wrote: > Although the gap still exists within the environment itself, one > significant advantage with PostgreSQL is you can use a more native (to > the programmer anyway) language to generate your logic. > > With PostgreSQL alone you can use plPerl,

Re: [HACKERS] PostgreSQL as an application server

2004-08-06 Thread Joshua D. Drake
The major disadvantage is that the development environment and tools for in-database languages aren't nearly as rich as your typical standalone environment, which makes programming a pain in the ass for many types of codes. I might have missed something in the intervening years, but I Although th

Re: [HACKERS] PostgreSQL as an application server

2004-08-06 Thread J. Andrew Rogers
On Thu, 2004-08-05 at 22:27, Jonathan M. Gardner wrote: > A few nights ago, I implemented some of my application logic in PostgreSQL > via PL/PythonU. I was simply amazed at what I was able to do. My question > becomes: Why not get rid of the middle layer and move it into the databse > entirely?

Re: [HACKERS] PostgreSQL as an application server

2004-08-06 Thread Ned Lilly
Jonathan, This is exactly how my company has built a very robust ERP application. See www.openmfg.com. All the ERP business logic is in pl/pgsql (20,000+ lines, very high fiber content). The GUI is the Qt framework for C++, which gives us a client in Linux, Windows, Mac OS X, and even wireless

Re: [HACKERS] PostgreSQL as an application server

2004-08-06 Thread David Garamond
Jonathan M. Gardner wrote: Thoughts? Comments? Hasn't Oracle done something like this? Probably this is more suited to -general? I haven't done anything near this. I wonder how much more painful it is to debug the application, put it under version control, etc. Personally, I can't stand editing/d

[HACKERS] PostgreSQL as an application server

2004-08-05 Thread Jonathan M. Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Consider this. Most (well-written) applications are written in three layers. The data abstraction layer provides a clean interface to the underlying data so other people don't have to write SQL statements. The GUI layer handles all the GUI events an