Mysql 5.6 slow query log jobs
Build an ISO for a raspberry pi (with cellular notecard) to scan for unique cell phones in a specific range and log the unique phone ID and timestamps/ping (distance) from the raspberry pi and store in mysql database using cellular adapter.
I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.
...for an experienced mobile app developer who can build a feature-rich e-commerce app that will work seamlessly on both Android and iOS. The app will cater to a WordPress-based online shop, ensuring customers have a smooth shopping experience with access to unique features. Key Features & Functionalities: - User Registration & Login: A seamless and secure process for users to create accounts and log in. - Push Notifications: Utilizing notifications to engage with users and keep them updated with the latest offers, deals, and more. - Connected to WordPress Shop: The app should effectively fetch and display product data from the existing WordPress shop, ensuring real-time updates of the product catalog. - Custom Stock Management: Admin should have the capability to manage an...
...backend developer who can build a robust REST API. The ideal candidate should be proficient in MySQL, and have experience in user authentication, data retrieval, and data modification. Key Requirements: - Develop User Authentication: The API should include secure user authentication functionality. - Implement Data Retrieval: The API must be able to retrieve data from MySQL database as needed. - Data Modification Capability: The API should also support updating and deleting data in the database. Additional Needs: - Third-Party Integrations: The API will need to integrate with a payment processing system and also be able to send WhatsApp messages. If you have a strong background in Node.js, MySQL, and building REST APIs, I'd like to hear from you. Please incl...
I'm looking for an experienced web developer to help me with some quick fixes on my website. Key Issues: - Slow Loading Time: My homepage and product pages are experiencing slow loading time. The website is currently loading in more than 10 seconds, and I need this to be improved to less than 10 seconds. - Formatting Issues: There are also some formatting issues on the website that need to be corrected. Ideal Skills and Experience: - Proficiency in web development and optimization - Experience in resolving slow loading time issues - Strong understanding of responsive web design and CSS for fixing formatting issues
I need a WordPress portal that allows me to input text and images for specific user groups to access. Key Elements: - The admin should be able to input and update text or image content on the platform. - I want this content to be visible only to registered users and admin users. Guests should not have access to it. - Users will need to log in to view the content, so some form of user authentication is also necessary.
Hi Mubashar H., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I need a professional who can dissect my iPhone logs and provide detailed insights. The ideal candidate should be proficient in the following areas: - iPhone log analysis: You should have experience in extracting and analyzing iPhone logs, especially the requested data like app usage, location, and potential malware, suspicious or kernel access. - Data interpretation: You should be skilled at understanding log data and transforming it into comprehensive, understandable reports. - Security: A strong background in cybersecurity is essential, as you will be examining for potential threats, breaches, or unauthorized access. Please note, I have the logs in a text file already. This project requires a high level of attention to detail, a thorough understanding of iPhone logg...
I need a talented full-stack developer with experience in PHP and MySQL. You'll be designing and creating a platform that supports 360-degree videos, similar to YouTube. Deployment in the cloud will also be required. Key Responsibilities: - Develop the front-end and back-end of the platform. - Design the platform's layout (the design concept is yet to be decided). - Enable 360-degree video support. - Implement features for video uploading, sharing, and rating. - Enable user account and profile creation. - Include a commenting system. Ideal Skills and Experience: - Proficient in PHP and MySQL. - Experience with cloud-based deployment. - Good understanding of user-friendly design concepts. - Familiar with user account management systems. - Experience in developing v...
I'm in search of a skilled Python PHP developer with experience in backend development. If you have a good grasp of Python and backend systems, this project is for you. Essential skills and experience: - Proficiency in Python PHP - Proficiency in Firebase MySQL - Experience in developing real-time features like live chat and notifications Ideal candidates will have: - Strong communication skills - Experience in developing and maintaining a reliable backend system - A keen eye for detail and the ability to troubleshoot and solve problems quickly If you think you're a good fit for this project, please get in touch. I'm excited to see what you can bring to the table.
I'm looking for experienced freelancers who have worked with the Foodyman template. My goal is to customize it for a 6-month project, focusing on enhancing its visual design and functionality. Key Requirements: - Proficiency with the Foodyman template - Strong background in visual design and website functionality - Understanding of web design principles and trends - Proven experience in template customization - Availability for a 6-month project Tasks include but are not limited to: - Enhancing the visual appeal of the template - Improving its functionality and user experience - Incorporating any necessary content structure changes Your previous work with the Foodyman template will be a pre required. Please share your portfolio and references when applying.
...seeking a skilled PHP developer to assist with a project that involves fixing a PHP file and combining a Php ,MySQL database. The main tasks for this project include: - Resolving a database connection issue in the PHP file. - Combining the MySQL database in the backend of the PHP file. Your role will be crucial in ensuring that the database is correctly integrated into the PHP file and that the database connection is stable and error-free. The PHP file should be able to successfully communicate with the MySQL database once the project is complete. Ideal candidates for this project should have: - need to change php file and combine database. - Proficient experience in PHP and MySQL. - Demonstrated experience in resolving database connection issues. - Excel...
I'm looking to get my BMW 5 series coded to both enhance its performance and add some personalized touches to it. The project should be completed within a week. Key tasks include: - Engine Performance: The engine should be tweaked to generate more horsepower, making the car more powerful. - Fuel Efficiency: Along with boosting the engine's horsepower, you need to alter the coding to make the car more fuel-efficient. - Lighting Effects: The vehicle's lighting system should be adjusted to custom effects that suit my personal preference. - Audio System: The coding should also improve the car's default audio system to offer a superior sound experience. Ideal candidates would be familiar with BMW coding, particularly for the 5 series model, and und...
I'm in need of an experienced website developer who can create a simple, yet warm and inviting 5-page website. Here are the key requirements: - The website needs to be built on WordPress - I will provide all the text and images required for the website The site will consist of the following pages: 1. About 2. Services 3. Products 4. Design process 5. Contact us For the 'Contact Us' page: - A contact form is essential, with all the necessary fields and a submit button Ideal Skills and Experience: - Proven experience in WordPress website development - Ability to create a warm and inviting design style - Proficiency in integrating forms in WordPress - Strong communication skills to understand and implement provided text and images.
I need assistance in creating Marathi subtitle files in SRT format for five separate videos on YouTube. Each video is approximately 20-25 minutes long. The subtitles should be in Marathi and match the spoken content in the videos verbatim. Non-verbal elements such as background music, sound effects, and speaker identification do not need to be included. The focus is solely on the spoken content. The freelancer shall deliver one subtitle per day and complete the project in five days.
...for a talented web developer to create a website similar to Tottaa.com. The platform will primarily serve as a classified ads site, allowing users to list products, search for items, and register/login. Key Features: - Product Listings: Users should be able to post their products for sale, akin to a classified ads platform. - User Registration and Login: A secure system for users to register and log in to the site. - Search Functionality: An effective search feature for users to easily find the products they're looking for. - Listing Ads: Apart from regular product listings, the platform should have the functionality for users to list ads. - Admin Panel: An administrative panel for both user and general site management. - Blog Admin: Capability for an admin to manage and u...
Hello, I'd like to correct an error I have on our Python/Django website hosted on PythonAnywhere. Here are the logs: If you think you can fix this bug, please contact me via Freelancer.
...features: - Product Catalog: The website must be able to showcase a wide range of products, organized in a user-friendly and visually appealing way. - Shopping Cart & Checkout Process: A seamless and secure shopping experience for users is paramount. This involves a smooth cart functionality and a secure checkout process. - User Registration & Login: The site should enable users to create accounts and log in, allowing for personalized shopping experiences and order tracking. - Super fast load time at least 93 score in google load time. - Booking Platform with Calendar: Additionally, the site will have a booking platform integrated with a calendar. After payment, users should receive a confirmation itinerary and payment invoices to be sent to the client after the payment ...
I am excited to apply for the part-time Software Developer position. ...contribute effectively to your projects. Technical Skills and Expertise Front-end Development: Skilled in HTML, CSS, and JavaScript, with experience in and Tailwind CSS. I focus on creating responsive and visually appealing user interfaces. Back-end Development: Proficient in Python and Node.js, with a track record of building robust APIs and microservices. Database Management: Experienced with MySQL and MongoDB, capable of designing efficient database schemas and performing queries. Full-Stack Development: Able to integrate front-end and back-end systems seamlessly, handling state management, authentication, and real-time data. UI/UX Design: Knowledgeable in using Shadcn and other tools to enhance user experie...
...Features: - User authentication - Push notifications - Payment integration - Job posting and Employee Profile creation - In-app chat and Whatsapp integration - Bookmarking and job/profile sharing functionalities - Premium membership that enables additional contact features - MySQL database schema design - Integrated Google Admob Advertisement Backend Work: - You'll develop a RESTful API with PHP+MySQL to support app functionalities. The ideal candidate will have significant experience in Flutter Development, PHP, and MySQL, coupled with a strong understanding of RESTful API design and integration. Please bid if you're capable of delivering high-quality, efficient code and can prove past experience in developing similar applications. Your ability to me...
I'm seeking a skilled individual who can help me implement an IoT solution within a month timeframe. Key Aspect...MQTT (Message Queuing Telemetry Transport) and how to use it to integrate various IoT devices. - Data Collection & Analytics: Proficiency in handling data streams from these devices, ensuring seamless collection, storage, and basic analytics. - User Interface & Experience: Creating a clear, intuitive UI to monitor and interact with the IoT data is essential. Ideal Skills: - Proficient in Java, MySQL, and Tomcat - Experience with MQTT and IoT SCADA is a plus - Strong background in designing user-friendly interfaces - Able to deliver quality work within a tight timeframe Go through the PDF file attached to understand the flow . For Gateway and Sensors Deta...
...inventory management app using Google AppSheet and MySQL. The app will cater to a user base of less than 50, but it needs to be designed and optimized for scalable growth. It should be intuitive, easy to use, and have a professional interface. Key features that need to be incorporated into the app include: - Real-time inventory tracking - Sales and purchase order management - Product barcode scanning As the app will be handling crucial data for my business, security and reliability are of utmost importance. The developer should have experience in creating and integrating secure databases, as well as a track record of building robust, scalable applications. The successful freelancer should have: - Proficiency in Google AppSheet and MySQL - Experience in developing inve...
Hi Atiurrahman A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I am in need of a proficient developer to create a user-friendly, private gateway platform. This will allow guest users to register, log in, and top up credits using certain cryptocurrencies. Key Requirements: - Implement a username and password authentication system for user registration and login - Enable guest-user roles only - Incorporate an interface for topping up of credits using BTC, Solana (SOL), Ethereum (ETH), and Monero (XMR) - Functionality to send these credits to any country - Customizable sender ID for promotional use Ideal Skills and Experience: - Strong experience in the development of Gateway platforms - Proficient in cryptocurrency integrations - Knowledgeable about various authentication systems - Proven track record with user interface design - Experience wi...
...an admin dashboard for an e-commerce site. This will involve managing callback values for various e-commerce events such as sales, cancellations, and renewals. These values need to be stored in a MySQL database. Additionally, email notifications need to be sent to both the admin and users, triggered by specific e-commerce events. Key Requirements: - Develop an admin dashboard for managing callback values - Utilize a MySQL database for storing the callback values - Implement a system for automated email notifications upon e-commerce event triggers Skills & Experience: - Strong proficiency in MySQL - Extensive experience in e-commerce site development - Proficient in creating admin dashboards - Skilled in implementing automated email notification systems - Abil...
I need a developer or team who can implement a multi-login feature on , allowing users to log in from multiple accounts simultaneously. The aim of this feature is to facilitate user management by enabling users to control multiple accounts at the same time. Key Responsibilities: - Integrate simultaneous multi-login feature on - Ensure the feature is user-friendly and stable - Thoroughly test the feature to ensure it's functioning as intended Successful applicants should have: - Proven experience with web development, particularly in implementing login systems - A strong understanding of user management principles - A portfolio showcasing past work, particularly similar projects - The ability to work independently and efficiently to meet project deadlines
I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration ...be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are high...
I'm on the lookout for a diligent freelancer to help in testing the gameplay balance of our latest PC game. The core focus of your responsibilities will be: - **Gameplay Testing:** Deep dive into the gameplay, ensuring the mechanics are engaging and balanced. - **Balance Issues Identification:** Critically analyze and report on gameplay balance. This involves playing through the levels, understanding the game mechanics, and identifying areas that feel too easy or too challenging. - **Feedback & Suggestions:** Provide constructive feedback on how to improve gameplay balance. Your insights will be invaluable in tuning game mechanics to enhance the player experience. **Ideal Skills and Experience:** - Proven experience in PC game testing, particularly gameplay aspects. - Keen analy...
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
Hello! My company, , just launched our updated website and product. It is free to try, but we are looking for paid testers beyond that. I am looking for teams or individuals with some software experience to visit our site and sample our AI powered component UI generator. Please send me your proposal(s) Looking for this to be done as quickly as possible. More user feedback, the better.
I am currently having issues updating my pages with Elementor, and I'm not receiving any error messages. Additionally, I've noticed that my website's performance is slow and could benefit from more memory. Key Requirements: - Troubleshoot and resolve the issue of Elementor not updating pages without error messages. - Optimize the website's performance to improve its speed. Ideal Skills and Experience: - Proficient in WordPress and Elementor. - Experience in troubleshooting and resolving plugin compatibility issues. - Demonstrable experience in website optimization for speed and performance enhancement. Your bid should address these points specifically. Please provide examples of similar work you've completed in the past.
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...
Japanese to English Proofreading 5-365
I'm on the lookout for a diligent freelancer to help in testing the gameplay balance of our latest PC game. The core focus of your responsibilities will be: - **Gameplay Testing:** Deep dive into the gameplay, ensuring the mechanics are engaging and balanced. - **Balance Issues Identification:** Critically analyze and report on gameplay balance. This involves playing through the levels, understanding the game mechanics, and identifying areas that feel too easy or too challenging. - **Feedback & Suggestions:** Provide constructive feedback on how to improve gameplay balance. Your insights will be invaluable in tuning game mechanics to enhance the player experience. **Ideal Skills and Experience:** - Proven experience in PC game testing, particularly gameplay aspects. - Keen analy...
I'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...
...availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen courier to confirm the shipment. Automate File Transfer Based on Client and Project: Implement a system that automatically transfers the transport query from one file to another in the local drive based on the client and the current project folders. Project Goals: Automate Courier Selection: Develop a way to automatically select suitable couriers from the database based on predefined criteria (distance, size, location). Automate Communication: Automate the process of contacting couriers via Outlook, including sending inquiry emai...
I am currently using R, specifically the ppcor package, to conduct partial correlations on a sizable dataset. Unfortunately, the process is slow and fails to address all columns efficiently. I'm seeking assistance to: - Improve the computation speed - Enhance the handling of columns within my dataset The ideal freelancer for this task should be proficient in R programming, with specific experience in working with the ppcor package or similar tools for statistical analysis. A background in optimizing code for large datasets would be highly beneficial.
...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. - Ability to work independently and meet deadlines. - .NET and are a plus but not a requir...
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.
I need a desktop 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 to be user-friendl...
I have a Node.js website where a critical bug has surfaced. Every time I log in with one ID, the session automatically switches to another ID after a page refresh. This is causing severe disruptions and needs urgent attention within 24 hours. Key Aspects: - Immediate resolution of the login bug that switches sessions. Ideal Skills and Experience: - Proficient in Node.js and troubleshooting login related issues. - Quick turnaround to address the issues within the specified time frame.
We are in search of a skilled software integrator to help me integrate my personal deployment system with a...and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need access to final git repository Project Completion: 2 weeks This project is an exciting opportunity to work on a cutting-edge software integration and development. If you have the right skills and enjoy a challenging, innovative project, I'd love to...
Hi Amritpal S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
...for an experienced React + developer to optimize the loading times of my web application. Key Points: - The main issue with the current site seems to be the product pages, which need to have their loading times significantly improved. - Additionally, I suspect that large images or media files, inefficient code or algorithms, and server response times are also contributing to the overall slow performance. - Moreover, I need to update application packages, currently I am using nextjs 9.2.0 and some depreciated libraries. Ideal Candidate: - Proficient in React and to be able to efficiently refactor the code and optimize the loading times. - Experience with image and media optimization, as well as knowledge of best practices to ensure efficient image loading. - A strong unders...
...date and service â—¦ Sees his orders including the resulting photos â—¦ Evaluates - Photographer â—¦ Sees assigned jobs with a schedule (calendar) of jobs â—¦ Confirms the job â—¦ Inserts the resulting photos â—¦ Sees your historical orders as well Here is the necessary screens: ### 1. Login Screen - **Purpose:** Allow users (brokers and photographers) to log in. - **Elements:** - Email/Username input - Password input - Login button - Forgot Password link - Signup link ### 2. Profile Setup Screens #### Broker Profile Setup Screen - **Purpose:** Allow brokers to set up their profiles. - **Elements:** - Profile photo upload - Name input - Phone number input - Agency name input - Save button #### Photographer Profile Se...
I am looking for a proficient full stack 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 f...
I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused
