- 최신
- 최다 투표
- 가장 많은 댓글
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.
As mentioned by Rodney, you could use PostgreSQL (RDS for PostgreSQL or Aurora PostgreSQL-compatible edition) or MySQL (RDS for MySQL or Aurora MySQL-compatible edition).
I would lean towards PostgreSQL because of the relative simplicity. There is an XML type. Postgres doesn't require specifying max character lengths for VARCHAR, and you can use VARCHAR or TEXT for strings of any length, if you just want to treat the values as strings.
postgres=> create table xml_t (t xml);
CREATE TABLE
postgres=> insert into xml_t values ('<foo>bar</foo>'::xml);
XML support in the PostgreSQL engine:
https://www.postgresql.org/docs/current/datatype-xml.html
XML support in the MySQL engine:
https://dev.mysql.com/doc/refman/8.0/en/load-xml.html https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html