[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Slickest way to do "joins"/lookups in text files



On Fri, 2004-12-17 at 20:39 -0500, William Ballard wrote:
> In SQL you join tables.  If it's indexed it's fast.
> Can you do this using text files from the prompt?
> 
> Example:
> I'd like to investigate the most popular RSS readers Debian offers.
> 
> $apt-cache search rss | cut -d' ' -f1 > rss.txt
> $wget http://popcon.debian.org/main/by_vote.gz
> 
> I'd like to "filter" by_vote.gz to just the package names
> in "rss.txt".  In SQL this would be a join.  I'd like it
> to be "fast".  Do I have to do this in SQL?

There is (was?) a product called "/rdb", which may be what you are
looking for.

-- 
-----------------------------------------------------------------
Ron Johnson, Jr.
Jefferson, LA USA
PGP Key ID 8834C06B I prefer encrypted mail.

4 degrees from Vladimir Putin

Attachment: signature.asc
Description: This is a digitally signed message part


Reply to: