Application Design and PostgreSQL 
Author Message
 Application Design and PostgreSQL


> But then i thought: Do i really need complex middleware or is it just
> a wrapper around PostgreSQL??

Your original thinking is correct.  You want a front-end (client),
some middleware that implements your business logic, and then the

The client should be a basic display/input tool, ideally a browser.
Every computer has one these days.

The middleware is the part that is particularly custom to your
world.  It should be written as portably as possible, for example
Java Servlets in a container such as Tomcat (free) or JRun (not

The communication to the database engine should be only ANSI SQL via

By doing this, you will not be at the mercy of any vendor.  You can
swap database engines if desired.  You can play Oracle off against
Informix or Sybase by saying, "It doesn't really matter to me, give
me your best deal."

Every vendor will try to get you to use their proprietary extensions
and/or 4GL.  Be very aware of the hidden costs of such things.  Use
the extensions if it is the =only= way you can build your

We've been through this design cycle several times for some very
large applications, and we've gotten smarter (you might even say
paranoid) about vendor lock-in each time.

> I think its possible to implement the whole logic inside postgresql.

Perhaps.  And if your application is for internal use only, and you
never imagine selling a license version to anyone, and you'll never
get into the ASP business with your app, go for it.

But some day, some pesky customer will say, "Yes, but we've already
got a site license to Informix and a bunch of Informix DBAs so we
won't buy unless it can run on Informix (replace your favorite
annoying commercial database vendor here).  Layer your application
properly and you can say, "We think that would be a mistake, but we
can accomodate your need."


  Eldorado Computing, Inc.   602-604-3100
     5353 North 16th Street, Suite 400
       Phoenix, Arizona   85016-3228

---------------------------(end of broadcast)---------------------------

Sat, 10 Jan 2004 00:55:13 GMT
 [ 1 post ] 

 Relevant Pages 

1. Application Design and PostgreSQL

2. VLSI design data in PostgreSQL?

3. Visual design tools for Postgresql

4. PostgreSQL 7.2 for real-life applications

5. Distributing postgresql with my application

6. Deployment of PostgreSQL Applications

7. ERP Applications on Postgresql -- ERPTool

8. [Fwd: Bug#184566: security threat to postgresql applications]

9. Success: Finished porting application to postgreSQL

10. Porting Web application written in Oracle 8 PL/SQL to Postgresql

11. Porting Web application written in Oracle 8 PL/SQL to Postgresql

12. Success: Finished porting application to postgreSQL

Powered by phpBB® Forum Software