[pdb-discuss] stuff to do

Mon Jun 26 18:53:32 UTC 2006

Nathan Lewis wrote:
> Hi Rufus,
> 
> The Demo looks extremely good. I'll have a go at adding your
> suggested error field to the output. Have you entered anything into a
> database yet?
> 
> If you are using mysql could you please do a mysqldump of it and
> commit the sql into svn?

All the db interfacing is being done via sqlobject, a python 
object-relational mapper library (see dm.py). This wrapper is database 
agnostic so you can use mysql/postgres/sqlite (see the uri string in 
etc/pdw.conf.new). At present i'm just using sqlite in memory and/or on 
disk because it is very quick however when we come to proper deployment 
we'll probably use postgres or mysql.

Thus I'd recommend interfacing with the db via this wrapper: it is 
**very** simple and provides a very nice object interface as well as 
meaning we aren't tied to any db. If this isn't convenient i can post a 
sql dump of the db structure which you could use to directly insert stuff.

Regards,

Rufus

> 
> On Saturday, June 24, 2006, at 11:30AM, Rufus Pollock
> <rufus.pollock at okfn.org> wrote:
> 
> 
>> With the wiki prototype now up we have something to aim at and
>> there is so much to be improved. Just off the top of my head we
>> have:
>> 
>> 0. use uuid for ids for all db objects 1. Need an is_public_domain
>> flag (!!) 2. We need to integrate data from composers.txt: *
>> http://project.knowledgeforge.net/pdw/svn/trunk/data/ * Nathan has
>> made significant progress on parsing this file but it isn't yet
>> integrated into the db/wiki. 3. Lots of performers names have a
>> bunch of other stuff integrated such as birth/death dates,
>> nationality. This needs to be parsed out. 4. Need to extract more
>> data from the british library site
>> 
>> These probably should be entered into the trac system so we can
>> keep track of things properly.
>> 
>> Regards,
>> 
>> Rufus
>> 
>> _______________________________________________ pdb-discuss mailing
>> list pdb-discuss at lists.okfn.org 
>> http://lists.okfn.org/cgi-bin/mailman/listinfo/pdb-discuss
>> 
>> 