Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

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
Node Status?
node history
Node Type: note [id://849842]
1nickt used to be in a meatspace monastery, in EU, with lots of wanderers from all over the world ...
[karlgoethebier]: 1nickt: Thanks. Now i know what "meatspace" means...
marto is glad to see others advising against learning CGI, unless someone really has to :P
[karlgoethebier]: he,he! literally it's "Fleischraum"

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (10)
As of 2017-12-13 13:12 GMT
Find Nodes?
    Voting Booth?
    What programming language do you hate the most?

    Results (367 votes). Check out past polls.