Reconstruction of my project as a seller

The project has been stuck for a long time, and it is particularly uncomfortable to come back today. In the past few days, I have been studying Japanese every day and have not had much time to think about the project, but I am always worried, in any case, this project is my dream. After more than a year, I cannot give up. However, I still feel very tired. When I go home, my mood is even heavier, and the pressure on my life is getting bigger and bigger. I used to take care of myself at school and outside, I feel like a person who has lost his or her source of income is not so free to do anything. Besides, the current family's economic situation is not good, now is the most sad time, hi .......

How can this problem be solved?

It may take some time to quickly develop a language. I learned Japanese in August 20 and now I have been learning Japanese for over 10 days. I finally got a feeling, I have discovered that I have made an old mistake again. In fact, a medicine can treat my own illness. If I use it a few times, there will be no major effect. The same is true now, in my heart, I still cannot get rid of the shadows of projects. Sometimes I start to become distracted when I look at books. Hi... Who can tell me how to focus? Haha. I started my work today.

I knew this problem a month ago, but it took me a month to solve it. It was a bit of shame, this month, I have been freed from the company that has been working overtime and returned from Zhejiang. Then I went to train Japanese. In short, I have not spent any time! When I came back this evening, I dragged the project out and managed it properly. The code hasn't moved for a long time, so I made some adjustments on the architecture, find a good solution to some problems encountered in the original ZZW project.

Rebuilding the UI

For the UI layout, the original layout is based on the layout of several websites, which have Douban, together, my wardrobe, And the UI of other websites, and then overlay them by themselves, some modifications were made tonight to extract static resources through configuration and configure them. The problem of browser compatibility has been modified. For browser compatibility, this troublesome problem has plagued me for a long time. The layout on the UI is as follows, it also takes a lot of time to adjust the corresponding CSS and images. I am not an artist myself, and I have a lot of weak capabilities, I am a little afraid of doing this. It is also the reason for the delay in moving the interface. I modified it tonight to solve the error in IE6, IE6.

Summary:

1. CSS files will increase with the continuous improvement of the project. I use the single-file CSS of Douban here, because the interface is relatively simple and similar in layout, there are not many duplicates

2. for compatibility issues, IETester is required (mainly to solve various compatibility issues in IE6 \ 7 \ 8), but it seems that IE7/8 is much better compatible, it mainly solves the problem in IE6, followed by display problems in FIREFOX and Google Chrome. We recommend that you use a simple interface.

3. Make good use of FireBug in Firefox. It is good for obtaining the layout of others' websites and promoting understanding of HTML, CSS, and JS. We recommend that you use

4. for the layout and elements of the interface, if you need to use the JS framework in your project, you need to plan the layout of the interface before development. For example, I used the JQuery framework in the seller Project, it is necessary to standardize the name of the ID for operation, especially when it is emphasized that planning is still very important.

 

DB Reconstruction

After listening to the video of the development history of Douban.com's technical architecture, I found that I had a better understanding of the overall process of developing a Web website. "Rome was not built in one day ." Every project is the same. There is always a process. But how can we grasp business changes and activate your code in this process, your code changes a little and reduces repetitive work, which is relatively basic. Therefore, I am very grateful to Douban.com for sharing these good experiences. It is better to share the technology of such sites in China. In fact, many technical staff share technical information, however, large companies are restricted by confidentiality agreements. Even if you think about confidentiality agreements, these are only forms, but they are also the company's assets. If you think about yourself as the boss, you have to do the same, sorry.

I have learned a little bit about database reconstruction recently. This project is used as an example:

I am a seller and use MySQL 5

1. for the data type, the best way is to reverse the database of a large project and obtain the ER relational table of the database if there is no special Database Designer project in the initial stage of the project, however, most of the databases are still MYISAM storage engines (now we can see the UcenterHome, Which is MyISAM). In this way, the reverse table can be used to summarize the data types, you can have a rough understanding of the types used by the storage.

2. databases are the foundation and core of a project, and there are many things to consider. For a good architecture, some extensions can be reserved for the design of the architecture to be considered as a large site, but don't design too much. I have no experience in the reserved expansion of databases. In this project, the database design also suffers a lot. Remember not to design too much, the reserved part is allowed.

3. Conversion from business to data entities requires a process. From business to data entities to final storage, this process is relatively difficult, and the level of database designers is also reflected here. For the business logic, there is an entity and a link here. We need to flip down the database books. It is recommended that you spend about a week to supplement the knowledge of the database, it is very helpful for design.

4. Different development and deployment environments require detailed descriptions of database deployment. For example, the database version, database engine, table structure, and initial data filling. In this way, you can save a lot of time for repeated operations during migration.

5. this is very important for database design synchronization. It was encountered during the ZZW project in March. Many problems were encountered when PD12.5 was used for database design synchronization, this is especially troublesome for many tables. The current practice is to submit modifications to a Database Synchronization operator instead of modifying all of them, just now, MySQL WorkBench supports synchronization. You can use it to design and unify the database. Here we will introduce MySQL WorkBench. I use OSS 5.1.18, which is basically enough in China.