[Perl-org-patches] lists.perl.org - a start and help needed

[Shlomi Fish]

Hi Leo!

On Monday 23 Nov 2009 20:37:52 Leo Lapworth wrote:
> Hi (Shlomi specifically?),
> 
> The guys at list.cpan.org have been kind enough to supply us with their
> database:
> 
> https://svn.perl.org/perl.org/docs/live/lists/data/lists.sql
> 
> Could someone (Shlomi?) merge in the TPF data into that (making sure there
> are
> no duplicates) and do any additional cleaning possible? If it could be kept
> as
> SQL for now that would make implementing it easier for me.

Hmmm.... there are a few problems that we may run into. The first is that this 
is a MySQL-only SQL file and the table is MyISAM. I have mysql running here 
and it may be good enough to process the SQL, so that may not be a problem. A 
second problem is that we've got rid of many defunct mailing lists on the wiki

http://www.perlfoundation.org/perl5/index.cgi?lost_mailing_lists

Should we remove them from the SQL too?
 
> 
> I put the basics of the lists site into svn, but it's just the index page
> and nothing
> else yet. Once I've got the data and get a first version live I will make
> sure everything
> can run out of JSON files so that it's easy for people to send patches and
> we'll
> drop the SQL file.

The SQL may give me some idea about how to structure the table appropriately. 
Seems like the identifier of the table is the "name" column. In any case, I'll 
try to get it tomorrow.

Regards,

	Shlomi Fish

> 
> Many thanks
> 
> Leo
> 

-- 
-----------------------------------------------------------------
Shlomi Fish       http://www.shlomifish.org/
Best Introductory Programming Language - http://shlom.in/intro-lang

Chuck Norris read the entire English Wikipedia in 24 hours. Twice.