Re^2: delete/over-write record in FlatFile

Hi Sam,
That's what I meant by right -- having a "real" DB and the use to tools/mods but I'm stuck with what I have. As for locking people out, I was going to use a C-style flock() but not sure yet. I know this will totally suck, that I can agree with! I will say after the dataset is complete there will be ZERO chance to simultaneous edits to the DB, so locking isn't a huge concern at this point. I'll try to make what you have there work, but like I said -- I'm not really much of a developer, I just try to help when I can. Thank you sir!

lakeTrout

Comment on Re^2: delete/over-write record in FlatFile

Replies are listed 'Best First'.
Re^3: delete/over-write record in FlatFile by chromatic (Archbishop) on Mar 25, 2008 at 22:50 UTC
You could write two programs. One takes what you have in the flatfile and inserts it into the database. The second does what you need to do out of the database. Before you object, consider that it's effectively the same amount of work as what you're doing now. The difference is that it'll be much easier to work with data when it's in a database. (You'll have to figure out how to map back and forth between Perl and your flatfile, which is what the flatfile-to-database converter has to do anyway.)	[reply]
Re^3: delete/over-write record in FlatFile by samtregar (Abbot) on Mar 25, 2008 at 23:28 UTC
"Stuck" huh? That sounds unpleasant. Should we call the police? Are you being held against your will? I guess I'm just an asshole, but I can't imagine anyone successfully preventing me from using a technique I knew was superior and which wouldn't take any additional time to implement! What's the worst they can do? Fire you? It sounds like they'd be doing you a favor! -sam	[reply]