I was wondering about two new features:
- search for keywords.
- retrieving top250 and bottom100 lists.
Below there are my thought (keep in mind that both are still to
be implemented).
[SEARCH FOR KEYWORDS]
To make it short, there will be two new functions:
- get_keyword('keyword'): takes a string and return a list of movies;
it must be an _existing_ keyword, or an empty list will be returned.
- search_keyword('keyword'): takes a string and return a list of
existing keywords that resemble the given one, sorted by similarity.
Any problem with this design?
Feasibility:
It can be done for 'local' (slow but... who cares?), while 'sql'
will require a minor change to the db layout: a separated "keyword"
table will be used.
Not a big deal I assume, but see the note below.
For 'http' (and 'mobile'), two simple parsers are needed; they should
not be that hard to write.
[TOP250 AND BOTTOM100]
Two new function: get_top250_movies() and get_bottom100_movies();
easy to write for 'http' and 'mobile'.
'local' may require a new script to be run (it should be easy enough),
while 'sql' present the same problems as above: a new table is
required.
But... for 'sql' both problem could be solved without new tables, but
with an index other the movie_info.info_type_id column.
Being over 11 millions of fields (and counting...) in that table
and 113 diffent values of info_type_id, it will slow down a bit the
creation of the database, and take some space.
On the other end, it will simplify a lot searches for other kind
of info about movies.
Does anyone have an opinion to share? :-)
--
Davide Alberani <davide.alber...@gmail.com> [PGP KeyID: 0x465BFD47]
http://erlug.linux.it/~da/
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Imdbpy-devel mailing list
Imdbpy-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
