The latest articles on DEV Community by ckoshien (@ckoshien). https://dev.to/ckoshien https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F119959%2F8d536350-af8c-4bde-b874-3b755e28565d.png https://dev.to/ckoshien en ckoshien Fri, 21 Dec 2018 07:06:18 +0000 https://dev.to/ckoshien/about-technology-used-for-baseball-league-score-management-system-9m6 https://dev.to/ckoshien/about-technology-used-for-baseball-league-score-management-system-9m6 <p>I will introduce technology of the current baseball league score management system developed personally and the technology of the developing system.</p> <h1> About the current baseball league score management system </h1> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--B3iSPijF--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://storage.googleapis.com/deviita/upload_images/b08b548caec5795ad40e35af9c85f4c95c0241635d9a3.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--B3iSPijF--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://storage.googleapis.com/deviita/upload_images/b08b548caec5795ad40e35af9c85f4c95c0241635d9a3.png" alt="image"></a></p> <p>It is a CMS that provides breaking of players results for <a href="http://jcbldata.fc2web.com/cbl_index.html">Japan Colorball Baseball League</a>.<br> I am developing, operating, adding new functions from June 2015.</p> <h1> Function introduction </h1> <h2> Season results page </h2> <p>This page is called in the frame from the official page of the baseball league.<br> It is a specification to display the top ten place except team ranking.</p> <ul> <li>Team ranking</li> <li>Personal batting division <ul> <li>Batting average</li> <li>hits</li> <li>homeruns</li> <li>RBI（runs batted in）</li> </ul> </li> <li>Personal pitcher division <ul> <li>ERA（earned run average）</li> <li>Number of victories</li> <li>Save</li> <li>Strikeouts</li> </ul> </li> <li>Personal non-title division <ul> <li>OBP(On base percentage)</li> <li>Double</li> <li>Slugging percentage</li> <li>Fourballs</li> <li>OPS</li> </ul> </li> </ul> <h2> Player personal page </h2> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--1ZWC9252--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://storage.googleapis.com/deviita/upload_images/e40e06bce35e3ceca1be5b957251e7805c024cbc9d874.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--1ZWC9252--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://storage.googleapis.com/deviita/upload_images/e40e06bce35e3ceca1be5b957251e7805c024cbc9d874.png" alt="image"></a></p> <ul> <li>Introduction of player (belonging team, title summary etc.)</li> <li>Batting results (by period, by opponent team)</li> <li>Pitching results (by period, by opponent team)</li> <li>Graphs of the above</li> </ul> <p>The graph is implemented by highcharts.</p> <h2> Team introduction page </h2> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--O1bZPLE9--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://storage.googleapis.com/deviita/upload_images/7f39cb0c5dca52ee81244c660d3c2ff65c024aef4da4a.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--O1bZPLE9--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://storage.googleapis.com/deviita/upload_images/7f39cb0c5dca52ee81244c660d3c2ff65c024aef4da4a.png" alt="image"></a></p> <ul> <li>Total results for each season</li> <li>Recent result of victory / defeat</li> <li>Total batting results of team member</li> <li>Total pitching results of team member</li> </ul> <h2> Statistics page </h2> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--AC0ft8x9--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://storage.googleapis.com/deviita/upload_images/dff46e83372943224665879750da16be5c024fc71a26e.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--AC0ft8x9--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://storage.googleapis.com/deviita/upload_images/dff46e83372943224665879750da16be5c024fc71a26e.png" alt="image"></a><br> I am implementing the participant transition graph by season and team using highcharts.</p> <h2> All period total score page </h2> <p>The league itself has been held since 2004, and the results data has been inputed from 2010 to 2018. The layout is the same as the season results page.</p> <h2> Continuing participant grades page </h2> <p>It displays a list of the participants' participation in the last two years.<br> The layout is the same as the season results page.</p> <h2> slack / pushbullet (push notification) collaboration </h2> <p>There is an push notification for slack and pushbullet.</p> <ul> <li>Long-term weather forecast acquisition</li> <li>Schedule adjustment</li> </ul> <h1> Technology used in (current) baseball league score management system </h1> <h2> Backend </h2> <ul> <li>Language: Java 8</li> <li>FW: SAStruts (It became EOL while continuing operation)</li> <li>DB: MySQL 5.7</li> <li>AP server: Tomcat</li> <li>WEB server: Nginx</li> </ul> <h2> front end </h2> <p>Although the base is still JSP,I am proceeding APIization and client rendering, and are dynamically generated with ajax + datatables.<br> jQuery / <a href="https://materializecss.com/">materialize</a> / <a href="https://datatables.net/">datatables</a><br> I use Noto Sans Japanese font mainly, the number part is Roboto font.</p> <h1> About the baseball league score management system (under development) </h1> <p>I explained the current system.<br> However, since SAStruts is an EOL technology, it is currently being renewed in a modern development environment.<br> From here on I will introduce about the system under development.</p> <h2> Backend (under development) </h2> <ul> <li>TypeScript / NodeJS / Express</li> <li>DB: MySQL 5.7</li> <li>Netlify</li> </ul> <h1> Front end (under development) </h1> <p>The design continues to be based on materialize, and components use react-bootstrap that is user friendly.</p> <ul> <li>ReactJS</li> <li>component library <ul> <li><a href="https://react-bootstrap.github.io/">react-bootstrap</a></li> <li><a href="https://react-bootstrap-table.github.io/react-bootstrap-table2/">react-bootstrap-table-next</a></li> </ul> </li> <li><a href="https://www.chartjs.org/">chart.js</a></li> <li>materialize</li> </ul> <h2> Functions only available in beta version under development </h2> <p>I implement these functions not implemented in current systems.<br> New features are being implemented from where I thought.</p> <h3> Batting average distribution graph </h3> <p>The league has also been running for a long time, and there is nothing but a certain normal data if it is not a clean normal distribution.</p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--pks0Eimt--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://storage.googleapis.com/deviita/upload_images/aa4dd599478ee4d40f9496e64b955de75c025692ec31f.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--pks0Eimt--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://storage.googleapis.com/deviita/upload_images/aa4dd599478ee4d40f9496e64b955de75c025692ec31f.png" alt="image"></a></p> <h3> Each player ability chart </h3> <p>Although it is a difficulty that the standard deviation calculation process is somewhat heavy, it speaks eloquently the character of the athlete than sentences.</p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--D2_Otd6F--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://storage.googleapis.com/deviita/upload_images/7dde7d39177c2fc8ac81e6e469fa63b55c0256b957aab.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--D2_Otd6F--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://storage.googleapis.com/deviita/upload_images/7dde7d39177c2fc8ac81e6e469fa63b55c0256b957aab.png" alt="image"></a></p> <h1> Task </h1> <h2> The API response is slow </h2> <p>Because I am using a server with a low spec, API response takes about 1 second. I am planning to change the server.</p> <h2> There is no design sense </h2> <p>UI's sense is devastating because the experience of the business system was long.<br> UI is still under trial and error.</p> <h2> I did not write the test code </h2> <p>It is basically human test...(haha)<br> Recently I started using Jest so write the test code ....</p> <h2> There are many pages </h2> <p>Although it becomes the story of the UI mentioned above, since it has many pages, what kind of menu is used and what to do with conductors ... is that.</p> <h1> Original Post </h1> <p><a href="https://crieit.net/posts/0431d68ab5279f65797e41cfc18a0eb5">野球リーグスコア管理システムに用いている技術について</a></p> java react node