Budget: 1000 UAH Deadline: 1 day
Good day.
I will accept your project for support. The Yii framework (Yii1 or Yii2) is excellent for scalable systems, and having a connection with the previous developer is a huge plus that will allow me to quickly understand the nuances of the current architecture and database structure.
The specified budget of 1000 UAH is conditional and suitable for making the first small adjustments. For ongoing support, we can agree on a fixed cost for each task pool or an hourly rate.
Technical solution
Database and code audit:
I will deploy a copy of the project in a local environment, analyze the database structure (indexes, foreign key table relationships, presence of outdated or duplicate fields).
I will check the ActiveRecord models of the framework to understand how the application logic interacts with the database and exclude "heavy" SQL queries that may slow down the website.
Safe implementation of changes and migrations:
All changes to the database structure (adding new tables, changing field types) will be implemented strictly through the Yii migration mechanism (yii migrate). This guarantees that when transferring changes from the test server to the production server, nothing will break, and client data will not be lost.
The logic of new enhancements will be separated into individual components or service layers to maintain code cleanliness and the architectural pattern MVC established in Yii.
Query optimization (SQL):
I will analyze logs and slow queries. If the database is overloaded, I will set up proper lazy/eager loading of data (with() in ActiveRecord), add necessary indexes in MySQL/PostgreSQL, and optimize complex selections.
What is needed to start and assess:
What version of the framework is being used (Yii 1.1 or the second branch Yii2)?
The first list of adjustments or a description of the task that needs to be completed first.
Access to the repository (GitHub/GitLab) or an archive with the code and database dump for review.
Send the details in private messages — I will promptly study the task, communicate with your previous executor if necessary, and formulate a clear work plan.