BOSI v2 Preview

CommishJoe · 12-07-2003, 01:30 PM

http://bosi.allin1websolutions.com/v...v2_preview.htm

My apologies for the cross post. Feel free to ask any questions you might have.

A.J. Holz · 12-07-2003, 01:40 PM

Awesome, Joe! Can't wait!

Will there be an upgrade path for leagues that are using BOSI v1 right now? Also, since my league is hosted on the BOSI server, will that data be updated, or will we have to start from scratch?

CommishJoe · 12-07-2003, 01:48 PM

Quote:

Originally posted by A.J. Holz
Awesome, Joe! Can't wait!

Will there be an upgrade path for leagues that are using BOSI v1 right now? Also, since my league is hosted on the BOSI server, will that data be updated, or will we have to start from scratch?

Central and official servers will be upgraded automatically(after being backed up of course

), and data will be brought along with it. The only thing I might not be able to bring forward will be amateur draft picks. I plan on totally overhauling the way I store that information. It is my intention to provide an upgrade path for those as well, but I might not be able to pull it off.

Currently, our upgrade script is 285 lines and growing. The database is being changed in a lot of ways:

1. I'm using a new table type .. Inno DB. It allows me to have foreign keys. This means that if 2 tables are related, a value must exist in the master table in order to be referenced in the child one. For example, in PLAYER, a TEAM_ID has to exist in the TEAM table before it can be used in PLAYER. What this also does is allow me to "cascade delete". When I say delete from PLAYER where PLAYER_ID = 1, it not only deletes the player record, but all his stats, ratings, history, etc. as well.

2. Putting bosi_ in front of all tables so you can install it in an existing DB and not worry about it overwriting any of your existing tables. This could come in handy if your plan has a small # of MySQL DBs available.

3. Taking all the Month, Day, Year columns and making them into a date field.

4. Paying close attention to indexes. They take up some storage space, but, when created properly, they make the application run much faster.

potatoman · 12-07-2003, 01:53 PM

Are we going to beta test it on IABL?

EagleEye_0 · 12-07-2003, 01:54 PM

Looks good Joe.

CommishJoe · 12-07-2003, 01:55 PM

Quote:

Originally posted by MeTsKiD33
Are we going to beta test it on IABL?

IABL is on the central server, so no, they will not be involved in the beta testing.

potatoman · 12-07-2003, 02:11 PM

I see a bug...I checked out the jacktest page and i checked out my Mets. In team records, it says Josh Beckett with 11 wins but last season, he was with me for 1/2 the season and had 13 wins with me....

CommishJoe · 12-07-2003, 03:08 PM

Quote:

Originally posted by MeTsKiD33
I see a bug...I checked out the jacktest page and i checked out my Mets. In team records, it says Josh Beckett with 11 wins but last season, he was with me for 1/2 the season and had 13 wins with me....

Thanks for your enthusiasm, but this data isn't ready for beta testing. It's a cut from the central server, but it's not live data, and it's not using the new importer that I am currently working on.

clarnzz · 12-07-2003, 04:57 PM

Thanks for all your hard work to make the OOTP experience an even better one. Looking forward to it.

Cuss16 · 12-07-2003, 05:03 PM

looks great!

jmaness84 · 12-07-2003, 05:47 PM

is metskid AKA Potatoman?

EagleEye_0 · 12-08-2003, 02:16 AM

Yes, and that should be a nomination for worst name change ever

.

Joe, I'm going to be looking at adding B.O.S.I for the UBL. Do you think I should wait for v2 or add v1 and then look to update? Will updating be an easy process?

Karen Lutz · 12-08-2003, 02:52 AM

Quote:

Originally posted by jmaness84
is metskid AKA Potatoman?

yes.

JimiP · 12-08-2003, 07:33 AM

Joe:
Looks great !l ove the 'career' path development report - sweet - plus the way in which you and the boys packed the info in - it's AbFab!
I recall you making mention of wa way for Commishes to access 'computer owned' teams in the upgrade - to help facilitate any trades etc., is this still a go ?
Again thanks a plenty from me and i'm sure i speak for the rest of the OOTP Community in this matter too.

Matteo · 12-08-2003, 08:24 AM

Quote:

Originally posted by JimiP
l ove the 'career' path development report - sweet

He Joe, did you read that!

CommishJoe · 12-08-2003, 08:50 AM

Quote:

Originally posted by EagleEye_0
Yes, and that should be a nomination for worst name change ever .

Joe, I'm going to be looking at adding B.O.S.I for the UBL. Do you think I should wait for v2 or add v1 and then look to update? Will updating be an easy process?

Upgrading should be as easy as running a script in MySQL and uploading the new files. We are going to do our best to make upgrading as easy and painless as possible.

As to when you want to start using BOSI, that's completely up to you. I figure we still have at least 2 months worth of effort before this version is released.

CommishJoe · 12-08-2003, 08:52 AM

Quote:

Originally posted by JimiP
I recall you making mention of wa way for Commishes to access 'computer owned' teams in the upgrade - to help facilitate any trades etc., is this still a go ?

We haven't gotten to the new login logic yet, but we should be able to work this in.

CommishJoe · 12-08-2003, 08:52 AM

Quote:

Originally posted by Matteo
He Joe, did you read that!

Yep, and I agree 100%. It was a great idea .. thanks for suggesting it!

Subby · 12-08-2003, 11:33 AM

Joe -

Will an update to your exporter accompany this? I am still hoping for a new fielding characteristics export that inlcudes ALL fielding data for a player in one record (as opposed to now, where a record exists for each player's position.)

Thanks!

CommishJoe · 12-08-2003, 11:35 AM

Quote:

Originally posted by Subby
Joe -

Will an update to your exporter accompany this? I am still hoping for a new fielding characteristics export that inlcudes ALL fielding data for a player in one record (as opposed to now, where a record exists for each player's position.)

Thanks!

Not for that, no. 1 record per position is what BOSI, CATO, and probably kq76's utility are based on, so I won't be changing that in the main exporter. However, I will work you up something special once BOSI v2 is released and the accompanying questions settle down. Just keep bugging me about it so I don't forget

12-07-2003, 01:30 PM	#1
CommishJoe Global Moderator Join Date: Feb 2002 Location: Minneapolis, MN Posts: 5,238	BOSI v2 Preview http://bosi.allin1websolutions.com/v...v2_preview.htm My apologies for the cross post. Feel free to ask any questions you might have. __________________ Joe Success isn’t owned. It’s leased. And rent is due every day.

12-07-2003, 01:40 PM	#2
A.J. Holz All Star Reserve Join Date: Apr 2002 Location: Atlanta, GA Posts: 650	Awesome, Joe! Can't wait! Will there be an upgrade path for leagues that are using BOSI v1 right now? Also, since my league is hosted on the BOSI server, will that data be updated, or will we have to start from scratch? __________________ NABA - Tijuana Toros / Commish ORB - Oakland Athletics (former owner) MBBA - Seattle Storm JOBL - Grand Forks Varmints (former owner) FIBB - Chicago Fire TMBU - Tulsa Tomcats (former owner) ACL - Oakland A's (former owner) ACB - Rockville Superbas

12-07-2003, 01:53 PM	#4
potatoman Hall Of Famer Join Date: Dec 2002 Location: New Jersey Posts: 2,410 Infractions: 0/1 (1)	Are we going to beta test it on IABL? __________________ GFBL - Storm - 5 seasons - 500 - 310 New Jersey Nighthawks (1227-717) Last 5 seasons 2011: 118-44 2012: 100-62 2013: 111-51 2014: 106-56 2015: 108-54 OTBA Champions: 2008, 2010,2011

12-07-2003, 02:11 PM	#7
potatoman Hall Of Famer Join Date: Dec 2002 Location: New Jersey Posts: 2,410 Infractions: 0/1 (1)	I see a bug...I checked out the jacktest page and i checked out my Mets. In team records, it says Josh Beckett with 11 wins but last season, he was with me for 1/2 the season and had 13 wins with me.... __________________ GFBL - Storm - 5 seasons - 500 - 310 New Jersey Nighthawks (1227-717) Last 5 seasons 2011: 118-44 2012: 100-62 2013: 111-51 2014: 106-56 2015: 108-54 OTBA Champions: 2008, 2010,2011

12-07-2003, 05:03 PM	#10
Cuss16 Hall Of Famer Join Date: Dec 2002 Location: BC, CANADA Posts: 2,994	looks great! __________________

12-07-2003, 01:54 PM	#5
EagleEye_0 All Star Starter Join Date: Feb 2002 Location: Los Angeles, CA Posts: 1,426	Looks good Joe.

12-07-2003, 04:57 PM	#9
clarnzz All Star Starter Join Date: Jun 2002 Location: Following everyone off a cliff. Posts: 1,522	Thanks for all your hard work to make the OOTP experience an even better one. Looking forward to it.

12-07-2003, 05:47 PM	#11
jmaness84 All Star Starter Join Date: Nov 2002 Location: Georgia Posts: 1,685	is metskid AKA Potatoman?

12-08-2003, 02:16 AM	#12
EagleEye_0 All Star Starter Join Date: Feb 2002 Location: Los Angeles, CA Posts: 1,426	Yes, and that should be a nomination for worst name change ever . Joe, I'm going to be looking at adding B.O.S.I for the UBL. Do you think I should wait for v2 or add v1 and then look to update? Will updating be an easy process?

12-08-2003, 07:33 AM	#14
JimiP Minors (Triple A) Join Date: Dec 2001 Location: Lowcountry SC Posts: 226	Joe: Looks great !l ove the 'career' path development report - sweet - plus the way in which you and the boys packed the info in - it's AbFab! I recall you making mention of wa way for Commishes to access 'computer owned' teams in the upgrade - to help facilitate any trades etc., is this still a go ? Again thanks a plenty from me and i'm sure i speak for the rest of the OOTP Community in this matter too. __________________ Love, Peace & Chicken Grease, chef jimiP

12-08-2003, 11:33 AM	#19
Subby Major Leagues Join Date: Dec 2001 Posts: 375	Joe - Will an update to your exporter accompany this? I am still hoping for a new fielding characteristics export that inlcudes ALL fielding data for a player in one record (as opposed to now, where a record exists for each player's position.) Thanks!