database..

[avssports]

i'm looking for a good database to store scores and stats in..anyone use or can recommend a good/user friendly one?..

 

[wolfie_cr]

filemaker 7

 

[lander]

MS Access should suffice, but if you have any SQL skills I'd recommend MySQL or PostGres (both free, fairly powerful, Open Source RDBMS's)

 

[avssports]

i don't have any sql knowledge at all..is it hard to learn?..is the mysql you're talking about the same as the free download at mysql.com?..

 

[lander]

Yep, that's the one.

The sql itself is fairly easy to learn, but the most important bit is the actually understanding of proper RDBMS modeling. Effective modeling is what enables SQL to be so powerful.

 

[avssports]

thanx lander..don't know what the last 2 sentences mean..but i'm looking for a sql tutorial rite now to help me with that...

 

[avssports]

lander, what should i open the file with after downloading it?..

 

[lander]

They have different formats for different file systems. The Windows version was a regular .exe file (i believe).

You might have downloaded a GZIP (.gz) for UNIX by mistake.

 

[Little_Joe]

avssports:

Hello,

I would certainly be interested in helping you setup a database, I have the knowledge, the motivation and the ressources (not that much time - we will have to see...) but I have no data. If you can demonstrate that you have access to good data, or are willing to put quite some time in updating the database daily, then we could talk (i don't plan to have any money involved - simply time). To back what I'm saying here is a very simplistic application I developed for sportsavant in reply to one of his threads;

Line conversion tool

Drop me a line if your'e interested. Good day, LJ/NL