Re: File handle modules

Do you have a file structure in mind or are you just at the planning stage? What about using DBD::CSV to perform SQL (select,insert,update and delete) on your data. You could encrypt/decrypt using one of the many encryption modules. Perhaps if you elaborate on what you want to do others may have more concrete advice.

Comment on Re: File handle modules

Replies are listed 'Best First'.
Re^2: File handle modules by Anonymous Monk on Aug 06, 2010 at 13:02 UTC
This is in the planning stage and doesn't involve SQL. Perhaps I should have said read/write operations on a text file instead. Apologies. The file would look something like this, where the first column is an id column which would be used when updating or removing the relevant record from the file `id col1 col2 col3 col4 username email.address status` [download] I'd envisage around 3000 records being present in the file to start with. Growing over time to a much larger number (50,000 records). So performance will play a part as the file grows.	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: File handle modules
by Anonymous Monk on Aug 06, 2010 at 13:02 UTC

The file would look something like this, where the first column is an id column which would be used when updating or removing the relevant record from the file

id col1 col2 col3 col4 username email.address status
[download]

[reply]
[d/l]