Archive for December, 2007

MySQL Adds XML and XPath Support

I was browsing around the web and ran across this article at xml.com, XML Moves to mySQL. Being a heavy XML user, I had to read the article. It looks like MySQL is expanding the built-in support for XML.



This article isn’t very detailed but it links to Using XML in MySQL 5.1 and 6.0 at mySQL.com which is very detailed.



I like the ability that is built in to support loading XML from files. That’s a feature I wish Oracle would work on. Even in 11g, that functionality is still limited.



MySQL also adds ExtractValue() and UpdateXML() support.

Click to continue reading “MySQL Adds XML and XPath Support”

Read the rest of this entry »

Compatibility Between EntepriseDB and Oracle

Have you wondered what features are compatible between Oracle and EnterpriseDB? Have you wondered if EnterpriseDB is REALLY compatible with Oracle?

EnterpriseDB has compiled a new document called the Oracle Compatibility Developer’s Guide. You can download the Oracle Compatibility Developer’s Guide for EntepriseDB 8.2 or the Oracle Compatibility Developer’s Guide for 8.3 Beta.

This new document should help answer one of the most common questions I get asked, i.e., what is compatible and what is not compatible between EnterpriseDB and Oracle. If you are interested in EnterpriseDB but haven’t taken the plunge, check out this document.

Click to continue reading “Compatibility Between EntepriseDB and Oracle”

Read the rest of this entry »

New Postgres Online Magazine

I ran across a new Postgres ezine, Postgres Online Journal. Dec 2007 is complete and Jan 2008 is being constructed. You can read the current, under construction issue as HTML while it is being constructed. It looks like you can also download a PDF when an issue is complete.
It will be nice to have an additional resource for Postgres developers and DBAs. This is just a sign that Postgres is becoming more mainstream. In the past all online Postgres information came from a very small group of people.

Click to continue reading “New Postgres Online Magazine”

Read the rest of this entry »