Обсуждение: 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