PostgreSQL 8.3 data types: xml vs varchar -
There is XML data type in postgres, I have never used it before, so I want to hear feedback. Dosacides and upsides using regular varchar (or text) columns to store XML
The text I will write is XML, well-formed, there is no need to search by UTF-8 (search by XML is slow).
This XML is actually ready for PDF PDFs with Apache FOP XML can be dynamically generated from the data found elsewhere (other postgres tables) , It is stored only so that I do not need to generate it twice . Kind Backup # 2 for pre-generated PDF documents.
To learn something else? Good practice, performance, maintenance, etc?
XML
is different from TEXT
only logical Firstly, the validity of the input is checked, second, XML
is a type of compression operator, so you can call it DISTINCT < / Code> etc.
If you are not searching against it using indexes and want to create additional checks for validity, then use XML
securely.
Comments
Post a Comment