Re: PGSQL and XML

operationsengineer1(at)yahoo(dot)com wrote:
> With lots of help from folks on this mailing list, the readme files and other net sources, i've found a simple process for seeting up an WinXP box as PHP/PostgreSQL development environment.
>
> Just as I was getting started to begin work on my PHP apps, I ran into this...
>
> http://www.joot.com/dave/writings/articles/php/
>
> http://www.joot.com/dave/writings/articles/bsp/
>
> and the last message here...
>
> http://www.webmasterworld.com/forum21/3799.htm
>
> Which put me in a dangerous state of mind - thinking.
>
> Should I evaluate XML and XSL to see if it makes more sense using it than PHP scripting? Is keeping the business logic separate from the presentation important enough to switch technologies (at least I'm at the beginning stages)?
>
> What is this Box stuff?
>
> http://www.joot.com/box/
>
> While Box has an open license, does XML require proprietary anything or license fees?
>
> Does PGSQL integrate well with XML or is it a moot point?
>
> Any experience and related input would be very much appreciated.
>
> PS - Thanks to all for re-affirming my decision to go PGSQL and stick to it when my lack of experience got really frustrating! ;-)
>

Im not sure I totally understand what your wanting, but Im assuming you
are looking to XML for the interface portion of your web app?

If thats it, look here : www.xulplanet.com

This only works in gecko based browsers, but its _very_ powerful. You
will still need some kind of logic on the server side (I opt for PHP) to
create your XML docs and pass them to the client. They can then be read
and acted apon by the browser using javascript.

Here are some quick examples, they have no logic applied to them, so
they don't do anything, but you get an idea of its potential :

http://xulplanet.com/tutorials/xultu/examples/findfile/findfile-popups.xul
http://xulplanet.com/tutorials/xultu/examples/ex_6_8_2.xul

This really has little to do with pgsql. Recently I created an app
using this technology, pgsql on the backend, PHP for the server side
scripting and XUL/XML for the presentation. Worked great, and I liked
the natural seperation of logic and presentation it created, that is
sometimes difficult in PHP.

It does rely on gecko (mozilla) so its not ready for a public internet
site, but for internal applications its great, since even if IE is still
required, you can provide firefox like some kind of runtime environment
for your web services.

A Gilmore