LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 10-02-2012, 10:27 AM   #1
medirecpr
LQ Newbie
 
Registered: Apr 2012
Posts: 17

Rep: Reputation: Disabled
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,
 
Old 10-03-2012, 07:07 AM   #2
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.5, Centos 5.10
Posts: 16,269

Rep: Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028Reputation: 2028
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....
 
1 members found this post helpful.
Old 10-03-2012, 07:24 AM   #3
schneidz
Senior Member
 
Registered: May 2005
Location: boston, usa
Distribution: fc-15/ fc-20-live-usb/ aix
Posts: 4,008

Rep: Reputation: 624Reputation: 624Reputation: 624Reputation: 624Reputation: 624Reputation: 624
Quote:
Originally Posted by medirecpr View Post
(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.

Last edited by schneidz; 10-03-2012 at 07:26 AM.
 
1 members found this post helpful.
Old 10-03-2012, 08:03 AM   #4
medirecpr
LQ Newbie
 
Registered: Apr 2012
Posts: 17

Original Poster
Rep: Reputation: Disabled
LAMP

Quote:
Originally Posted by schneidz View Post
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,
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] awk question - read in txt files, offset data by given amount, output new txt files pomico Programming 19 09-17-2012 11:43 AM
compare directory to .txt or .xml??? aircftech Programming 9 12-15-2010 12:14 PM
Copy the contents of a txt file to other txt files (with similar names) by cp command TheIndependentAquarius Linux - Newbie 7 07-03-2010 12:54 AM
Information store: What software could I use to store and access various info merixon Linux - Software 2 12-17-2008 11:51 AM
Hash of mystery audio files -> ID3 information database? ewolf Linux - Software 1 08-20-2008 10:36 AM


All times are GMT -5. The time now is 07:19 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration