get your own free blog here

International Football Results 1872-present - www.world-results.net

2007-11-20 - world-results.net

Important Announcement

If all goes to plan over the coming months and if there's sufficient interest world-results.net will be going open source! After years of trying to move the website into the 21st century and trying to make the archive behind it more functional for website visitors I have to admit that I'm losing the battle to do everything that I have planned to do on my own in a reasonable time.

 

Below is a list of general areas that I've been trying to address in recent years in order to improve the user experience:

  • New database structure - When I started with the archive in 1988 I created a bespoke database that stored the matches in a very primitive manner. Then in the late 1990's I converted my archive to MySQL. In 2005 I started changing the physical database structure from a set of simple tables, one of which contained a complete list of matches, to a more object-oriented structure that would allow queries to happen at different levels. Both these database structures currently coincide side-by-side, although the new structure hasn't been updated since late 2006 due to lack of time. The older database structure has tournament data embedded into match records and this is hardly ideal. The newer structure is more object oriented and separates the tournament structure from the matches itself. I plan a further upgrade of the new structure without affecting the operation of the programs that query the data and generate web pages out of it.

 

  • Creation of tournament templates - When I started the website in 1996 I quickly developed a set of tournament templates that could be copied and then modified to generate the pages you see on the website today. In 2000 these templates were made more advanced through embedded SQL statements that query the database, and the ability to add standard headers and footers. Before this process was completed, I decided upon yet another format that would store a set of tournament templates inside the database, and through a program allow creation of XML files that could then be transformed into any output format with the help of XSLT. The advantage being that the XML could be used to generate HTML files for the web, and other formats for those wanting to use the data in another way. The programs to do this partially working, but need further effort.

 

  • New website - The primary role of the website has always been to share international football results and fixtures with interested visitors, with the
  • emphasis on the data and not on how it is presented. I'm the first to admit that the presentation of the data on the website is stuck in the last century, and that's hampering the usefulness of the data itself. Although I'm not after an all-singing and dancing website that draws visitors through its attractiveness, I would like to have something that visitors can use in the way that they want to use the data that it contains. As such I would like it to be customisable and internationalisable. I would also like to provide more dynamic features such as the ability to query the data.

 

  • Updating of results / fixtures / news / event calendar - Although I generally have no problems keeping the data up-to-date as much as possible, I think it could be done better if this is shared between a set of trusted individuals. To be able to do this there needs to be some sort of application that allows this. Although I currently have an application that allows me to do this myself from anywhere with an internet connection, the application is far from ideal. I live on Central European Time (CET) so unless I stay awake until the middle of the night I can't always update the archive/website until the next morning for matches that are played in the Americas. Ideally the website will be kept up-to-date on a 24 hour 7 days a week basis, 365 days per year, but for that I need people I can rely on in different parts of the globe.

 

  • Adding of auxiliary data - Many years ago when I started with the archive I chose to only record results and fixture data. I wasn't even interested in which country the match took place let alone which players played in the match or who scored the goals. Even though I updated my archive with country venues and later city/stadium venue information, player, scorer and other data is still missing from the archive. Although my interest in the data is pretty much covered by what the archive stores at present, I realise the are many people who are interested in retrieving auxiliary data from it. I would therefore be interested in people who have the time and interest in adding such data to the archive. I would also be interested in people that can populate the database with further venue information. Currently around 25% of all matches in the archive has complete venues associated with it, meaning a country, city and stadium but ideally this figure would be 100%.

In order to improve and develop the website and the archive behind it I'm looking for people who have time and share my enthusiasm and dedication for the collection of international football results. Ideally I'm looking for a team of people who are interested in working with the website and data in their spare time on an informal basis and want to share in it in some shape or form. Its not important that you are able to spend a fixed number of hours per week or per month. For me its more important that you are able to take tasks of any shape or form and complete them in a reasonable time, and communicate with others where you are at and if you are having problems.

 

I'm basically looking for experienced software developers (ideally with good Java experience, my preferred programming language), website developers, people who are good at organising, and people who don't mind updating the archive on an ad-hoc basis.

 

As the founder of the archive and the website I would like to continue to play a leading role in the future of it but I would also like to open up the archive/website and the direction it takes in future to those who offer to spend time working on it.

 

If you're still reading and contributing to world-results.net seems something that you would like to be a part of, please send me an email and let me know what you think and what you would be interested in doing. It would also be nice to have some sort of information about yourself and don't forget to let me have a reliable email address so I can keep you in touch with developments. If you don't think you'll have time to contribute, but would like to make some suggestions then feel free to email me also.

Post A Comment!

2007-11-21 - Untitled Comment

Posted by Johnny
Hi!
I've had my own project going on for few years and while I too have many ideas...there's less time.
Maybe there's room for some co-operation?
Keep up the good work!

http://www.eurovision-db.com/soccer
Permanent Link

<- Last Page :: Next Page ->

About Me

This weblog will list the latest interesting issues in international football to do with tournaments and results in general.

Friends

ringtones downloadsringtone-freeringtone for lg vx3200lg c1300 ringtoneringtone mmfmotorola razr ringtone softwarefree nokia philippine ringtonepickerington panthersblinded by the light ringtoneringtone v505