Thanks Danny, I did not think of that at all. I have some experience with postgres.
i will do that. thanks --- Danny Yoo <[EMAIL PROTECTED]> wrote: > > > > This is just a simple example, in my list I have > ~40 > > sections and ~10K people (this is repeated number > and > > I do not know how many unique persons are there). > > > > Question to tutor: > > > > Could any one help me proceed further. > > Will a dictionary (key and values ) based method > work > > for this kind of problem. > > Hi Srivivas, > > You may want to consider a relational database > approach. It is possible > to do something like this in straight Python, but > you'll be basically > implementing the basic behavior provided by any good > relational database. > > > The kind of queries that you're asking: > > 1. Who are the people unique to Accounts? > > 2. Who are the people working for two sections > of the > office? > > are the ad-hoc queries that make relational > databases a really big win --- > it should be relatively straightforward to express > those questions in SQL. > > > There are a few free database system you can > experiment with, like SQLite, > PostGreSQL, or MySQL: > > http://www.sqlite.org/ > http://www.postgresql.org/ > http://www.mysql.com/ > > These systems interact well with Python through > Python's DB-API. > > http://www.python.org/peps/pep-0249.html > > > Good luck! > > > ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs _______________________________________________ Tutor maillist - [email protected] http://mail.python.org/mailman/listinfo/tutor
