Which database to use? or XML?


 
Thread Tools Search this Thread
Top Forums Web Development Which database to use? or XML?
# 1  
Old 07-12-2010
Which database to use? or XML?

so I am working on a server asset tool for our company, this will be a web based tool, perl/CGI.

each record will have server name, serial number, os type, rack number and such.

then we will have a page for searching, by serial number of host name or whatever...

this will end up with about 1000 records.



I am not too keen on using a full SQL database, I would rather use some kind of flat file.
this make us less dependent on the DBA team.



the question is what kind of database to use, or do I need a database at all?
# 2  
Old 07-12-2010
if you can use a database, I would. It allows for flexibility and expansion

Any database is good, they will all basically do the same thing in this situation
# 3  
Old 07-12-2010
Quote:
Originally Posted by bankai
if you can use a database, I would. It allows for flexibility and expansion

Any database is good, they will all basically do the same thing in this situation
that is my basic thinking too, but if I go my-SQL or oracle, then our DBA team will want to get involved and that is just a pain I want to avoid.


what about some kind of flat file database?
maybe Berkley database?

an end product I can just tar up and move between servers would be very nice.
# 4  
Old 07-13-2010
SQLite
Flat file, SQL support, no server needed, and you can move files (=databases) around without problems. There are drawbacks, tho: no real date format, column type is less-than-strict enforced (if all), and some other quirks.
# 5  
Old 07-19-2010
MySQL is pretty easy to set up, and free. I assume that is too heavy of a foot print for you.
# 6  
Old 07-19-2010
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Splitting a single xml file into multiple xml files

Hi, I'm having a xml file with multiple xml header. so i want to split the file into multiple files. Sample.xml consists multiple headers so how can we split these multiple headers into multiple files in unix. eg : <?xml version="1.0" encoding="UTF-8"?> <ml:individual... (3 Replies)
Discussion started by: Narendra921631
3 Replies

2. Shell Programming and Scripting

Split xml file into multiple xml based on letterID

Hi All, We need to split a large xml into multiple valid xml with same header(2lines) and footer(last line) for N number of letterId. In the example below we have first 2 lines as header and last line as footer.(They need to be in each split xml file) Header: <?xml version="1.0"... (5 Replies)
Discussion started by: vx04
5 Replies

3. Shell Programming and Scripting

Shell Command to compare two xml lines while ignoring xml tags

I've got two different files and want to compare them. File 1 : HTML Code: <response ticketId="944" type="getQueryResults"><status>COMPLETE</status><description>Query results fetched successfully</description><recordSet totalCount="1" type="sms_records"><record... (1 Reply)
Discussion started by: Shaishav Shah
1 Replies

4. Shell Programming and Scripting

CRON Job to copy database and replace existing database

I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the... (1 Reply)
Discussion started by: nzrobert
1 Replies

5. Shell Programming and Scripting

How to add the multiple lines of xml tags before a particular xml tag in a file

Hi All, I'm stuck with adding multiple lines(irrespective of line number) to a file before a particular xml tag. Please help me. <A>testing_Location</A> <value>LA</value> <zone>US</zone> <B>Region</B> <value>Russia</value> <zone>Washington</zone> <C>Country</C>... (0 Replies)
Discussion started by: mjavalkar
0 Replies

6. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General... (0 Replies)
Discussion started by: solaris_user
0 Replies

7. Solaris

redirect solaris database from linux database..

hi.. i have a need .. my php runs on my linux redhat box with mysql.. i want my php code to refer another mysql database which is in solaris 10 x86... can u tell me the procedure .. how it can be done through php .. sorry am new to php... is it possible to redirect from linux mysql to... (7 Replies)
Discussion started by: senkerth
7 Replies

8. UNIX for Dummies Questions & Answers

Hiding database connection strings from xml file

Hi , I have a configuration file with the following structure: <CONFIG> <DEFAULTS operator="oraread"> <PROPERTY name="hostname" value="myhostname"/> <PROPERTY name="port" value="12343"/> <PROPERTY name="dbname" value="dbname"/> <PROPERTY... (0 Replies)
Discussion started by: neeto
0 Replies
Login or Register to Ask a Question