Cricket databases

[Nirvanam]

Does anyone know of any good cricket stats databases in the market. I know statsguru is there but there are some things it cannot do. It does not allow slightly weird us to add columns to a query. I am looking for a free onw, but even if they are priced, pls lemme know I may consider investiung some money on it.

[The Outsider]

If you know SQL PM varun. He might be able to find a way to give you access to the ICF DB.

[Sachinism]

http://howstat.com/cricket/home.asp http://www.testmatchstats.com/

[Nova]

Bossbhai has developed his own database but I think it is only SRT related. May be he can help you too.

[varun]

Hmm.. we have an automatically updated DB for international test, odi and t20 matches. Lemme know if you know sql and can run mysql. I'll put out a dump file for u.

[varun]

Btw, the ICF PlayerStats page is powered by it http://indiancricketfans.com/index.php?pageid=playerstats You can check it out to see if the data looks ok to u

[Sachinism]

Bossbhai has developed his own database but I think it is only SRT related. May be he can help you too.

:hysterical::hysterical:

[Tapioca]

Hmm.. we have an automatically updated DB for international test, odi and t20 matches. Lemme know if you know sql and can run mysql. I'll put out a dump file for u.

I am also interested. Haven't used SQL for well over ten years ... what frontend is easiest/most powerful to use with mysql ? Saw a list at http://en.wikipedia.org/wiki/MySQL#Management_and_graphical_frontends

[kabira]

Varun, if I need it, can you give me a sql dump

[varun]

Ok download the gzipped dump from: http://www.indiancricketfans.com/statsdb.sql.gz

[varun]

I am also interested. Haven't used SQL for well over ten years ... what frontend is easiest/most powerful to use with mysql ? Saw a list at http://en.wikipedia.org/wiki/MySQL#Management_and_graphical_frontends

I personally just use the command-line client.

[akshayxyz]

I am also interested. Haven't used SQL for well over ten years ... what frontend is easiest/most powerful to use with mysql ? Saw a list at http://en.wikipedia.org/wiki/MySQL#Management_and_graphical_frontends

I personally just use the command-line client.

What is your background? Any programming experience, any experience with Linux/Unix/Solaris kind of OSes? how frequent do you use command line on windows? - if you relate to this then go for command line stuff. Otherwise - mysql Workbench is good for hassle free setup, For anything thirdparty you will have to configure MYSQL connection by using appropriate JDBC drivers - but do not worry anything you pick you will find tonnes of tutorials/howtos.

[Tapioca]

Thanks a lot !!! I installed MySQL workbench and am able to make simple queries using the SQL editior (which is the same as using the command line, right ?). Akshayxyz - I have some programming experience though the last time I worked on databases was very long ago. Will now have to brush up the SQL to do more with this.

[Nirvanam]

Btw, the ICF PlayerStats page is powered by it http://indiancricketfans.com/index.php?pageid=playerstats You can check it out to see if the data looks ok to u

Thanks Varun, I am looking for something that can give very detailed raw numbers. For ex - Consider Rahul's latest innings. The database should be able to tell me: which bowlers bowled to him, how many balls each, how many runs scored off each, how out, result of match, his partnerships - how many, runs of each p'ship (including contribution), FoW when he came in and FoW when he got out, all FoWs, Also ICC ratings of the batsman during that Test and ICC ratings for all the bowlers he played against. Statsguru gives quite a lot of them but does not have info on ICC ratings and balls faced from a bowler during an innings, runs scored during that innings. I mean we have to open up each scorecard to see who were the bowlers...but it still doesn't tell who bowled to Rahul

[Tapioca]

which bowlers bowled to him, how many balls each, how many runs scored off each, how out, result of match, his partnerships - how many, runs of each p'ship (including contribution), FoW when he came in and FoW when he got out, all FoWs,

All except the bolded part is available from this database.

[Nirvanam]

All except the bolded part is available from this database.

How about ICC ratings for him and the bowlers he faced during that match?

[Sachinism]

Thanks Varun, I am looking for something that can give very detailed raw numbers. For ex - Consider Rahul's latest innings. The database should be able to tell me: which bowlers bowled to him, how many balls each, how many runs scored off each, how out, result of match, his partnerships - how many, runs of each p'ship (including contribution), FoW when he came in and FoW when he got out, all FoWs, Also ICC ratings of the batsman during that Test and ICC ratings for all the bowlers he played against. Statsguru gives quite a lot of them but does not have info on ICC ratings and balls faced from a bowler during an innings, runs scored during that innings. I mean we have to open up each scorecard to see who were the bowlers...but it still doesn't tell who bowled to Rahul

Cricinfo has player vs player, don't know how many years back it goes But for the last game http://www.espncricinfo.com/india-v-new-zealand-2010/engine/match/464533.html?view=pvp - you can check who bowled to Rahul and the runs he scored off them

[Nirvanam]

Cricinfo has player vs player, don't know how many years back it goes But for the last game http://www.espncricinfo.com/india-v-new-zealand-2010/engine/match/464533.html?view=pvp - you can check who bowled to Rahul and the runs he scored off them

Thanks Sachinism...unfortunately this detail is recent...I tried to look for Hobbs and couldn't find the scorecards of those dys translated into statsguru with such details