NYCPHP Meetup

[Tim Gales]

Jon Baer wrote:
> I know this is a PHP list but has anyone noticed the last 2 added  
> features to MySQL 5.1.5 and 5.1.6?  (Both of which don't seem to be  
> available in alpha yet)
> 
> 5) XML/XPath support:
> http://dev.mysql.com/tech-resources/articles/mysql-5.1-xml.html
> 
> 6) Events
> http://dev.mysql.com/tech-resources/articles/event-feature.html
> 
> I find these to be very cool and useful but is it or would it be the  
> general consensus that as it matures (along w/ routines/functions)  
> that these type of procedures will run faster and optimized at the db  
> level?  Without the need for php/ruby/python/java?
> 
> Do other commerical rdbms offer both options?
> 
If you agree that scheduling is pretty much the
same thing as the 'event feature', then yes --
----
MS Sql 2005 has a native xml type which supports xpath.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5xml.asp

and SQL Server agent
http://www.microsoft.com/technet/prodtechnol/sql/2005/evaluate/newsqlagent.mspx 

----
Sybase ASE 12.5.1 has the 'ASE XML Engine'
http://www.sybase.com/content/1026308/xml_wp2.pdf

and  a scheduler
http://www.sybase.com/detail?id=1026304
-----
Oracle 9i/10g has 'native xml support'
http://www.oracle.com/technology/tech/xml/xmldb/index.html

10g has a scheduler
http://www.oracle.com/technology/products/database/scheduler/htdocs/scheduler_fov.html 

-----
PostgresSQL:

http://www.throwingbeans.org/tech/postgresql_and_xml.html

http://people.planetpostgresql.org/dpage/index.php?/archives/4-Its-Alive!.html

-- 
T. Gales & Associates
'Helping People Connect with Technology'

http://www.tgaconnect.com