Обсуждение: about middleware over postgreSQL....

Hi, everybody......   I'm new to the linux world, so newbie on postgresql, et
al, and right now I'm facing a distributed web site development on postgresql
and don't know what is best to develop the middleware, to place between the
front end and the database... so I have a couple of questions....


    - is there any app server to run c++ objects ?

    - is optimous to use Tomcat and java ?


I appreciate any comment on this subject...... I even wonder if there is any
proyect on this topic....


Thanks in advance...


Andrew
--
"Si avanzo sígueme, si me detengo empújame, si retrocedo mátame"
======================================================
J.A.Mella

Hello,

  It really depends on your needs. TomCat and Java are great if you have
the horsepower (CPU + RAM etc...) to make use of them. There is PHP
which will allow you to build a custom solution. LXP which is the XML
PostgreSQL application server by Command Prompt (us). LXP is great
because it can use c++, c, java or anything that Apache can understand.
You can check it out at http://www.commandprompt.com/

Sincerely,

Joshua Drake


Andres Ledesma wrote:

>Hi, everybody......   I'm new to the linux world, so newbie on postgresql, et
>al, and right now I'm facing a distributed web site development on postgresql
>and don't know what is best to develop the middleware, to place between the
>front end and the database... so I have a couple of questions....
>
>
>    - is there any app server to run c++ objects ?
>
>    - is optimous to use Tomcat and java ?
>
>
>I appreciate any comment on this subject...... I even wonder if there is any
>proyect on this topic....
>
>
>Thanks in advance...
>
>
>Andrew
>
>

Hi Joshua,

Thanks for your anwser. I'm pretty new on linux, so you mention a lot of
things I don nkow, but I will do.

I don't now if PHP is able to build a well distribuited app,  say, an app
with the presentation, middleware and data layers well diferentiated. Isn't
it?

Is the LXP transactional  and  scalable. ?  In that case, I could code my
middleware on C++, directly attacking the postgreSQL database without any
drivers, like jdbc ?


Just some questions.

Thanks again !

Andrew

Andres Ledesma <aledes@telefonica.net> writes:

> Hi Joshua,
>
> Thanks for your anwser. I'm pretty new on linux, so you mention a lot of
> things I don nkow, but I will do.
>
> I don't now if PHP is able to build a well distribuited app,  say, an app
> with the presentation, middleware and data layers well diferentiated. Isn't
> it?
>
> Is the LXP transactional  and  scalable. ?  In that case, I could code my
> middleware on C++, directly attacking the postgreSQL database without any
> drivers, like jdbc ?
>
>
> Just some questions.
>
> Thanks again !
>
> Andrew

Another bit of middleware that allows for well distributed apps and
that works well with PostgreSQL is Zope.  Pretty cool stuff.

Jason

>
>
>I don't now if PHP is able to build a well distribuited app,  say, an app
>with the presentation, middleware and data layers well diferentiated. Isn't
>it?
>

PHP is a full fledged language and can do anything that any other
language can do. The largest difference is that your presentation media
is the web. As long as your application can use the web as the
presentation media you can use PHP.

>
>Is the LXP transactional  and  scalable. ?  In that case, I could code my
>middleware on C++, directly attacking the postgreSQL database without any
>drivers, like jdbc ?
>
LXP scales very well and supports PostgreSQL transactions. Basically (at
least from our experience) LXP can take anything you throw at it, and as
long as PostgreSQL and your OS can handle it, your all set. However, LXP
is also a web presentation language.

LXP is provides true persistence to PostgreSQL. Here is an example of
how to pull results from PostgreSQL and LXP.

<lxp>
 <!-- select all my employees and their phone numbers from our employee
table -->
    <include sql="SELECT employee_firstname, employee_lastname,
phone_number FROM employees">
      <div align="bold_content">
        First Name:
      </div>
        <field name="employee_firstname">
     <div align="bold_content">
        Last Name:
      </div>
        <field name="employee_lastname">
     <div align="bold_content">
        Phone Number:
      </div>
        <field name="phone_number">
   </include>
</lxp>


This will pull everything out and display write to the web browser. Very
simple. Very powerful.

LXP allows the loading (as of 0.9) of share objects in C++ so you could
write custom functionality. You also don't need any special driver for
PostgreSQL because LXP ships with everything.

The nice things about all of it, is that LXP will work with
C++/C/Java/Perl anything you want. So if you need to do something in
another language you can.


Sincerely,

Joshua Drake




>
>
>Just some questions.
>
>Thanks again !
>
>Andrew
>
>

Andres Ledesma wrote:
> Hi, everybody......   I'm new to the linux world, so newbie on postgresql, et
> al, and right now I'm facing a distributed web site development on postgresql
> and don't know what is best to develop the middleware, to place between the
> front end and the database... so I have a couple of questions....
>
>
>     - is there any app server to run c++ objects ?
>
>     - is optimous to use Tomcat and java ?
>
>
> I appreciate any comment on this subject...... I even wonder if there is any
> proyect on this topic....
>
>
> Thanks in advance...
>
>
> Andrew
if you want to develop your website take PHP. it's the best thing and
you can programm it easy for yourself.

Take Adodb as database layer and you have all you need for a website.

(Experience wihth sudch a construction: 250.000 Hits /per day 5%
database load)

Epi