LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - General (http://www.linuxquestions.org/questions/linux-general-1/)
-   -   database to store information from txt and xml files (http://www.linuxquestions.org/questions/linux-general-1/database-to-store-information-from-txt-and-xml-files-4175430074/)

medirecpr 10-02-2012 10:27 AM

database to store information from txt and xml files
 
Hello to all contributors,

My system manages xml files. I wish to read the xml files and save information to a database.
I do not want to create the database on the same server, so I am writing the information I gather from the XML to a flat file.

Currently, I use perl and XPATH to parse the XMLs and save the info to a flat file.

What database system should i use, MySQL?

Am i wrong to not want to add a database on the current server? Can i create another instance of MySQL for this purpose without affecting the existing third party MySQL instance?

(Which development technology?) How about accessing the info in the database? How should I create the web interface to access the information?

Looking for direction more than details.

Kindest regards,

chrism01 10-03-2012 07:07 AM

Choice of DB is up to you, but MySQL is usually the default on a lot of distros.
If you're already using MySQL (albeit from a 3rd party), I'd stick with that; less confusing.

You have a couple of choices
a) create the new DB instance on a new system
b) add a new schema to the current DB instance. This won't interfere, so long as you create a new user (ie schema owner) etc for it.

Its useful you're using Perl, because Perl has modules for dealing with almost any DB, including MySQL; been there, done that, got the T-Shirt :)

You could also do the web pages in Perl, although you'll also find a lot of recommendations to use php for that, because a lot of web hosters supply that as std.

Its your choice....

schneidz 10-03-2012 07:24 AM

Quote:

Originally Posted by medirecpr (Post 4795014)
(Which development technology?) How about accessing the info in the database? How should I create the web interface to access the information?

look into setting up a lamp server.

medirecpr 10-03-2012 08:03 AM

LAMP
 
Quote:

Originally Posted by schneidz (Post 4795937)
look into setting up a lamp server.

I found this article:

http://www.lamphowto.com/

Thank you for the direction, I will research the topic.

Kindest regards,


All times are GMT -5. The time now is 10:49 PM.