I'm currently working on the migration of the mysql db to postgresql due to the more reliable compatibility to SQL standards. And in due course, if resources allow, I'm going to change the perl code to python due to the clearer code. Following is README. <enno dot vet AT gmx dot net>
Legal Stuff: This program and the adjacent database are published under the terms of the GNU Public License (GPL) in its current or amended version. The terms of the license can be found in the file GPL contained in the archive or alternatively looked up at http://www.fsf.org/licensing/licenses/gpl.html (as you seem to view this on the web I'll refrain from repeating the snail mail address;)). Requirements: In order to use it one needs [licenses in square brackets]: (All software involved is Free Software) perl standard distribution >=5.6.0 [GPL|Artistic License], www.perl.org mysql >=4.0.21 [as indicated in copyright notice] www.mysql.com -- for 4.1 poss. some adaptations necessary (timestamp) a cgi-able webserver, e.g. apache [as indicated in copyright notice] www.apache.org a cgi-able web browser, e.g. mozilla|firefox|iceweasel [as indicated in copyright notice] www.mozilla.com|www.debian.org each of them to be used under their own license terms. Depending on your browser you might have to adapt the accesskey settings to make them work. The Program: This program and the adjacent database were initially created in an effort to reduce the amount of time I had to spend looking through old book entries to find out if a particular greyhound had been vaccinated or not etc. It also offers to print monthly statements of vaccinations for the trainers and a preview of chargeable items (vaccinations and euthanasias per trainer) as a month end for the track management as well as an injury recording facility including estimated offtimes due to injury. For the printing a working TeX/LaTeX installation is required. This software has been developed and used on Linux but should also be functional on other operating systems, provided that the additional software, perl in particular, is present. The main window lists recorded tracks with the possibility to select your track via hot-key Alt+m (in the current program linked to Hall Green) and then gives a list of the dogs attached to the track together with vaccination and id data (sex, colour, dob, earmarks, trainer) and annotations. From that list single or multiple dogs can be selected for purposes of updating vaccination information, record injuries or euthanasia, change of trainer etc. You can search for dogs by name and/or earmarks, and if You keep track of name changes of dogs you will find Rapid Queen, even if she by now is Dimeandpenny. I think everything is pretty straightforward and I've been using it for one and a half year, adding features one after the other, the central concern being vaccinations, as the tracks' abilities towards this have repeatedly proved to be unsatisfactory. As I'm not a proficient perl programmer most of the code should be easily understandable even for a less proficient programmer than me. It certainly is a lot of work to enter all the dogs, but in due course it will show you, I suppose, a convenient way to keep track of your track work. Any comments welcome at enno dot vet AT gmx dot net. The Database: The mysql database can be created with the db.sql script, as stated therein. The Webserver: The webserver might also need some adaptation to work with the perl script dogs.cgi.pl. Trust your documentation. On a standard debian installation with apache for instance the script has to be placed in /usr/lib/cgi-bin. Annotations: The perl script might also work with MSIE, however I haven't been able to test that, and as there are free alternatives available, I'd recommend not to use MSIE in general due to the repeated severe bug reports. I've taken the liberty to abbreviate colour descriptions: black k b blue blue b d dark-brindle brindle r e red fawn darkbri d f fawn fawn f k black redfawn e r brindle white w w white It might of course be an idea to convert them to an enum. Have a lot of fun!