PostgreSQL and XML
PostgreSQL users working with XML may be interested in my post at:
http://www.throwingbeans.org/tech/postgresql_and_xml.html
It explains the work I did with John Gray to enable XPath in SQL queries
against XML stored in Postgres text columns; my company is now using this
functionality in several large-scale implementations.
As far as I know, this represents the most complete XML support of any open
source RDBMS. I'll be very pleased to receive any questions or suggestions!
Best wishes
Tom
-----------------+
tom dyson
t: +44 (0)1608 811870
m: +44 (0)7958 752657
http://torchbox.com
When searching the online docs for
PostgreSQL 7.3 allows UDFs to return multiple rows
I noticed the site is tits up because of a PHP error...
OK this won't make me very popular but why are you guys messing around
with this junk? PHP is for MySQL weenies... Real men use JSP!
OK so it is Friday afternoon - I'll just go to the fridge and get a beer
now...
Cheers
Tony Grant
--
www.tgds.net Library management software toolkit,
redhat linux on Sony Vaio C1XD,
Dreamweaver MX with Tomcat and PostgreSQL
On 14 Mar 2003, Tony Grant wrote:
When searching the online docs for
PostgreSQL 7.3 allows UDFs to return multiple rows
I noticed the site is tits up because of a PHP error...
OK this won't make me very popular but why are you guys messing around
with this junk? PHP is for MySQL weenies... Real men use JSP!OK so it is Friday afternoon - I'll just go to the fridge and get a beer
now...
Wow, what is it with you guys and your unsupported assertions against PHP
today. First on hackers and now on general. You don't PHP, don't use it.
You want the website done in JSP, then do it and quit bitching about
someone else's choice of tools.
It's not failing because of a PHP error. did you look at the screen?
It's failing because the database isn't answering. JSP wouldn't make it
any better, it would still be offline.
My PHP server stays up 24/7 under heavy load doing very complex things.
One machine, 99.99% uptime, no unscheduled downtime in two years.
Our JSP Server farm has failures every week, where some part of the
complex inner workings that is JSP fail for no apparent reason and needs
to be reset. That's enterprise computing? If it wasn't a failover of
three machines it would be offline for an hour or so a week.
I've seen as many unsupported assertions that "postgresql is a toy, use
oracle" before.
They're just as ugly no matter what you're talking about. PHP works a
charm, and if you'd actually try and benchmark it against JSP you might be
surprised how much faster it is, especially under load.
Informed opinion is welcomed, but this kind of off the cuff slamming of
something you know so little about it just ugly.
I have to agree here. I use php on a site that gets 13,000,000 hits a
day, and has 1,600,000 visitors. I don't have any problems. It's a
solid well development system, and all it takes is to configure the
postgres daemon to accept as many connections as your webserver can
handle. No need to bash any language, each has their own niche, just as
DBMS's do.
Gavin
scott.marlowe wrote:
Show quoted text
On 14 Mar 2003, Tony Grant wrote:
When searching the online docs for
PostgreSQL 7.3 allows UDFs to return multiple rows
I noticed the site is tits up because of a PHP error...
OK this won't make me very popular but why are you guys messing around
with this junk? PHP is for MySQL weenies... Real men use JSP!OK so it is Friday afternoon - I'll just go to the fridge and get a beer
now...Wow, what is it with you guys and your unsupported assertions against PHP
today. First on hackers and now on general. You don't PHP, don't use it.
You want the website done in JSP, then do it and quit bitching about
someone else's choice of tools.It's not failing because of a PHP error. did you look at the screen?
It's failing because the database isn't answering. JSP wouldn't make it
any better, it would still be offline.My PHP server stays up 24/7 under heavy load doing very complex things.
One machine, 99.99% uptime, no unscheduled downtime in two years.Our JSP Server farm has failures every week, where some part of the
complex inner workings that is JSP fail for no apparent reason and needs
to be reset. That's enterprise computing? If it wasn't a failover of
three machines it would be offline for an hour or so a week.I've seen as many unsupported assertions that "postgresql is a toy, use
oracle" before.They're just as ugly no matter what you're talking about. PHP works a
charm, and if you'd actually try and benchmark it against JSP you might be
surprised how much faster it is, especially under load.Informed opinion is welcomed, but this kind of off the cuff slamming of
something you know so little about it just ugly.---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
On Fri, 2003-03-14 at 19:16, scott.marlowe wrote:
OK so it is Friday afternoon - I'll just go to the fridge and get a beer
now...Wow, what is it with you guys and your unsupported assertions against PHP
today. First on hackers and now on general. You don't PHP, don't use it.
You want the website done in JSP, then do it and quit bitching about
someone else's choice of tools.
Tongue in cheek Friday nonsense OK.
I don't like or use PHP for personal reasons but it was just a bit of
end of week fun in very bad taste.
It is called unwinding.
No harm meant. No harm felt?
Cheers
Tony Grant
--
www.tgds.net Library management software toolkit,
redhat linux on Sony Vaio C1XD,
Dreamweaver MX with Tomcat and PostgreSQL
BTW Awesome work, would love to see this included in upcoming releases.
Gavin
tom dyson wrote:
Show quoted text
PostgreSQL users working with XML may be interested in my post at:
http://www.throwingbeans.org/tech/postgresql_and_xml.html
It explains the work I did with John Gray to enable XPath in SQL queries
against XML stored in Postgres text columns; my company is now using this
functionality in several large-scale implementations.As far as I know, this represents the most complete XML support of any open
source RDBMS. I'll be very pleased to receive any questions or suggestions!Best wishes
Tom
-----------------+
tom dyson
t: +44 (0)1608 811870
m: +44 (0)7958 752657
http://torchbox.com---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
On 14 Mar 2003, Tony Grant wrote:
On Fri, 2003-03-14 at 19:16, scott.marlowe wrote:
OK so it is Friday afternoon - I'll just go to the fridge and get a beer
now...Wow, what is it with you guys and your unsupported assertions against PHP
today. First on hackers and now on general. You don't PHP, don't use it.
You want the website done in JSP, then do it and quit bitching about
someone else's choice of tools.Tongue in cheek Friday nonsense OK.
I don't like or use PHP for personal reasons but it was just a bit of
end of week fun in very bad taste.It is called unwinding.
No harm meant. No harm felt?
It's ok, but it gets real old when, after a year or two, you constantly
hear how PHP is crap and JSP is the only way to go, when the people saying
it are in the marketing or sales department and wouldn't know java or php
code if it bit them on the buttocks. Yet, they parrot this stale old
stuff over and over, and eventually, they really do start to affect policy
decisions based on emotion rather than logic.
Being of Vulcan descent, this bugs me to no end.
Plus, do you really want all the PHP folks to stick to MySQL and never
learn Postgresql? PHP may well be your biggest potential market. If a
new PHP developer is reading this list, he may well have headed over to
MySQL to see what it has to offer, since he's not gonna feel very welcome
here.
Besides, we all know the one true language is RPL... :-)
Besides, we all know the one true language is RPL... :-)
Funny way to spell Perl :-)
--
Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582
Kaki Data tshirts, merchandize Fax: 3816 2501
Howitzvej 75 �ben 12.00-18.00 Email: kar@kakidata.dk
2000 Frederiksberg L�rdag 12.00-16.00 Web: www.suse.dk