From: Robert Klemme <shortcutter@...>
Date: 2011-11-19T22:34:47+09:00
Subject: Re: any command line tools for querying yaml files

On Sat, Nov 19, 2011 at 1:34 PM, R. Kumar <sentinel1879@gmail.com> wrote:
> Thanks Robert.
> The issue here is not just me. Some people are using a record per yaml
> file approach. My issue is not just with me pulling up the file or files
> in IRB and doing some transformations. Users of my application will find
> it hard to query the data as they could if it were SQL or CSV.
>
> At this moment, i think sqlite is the simplest way of data storage. I
> suppose if i really need to version the data, I could take a dump using
> ".mode line" for the important columns and keep that in version control.

If you are free to choose the storage (as it now seems) you could as
well add version information to your data (e.g. a modified timestamp
column).  It's not easy because there are some pitfalls but then you
can keep all the data in one location.  If you use sqlite you can even
add proper indexes and views.

Of course, with CSV or other text based file formats a version control
system would be an easy way to hold the versions.

> Still, I'll check out the ypath and other tools mentioned. Thanks for
> the inputs.

You're welcome!

Kind regards

robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/