You need a person to optimize the database structure and requests to it.

We are seeking an experienced web developer to re-engineer and fix critical bugs in an existing web application. The application was developed using pure JavaScript (Vanilla JS), without frameworks, and is deployed on Vercel. Currently, the application is functional but experiences intermittent crashes and freezes in certain functionalities that require urgent attention. The application's technical stack includes: - Frontend: HTML5, CSS3, ES6+ JavaScript. - Backend/Data: Supabase (using PostgreSQL, Auth, and Realtime) and Upstash (for Redis). - Deployment: Vercel. The main objective of this project is to identify and resolve the root causes of the problems, as well as optimize the code to improve stability and performance. Key tasks include: 1. Thorough analysis of network errors and logs available in Supabase and Upstash to pinpoint the source of the failures. 2. Refactoring the JavaScript code to ensure robust handling of loading and error states. 3. Optimizing state persistence on the frontend. 4. Improving communication between the client and Supabase/Upstash services, including query efficiency and secure API integration. The current code, although generated with AI assistance (Claude Code), has a logical and modular structure, but requires human review and expertise to achieve the necessary quality and robustness standards. The developer is expected to have a solid understanding of modern JavaScript, relational and non-relational databases, and cloud deployment platforms.

Copying the database and front for the database (Currently, the front is partially copied and some characteristics are incorrect. The parser filled the database with its own characteristics) Synchronizing the parser with the database and the characteristics of the database Fixing the bug in the parser agent Cropping photos proportionally to the watermark that comes from the parser Working with the buffer with the new database and tools with the objects of this database Fixing minor bugs: for example, text in pop-ups, or small issues on the front, bugs that appear during task execution Connecting a new storage for media storage Logs have stopped writing to the financial operations table, which affects the balance and tariff plan pages (payment of the tariff, account replenishment (successful/not)) Check the payment functionality again and then replace the test billing API from Monobank with the real one Refine access rights for the database administrator user There are currently hanging processes that load the server; this needs to be checked The logic of comments and notes is currently working incorrectly; it needs to be such that for the same object in 2 databases - comments are tied to each database, not to the object, the source of which is the object of this database (I can explain in more detail in private) Fix the sorting in the databases correctly (Currently from the first added to the last. It needs to be the opposite; the sorting functionality is created) Check and correct the accuracy of filters in the databases, possibly add restrictions on filtering with large data volumes

It is necessary to migrate a custom project from CodeIgniter 2 to Laravel 12. I will provide details in private messages.

Project The existing website is developed on Symfony. The project needs to be taken over for support, familiarize with the code, and subsequently carry out improvements. Main tasks Implement all technical recommendations from the SEO specialist according to the provided technical assignment. Make changes to the monument configurator according to a separate list of requirements. Implement the updated website design (layout and integration of the new design). Carry out further technical improvements and support for the website as needed. Expectations from the developer Familiarization with the project structure and codebase. Assessment of costs and timelines for each stage. Adherence to the existing project architecture and quality implementation of changes. Maintaining communication regarding task execution and possible technical solutions.

I want a bot for Telegram. Loading dialogues. With the help of AI, checking for potential lies. A website with advanced features. Registration, API, statistics, etc.