SQLite

[Président ANHS]

Has anyone started or completed building a website using only the SQLite database? My tech guy is currently working on that and he keeps saying that the results are awesome simply for the fact that it accelerates the loading time of the information a lot compared to using the csv and xml files.

Anyone want to share their work so far?

[SimonT]

I’m happy to see someone using the SQLite database.

In the future, I might build some php files but I have nothing done right now. I’m working in making the default website even better in 2.3.1.

[RPHALabs]

Hi Simon,

AS Steff has mentioned, I have been using the SQLite file to begin building his website, and its working very well. Response time is great, and easy to use. However, I am come across some naming conventions that I believe you need to change.

Table: ProTeam Finance

1) On your Schema page(http://sths.simont.info/DatabaseInfo.php) Field "SalaryCapToDate" does not exist in the Db, but the field is called "Payroll" I believe. So this should be changed on your page to reflect as that page is very helpful to have open while working.

2) Error in the field SpecialSalaryCapY3 currently called "BonusSalar3" this should be changed immediately in the Db to keep in sync with your schema and other fields SpecialSalaryCapY1-10

I haven't gone through every table yet, but as I come across them I will post here for you to update.

Thanks for this

[RPHALabs]

Also the same "Payroll" field for TeamFarmFinance

[RPHALabs]

Table: LeagueGeneral

There is a field for ProScheduleTotalDay But none for FarmScheduleTotalDay. Often this value can be different it is needed to calculate expenses. Could this be added to the next release?

[RPHALabs]

VisitorTeamName and HomeTeamName are in the "SchedulePro" table but no listed in your web schema

[SimonT]

Hi.

The Payroll field is now call SalaryCapToDate in the database.
"BonusSalar3" field was renamed to SpecialSalaryCapY3.
FarmScheduleTotalDay was added in the League General.
I fix the web schema. I had TeamName value after because I think it was easier to read 1 table with all the information instead of having to do another query to Team*Info table. If you want other location where you think it’s be worth to add this kind of daa, tell me.

[RPHALabs]

This is great. I agree its great to have the name in the table. All I meant was that it wasn't showing on your web schema.
I would also like to make a suggestion in renaming a fields as well. PlayerPro(Farm)Stat, GoalerPro(Farm)Stat 4 different field names for the penalty shots

Goalies:
PenalityShotsShots
PenalityShotsGoals

Players:
PenalityShotsScore
PenalityShotsTotal

I believe these names can be changed to be equal in all 4 tables, and switched to a more english field name like all others:

PenaltyShotsShots
PenaltyShotsGoals

The description makes sense for both, and its easier to remember while working penalty shots sections.
Your Thoughts?

[RPHALabs]

Tables GoalerProStat and GoalerFarmStat

Fieldname is "Shootout" where I think its suppose to be "Shutout"?

Alternatively, in the SchedulePro and ScheduleFarm the field says "Shutout" where I believe it should be "Shootout"

I hope all these messages are ok, if not please let me know and I will do something different

[RPHALabs]

PlayerInfo, and GoalerInfo Tables

Website Schema says fieldname "InjuryDuration", field in DB NumberOfInjury

[RPHALabs]

GoalerInfo Table, the Overall Field doesnt seem to have the right value in it. in the ANHS league Kris Miller is an 87OV where in the DB its showing 69OV

[SimonT]

Well, it’s the variable name inside the STHS, the name inside the CSV, the name in the XML files so I think it’s better if stay like that to be consistent even with error.

NumberOfInjury is fix in the web schema.
GoalerOverall will be fix in 2.3.1.

[SimonT]

Note : This thread might also interest you : http://sths.simont.info/Forum/viewtopic ... 740#p49740

[RPHALabs]

Everything else I can come across seems to be working great. Thank you so much for the replies.

I would like to get your opinion on something.

The LeagueLog and TeamLog tables.

There is so much valuable information in there that can really be used in many places on a website. Is there anyway you can make a few more fields to make the table more useful?

Examples

1) Some sort of filter field that denotes the type of transaction, it could be an integer field or text
Just as an example

0 - Trade
1 - Waivers
2 - Injury
3 - Roster Errors
4 - Line Errors

2) Another field if the transaction is happening in the pro or farm.

Example, in the LeagueLog file it may say:
"Aaron Kriss from BlackHawks is injured (Strained Back) and is out for 1 week."

There could be a BlackHawks in the pro, and a BlackHawks in the farm (like the Montreal Canadiens used to be with the Fredericton Canadiens) Or in a fictional league, Maybe there is another BlackHawks thats the farm team for a different pro club. To me it seems there is no way to differentiate that by. Or maybe add injuries and other type of information to the TeamLog.

do you have any thoughts on this?

[SimonT]

Hi.

1) This was already change in 2.3.1!!
2) This is hard to do because I don't calculate if the transaction is Pro and Farm but I like the idea.