[Tutor] Will a dictionary based method work for this problem

[Srinivas Iyyer]

Thanks Danny, 
 I did not think of that at all. I have some
experience with postgres. 

i will do that. 

thanks

--- Danny Yoo <dyoo at hkn.eecs.berkeley.edu> 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