Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: best way to change xml record using XML::Simple?

by RiotTown (Scribe)
on Feb 24, 2003 at 18:48 UTC ( #238198=note: print w/replies, xml ) Need Help??


in reply to best way to change xml record using XML::Simple?

Why not use a simple database? The schema is already defined within the excel spreadsheet, and you'd get away from data integrity errors (your solution is not multi-user safe). And you would still be able to create the spreadsheet whenever necessary using something like Spreadsheet::WriteExcel. You already seem to be doing much of the work already; using a db would allow SQL to more efficiently update just the row that needed to be instead of chugging through the entire XML file each and every time.
  • Comment on Re: best way to change xml record using XML::Simple?

Replies are listed 'Best First'.
NO DBs allowed
by waxmop (Beadle) on Feb 24, 2003 at 18:53 UTC

    I agree that this a DB problem. However, that is not possible right now.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://238198]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (5)
As of 2021-01-24 19:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?