Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re: SQL Query a Non-CSV Flat File - Any Suggestions? :S

by TedPride (Priest)
on Jul 15, 2010 at 19:18 UTC ( #849842=note: print w/replies, xml ) Need Help??

in reply to SQL Query a Non-CSV Flat File - Any Suggestions? :S

Depends on what you're trying to do with those SQL's, doesn't it? If all you're doing is selecting certain records based off values or value ranges, then it's a simple matter of going through the file line by line, pattern matching out the data into fields, and then matching against those fields. If on the other hand you need to add or remove records from anywhere except the very end of the file, then you have a problem. One easy solution would be to rent some cheap mySQL hosting, export your data over there, and query against it, rather than trying to do all the heavy lifting on your machine.
  • Comment on Re: SQL Query a Non-CSV Flat File - Any Suggestions? :S

Replies are listed 'Best First'.
Re^2: SQL Query a Non-CSV Flat File - Any Suggestions? :S
by Anonymous Monk on Jul 16, 2010 at 00:40 UTC
    I'll only do SELECTS, for simple ones (no groupping or ordering) u're right, just parsing, applying filer to fields and write the resulset. But I need groupping and ordering. I thing export Gbs of data to a host is impossible. Thanks!

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (5)
As of 2021-10-16 13:08 GMT
Find Nodes?
    Voting Booth?
    My first memorable Perl project was:

    Results (69 votes). Check out past polls.