SDQL - What's next

[Gambrinus]

Hey fellow SDQL fans,

I've been hard a work playing with SDQL3 for several months. I'm close to loading a ton of historic data for the NFL and NCAAFB very soon. Up to this point, I've been testing data acquisition. I have it nailed for the NFL and expect to have a basic site up very soon. 

This basic site will allow queries and return game results just like your used to. Initially, you'll have to write queries in longhand, meaning, instead of "AD and p:W" you'll need to use "site='away' and line>0 and p:points>po:points". Joe was great about providing cool shortcuts for us to use, and I intend to add them all as fast as possible. In the meantime, to get it working, you'll have to use the longhand.

I expect to have the NFL working in advance of the season. I hope to do the same for NCAAFB. I'll do my best. 

I expect the basic site to evolve into something really cool, with new features and ease-of-use options. But great things take time, so be patient.

Lastly, I'm spending every spare moment trying to get this ready for the season. I'll update more when I can. Look for a simple NFL test site very early in August. There are gonna be hiccups, data anomalies, and other unforeseen issues for sure. Again, be patient and we'll work hard to get it right as fast as possible.

I love SDQL! Joe Meyer has given us all a great gift. I'm very grateful to him, thanks Joe!

SDQL is not going away. Stay tuned!

[Andy Nguyen]

I needed to hear something like this. Thats great news, thanks for the update. 

Do you think we will eventually have the ability at some point to still save trends and get daily breakdowns like on killersports? 

[Phoenix Chiropractic Centre Drentlaw]

I appreciate what must be a lot of work for you.

I would pay to support your efforts for the football codes and seasons, CFL, NFL, NCAA FB.

Best,

M

--
You received this message because you are subscribed to the Google Groups "SportsDataBase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sportsdatabas...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/387f3243-229c-4456-a36a-58d2a56cfb01n%40googlegroups.com.

[GoodBadUgly]

Thank you for your time and hard work, Gambrinus. Much appreciated.

One question...with this SDQL3 transition, will users know which book the lines come from?

Staying optimistically patient.

--John

On Monday, July 26, 2021 at 5:21:54 PM UTC-7 Gambrinus wrote:

[Andrew Walker]

Gambrinus, you will be "GOD" status in my books if you can get this up and running.  This is music to me ears. 
Thank you so much for your time in delivering this to us. This must be taking you a lot of personal time to complete much highly appreciated. 

Thank you again,

[dean.on...@gmail.com]

this is awesome!!!

[OffshoreInsiders.com]

Sounds fantastic! Will rushing yards return as an option to CFB? Will we be able to save stuff like we did at Killer?

[JJ 21]

Wow, that is great news Gambrinus! You have clearly made a lot of people very happy, myself included. 

JJ

[A B]

Hi Gambrinus,

Tom - PCG here. I am currently bumping heads on this with Venatus on discord. Sports Wagering Analytics Group

I am interested in helping, and shared with him some work I've done that I can share with you as well.

Also, if you need people to help on server costs, I saw some screenshots of your work in progress....looks pretty good...and you could count me in.

Cheers,

Tom

On Monday, July 26, 2021 at 7:21:54 PM UTC-5 Gambrinus wrote:

[Tomcat]

Great news! I'd be more than willing to help financially...probably not much help elsewhere.

On Monday, July 26, 2021 at 5:21:54 PM UTC-7 Gambrinus wrote:

[Timothy Cate]

I ditto what Tom said...I'm a dead-ringer on both accounts, in fact.

I also love this sentence:

I love SDQL! Joe Meyer has given us all a great gift. I'm very grateful to him, thanks Joe!

No Doubt!!!~!!!!

--
You received this message because you are subscribed to the Google Groups "SportsDataBase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sportsdatabas...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/c5b2ff5d-2819-415f-8e41-7ea8ac9a6ff4n%40googlegroups.com.

[Timothy Cate]

to be more explicit: I need this project, of what I  --  hope to soon say ~Ours, ...~ to mimic as near as possible to what I have frankly felt, spoiled by for years now, and that of course is the magnificent contribution to the World: for free: that of Dr. Myers.

and fwiw, I have dollars to back that up.. thank you again to all contributors. I feel there are many....

On Thu, Aug 12, 2021 at 2:00 PM Tomcat <thomas...@gmail.com> wrote:

[Gambrinus]

Hey guys, 

Thanks for the support. I appreciate it. I'm behind schedule, I hoped to be beta testing by now. Frankly, the new website is the holdup. Being able to display the various outputs from the raw SDQL data is challenging. I have most of the SDQL stuff worked out. I'm even closing in on finishing all the NFL and NCAAFB shortcuts. 

I think everyone will be very happy, but remember, the goal is to start with a site that allows input of SDQL and returns accurate results. Once we have that working, more good stuff will follow. 

I have some cool things cooking pertaining to lines. 

I'm storing the line, as well as the odds from various sources. The lines will update at least once per day. You could enter something like, "HF and line fd>9" to see how +9 dogs do according to the FanDuel line.

Here's what the lines are. 

• line is the consensus line
• line ce - Ceasars
• line ci - Circa
• line dk - Draftkings
• line fd - Fan Duel
• line lv - consensus Las Vegas
• line mgm - mgm
• line mir - mirage
• line pb - points bet
• line sh - sugarhouse
• line sp - south points
• line ub - unibet
• line wh - william hill

I'll have more info soon. 

[GoodBadUgly]

Gambrinus, regarding the lines...that's super awesome!

[Timothy Cate]

Gambrinus: that is Phenomenally  Phenomenally  Phenomenally  Phenomenally  Fantastic, sir... let me know of any resources you lack to support and or add comfort to this cause... made my day seeing this.... thank you!!!

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/4f3ad2a6-1ee3-496a-816a-722eb34cd853n%40googlegroups.com.

[John Dickey]

Looks good! 

BTW, thought Caesars and William Hill joined to become Caesar’s Sportsbook… or is there a difference between the Vegas and online listings?

JD

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/4f3ad2a6-1ee3-496a-816a-722eb34cd853n%40googlegroups.com.

[Biz P]

Gambrinus,

Incredible work you have done. 

Like the others have said, any assistance you need count me in.....and many thanks for your efforts..

On Monday, July 26, 2021 at 5:21:54 PM UTC-7 Gambrinus wrote:

[smc chandler]

hadn't read this thread........... have the administrators thought of cutting down on the data items for each game?............ i'm guessing 99.9% of users probably use 15% of the data at most. and 15% sounds really high if you include player data (which i did use some)

[wes...@colorado.edu]

Gambrinus,

Thank you for your hard work and I will gladly throw you some cash.

I have several projects that are going to be completely sidelined by the SDQL3 rewrite.

On another note, does anyone know if Joe is going to allow SDQL2 access past September 1, 2021? 

I realize this is probably a stupid question and the answer is "No" given all of the warnings on the website.

Thanks,

Andrew

[Gambrinus]

Hi Andrew, 

I'm not sure what you're doing, so I can't answer on compatibility. Right now my continued focus is to get the NFL and NCAAFB operational. Then I'll be able to look at other things. 

Good luck. 

[TripleC106]

Is there a link to the new site you are working on yet? Thanks for the hard work.

[Gambrinus]

I have a few people testing it. Still need to iron out some kinks. I'm doing my best to have it ready before the season.

[John Ryan]

I would love to take a test drive and have built many large databases in my career. So, I have been talking with Austin Wang as well. But, p[lease give me a chance to see it in action and a chance to be a help to bring this awesome project to the and through the finish line. Please let me know as soon as you are able. TY

 

John Ryan

 

John Ryan Sports

--

You received this message because you are subscribed to the Google Groups "SportsDataBase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sportsdatabas...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/8e7ae456-48f8-4c6d-9ee4-9bc7ec4ff385n%40googlegroups.com.

[Ed Miller]

Does this mean I don't have to go back to school to become a programmer? (smile, and thanks!!!)

--
You received this message because you are subscribed to the Google Groups "SportsDataBase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sportsdatabas...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/c5a2bcf1-f008-46da-a854-5eeceac8b46dn%40googlegroups.com.

[Andrew Roupas]

any update?

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/CADYzonjJnOzdyJYCvhmvX0sqSjsjDkPVs9g1k4PGrO%2Bw1P-PJQ%40mail.gmail.com.

[OffshoreInsiders.com]

It's up. Great job, except as of a half-hour ago, no 2021 data. 

[Andrew Roupas]

Besides that though, which should be fixed were good to go? If I may ask again, will we be writing the code in with short cuts or by long hand? Either way works am just curious as I cannot pull any NFL results ATM... 

Best,

Andrew

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/96539451-eb2f-43ee-9412-b60ae4792afen%40googlegroups.com.

[OffshoreInsiders.com]

I am VERY open to someone who has an enhanced suggest for better display but so far my decent understanding has this for ATS

date,day,week,season,team,o:team,site,line,ats margin,S(points+line>o:points),S(points+line<o:points)@

Normal SDQL goes after the @ 

[Andrew Walker]

Hi Andrew,

So which site are you using? 

[Andrew Roupas]

killersports.com - what is the correct site now?

Thank you again!

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/0ae66c92-39b3-4626-9a9c-81ae6b7c36f3n%40googlegroups.com.

[Andrew Walker]

Not too sure mate. I was waiting to see if Gambrinus was going to post the new site. 

I only just realised that killersports is still working for NFL. I thought they were only keeping it open for MLB

[OffshoreInsiders.com]

https://s3.sportsdatabase.com

[Rayray821]

Any update? I can't seem to figure out how to work s3.sportsdatabase.com at all. Anyone have some pointers on how to write the queries we are used to writing or what the difference is?

[Gambrinus]

It's looking pretty good. I have several beta testers using it. We're doing our best. This week is possible. 

[vegasniceguy]

Gambrinus, Thank you very much for what you are doing. It is greatly appreciated!

[E Miller]

I believe Killer Sports still working for MLB, but that's about it (NFL doesn't return anything).

I remain confused about the fate of SDQL-based web sites with regards to a front-end interface for those of us who are not programmers. Is that what Gambrinus is doing, building a user-friendly front-end? If so, cannot wait!!

[Eric Arnold]

I agree with Ed.  I am able to use the Killer Sports website to query the database, like normal, for MLB.  I've been using the S3.sportsdatabase.com for NFL and NCAAF with very limited success.  Queries that worked last weekend, do not work now.  I don't know if someone is actively working inside the database, which is why a simple query like @line<-13 returns syntax error gibberish, or something else.  I'm not a programmer.  I do know as of yesterday, the data for the 2019 and 2020 seasons in college football were either incomplete, or wrong.  Teams would show 5 games played for 2019.  Other teams would show two games played on the same day against two different opponents.  One positive:  @team=OHST returned gibberish as of two days ago.  It seems to now produce correct results.  However, @team=OHST and o:team=MICH still doesn't work.  I don't know if the query structure I'm using is wrong, or the database is jacked up.  I think it's the latter, as these queries used to work.

I got my hopes up when I got that email from whoever the new proprietors of Killer Sports are.  That was over a week ago.  It's a shame.  This database was like having a crystal ball.  I, like the rest of us, am hoping for something that works soon.  I'll be happy to pay for it, too.

[Gambrinus]

Have faith and patience fellas, we're really close. We won't launch until it's ready. This is complex and it takes time to develop. There are also things beyond our control that are in play as well. We'll get you exactly where you want very soon. Here's a sneak peek:

[Andrew Walker]

Gambrinus, keep doing what you are doing mate. Its amazing that you're putting your own personal time into building what looks like an amazing database for us. 

[TripleC106]

Out of curiosity, will the queries return ATS/OU/SU/Teaser records along with the margins and average lines/totals automatically like would happen before?  Also, will we be able to sort?  The S3 database does not and this is very frustrating.  I was given an input to get the record info only but it seems to be adding the games the query applies to.  The last version was so much cleaner and easier to read.

[Andrew Roupas]

Gambrinus we all owe you brother - thank you again and let me know if there is anything I can do to help.

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/9191b4a9-5677-4bf7-8db4-56ab6b919ce9n%40googlegroups.com.

[JB]

Guys, SDQL3 really isn't as bad as it seems. Yes, it's not as pretty but it is still functional and usable while Gambrinus puts the finishing touches on his site. If you need help using SDQL3 and want more frequent updates of what is going on behind the scenes, join the Sports Wagering and Analytics Group discord: https://discord.gg/BqD9kxggjc

Many people there will be able to help you figure it out. And guess what? SDQL3 is pulling from the database that Gambrinus made, so if you find issues, they can be addressed very quickly. 

[TripleC106]

My issue is it seems some conditions arent working. When I utilize p: for previous game I get errors or when I utilize season>=2016 I get no results or errors too. I just wish we could sort and get return results for the records I mentioned above. To me that was the most important info. Getting a list of games doesnt do too much good if I cant see the accurate record of wins and losses along with the average margins and lines/totals. If there is a way to do this please let me know. Its too much to sit there and add up every win and loss to get a total record. I think too much work is being put into this to not get similar results that we were getting before. If the inputs actually work, that parts not that bad. It’s the result you get that I am not a fan of.

[Andrew Walker]

Hi JB,

is it still accessible even without a token and username? I just joined the discord group and the information is gold. 

I have tried to run a few queries without having a token and I dont actually get the table showing the SU, ATS and O/U records like it used to show on sportsdatabase. I just get a long list of previous games and their results. 

Any info you can provide will be much appreciated. I am definitely not a programmer or a data analytics guru so this change to SDQL3 is a little hard to comprehend. 

Thanks mate

[E Miller]

Gambrinus,

Hello, just curious, are you close? Apologies for appearing anxious but with each passing football weekend, I get that much more antsy. As always, many many thanks for your efforts.

On Wednesday, September 15, 2021 at 5:34:28 PM UTC-4 Gambrinus wrote:

[OffshoreInsiders.com]

Not sure what the exact question is. SQL is working https://s3.sportsdatabase.com Not all the traditional shortcuts are for example "WP." Killer did tell me they hope to bring back the store option, but the basics are ready.