Database on the fly with scripting languages
Posted
by afilatun
on Stack Overflow
See other posts from Stack Overflow
or by afilatun
Published on 2010-04-05T19:10:17Z
Indexed on
2010/04/05
19:13 UTC
Read the original article
Hit count: 375
I have a set of .csv files that I want to process. It would be far easier to process it with SQL queries. I wonder if there is some way to load a .csv file and use SQL language to look into it with a scripting language like python or ruby. Loading it with something similar to ActiveRecord would be awesome.
The problem is that I don't want to have to run a database somewhere prior to running my script. I souldn't have additionnal installations needed outside of the scripting language and some modules.
My question is which language and what modules should I use for this task. I looked around and can't find anything that suits my need. Is it even possible?
© Stack Overflow or respective owner