men lie. woman lie. numbers don't...
and there are so many more that are consistent
and there are so many more that are consistent
-
Comment -
Liars figure, figures don't lie.men lie. woman lie. numbers don't...
and there are so many more that are consistent
Men lie, women cheat.
Well, men cheat, we lie about it to.
Um, what were we talking about again, oh SQL as it pertain to sports.
Killer is a great site, I go to it every now and than.
My bread and butter is baseball, I use my own database.
One thing databases, stats whatever won't tell you, unless there were major injuries, the last game has no bearing on the nest game.
Also, trends can be useful, however if a team is 5-1 lifetimes vs. another team but three of those games were played ten or more years ago, the trend is meaningless. If team 'a' beat team 'b' 35-6 is a killer blowout in 1995, it's no relevant if team 'a' is playing team 'b' again tomorrow.
Point being, you need databases and stats as a tool to handicap, but you need to choose your stats wisely, use only relevant stats.
The operative letter in SQL is 'Q'
Q Query
If a lefthanded pitcher is starting for team 'a', one thing I want to know is can team 'b' lineup hit lefthanded pitching.
If the aforementioned lefty throws primarily curveballs I need to know does team 'b' have trouble with the curve, or does the lineup for team 'b' hit lefthanded pitching well, does team 'b' hit lefty curveball hitting pitching well?
In MLB there are 30 teams, each team have 40 man rosters, that's 1200 players I need to track, even though only 26 of those 40 players are allowed in the dugout, current roster if you will, i still need to track 1200 players.
Last season, out of those 1200 players, 491 were pitchers I needed to track, of those 491 pitchers, 137 throw left, 354 throw right.
How do I know this? Easy, I query my database.
See where I am going with this.
With databases, and knowing how to use them, is most of the battle to successful baseball handicapping.
Simply put in laymen's terms, SQL is an acronym for Structured Query Language, it's a programming language used for managing data.
It's nothing new, SQL was first developed in the mid 70's when I was in grade school, I've been in IT since I got our of HS, I'm going to be 50, do the math, I've been aware of it for 30 years, without SQL, everything is guess work.Comment -
Sick of this LGBTSQDL crap being rammed down our throatsComment -
^
Nobody is telling you how to use it.
Nobody is telling you how to handicap.
My eight year old niece picks teams based on whose uniforms have the prettier colors, and I bet she can pick more winners than Johnny Vegas can, but since this is a SQL thread, I thought I'd contribute my two pennies and say it's a good handicapping tool is all.
How's it going Pablo, how was the weekend?Comment -
data basses are a tool but they do not work because each data base is done by certain people asking a QUERY like no way data bases work
i saw over at covers guys using data bases and they all lost each game 100% S/U and atsComment -
Billy your put of your league here
The thread for professionalsComment -
Correct Nasher. I thought you might have been mad for encroaching on your territory.
I will tread lightly.Comment -
Oh boy. This thread.
I just don't know how to break it to you guys.Comment -
Anyone using spreadsheets is a jerk off
They just don’t have the power nor the speed to keep up with databases
I was a math teacher
Before I got fired from missing CB radiosComment -
Spreadsheet are too slow once you start building bigger files
If you’re going to use SQL, I would lay off JavaScript especially if you have a lot of formulas. Write it in PHP. It’s lightning quick. All I do is teach.Comment -
The machine gives all the winners. There’s no human emotions anymore.Comment
