Use XPath in PL/PGSQL for Batch Processing
A while ago I had to process XML loaded in a PostgreSQL database. The task was to extract references from a publication structure. Fortunately, PostgreSQL
xml
Add XML to PostgreSQL from Python
One of the projects I worked on was to import a large number of XML files in a PostgreSQL database (as XML files). I chose
Loading XSDs into Oracle through Python
Following the previous incursions in Oracle and their own documentation, we decided it was useful to attach schemas to the inserted data, just because only
Memory dump: Work with XMLField in Oracle (part 2)
TL;DR: Here I present a SQL example from creating the table to performing a SELECT.
Table of Contents
1. Part 1 - Prerequisites
2.
Install lxml on windows (on a virtualenv)
Lxml is a nice python library for XML processing. ETree is really quick, which makes things interesting if you have a large amount of XML