On Friday 22 June 2007 09:18, felciano wrote: > Hello -- > > Is there a convention, library or Pythonic idiom for performing > lightweight relational operations on flatfiles? I frequently find > myself writing code to do simple SQL-like operations between flat > files, such as appending columns from one file to another, linked > through a common id. For example, take a list of addresses and append > a 'district' field by looking up a congressional district from a > second file that maps zip codes to districts.
Two pointers, but maybe not a complete solution: http://search.cpan.org/dist/DBD-Sprite/ Perl library that uses CSV files and supports simple joins. Maybe a port of this? http://www.biostat.wisc.edu/~annis/creations/pseudb.html Functional interface for CSV files inspired by Sprite, but does not support joins. Possibly could be extended? j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE -- Posted via a free Usenet account from http://www.teranews.com -- http://mail.python.org/mailman/listinfo/python-list