[PLUG] Storing XML docs in SQL database on Linux?

[Robby Russell]

<?echo Alex Daniloff managed to take the time to type out the following:

> Hello Linux folkz,
> Does somebody know about possible solution
> to store XML formatted documents in SQL DB
> on Linux?
> Our company is in need for document storage
> server.
> We have Linux server with MySQL DB server and
> set of Perl applications and FCGI scripts to collect,
> analyze and plot engineering and process data right
> in a browser window.
> I think, that it's a good idea to store pre-formatted
> XML documents right in DB.
> The question is how to format and manage sich a
> collection of documents.
> Mickysoft has some XML documents management
> system. Is there something similar in Linux world?
>
> Thank you in advance for any ideas or sources of information.
>

You can use a blob data/field type in MySQL.

I might suggest using psql though. Are you hoping to extrace the data from
the xml files? or just store them in the database?

-Robby