Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

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
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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (11)
As of 2014-08-29 20:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (289 votes), past polls