Re: I just got it: PostgreSQL Application Server -- a new project.

From: "Thomas Hallgren" <thhal(at)mailblocks(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>, "Carl E(dot) McMillin" <carlymac(at)earthlink(dot)net>, <pgsql(at)mohawksoft(dot)com>
Subject: Re: I just got it: PostgreSQL Application Server -- a new project.
Date: 2004-06-12 20:11:35
Message-ID: thhal-0oPumAVcvTtsqi/ege49HRvOWn8OhVK@mailblocks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The term "App-server" is very commonly used to describe the container where
the application logic resides. As such, an app-server has access to one or
several Storages. PostgreSQL is an implementation of such a storage. The
thing you describe, "a container for functionality that persists
control/data state beyond a single invocation" is also a Storage.

It's very common that you impose a separation of concern that imposes 3 (or
more) layers (3-tier, n-tier). You have the backend tier, a middle tier, and
a client tier. PostgreSQL inherently belongs in the backend tier. An
app-server is more or less always considered to be the thingy that lives in
the middle tier.

The ability to persist the state of a session, efficient handling when
storing HTML/XML, and cluster capabilities, will make PostgreSQL an
excellent backend for many app-servers that can utilize that kind of
functionality. It will not however, make PosgreSQL an app-server in itself.

I really think that pgsql(at)mohawksoft(dot)com has great ideas (B.T.W. it would be
nice to know your name) and I'd be happy to help out if this project takes
off. But some other name for it would be preferable.

Kind regards,

Thomas Hallgren

----- Original Message -----
From: "Carl E. McMillin" <carlymac(at)earthlink(dot)net>
To: "'Thomas Hallgren'" <thhal(at)mailblocks(dot)com>;
<pgsql-hackers(at)postgresql(dot)org>
Sent: Saturday, June 12, 2004 20:24
Subject: RE: [HACKERS] I just got it: PostgreSQL Application Server -- a new
project.

If you consider an app server as a container for functionality that persists
data/control state beyond a single invocation, PostgreSQL (and lots of other
DP solutions, of course) falls into the category already, ne?

I suppose my def. is too gross, but I agree with pgsql(at)mohawksoft(dot)com's
conjecture that Postgres COULD provide "externalization" hooks so that the
SQL engine could integrate external services/data-sources without
recompiling the backend, postmaster, or any other kind of major (and
dangerous) restructuring.

I believe that some of the contribs (like PL/Perl) have functionality for
controlling external processes from stored-procedures, but this kind of
functionality should be in the "kernel" of the engine, in my mind.

If I'm totally offbase, plz correct.

Carl <|};-)>

-----Original Message-----
From: pgsql-hackers-owner(at)postgresql(dot)org
[mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Thomas Hallgren
Sent: Saturday, June 12, 2004 9:47 AM
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] I just got it: PostgreSQL Application Server -- a new
project.

Even if I find the concepts as such very interesting, I think the term
"Application Server" is very misleading. People would get very confused and
place PostgreSQL in the same category as JBoss, Jonas, Apache Geronimo, IBM
Websphere, BEA Weblogic to name a few well known App-servers.

IMHO, you really need some other umbrella name for this.

Kind regards,

Thomas Hallgren

""Carl E. McMillin"" <carlymac(at)earthlink(dot)net> wrote in message
news:000801c4508b$8c2ef3a0$6500a8c0(at)DEVSONY(dot)(dot)(dot)
Jumping on that bandwagon with all 6 feet!

Carl <|};-)>

-----Original Message-----
From: pgsql-hackers-owner(at)postgresql(dot)org
[mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of
pgsql(at)mohawksoft(dot)com
Sent: Friday, June 11, 2004 9:38 PM
To: pgsql-hackers(at)postgresql(dot)org
Subject: [HACKERS] I just got it: PostgreSQL Application Server -- a new
project.

I have been harping for the last few days (years, actually) about tweaks and
changes to PostgreSQL for a number of reasons ranging from session
management to static tables. I even had a notion to come up with msession on
PostgreSQL.

I have been incorporating full text search, recommendations, and a slew of
other features into PostgreSQL, but you know what? While it does touch
Postgre in a real sense, it is not strictly SQL. It is about how to create
applications with PostgreSQL. That's what we're missing, Coneptually,
PostgreSQL is strictly a database and the core team (rightly so) is
fundimentally happy with that aspect of it.

Maybe we need a pgfoundary project called "PostgreSQL Application Server."
Like Apache Tomcat or regular apache or PHP, PostgreSQL could form the SQL
base of a far more intricate and flexable framework that encompases a lot of
the various features that could provide "application sever" features from
PostgreSQL.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-06-12 20:35:31 Re: Releasing 7.4.3 ...
Previous Message Tom Lane 2004-06-12 19:45:47 Re: Why frequently updated tables are an issue