Storing XML data in AWS DB
What is the best DB service in AWS to store XML data? I do not want to convert to JSON. Need to retrieve XML and display on UI when needed. Size may not be more than 200 KB max. Today it is stored in oracle as BLOB/CLOB which we want to redesign.
Aside from using RDS Oracle, both MySQL and PostgreSQL support BLOB/CLOBs and they are available both as RDS and Aurora Engines:
Hi, @AWSUserXML
If you just want to get specific XML by key or record, you can just use various RDBMS large objects and KVS.
See @Rodney Lester 's answer.
If you want to query on an element of an XML document, the native XML database service is not provided by AWS.
You can host your own native XML database on EC2.
However, considering the management cost, I think it is better to implement a wrapper that converts to XML at the timing of saving and fetching in the application.
Relevant questions
Redshift varchar(max) not enough to store json data type column from Postgres
asked 3 months agoStoring XML data in AWS DB
asked a month agoXML interpret one struct as an array
Accepted Answerasked 5 months agoLinking Simple Images results in XML Error
asked 5 months agocan't send xml to non-Amazon REST API
asked 3 years agoxml file not read/writable in aws hosting of .net core project
asked 2 years agocan NOT see Athena "data source connector" db in QuickSight
asked a month agoAWS Datasync to transfer the PDF and xml togather
asked 5 months agoDoes Babelfish support XML? How can I use XML?
asked 20 days agoElemental Live xml to MediaLive json
asked 9 months ago