Page 5 of 7

Re: Forum update

Posted: Sat Sep 02, 2017 7:39 am
by sealhall74
Ouch, Patty V, we have a problem. Looks like the conference site has a new way of displaying results and getting to the boxscores and it looks like scraping the stats to automatically fill in the weekly StatPick result will need some work. Not a big issue as I can easily enter the StatPick value by hand like I did this week but ST, if you any ideas on how best to scrape dynamic javascript-generated page content, I would be a willing listener.

Re: Forum update

Posted: Thu Sep 14, 2017 12:20 am
by ST_Lawson
Just FYI, I was putting in my picks tonight and it kept giving me an error message as it was trying to save them. I think it did, but if not, I can PM you a pdf of my picks before Saturday. I don't know if everyone is having the same issue, or if it's just me, but I thought I should let you know.

Re: Forum update

Posted: Thu Sep 14, 2017 1:38 pm
by sealhall74
ST_Lawson wrote: Thu Sep 14, 2017 12:20 am Just FYI, I was putting in my picks tonight and it kept giving me an error message as it was trying to save them. I think it did, but if not, I can PM you a pdf of my picks before Saturday. I don't know if everyone is having the same issue, or if it's just me, but I thought I should let you know.
Do you recall what the error message was? It looks like your picks are there now. I am urging everyone to login sometime after submitting to make sure their picks are good. The one problem that I am seeing occasionally is sometimes I see 12 blank rows in the main Picks sheet. Not sure if someone timed out during the submit process or what is going on. When that happens, it screws up the formulas and a few other things. A player could then login and it would appear to them they have no picks in place. Easy to fix, I just delete the empty rows and resort (if necessary) the picks for the week. Next season, we are moving to MySql for sure.

Update: This might be what you ran into:

2017-09-14 01:17:43 Form Submit 3 Caught Exception with message=Service error: Spreadsheets

Re: Forum update

Posted: Wed Sep 20, 2017 5:20 pm
by sealhall74
ST, does your hosting service provider support running node.js/javascript apps? If I have throw a lot of code away, I am leaning to Node.js/express.js framework on the server and AngularJS framework in the browser along with Mysql as the backend database.

Re: Forum update

Posted: Wed Sep 20, 2017 9:26 pm
by ST_Lawson
sealhall74 wrote: Wed Sep 20, 2017 5:20 pm ST, does your hosting service provider support running node.js/javascript apps? If I have throw a lot of code away, I am leaning to Node.js/express.js framework on the server and AngularJS framework in the browser along with Mysql as the backend database.
Here's the situation with node.js on the current host: https://help.dreamhost.com/hc/en-us/art ... s-overview
We currently run on shared hosting, but the lowest level of VPS might be within the current website budget. I'd have to take a look at what the ad has brought in on average and see if we can swing it.

Re: Forum update

Posted: Wed Sep 20, 2017 10:11 pm
by sealhall74
ST_Lawson wrote: Wed Sep 20, 2017 9:26 pm
sealhall74 wrote: Wed Sep 20, 2017 5:20 pm ST, does your hosting service provider support running node.js/javascript apps? If I have throw a lot of code away, I am leaning to Node.js/express.js framework on the server and AngularJS framework in the browser along with Mysql as the backend database.
Here's the situation with node.js on the current host: https://help.dreamhost.com/hc/en-us/art ... s-overview
We currently run on shared hosting, but the lowest level of VPS might be within the current website budget. I'd have to take a look at what the ad has brought in on average and see if we can swing it.
I would be willing make up the difference to take us to the level above the lowest level if you are interested in going there. Regardless of level, moving to the SSD that comes with the VPS should be a noticeable improvement for everyone.

Re: Forum update

Posted: Thu Sep 21, 2017 11:30 am
by ST_Lawson
sealhall74 wrote: Wed Sep 20, 2017 10:11 pm I would be willing make up the difference to take us to the level above the lowest level if you are interested in going there. Regardless of level, moving to the SSD that comes with the VPS should be a noticeable improvement for everyone.
Did a check of what the ad has made for the site, and since I instituted it in April of 2014, we have averaged just a bit over $33 per month of revenue.

The entire account that we have currently is using 1.8 GB of disk space.

Dreamhost has 1GB of RAM and 30GB of SSD storage for $15/month
or 2GB of RAM and 60GB SSD for $30/month

Over the past year we've averaged 37,389 pageviews per month, which works out to (if you consider the site "active" 12 hours of the day), approximately 1.5 pageviews per minute, and our "busiest" day in the past year would have been 4.2 pageviews per minute.

It's unlikely we'll max out 30 GB any time soon unless we have some specific need, but do you think the difference in RAM is going to make a huge difference to the speed of the site and stuff?

I can get you lots of other numbers if you want, or we can see about going ahead and moving to the $30 level, having the website fund cover it and if we get to the point where we're not averaging $30/month, then I'll let you know and you can chip in some.
Or, we could go with the $15/month level, start with that, see how it goes, and if we decide we need to step up to the next level, we can do that pretty easily (since it's a virtual server).

Thoughts?

Re: Forum update

Posted: Thu Sep 21, 2017 12:40 pm
by sealhall74
ST_Lawson wrote: Thu Sep 21, 2017 11:30 am
sealhall74 wrote: Wed Sep 20, 2017 10:11 pm I would be willing make up the difference to take us to the level above the lowest level if you are interested in going there. Regardless of level, moving to the SSD that comes with the VPS should be a noticeable improvement for everyone.
Did a check of what the ad has made for the site, and since I instituted it in April of 2014, we have averaged just a bit over $33 per month of revenue.

The entire account that we have currently is using 1.8 GB of disk space.

Dreamhost has 1GB of RAM and 30GB of SSD storage for $15/month
or 2GB of RAM and 60GB SSD for $30/month

Over the past year we've averaged 37,389 pageviews per month, which works out to (if you consider the site "active" 12 hours of the day), approximately 1.5 pageviews per minute, and our "busiest" day in the past year would have been 4.2 pageviews per minute.

It's unlikely we'll max out 30 GB any time soon unless we have some specific need, but do you think the difference in RAM is going to make a huge difference to the speed of the site and stuff?

I can get you lots of other numbers if you want, or we can see about going ahead and moving to the $30 level, having the website fund cover it and if we get to the point where we're not averaging $30/month, then I'll let you know and you can chip in some.
Or, we could go with the $15/month level, start with that, see how it goes, and if we decide we need to step up to the next level, we can do that pretty easily (since it's a virtual server).

Thoughts?
I think the $15/month plan is sufficient to get started. Question: when someone posts with an image from the web, does the image get copied to PHPBB or does it just maintain the link to the image?

Re: Forum update

Posted: Thu Sep 21, 2017 2:59 pm
by ST_Lawson
sealhall74 wrote: Thu Sep 21, 2017 12:40 pm
ST_Lawson wrote: Thu Sep 21, 2017 11:30 am
sealhall74 wrote: Wed Sep 20, 2017 10:11 pm I would be willing make up the difference to take us to the level above the lowest level if you are interested in going there. Regardless of level, moving to the SSD that comes with the VPS should be a noticeable improvement for everyone.
Did a check of what the ad has made for the site, and since I instituted it in April of 2014, we have averaged just a bit over $33 per month of revenue.

The entire account that we have currently is using 1.8 GB of disk space.

Dreamhost has 1GB of RAM and 30GB of SSD storage for $15/month
or 2GB of RAM and 60GB SSD for $30/month

Over the past year we've averaged 37,389 pageviews per month, which works out to (if you consider the site "active" 12 hours of the day), approximately 1.5 pageviews per minute, and our "busiest" day in the past year would have been 4.2 pageviews per minute.

It's unlikely we'll max out 30 GB any time soon unless we have some specific need, but do you think the difference in RAM is going to make a huge difference to the speed of the site and stuff?

I can get you lots of other numbers if you want, or we can see about going ahead and moving to the $30 level, having the website fund cover it and if we get to the point where we're not averaging $30/month, then I'll let you know and you can chip in some.
Or, we could go with the $15/month level, start with that, see how it goes, and if we decide we need to step up to the next level, we can do that pretty easily (since it's a virtual server).

Thoughts?
I think the $15/month plan is sufficient to get started. Question: when someone posts with an image from the web, does the image get copied to PHPBB or does it just maintain the link to the image?
Ok, I'll look into switching over at some point. Says that it might take a little bit to do and the site would be down, so I'd want to do it when there's a slow time.

At this point, when someone puts in an image, it's hosted elsewhere and it's just linked to from here (other than the profile images).

Re: Forum update

Posted: Thu Sep 21, 2017 5:29 pm
by sealhall74
During test and development, I will be prototyping the new app by using sqlite instead of mysql for the database. I see that Dreamhost makes sqlite available on all of their servers so it could be a possibility for production as well if we dont need a full-blown database server. Sqlite is blazingly fast but not generally used for apps with a lot of concurrent users.