Sprint Summary Essay -- code crafters

目录

 I. Project expected planning and actual progress

II. Experience of the project 

III. Collaboration and workload distribution  

IV. Existing issues

V. Outlook for the next stage

---

 I. Project expected planning and actual progress

NO.	Time	Plan	Principal	Reality
1	2023.11.22-11.23	Realize registration, login, send mail function	Wang Zhengxian, Zou Yijie, Wen Zongyan	Completed
2	2023.11.24-11.25	Realize friends, confession, chat function	Wang Zhengxian, Lin Chenwei, Chen Kun	Completed mostly, the confession  is not yet successful
3	2023.11.26-11.27	Design user interface	Wang Xinyi	Completed
4	2023.11.28-11.29	Servers connected to the front and back ends	Wu Zhenkun, Qiu Weixiang, Yu Yuxin	Completed
5	2023.11.30-12.01	Test the functions	Yuan Chengrui, Fang Guangxian	Completed

Present results display:

注册登录

 

好友聊天

II. Experience of the project 

Members	Experience
Wangxinyi	In general, it was physically and mentally exhausting. Dealing with the problems of the team members was much more difficult than development. The different levels of development skills, the cooperation of the members, and the follow-up of the progress are all very mentally and physically exhausting. Some partners can't express their demands directly for various reasons, so as a team leader, you should take the initiative to walk into the team to find out the problems of your partners and solve them in time. Regarding the UI interface, I used unity's own ugui, I was very rusty in using some controls, and spent a lot of time in finding solutions, but I can feel that after the study, I have improved in this aspect, and I have mastered new skills in designing interfaces for software.
Fangguangxian	I learned a lot of practical testing skills and methods, and further understood the whole process of software development and the importance of teamwork. I think the role of testing is crucial in the project, which can help us find and solve problems and improve the quality and stability of the software. I am grateful to be able to participate in this project and to be able to make a contribution to the team's success through my testing work. I will continue to work hard to learn and improve my testing skills to prepare myself for future project development work.
Wuzhenkun	In this project I was part of the server setup, which we implemented using the remote communication protocol socket. The client through the socket will need to call the interface name, method name and parameter serialization passed to the server. The server deserializes and then uses reflection to call the corresponding method and return the result to the client. Until then, I had no idea about this stuff. It was only on the advice of the technical team leader and many attempts at other servers that we chose this. It's nice to gain new knowledge again!
Qiuweixiang	For RPC I had no contact with it at all before, I checked the information on the Internet, read the tutorials of Android APP developer tools written by other csdn bloggers as well as the code of its implementation, but I always found something that was not related to what I was looking for, so I studied it through the video on the B station, and found the content that was slightly in line with the current task, and the technical team leader and the other members of the team were also constantly and carefully guiding me during the process, so I ventured to try it out. The technical team leader and other team members also kept teaching me carefully in the process, so I boldly tried to do it, and I learned more knowledge and mastered more skills in the process.
Wenzongyan	I felt the challenge and fun of actual project development. In the classroom, we learn a lot of theoretical knowledge, but by participating in this project, I really realize the gap between theory and practice. In the project, I need to apply what I have learned to solve practical problems. In this process, I encountered many difficulties and challenges, but through continuous efforts and learning, I gradually overcame these difficulties and achieved certain results. This practical project development experience not only taught me a lot of new knowledge, but also developed my problem solving and teamwork skills.
Yuyuxing	After studying software engineering for nearly a semester, I was in a state of half-knowledge of software engineering and not quite able to connect theory with practice. To the current countdown stage, our team has experienced the pre-preparation work of bonding, github teamwork coding, each suitable for the work area is gradually clear, the team leader to coordinate, which really understand the soft work in the teamwork. Soft work needs to accumulate little by little to need to use the content, mainly most of the content is never touched, such as the RPC remote procedure call protocol I learned this time. The process was painful but rewarding.
Chenkun	In this project, I was a member of the front-end development team, responsible for the interaction of two users' friend chat. During this development, I realized that I was lacking in my ability to fix bugs and find appropriate solutions. This is very unfriendly to inexperienced students (such as me, who doesn't know front-end at all), there are a lot of things to learn, and it's very tiring to learn, and it's very painful when you can't figure out the problem. But I benefited a lot.
Yuanchengrui	About this alpha sprint: This is my first time to follow a project to develop a complete software project, which is a great challenge and a very interesting experience for me. In this process, I was mainly responsible for software testing, including functional testing, requirements checking, use case writing and defect management. I started to learn software testing from the ground up and eventually helped the team to successfully complete all the testing points we encountered in the alpha sprint. This gives me a sense of accomplishment and helps me to be more confident and courageous to contribute to the team in my future project development work! Translated with DeepL.com (free version)
Wangzhengxian	I am mainly responsible for the back-end development, because I have previous experience in back-end development, so I am more skillful than other students who are responsible for the back-end. Originally, I thought that compared to the front-end, the back-end would have less code to write and less things to do. Although it is true that the amount of code to be written feels less, but the back-end is not easier than the front-end, especially the deployment and management of the server is my responsibility, the front-end interaction problems I have to reply and deal with in a timely manner to avoid delays in progress.
Linchenwei	In this alpha sprint, I was responsible for part of the front-end development, the front-end development of the required language and so on is I have almost never come into contact with, in the early stage is really know nothing about it, the progress is slow, and the division of labor is very irrational, so people have no motivation and irritable. Later in the technical team leader's help and guidance before gradually mastered a little foundation. The atmosphere of the team is very important, especially for people like me who are easily infected by the atmosphere. The overall atmosphere of our group was okay, and the team members who participated put in a lot of effort, thanks to them. All in all, emo and rewarding.
Zou Yijie	Through participating in this project, I deeply realized the power of technology and the universality of application, and I learned a lot of programming knowledge. In this project, we use C# language and asynchronous programming pattern to store user account information through MySql database. The application of these technologies makes our system more efficient and stable.

III. Collaboration and workload distribution  

832101201_21124477_Wangxinyi	UI design, Front end of second-hand trading function, Summary blog	9.00%
832102204_21125929_Fangguangxian	Test the functions, Code Standards, Sprint Tasks, and Plans	9.00%
832102208_21126917_Wuzhenkun	Servers connected to the front and back ends, Third blog	8.87%
832102209_21125309_Qiuweixiang	Servers connected to the front and back ends	8.78%
832102228_21126895_Wenzongyan	Realize registration, login, send mail function, defense PPT	8.78%
832102222_21125414_Yuyuxing	Servers connected to the front and back ends, Fourth blog	9.00%
832102218_21125261_Chenkun	Realize friends, chat function	8.78%
832102223_21126348_Yuanchengrui	Test the functions, Test blog	10.05%
832102211_ 21124744_Wangzhengxian	Realize registration, login, send mail, friends, chat function, Create a database of friend lists	10.10%
832102220_21126496_Linchenwei	Realize friends, chat function, Second blog	8.86%
832102210_21126909_Zouyijie	Realize registration, login, send mail function, First blog	8.78%

IV. Existing issues

There are still two functions not yet realized: confession wall and second-hand goods trading.
The campus network is sometimes unstable, and the sensitive word detection server is sometimes delayed.
Can't post pictures, and the database is slow to get string.

V. Outlook for the next stage

Improvement of software functions: the database of the friend list has been completed, and the front and back ends are still working on the bugs. the second-hand trading and confession wall are intended to be similar to the form of community posting.

Support image upload function: Research and implement the image upload function to ensure that images can be uploaded safely and displayed correctly on the relevant pages. At the same time, it is also necessary to consider appropriate size and format restrictions for images to avoid excessive burden on the database and server.

Optimize database query performance: optimize the performance of database query operations, reasonably design the table structure, and use appropriate indexes to speed up the query; use caching technology to reduce direct access to the database; and reasonably use database connection pooling to improve the connection reuse rate and so on.