Smalltalk › Pharo › Pharo Smalltalk Users

World Cup 2018 with Glorp : SQL dump for SQLite : wc2018.sql

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

2 messages Options

Hannes Hirzel

World Cup 2018 with Glorp : SQL dump for SQLite : wc2018.sql

Hi Pierce

In your blog entry
'World Cup 2018 with Glorp'
you write about an SQL dump file wc2018.sql and mention a repo?

https://github.com/openfootball/world-cup/tree/master/2018--russia

seems to be a candidate, but on SQL.

In which repo is it?

--Hannes

Pierce Ng-3

Re: World Cup 2018 with Glorp : SQL dump for SQLite : wc2018.sql

On Thu, Oct 11, 2018 at 06:45:07PM +0200, H. Hirzel wrote:

> Hi Pierce
>
> In your blog entry
> 'World Cup 2018 with Glorp'
> you write about an SQL dump file wc2018.sql and mention a repo?
>
> https://github.com/openfootball/world-cup/tree/master/2018--russia
>
> seems to be a candidate, but on SQL.
>
> In which repo is it?

Hi Hannes,

I built SQLite databases from the data in
https://github.com/openfootball/datafile.git, then generated the SQLite
dump files, which went into the 'data' directory in my repo
https://github.com/PierceNg/footballdb-Glorp.

I don't remember whether the WC 2018 dump file has the match results,
but the WC 2014 one ought to contain the full tournament data.

Pierce