How to use mysql administrator jobs

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

Hi there. I'm running XCode 15.3 and I need a few pages done with simple, clean storyboards and View Controllers. I use Alamo Fire and Swift, so if you could use that to pull my data via my API links and display it in several pages that would be great. Categories > Collections > Items > Item Details You select one and it shows a list - Item Details is one record from a MySQL db I need each selected item to be a variable in the code of the ViewController so if I use the print function, I can see it at the bottom of XCode. I'll give you the 3 or 4 API webservice links. I can give you a super simple app to put it in too...

...experienced developer to provide long-term maintenance for my e-commerce website. The ecommerce is up and running and fully operational and we need a FULL STACK developer that can code in ALL AREAS of the webapp. - Frontend: React (JavaScript) - Backend: Node.js - Services: Python - Database: MySQL RESPONSIBILITIES: - Integration of new B2B APIs - New payment gateway integration - - Implementation of bug fixes and performance improvements. - Regular software updates and security patches. - Feature additions and enhancements. Skills and Experience: - Proven experience in maintaining e-commerce solutions. - Proficiency in React, Node.js, Python, and MySQL. - Strong problem-solving skills. - Excellent understanding of software best practices and design patterns. - ...

...need of a PHP page that helps our agents to send an order. This page should be intuitive and user-friendly while ensuring all necessary information is captured. The platform should be interactive and user-friendly, ensuring a smooth order submission process for our agents. Ideal Skills: - Proficient in PHP - Strong experience in web development - Knowledge in creating secure web forms - Experience in agent-based systems would be a plus Please bid for this project if you believe you have the skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel file containing the products that he wants to sell. ...

...terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must be able to see and edit all after importing with an interface you will create in Microsof...

We need an experienced Magento developer to assist with updating third-party extensions when conflicts arise due to newer php/mysql versions. Timeline: Start on the first project on 20th May using remote desktop tools like UltraViewer or AnyDesk for real-time collaboration. Bidders must be highly proficient in Magento 2.4x.

...application that can carefully monitor a MySQL database on my Windows system. The app should be able to perform the following functions: - **Monitoring MySQL Database**: The application should constantly monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application t...

We are in search of a skilled software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Pre...

...developer to help with a personal project. Using NodeJs and NextJs with MYSQL DB, your skills will include: - Expertise in utilizing NodeJs and NextJs - Develop a user-friendly platform - The ability to brainstorm and bring creative digital solutions - Strong problem-solving skills - Understand project requirements and deliver high-quality work - Should be proficient in using Github with AWS and coordinate with infra team member for coordinated push - Understands and knows the importance of proactive communication Expectations: - Your primary responsibility will be to design and develop the application, and to coordinate with the rest of the team working on different layers of the project. - Daily commitment for a minimum of 4 hours from Monday...

I have two websites that need to be merged with a main focus on consolidating information. The current websites are different in design and themes, and I'm looking for a professional who can successfully merge them into a cohesive, user-friendly site. Key requirements: - Consolidate information: The primary goal is to combine and organize the content from both websites into a single, easily navigable platform. The new website should provide a clear and seamless user experience. - Prioritize by relevance: The content should be arranged in a way that is most relevant to the user. This may involve restructuring and reorganizing information to ensure that the most important details are easily accessible. Ideal skills and experience: - Proficiency in we...

I'm looking for a skilled artist who can create a replica of an existing image in a cartoonish style. The replication should closely resemble the original but with...image will be used for digital purposes, such as on websites and social media. Key Requirements: - Replicate an existing image in a cartoonish style - Maintain a close copy of the original with altered elements - Ensure the final output is suitable for digital use Ideal Skills and Experience: - Proficient in digital art and illustration - Strong understanding of proportions, details, and shapes - Experience in creating cartoonish art - Ability to replicate existing images while adding a unique touch - Understanding of digital use and design principles Please provide examples of your previous cartoo...

We're seeking an experienced developer company to help upgrade a state-of-the art startup MEMBERSHIP PLATFORM; website, iOS & Android apps, and admin panel. **OVERVIEW** The framework is built in versions that are several years old. For example Node JS 7.10.0 and MySQL 5.7.0. Everything needs to be updated to highest stable version that offers support and packages. For Node.Js that will likely be version 18 or 20 Moreover, this project offers an excellent opportunity for more development. **QUOTE: UPGRADE** -Please provide a quote for upgrade of website, iOS & Android apps, and admin panel. -The Framework described below. -Specify team size and roles. -Time frame for completion. **PLATFORM FRAMEWORK & DETAILS** Framework: React, ...

i need to get the services of a developer who understands PHP & Java to correct and update some open source software. I have access to raw code and git hub library. Programs work, but needs some adjustments to get them to operate properly. There is not a lot of parts of the the different software that needs correcting and so i would not expect it to take too long, as most of the features work fine, but there are some features that are not working in correct manner. I want to start off with one application fix. Then if work fine, we can work together to add extra features.

I'm seeking an architectural draftsman proficient in creating a professional drawing of my mixed-use building purchased in 1973. Unfortunately, the DOB and HPD don't have an original layout drawing of my property, which is hindering my process of applying for a Letter of No Objection (LNO) and obtaining a Certificate of Occupancy (CO). The preferred freelancer will have: - A track record in architectural drawing and a deep understanding of building standards prior to 1938. - Proficiency in making comprehensive drawings without original blueprints or plans as a reference. - Broad experience in designing detailed plans that are acceptable for DOB and HPD procedures. - Ability to deliver work within an agreed timeline, as speediness is crucial for this projec...

I urgently need a skilled professional to set up a E-commerce website on AWS. Website is already hosted in AWS instance but due to some error website is stop, We need to start website Tools : php Mysql

...Developer to undertake a project we have. The website we need is a comparison website for Coach hire. This will entail a booking system where Coach companies (Operators) will bid/tender for work etc. Below are the features. User Registration and Authentication: • Users can sign up using their email or social media accounts. • User accounts store personal information, trip history, and preferences. Operator Registration and Authentication: • Coach operators can register and provide details about their services, pricing, preferred locations, etc. User Dashboard: • Users can submit trip details including location, and passenger count. • Users receive quotes from multiple operators. • Users can view and manage their trip requests, quotes, bookin...

I am curr...need of an experienced Django developer to assist me in deploying my Django web application on a VPS hosting provider. To bid on this project, you should: - Have intermediate to advanced level experience with Django and its related technologies. - Be proficient in MySQL, as this is the specific database system that my Django application is built with. - Understand VPS hosting thoroughly. Your role will be to guide me through the deployment process, ensuring that the application runs smoothly and functions as expected on the VPS host. Please show proof of similar projects handled in the past. Your time commitment should be immediate and full-time until completion of deployment. Your proposal should include a plan of action detailing how...

I'm looking to integrate Optical Character Recognition (OCR) into my web application. The primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds so that everything is finished. The application is in spring boot and angular. The database is mysql. Functionality for Taking Photos Using HTML5 and JavaScript, you can use an input element with the type file and the attribute accept="image/*" to allow users to take pictures of documents directly from the browser on a mobile device. Upl...

I'm in need of a skilled photo editor to work on a batch of 10 raw images initially. If the initial batch is to my satisfaction, I have more photos that will need editing. The photos are of jewellery (earrings, necklaces, bracelets), so the metal and stone colour should be clear. Requirements: - Expertise in working with RAW format (NEF to be precise) - Ability to edit photos in a natural and subtle style - Proficient in cropping and grading images The edited photos will be used for online publication, so it's important that the quality be top-notch. If this goes well, I will have more work for you in the future.

Your Responsibilities: System Monitoring and Maintenance You will monitor system health, proactively respond to monitoring alerts, and inspect application and system logs to take appropriate action in case of error conditions. Development and Implementation You will support in defining and implementing Kubernetes deployments and provide consultation in creating Kubernetes manifests for custom deployments. Software Audits and Disaster Recovery You are responsible for software updates, VM configurations, and the system's disaster recovery. • general VM updates and configuration through ours to be built IaC definitions (Terraform, Ansible and Kubernetes) • inspecting newer container images and software versions • planning and executing updates on infr...

I'm seeking an Azure expert to guide me through the AZ-104: Microsoft Azure Administrator certification. Key Tasks: - **Guidance on Key Topics**: I need support in understanding and mastering the crucial concepts covered in the certification. This includes both theoretical and practical aspects of Azure administration. - **Online Sessions**: Regular online meetings would be ideal to discuss questions, share insights, and track my progress. Ideal Candidate: - **Azure Proficiency**: You should have a deep understanding of Azure and practical experience working with the platform. - **Teaching Ability**: Prior experience in tutoring or mentoring would be beneficial. - **Good Communication Skills**: As I'm relying on online sessions, clear and effective commun...

...Frontend: Typescript + NextJS + Tailwind + Vercel + WAGMI + Ethers V5 + Typechain Backend: Typescript + Vercel Lambda + tRPC + AWS + Prisma ORM + Ethers V5 + Typechain + Upstash Redis Database: MySQL (Planet Scale) + AWS S3 Storage Randomization: Gelato VRF Static File Hosting: AWS S3, Pinata Smart Contracts: Foundry, Hardhat Monorepo. Here you go: Objective: Design and implement a scalable backend and frontend system for tracking and displaying NFT transactions similar to the "Activity" feature on OpenSea The system should handle varying loads seamlessly, from 500 to 50,000 users. Tasks: System Architecture Design: Task: Design the overall architecture for the activity tracking system. Include considerations for data collection, storage, processing, ...

I'm in need of a skilled developer to create a score card module using MAUI. This module should allow for the following: - **Score Entry**: Users should be able to input scores into the system. - **Calculation of Scores**: The module should be able to process the inputs and calculate the final scores. - **Display of Scores**: The final scores should be presented in form of summary reports. This module is designed for administrators, so it should only be accessible by those with administrator privileges. Ideal candidates for this project should be proficient with MAUI and have experience with creating data-driven modules. You should be able to integrate various data input methods, develop calculations and create concise, visually appealing repor...

I require a skilled website developer who can build an informational website for me, ensuring it is user-friendly and satisfies the following criteria: - It should feature engaging use case content that is easy to navigate by visitors. - The website's interaction should be based mainly on allowing users to efficiently search for information. Previous experience in creating similar informational websites would be beneficial to achieving the best results. Knowledge in effective SEO practices is also highly desirable.

...adept at enhancing and editing pictures. The pictures I need to be edited are meant for personal use, and they are a of a father and son. Key Requirements: - Color Correction - Retouching - Background Removal - The pictures should be edited in a natural and realistic style. I'm looking to work with a professional who can make these pictures even more special. Ideal Skills and Experience: - Proven experience in picture editing, especially for personal use - Ability to deliver clean, natural and realistic editing - Attention to detail - Strong communication skills, as we may need to discuss the editing direction. Please provide examples of your previous work, especially if you've edited family or portrait pictures before. I...

...looking for a highly skilled development team to recreate a complex web platform in JavaScript. This is expected to be a three to six month project, requiring a minimum of six full time developers. This platform will reside on the AWS network, preferably using MySql and Linux. We will be recreating a PHP/MySQL platform to a JavaScript/MySQL platform with approximately 200 features. This new platform will require a significant upgraded user experience, integration of animated graphics and faster reports processing. Our current platform has some components that are 10 to 20 years old. You will be creating from scratch and not using ANY of the current code. Key Developer Requirements: - Extensive experience in JavaScript platform d...

I am seeking a developer experienced in Apache NiFi to create a workflow pipeline. This will involve converting and integrating data into MySQL. Key Requirements: - Proficiency in Apache NiFi: You must have a solid understanding of the platform to develop efficient and reliable data conversion workflows. - MySQL Integration: Experience in integrating data with MySQL is essential. - Data Conversion: You will be responsible for converting the data - previous experience in this area is highly desirable. Please note the following: - The type and source of data to be converted is not yet defined. - The triggering mechanism and frequency of workflow runs are also pending. Ideal Skills: - Proficient in Apache NiFi - Strong MySQL Integration skil...

...specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the basic complexity level specified. This initial project wil...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.

I need assistance to effectively integrate a post form into my project. The form should be skillfully designed to send data to a MySQL database, and to handle CRUD operations. Key Requirements: - Collaborate with me to understand the form's workflow and user interaction. - Skillfully implement the form to effectively send user data to a MySQL database. - Ensure the form is able to perform Create, Read, Update and Delete operations, where necessary. Ideal Skills: - Proficiency in form implementation. - Strong experience with MySQL databases. - Good understanding of web project workflows. Your bid should demonstrate your understanding of the requirements and provide a clear strategy for how you intend...

...developer to join our team for a long-term project. You'll be responsible for creating innovative functionalities that extend beyond Shopify's default settings, pushing the boundaries of the platform. Here's what we need: Shopify Expertise: In-depth understanding of Shopify's file structure, directories, and templating system (Liquid). Experience manipulating orders, grabbing data from the database, and crafting custom views using Liquid shortcodes. Proven ability to develop custom Shopify plugins to achieve complex functionalities. Technical Skills: Proficiency in Shopify development languages (Liquid, JavaScript, HTML, CSS). Experience with database manipulation (likely MySQL). Communication & Collaboration: Excellent written an...

I'm looking to integrate Optical Character Recognition (OCR) into my web application. The primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds so that everything is finished. The application is in spring boot and angular. The database is mysql

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 co...

...aims to streamline the process of booking slots for various services, ranging from appointments at clinics to reservations at recreational facilities. Our goal is to create a flexible and scalable backend infrastructure that can handle high volumes of bookings while ensuring a smooth user experience. I need a skilled Core PHP Developer to build a custom web application with database management capabilities, using MySQL as the preferred database management system. The application should be well-structured and efficient with an emphasis on data handling. Key Requirements: - Extensive experience working with Core PHP. - Proven track record of developing dynamic, secure, and efficient web applications. - Strong understanding and experience with MyS...

I have an existing Laravel-based ecommerce application that requires a series of modifications a...existing Laravel-based ecommerce application that requires a series of modifications and additions. Key Tasks: - **New Tables & Conditions**: I'm looking to add several new tables and conditions to the application. Skills & Experience: - **Laravel Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience with ecommerce applications. The ideal candidate should be highly proficient in Laravel framework and comfortable creating new tables and conditions within the application. - **Database Management**: A solid grasp on database management is crucial to successfully add and integrate these new tables. Experience with MySQ...

...PHP developer who is well-versed with MySQL to help me with editing the search module of my website. The primary focus of this project is on modifying the way images are retrieved then displayed in the search results. Key Requirements: - Modify the retrieval of images in the search results to use URLs for specific sizes as opposed to the current methodology of storing images locally and then displaying. - No specific enhancements are needed for the image thumbnails, just an adjustment in the retrieval and subsequent display methodology. Ideal Skills: - Proficiency in PHP and MySQL - Experience with implementing search modules in web development - Familiarity with retrieving and displaying images in various sizes - Strong problem-solving abili...

Thumbnail for my monetized/commercial/personal use YouTube video

I need a skilled professional to join my team as a Control Room Administrator and Support Expert for the AA360 system. Key Tasks: - Monitor Bot performance and proactively address any issues that may arise. - Troubleshoot technical issues efficiently and effectively. - Create and maintain roles and user accounts ensuring smooth operations. - Setup and deploy AA360 solutions - Code enhancements and bug fixes Key Requirements: - Proficiency in troubleshooting tools is essential, as well as prior experience with the AA360 system. - An ideal candidate should have experience in control room operations and should be able to demonstrate a solid understanding of this field. Your role will be crucial in maintaining the efficiency and reliability of our system, making this a...

Hi, Nee one simple PhP,MySQL app which will prompt/require for Document-URL: and extract all the short abbreviations inner in (....) from entire document(with PDF,...extensions). The report/result will like this table with 2 columns: sentence | terms-founded | string of terms | check-selection | button "do-it" Then I will select the terms by checking and then I will press the button "do-it" and the selected terms founded between (...) will be savet into MysQl Table. So for Document-URL: this is simple example of line from this report -sentence: "With the deployment of

...website. The website aims to serve as a platform connecting job seekers with employers, facilitating the job search and recruitment process. 2. Scope: The recruitment website will provide a user-friendly interface for job seekers and employers to register, search, and manage job postings and applications. It will include job search, resume upload, employer profile creation, job posting, application management, and communication tools. 3. Functional Requirements: 3.1 User Registration and Authentication: • Users (job seekers and employers) should be able to register on the platform. • Authentication mechanisms should be implemented to ensure secure access to user accounts. 3.2 Job Seeker Features: • Job seekers should be able to c...

I'm looking for a specialist to develop an auto repair shop management software. The software's primary goal is to track and bill for services rendered. I'm looking for a system with two user roles: - Administrator - Mechanic The software also needs to integrate with: - An accounting system - An inventory management system - A billing system Ideal candidates for this job will have experience in developing similar software. They will need to understand the unique requirements and workflows of an auto repair shop. Understanding the importance of accurate tracking, invoicing, and integration with other key systems is vital. Strong skills in the chosen development platform, attention to detail, and superb communication skills are ...

...web developer to create a unique web application tailored to our specific needs. The ideal candidate will have expertise in the following areas: Recommended applications and Technology: HTML, CSS, JavaScript, React/Vue/Angular) Laravel, CodeIgniter, Node.js, Python, Ruby on Rails, PHP, or similar - Database management (MySQL, PostgreSQL, MongoDB, etc.) - API integration - Responsive design **Responsibilities:** - Develop and maintain the web application according to the project specifications. - Collaborate with our team to refine and improve features. - Ensure the application is secure, efficient, and scalable. **Requirements:** - Proven experience in custom web development. - Strong portfolio showcasing relevant projects. - Excellent problem-solv...

Current project is built on Laravel for both front and backend. Need to build React frontend to replace Laravel frontend side. All the pages inside current pages should be moved to React with new template UI and all same functionalities. Main Laravel frontend back end Login this saas/superadmin version (include All modules) USE THIS Admin TEMPLATE FOR Frontend Current system making this stacks - Laravel, MySQL, VueJS, JQuery & Bootstrap, DOCUMENTATION API DOC

...project where I need to connect my Azure Function to an Azure MySQL database. The function is being used as a Web API, and I need it to be able to both read and write data to the MySQL database. Key Requirements: - Development: You will need to establish a secure, reliable connection between the Azure Function and the Azure MySQL database. - Data Handling: The API should be able to retrieve data from the database as well as input new data into it. - Security and Optimization: Ensure proper security measures are in place to protect the data, and optimize the API for performance. Skills and Experience: - Proficient in C#: You should have strong experience working with C# and Azure Functions. - Azure Services: A...

Hello, I need a reliable, fast, and affordable installation of the Stripe payment processor for my website, from someone who keeps their commitments. This person must have knowledge of HTML, PHP, and MySQL. Regards

use translationpress and deepl to auto translate wp into many languages

bjective: To create a website where parents can enter their child’s name, and the name will be automatically integrated into a pre-recorded audio story. The child’s name will be generated using Text-to-Speech (TTS) technology and merged with the main audio file. Scope of Work: Setup and Configuration: Install and configure WordPress on a suitable hosting platform. Ensure the environment is secure and optimized for performance. Frontend Development: Create a user-friendly form for parents to input their child’s name and provide consent. Ensure the form is responsive and works seamlessly across different devices and browsers. Backend Development: Develop a custom WordPress plugin to handle form submissions, generate TTS audio, ...

I need an expert to pull data from my MySQL database, specifically from the Customers and Orders tables, and send it to a Slack channel in a unified message. The data includes text, numeric, and date entries. Key Requirements: - Integrate MySQL data with Slack: I need the freelancer to help me integrate the data entries from the specified tables with a Slack channel. - Collide Entries: The entries from the Customers and Orders tables need to be combined into a single, coherent message. - Include Specific Fields: The message should include specific fields from the MySQL tables. These fields include Customer Name, Order ID, Order Date, Customer Phone Number, Customer User ID, Product Details, and Product Quantity. Ideal Skills and Experience...

I've got a small batch of personal photos that I'd love to have professionally edited. - The pictures need to be enhanced to bring out their best qualities, without looking overdone. - I'd like any unwanted elements removed. It's crucial that the edits are subtle, yet impactful. - The final images should be suitable for personal use, like printing and framing. Ideal Candidate: - Experience in photo editing and retouching - A good eye for detail and creative sensibility - Ability to deliver a high-quality, professional finish. I'm looking for someone who can work efficiently and is open to a few revision rounds, if needed. Please get in touch if you can bring my personal photos to life.

I need a System Administrator to handle both setting up a website using Aruba and maintaining the MX (mail exchange) records. Here's what I'd need assistance with specifically: - Website setup and deployment: This involves general website operation management, hardware and software updates, and ensuring seamless website functionality. - MX record configuration and maintenance: This includes all tasks in relation to managing the mail exchange records - set up, checkups, modifications, and ensuring our web-communication stays efficient and up to date. A candidate with experience in both Aruba website deployment and MX record management will be considered ideal for this job. Knowledge about server troubleshooting will be a plus.