Re: [gentoo-user] OT: Lightweight commandline flatfile database

[Willie WY Wong]

On Fri, Jan 27, 2012 at 12:23:32AM -0500, Penguin Lover Walter Dnes squawked:
>   Rather than keep music on my hard drive, I'm going the "cloud" route
> by keeping a list of my favourite Youtube clips.  Ideally, I'd like
> something that I can activate from the command line, and even launch
> Firefox.  sqlite is overkill in terms of features/size.  Is there
> something smaller.  It does *NOT* have to be SQL.  I'd prefer a text
> mode program.  I'd prefer not to keep a list in a spreadsheet.
>

Then why not just a flat text file, one youtube link per line, each
line comma separated with 

 URL,artist,title

search with grep, once narrowed down to one item you can just
 firefox "`grep <terms> textfile | cut -d ',' -f 1`"
or even make that a bash function if you'd like? 

adding to the list is as simple as 
  echo "<url>,artist,title" >> textfile
a mixture of grep, cut, sort can even be used to make a full listing
of all entries. 

Or do you have a more specific set of features that you'd like? (like,
for exampe, an actual user interface?)

Cheers, 

W
-- 
Data aequatione quotcunque fluentes quantitae involvente fluxiones invenire 
         et vice versa   ~~~  I. Newton