Mysql Projects
Looking for freelance Mysql jobs and project work? PeoplePerHour has you covered.
opportunity
MySQL Query Optimization for Charity Website
We are seeking an experienced MySQL developer to analyse and optimise slow SQL queries for our website hosted on a shared server environment. Our monitoring has identified a significant number of slow queries that are adversely affecting server performance and website loading speeds. Background: During routine server monitoring, we discovered that our website is generating slow MySQL queries that are consuming extensive CPU and memory resources, leading to a degradation in performance. Scope of Work: Analysis of Slow Queries: Review the log file located at (****) containing 1,181 slow queries. Identify key factors contributing to the slow performance. Optimise the top 10 slowest queries, which have execution times ranging from 29.1 to 44.1 seconds. Implement query restructuring and indexing strategies to reduce execution time. Testing and Validation: Test the optimised queries to ensure they meet performance improvements. Validate that changes do not negatively impact the functionality of the website. Reporting: Provide a comprehensive report detailing changes made, before and after execution times, and any recommendations for further improvements. Deliverables: A detailed report of analysis and optimisations performed. Implementation of query optimisations in the live environment. Final validation report showing performance improvements. Timeframe: The project needs to be completed within three days of commencement. Selection Criteria: Proven experience in MySQL and database performance tuning. Ability to work efficiently under tight deadlines. Previous experience with high-traffic websites on shared servers is preferable.
12 hours ago21 proposalsRemoteopportunity
Need a front-end App to access the data from MySQL
We have a JAVA application and we want to develop a lighter version of the app using vue JS and Java API to create a responsive app.
18 days ago42 proposalsRemotePHP / MYSQL Programmer (UK Based)
We have a part completed website and need a PHP / MySQL programmer who is based in the UK. We have lots of ongoing work.
19 days ago38 proposalsRemoteurgent
FULL STACK DEVELOPER
We are looking for a super talent to join our team, good-natured, personable and professional in PHP Laravel, Node.js, TypeScript, MySQL, MongoDB, Docker, AWS, and React to join our dynamic team. The ideal candidate will have a passion for creating innovative solutions and possess excellent problem-solving skills. Responsibilities: Develop and maintain web applications using PHP Laravel, Node.js, TypeScript, and React Design, implement, and manage databases (MySQL, MongoDB) Containerize applications using Docker for easy deployment and scalability Deploy and manage applications on AWS cloud infrastructure Collaborate with cross-functional teams to define, design, and ship new features Optimize applications for maximum speed and scalability Implement security best practices and ensure data protection Stay up-to-date with emerging technologies and industry trends Participate in code reviews and provide constructive feedback to peers Requirements: Proven experience as a Fullstack Developer or similar role Strong proficiency in PHP Laravel, Node.js, TypeScript, React, MySQL, MongoDB Experience with Docker for containerization and deployment Familiarity with AWS services such as EC2, S3, RDS, Lambda, etc. Solid understanding of web development fundamentals (HTML, CSS, JavaScript) Excellent problem-solving and analytical skills Ability to work independently and as part of a team Good communication and interpersonal skills Preferred Qualifications: Experience with microservices architecture Knowledge of CI/CD pipelines and automated testing Familiarity with GraphQL Contributions to open-source projects Job Type: Full-time Status: Remote Pay: +2K US Dollar per month Application Question(s): Are you available to join immediately? Do you have minimum 1 year experience in PHP Laravel, Node.js, TypeScript, and React Experience: Full-stack development in HR field: 2 years (Required)
8 days ago80 proposalsRemoteExpires in 22Outgoing features to develop
Essential ( must speak English and UK hours ) Previous work experience or qualifications in a Web Development role Knowledge of/experience in Laravel and Vue (or something similar) Knowledge of/experience in MySQL (or something similar) Experience of monitoring and maintaining systems and networks Experience of solving technical and application issues by phone, email or in person Additional Skills Ability to work effectively as part of a team Ability to adapt feedback and criticism Effective self-organisational skills Strong problem solver All-round computer literacy Ability to establish good working relationships with colleagues Responsibilities A successful applicant would understand the importance of testing and documenting their work in an agile team environment. You will join a small team of experienced developers. Your main responsibility will be to enhance the LMS with new features and to fix any bugs that may arise. You will work closely with the IT support desk.
a month ago29 proposalsRemoteopportunity
Web Development Project Manager
I run a small web development firm that develops custom web applications and websites. We are growing and getting new customers each month. We are looking for a web development manager to join our remote team. Our developers are based in the far east and all have good English. Our customers are in UK and USA. You have experience and knowledge of: Web development project phases Excellent understanding of PHP coding, MySQL databases, web hosting, DNS, websites, design Translating customers needs into clear tasks for developers Interfacing directly with technical developers Ensuring developers are motivated Interfacing with non-technical customers Ability to test what developers have done and provide clear feedback Ensuring development tasks are chased and completed Ensuring urgent tasks are progressed Ensuring customers are updated with status and progress Generating development tasks from proposals Assisting developers with problem solving Work remotely with remote developers and remote customers Available to interact with customers in UK and USA during their working day Excellent written and verbal English Available for phone or video calls with customers Ability to create short demo videos for customers. Please, no AI responses.
21 days ago39 proposalsRemoteopportunity
Magento 2 issues - ajax 404 and indexing problem with two sites
Do you thrive on tackling intricate eCommerce challenges? We're seeking a highly skilled Magento 2 developer to diagnose and resolve two critical issues impacting our store's functionality. The Challenge: Issue 1: Defective Configurable Product Swatch Functionality Clicking a configurable product swatch on the catalog page results in a blank product image instead of an updated photo, as expected. Browser console reveals a 404 AJAX error. Importantly, this issue is isolated to the catalog page and does not occur on the individual product page. Issue 2: Conflicting Reindexing Between Separate Magento Installations We maintain two independent Magento 2 installations on the same server with distinct databases. A critical problem arises when reindexing one site: products mysteriously disappear from the catalog of the other site, and vice versa. Your Role: You'll meticulously investigate the root cause of both issues using your in-depth knowledge of Magento 2 architecture and debugging techniques. Develop and implement a robust solution to ensure proper configurable product swatch functionality on the catalog page, eliminating the 404 error. Formulate a sustainable strategy to address the reindexing conflict, guaranteeing seamless reindexing for each Magento installation without impacting the other. Maintain clear and concise documentation throughout the troubleshooting and resolution process. The Ideal Candidate: Proven experience as a Magento 2 developer (2+ years) with a solid understanding of core functionalities and best practices. A keen eye for detail and a methodical approach to problem-solving. Proficiency in PHP, MySQL, and debugging tools. Excellent communication and collaboration skills.
18 days ago32 proposalsRemoteopportunity
Drupal 7 Website Migration to Latest Version Drupal 9
Project Overview: We are seeking an experienced Drupal developer to assist in migrating our existing Drupal 7 website to the latest version of Drupal. The goal of this project is to ensure that our website remains up-to-date with the latest features, security enhancements, and performance improvements offered by the latest Drupal release. Project Scope: Convert the current Drupal 7 website to the latest version of Drupal (Drupal 9). Ensure all existing content, functionality, and design elements are successfully migrated to the new version. Update and optimize any custom modules, themes, or configurations to be compatible with Drupal 9. Ensure that the URLs of the new website remain the same as the old one to maintain SEO rankings and minimize disruption to users. Perform thorough testing to identify and address any issues or inconsistencies that arise during the migration process. Implement best practices for performance optimization, SEO, and security in the new Drupal installation. Key Deliverables: Successfully migrated Drupal 7 website to Drupal 9 with all content and functionality intact. Optimized and updated custom modules, themes, and configurations for compatibility with Drupal 9. Comprehensive testing documentation outlining the testing process and any identified issues or resolutions. Finalized Drupal 9 website with improved performance, security, and SEO features. Requirements: Proven experience in Drupal development, with specific expertise in migrating websites from Drupal 7 to Drupal 9. Strong proficiency in PHP, MySQL, HTML, CSS, and JavaScript. Familiarity with Drupal module development, theming, and configuration. Ability to troubleshoot and resolve compatibility issues during the migration process. Excellent communication skills and ability to collaborate with our team to ensure project success. Timeline: The project timeline is flexible and can be discussed based on the developer's availability and estimated completion time. However, we aim to complete the migration process in a timely manner while ensuring thorough testing and quality assurance. Budget: Our budget for this project is negotiable and will be based on the developer's experience, expertise, and proposed approach to the migration process.
19 days ago18 proposalsRemoteFull-Stack Developer with React.js and Node.js Expertise
Job Description: We are seeking a highly skilled and experienced Full-Stack Developer to join our team on a large-scale project. The ideal candidate will have a strong background in both front-end and back-end development, with specific expertise in React.js for front-end and Node.js for back-end services. This project involves building a robust, scalable, and high-performance web application that will be used by a wide range of users. Responsibilities: ● Develop and maintain the front-end of the application using React.js, ensuring high performance and responsiveness. ● Build and maintain back-end services and APIs using Node.js that will support the functionality of the web application. ● Collaborate with designers and other team members to convert designs and wireframes into high-quality code. ● Design and implementation of data storage solutions, including databases and server-side logic. ● Ensure the entire stack is designed and built for speed and scalability. ● Integrate various third-party services and APIs such as payment gateways, social media, geolocation, etc. ● Write clean, maintainable, and efficient code. ● Perform code reviews and enhance the performance of existing applications. ● Stay plugged into emerging technologies/industry trends and apply them into operations and activities. ● Provide detailed updates to project managers and stakeholders regarding development progress. Skills and Qualifications: ● Strong proficiency in JavaScript, including DOM manipulation and the JavaScript object model. ● Thorough understanding of React.js and its core principles, along with popular React.js workflows (such as Flux or Redux). ● Proficiency in Node.js and frameworks available for it (such as Express, StrongLoop, etc). ● Familiarity with RESTful APIs and experience in API design and development. ● Understanding of front-end technologies, such as HTML5 and CSS3. ● Experience with user authentication and authorization between multiple systems, servers, and environments. ● Integration of multiple data sources and databases into one system. ● Understanding of database systems such as MySQL, MongoDB, Oracle, and/or PostgreSQL. ● Knowledge of code versioning tools such as Git. ● Excellent problem-solving skills and ability to perform well in a team-oriented environment. Additional Requirements: ● Bachelor’s or master’s degree in Computer Science, Engineering, or a related subject. ● Proven track record of delivering large-scale projects successfully. ● Excellent communication skills and fluency in English. Project Details: ● Duration: 6+ months ● Hourly Rate: Negotiable based on experience ● Commitment: Full-time preferred, minimum 40 hours per week How to Apply: Interested candidates should submit a proposal detailing their qualifications, a portfolio of relevant projects, and at least two references. Please include your expected hourly rate and availability. This is a fantastic opportunity to work on a project that will be utilized globally and to expand your skills in a dynamic and supportive environment. We look forward to your applications!
6 days ago25 proposalsRemote
Past "Mysql" Projects
Mysql developer
I need a mysql developer assist with the development of a mysql database. I am developing a database of New Zealand lawyers. The database contains public details about them including email address and date of admission to the profession. There are about 16000. I am looking for someone to help me develop the database. A good knowledge of mysql is essential. I am AWS Lightsail Database on the web, and phpmyadmin on a local machine. It is for a php website.
pre-funded
PHP Function For Same Page Login With JavaScript
This project seeks a fully functional PHP login script integrated with MySQL that enables same-page authentication. The login form and processing should exist on a single page allowing the user to enter credentials which are then verified against the database. On success, the user's session should be initialized granting access to authorized areas of the site. The code provided must include a registration system, password hashing according to contemporary standards, and validation/sanitization of all user inputs. Preference will be given to submissions that demonstrate extensibility, security best practices and good coding style.
opportunity
Wordpress redesign and Fix.
We require a freelancer to redesign a WordPress site and implement the redesign on the live site. The freelancer should also have experience with PHP and MySQL tasks. The current site is available at [www.verifyonline.co.uk]. The freelancer should upload the design file and HTML of the attached design. If successful the project includes ongoing separate tasks for the site, which may not be part of WordPress. ( to be quoted ongoing)
Python Expert Urgent Project Deadline 2days
Software will listen to some tcp messages. When the message arrives, decode the message. Write the encoded message in a mysql table. Write the decoded information in 2 tables. Total fields to be decoded is less than 10. We provide the NodeJs version (attached) of the decoder, you will have to make the python version
Website data scraping
I need to scrape 9 data points from a website and put them into mySQL database. I have one table with these 9 fields. I need a script which runs every hour, scrape data and load the data into this table in mysql database.
Website migration and updates
This project involves migrating an existing website from its current hosting platform to a new host, Web Central. The site transfer will require uploading all website files to the new host's server. Once transferred, the main navigation menu will need to be updated to reflect any structural or page changes. Additionally, an online booking module must be developed and integrated onto the site to allow customers to make reservations directly through the website. It seems the current host may have been compromised, redirecting visitors to an incorrect domain. Therefore, the secure and stable hosting provided by Web Central will resolve this issue. Familiarity with server administration, common web programming languages like HTML, CSS, PHP, and databases like MySQL is preferable to complete this project smoothly. The goal is to have the new site launched on the new host within two weeks with the updated menu and functional booking system in place.
PHP / MySQL Coding
Hi We have an existing website and wordpress developer, however we need someone based in the UK to work alongside our wordpress developer. Must have experience of PHP / MYSQL and be based in the UK. thanks
ASP.NET Expert Required Urgently
Hi We have some 'small business management software' which has been running a few years now. It tends to run fine all the time however we have a glitch at the moment with it. We require someone to resolve the issue & be on standby for any future issues. The software is in DOTNET. The database is MYSQL. The software is being hosted on our server. Demo videos: https://drive.google.com/drive/folders/1SjO2m1f0WNL8md1HTUUbSJi_xFvYGxOx?usp=sharing Regards Justin Proactiv
CodeIgniter PHP System to a Progressive Web Application
Complete conversion of a PHP system (based on CodeIgniter framework) into a Progressive Web Application that will be functional on mobile applications and tablets. Also addition of some functionalities on the system. The complete technology stack is PHP as base language and MySQL as the database.
opportunity
Dev req to Complete Dynamic Calendar Feature with vis.js
I am seeking an experienced developer to finalize the integration of a dynamic calendar feature into an existing web-based employee training management application. This feature should provide a monthly view, displaying completed events such as trainings, meetings, and feedback for each employee. It should also indicate the week number for each week, allow filtering by time period and event type, and dynamically reflect any changes in employee status, updating to show past events accurately. The application is developed using procedural PHP, MySQL, jQuery, and Bootstrap, and this new feature needs to be implemented following the MVC architecture utilizing OOP in PHP. Current Progress: MVC structure is already implemented in the project. Database connections are established, and PHP classes have been set up. vis.js has been integrated with an initial example configured. Initial attempts have been made to display a list of employees from the database on the page, but this is not completed. Requirements: Complete Employee List Display: Fetch and display the list of employees on the calendar from the database. Events Display and vis.js Customization: Fetch and display past trainings, team meetings, and feedback events on the timeline, corresponding to each listed employee. Customize event display in vis.js with distinct colors for each type of event: Blue background with a centered 'M' for Meetings. Green background with a centered 'S' for Schulungen (Trainings). Orange background with a centered 'B' for Bewertung (Feedback). Event Filters and Date Picker Implementation: Implement checkboxes to filter the timeline display by event type. Integrate a "Month and Year only" date picker to allow users to select which month and year to view. Real-Time Updates: Ensure the calendar updates dynamically when new employees are added or existing employees leave the company. Automatic Event Update Logic for Calendar Feature: Implement an automatic update mechanism that ensures past events are dynamically displayed in the timeline. Deadline: I need this completed within a maximum of 4 days. Tools and Technologies: MVC, OOP PHP, MySQL, PDO, vis.js, JavaScript, fetch API, HTML, CSS, Bootstrap.
opportunity
Need an experienced php developer
We seek a highly skilled PHP developer to expand our live tracking capabilities. The selected freelancer will integrate our system with Firebase to implement real-time notifications and updates. The developer must have extensive experience building APIs for live data synchronization between client and server systems. Some key responsibilities include utilizing Firebase's webhook functionality to forward device registration tokens to our backend, allowing the publication of notifications to specific devices or segments of users. The developer will also implement logic in our backend APIs to manage subscriber lists for different notification types and handle responding to requests from the Firebase console. Strong knowledge of JSON, REST APIs, and frontend-backend integration is required. Candidates must demonstrate past experience architecting similar real-time syncing solutions between mobile and web applications. Proficiency with PHP 7+, MySQL, and JavaScript/Node.js is mandatory. US-based freelancers are preferred for better communication and collaboration.