Whether we like it or not, XML has become a part of our development lives. There are very few non-trivial applications that don't require some kind of XML interface. Even though Postgres has supplied XML functionality for many years, as an add on, there are still many developers who don't know the XML basics. Full SQL/XML support is now natively supported and Postgres 8.3 also supports a native XML data type.
This presentation will explain, in developer terms, what XML really is, what XML really is NOT and how to use SQL/XML to generate XML. Topics discussed will be:
Quick Overview of XML
The XML data type
SQL/XML Functions
When XML makes sense
When XML does NOT make senseLewis Cunningham is an Oracle Ace, author of EnterpriseDB: The Definitive Guide and a Database Architect.
Lewis's specialties are application development, database design, SQL and XML and he is a member of ODTUG, IOUG and ACM.
Lewis has been a developer, DBA, manager, team lead, architect and consultant. He has worked with Oracle since 1993 and Postgres, off and on, since 2001. He currently works as a solutions architect for EnterpriseDB Corp.