Stored procedure in mysql example jobs

I'm in urgent need of a professional web developer with experience in creating automation tools. We're looking to build a sophisticated website and dashboard, which will be later integrated with API and MySQL. The final product should be a robust, blockchain-based automation platform. Key responsibilities include: - Building a website and dashboard from scratch - Implementing blockchain technology for automation - Ensuring seamless integration with API and MySQL The ideal freelancer should have: - Extensive experience in web development, particularly in creating automation tools - Proven track record in implementing blockchain technology - Strong understanding of API and MySQL integration - Ability to deliver high-quality ...

I need a developer proficient in and a good understanding in API development. I have a parameter I would like to pass which is a string value to pull an entire user object with all of the properties in a database. this would be a string parameter passed into a Get request with a response of an entire record pulled from a MySQL database and using an Interface to extract the properties into a page. This is a very small project and should only take a few minutes of time.

I'm looking for a professional Flask and Python developer to help me implement a user management system for my website. The user management system should have Social Media login integration. Additionally, I would like the selected developer to set up a payment gateway and a MySQL database. Ideal Skills: - Proficient in Flask and Python - Experience in implementing user management systems with social media login integration - Proficient in setting up payment gateways - Proficient in working with MySQL databases

...Tailored Solutions: We create custom web applications that meet your specific business needs, enhancing productivity and operational efficiency. ● Versatile Applications: Our solutions range from customer portals to complex inventory management systems, each built to address unique business challenges. ● Technology Stack: Node.js, , Ruby on Rails, Django, Laravel, MongoDB, PostgreSQL, MySQL, AWS, Docker....

...looking for a talented full stack developer, specialized in Flutter, jQuery, MySQL, AWS, and Google Cloud Platform, to help me bring my vision to life. I plan to develop a premium content platform for the web. The platform will provide a seamless user experience yet restricts premium content behind pay walls. Key requirements: - Develop a web-based premium content platform using Flutter and jQuery - Implement a secure and reliable system for MySQL database management - Integrate an inbuilt payment gateway for user subscriptions - Utilize AWS and Google Cloud Platform to ensure the platform's scalability and performance Ideal candidates should have: - Extensive experience in full stack development - Proven expertise in Flutter, jQuery, MySQL...

Project Description: I am seeking an experienced freelancer to develop a directory listing website, similar in design and functionality to the following template: The design will be provided by me. Requirements: 1. Technical Specifications: - Framework/Technology: Please suggest suitable technologies. - Database: MySQL, PostgreSQL, or another relational database. - Responsiveness: The design must be fully responsive and work flawlessly on all devices (desktop, tablet, smartphone). - SEO: It must be possible to optimize each individual listing for SEO, as well as the overall website. - Security: Implementation of security measures to protect user data. - Performance: The website must load quickly

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of da...

I've been facing issues with a MySQL table that seems to be taking up too much space in my database, despite there being no data in it. The table is almost 2MB in size while it has no rows at all. The database was originally like 50kb a few weeks ago. Recently we made some minor changes, like adding index. Then it suddenly become so huge. Key points: - Table size issue: The MySQL table is bloated despite having no data, and it's causing performance problems. - Insertion operations: The table is mainly used for inserts, which are what I need it to be optimized for. The work needs to be done remotely using anydesk. If you know how to do it, it should be just a few min fix.

I need a custom custom GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example...

As a professional with a background in Mechanical Engineering and valid US registration, I am seeking assistance in reviewing and approving an ASTM testing standard for corrections locks. Your role is of utmost importance as it includes the validation of the test report using your official stamp after careful review. Brief requirements: 1. Registered US Mechanical Engineer 2. Proficient with ASTM testing standards 3. Able to review digital video footage Your expertise will be imperative in assessing and interpreting the digital video footage which documents the testing procedure. Detailed experience in the sector of lock mechanisms, especially corrections locks, is needed for comprehensive understanding and analysis. Please confirm you have...

I'm seeking Spanish speakers for a project where you will be reading conversational scripts in a formal tone. Your role will be to: - Read Spanish scripts in a formal tone - Ensure the scripts are conversational in nature The ideal freelancer for this job would have: - Native proficiency in Spanish - Ability to convey a formal tone - Experience with voiceover work would be advantageous - Knowledge of different regional Spanish accents is a plus. PLEASE FIND ATTACHED THE PROCEDURE YOU NEED TO FOLLOW TO DO THE RECORDING.

I am seeking an RPA Developer to automate tasks relating to a list of codes (stored in a txt file, excel file, etc) and Web interaction, for a demostration of micro RPA possibilities Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink the link will be a fixed text + the code taken from excel you will open a broswer tab with that link IF one text is present in the resulting html response, you will close the tab, and repeat the process with the next data from the file If another text is present, you will "click" 3 or 4 following buttons Iterate with the next data from the excel file Until Excel's data EOF Everything configurable via external TXT file - name of the excel file or txt fil...

I'm searching for a developer who can build an automated document verification system to simplify the document management procedure in educational institutions. The system must include the following features: - Database Integration: Integrate with MySQL, our preferred database management system, to make document retrieval and management easier. - User Authentication: I want the system to authenticate users via Single Sign-On (SSO) using existing authentication platforms like Google and Facebook. This is to ensure a secure, seamless and user-friendly sign-in process. Proficiency in MySQL, SSO Integration, and system development is required. Prior experience in document management system creation will be preferable. The ideal candidat...

I'm...system can verify documents immediately upon submission. - Secure Storage: Verified documents should be stored securely, ensuring confidentiality and data protection. - User-friendly Interface: The system should have an intuitive and simple-to-use design to allow effective handling of documents. Integration: - The system should be capable of API integration for seamless incorporation into existing structures. Ideally, the developer should have a strong background in system development and significant experience with API integration, real-time data handling, and secure storage solutions. Familiarity with the educational institution's documentation processes will be a plus. Your expertise in User Interface (UI) design will be highly appreciated to ensu...

My existing React Native application, which is supported by NodeJS and backed by a MYSQL database, needs immediate attention. Here's what needs to be done: User Interface Updates: The component related to photos in the application requires significant changes. I also need a feature that shows the GPS route to the specified delivery point. This functionality was not implemented in the initial version of the application. Additionally, changing screen configuration doesn't display corresponding states with their color (only changes upon updating the application). Functionality Improvements: On top of the UI changes, the app needs general functionality improvements to enhance user experience and the app's efficiency. Also, create a button for downloading P...

Website Designer , Php , E Commerce having knowledge of MySQL

I'm looking for someone to work with me on an automated crypto trading bot. It will use Tradingview alerts, (which uses Webhook URL) to ping a script on a server, which then uses an exchange API to execute crypto trades. I will integrate the script into MySQL using php to track the amount traded and set a e.g. a sell price for the crypto just purchased after the alert... I can do that... But I need help with the integration of alerts from Tradingview and the API code to the exchange.

I'm in need of a competent developer who can set up a script in my Airtable app to seamlessly integrate with the Aftership API. The main goal of this integration is to automate the process of generating DHL shipping labels. Key Responsibilities: - Utilizing JavaScript to create a script within the Airtable app for this purpose. - Configuring the Aftership webhook to relay the responses from the API to my Zapier app. Once the DHL shipping labels are generated, they should be stored within the Airtable app. This will allow for manual retrieval and distribution as needed. Skills and Experience Required: - Proficiency in JavaScript is a must. - Prior experience working with Airtable scripting and API integrations. - Familiarity with Aftership and Zapier wo...

I'm in need of a programmer well-versed in TIA (V18) Unified and JavaScript to assist with a specific task. - **Skillset**: Proficiency in TIA (V18) Unified and JavaScript is crucial. Experience in data manipulation and handling would be an added advantage. Your primary responsibility will be to help me export a datalogfile created in TIA (V18) Unified to a CSV file using JavaScript. The purpose of this export is for archiving, as the datalogfile is stored locally. Please reach out if you believe you have the right skills and experience for this task.

Project Overview: We are in need of a skilled backend developer to implement the necessary functions for our financial services website. The primary goal is to ensure smooth operation and functionality across various sections of the site. Project Details: Functionality Scope: Implement backend functions to support the frontend interface. Develop APIs for data retrieval and manipulation. Ensure seamless integration with the chosen frontend framework. Sections Requiring Backend Functionality: User Authentication and Authorization Data Retrieval for Services Newsletter Subscription Management Interactive Content Management Blog and Opinion Management Event Management Comment Section Functionality Social Media Integration Contact Form Submission Handling Specific Requirements: User...

I'm seeking a skilled system administrator to replace my current MariaDB with MySQL 8.0 on a CentOS server. The ideal candidate will be able to: - Completely remove MariaDB ensuring no data loss - Install and configure MySQL 8.0, adhering to: * Default configuration * Custom storage engine Security is a key concern. Remote access to the MySQL installation must be restricted. This is crucial to maintain the integrity and security of the server and its data.

Following skills are required: 1) Azure Pipeline creation for deploying Spring Boot application to Azure App Services (not Azure Spring App Services) 2) Azure Pipeline experience to deploy Artifacts (Gradle) We need somebody to walk us through the steps within an online meeting. We have set-up to Spring applications one needs to be stored as Artifact and the other one is based on the Artifact solution (dependency) and needs to be deployed to Azure App Services. We estimate the meeting to take between 2 - 4 hours. We'll only consider candidates who have performed this activities already.

I...Form submission - to post HTML data to the database. - Data visualization - to display posted data on the webpage. Ideally, the freelancer should have: - Proficiency in WordPress plugin development, - Expertise in HTML, and - Familiarity with handling data through form submission and visualization techniques. The data integration will not involve manual input, spreadsheet import, or API connection as the data is already displayed on the page. We just need it saved. This is to complete a mostly complete wordpress plugin which already captures the user ID, Data source ID and captures the html data which needs to be stored. We have a problem getting the plugin to trigger an Ajax response which we need help debugging. Please submit your bid if your skills align ...

...can find emails from LinkedIn Sales Navigator URLs. The emails need to be in Excel format. What I Need in Excel: - Name of the person - Email - Location - Designation Procedure: - I shall enter sales navigator ulr where multiple leads in pagination format displayes. - Software will pick each person url and find out his email (personal/professional) - Add that record along with above fields in excel sheet. Make sure software must not stuck, and i shall clear the payment after testing couple of days. Ideal Skills: - Proficiency in Python. - Experience in web scraping, particularly with LinkedIn URLs. - Familiarity with data manipulation in Excel files. This project is ideal for someone with a strong background in Python a...

...set up a functional webviewer linked to a database from it. This is the first open source 3D atlas of gross anatomy and I'd like to be able to update its content autonomously. The license is CC-BY-SA and the authorship will go to 'BodyParts3D', 'Lluis Vinent' and 'Z-Anatomy'. The tools need to be set up for and be owned by the client. Profile: >3 years of experience in tailored projects in Unity Experience in the set up and use of databases Good organization and communication skills Necessary missions (estimated 100 euros): Share the project on Unity Hub Create a database containing a .csv file (the translations) and a series of texts (the definitions), Link it to the objects (the anatomical struc...

...an experienced AWS DevOps specialist to host my business management tool which consists of a React-based front-end, an ASP.NET API and a MySQL database on AWS, specifically using Elastic Compute Cloud (EC2). Key requirements: - Hosting: Set up and manage the hosting environment on AWS EC2, ensuring the site is stable and accessible. - Scalability: Implement strategies to accommodate low traffic, up to 100 users per day. - Security: Ensure the highest level of security and integrity of the data. Ideal candidates should have: - Proven experience in DevOps and cloud hosting, particularly with AWS EC2. - Background or familiarity with React, ASP.NET, and MySQL. - An understanding of best practices for hosting and optimizing web applications. This project is crucial f...

??? ?????: ????? ?????? ????????? (????-????, ??????) Salary: up to 4000$ USD/month The ideal candidate will have a passion for algorithmic trading and ex...Familiarity with the full development life cycle (preferably using the agile process), including automated testing and building • Experience with version control and continuous integration tools such as GitHub/GitLab • Knowledge of third-party libraries and APIs • Proficiency in building enterprise web solutions using the MERN stack • Strong proficiency in HTML, CSS, JavaScript, and JavaScript frameworks like Dart, React, and Node • Experience with server-side languages such as Python, PHP, and C# • Knowledge of databases such as MySQL, NoSQL, and GraphQL Ability to accurately forecast...

...candidate would possess: - Proven experience in iOS app development - Familiarity with creating apps requiring user authentication and account setup - An understanding of backend programming for data storage - Experience with healthcare field is a plus The main function of the app will be to conduct medical surveys. Users will need to create an account, log in and answer health-related questions. This sensitive data needs to be stored securely. The app should have an intuitive, user-friendly interface that can easily be navigated by individuals with various tech skill levels. This is something that would be an ADDITION to apps like MyChart and it conducts an AI based survey to give a patient a rough diagnoses, based on multiple choice questions. Skilled in...

I'm in need of a professional to optimize my PL/SQL code for better performance. The primary focus of this project is to enhance the overall efficiency of the code. Key Responsibilities: - Perform PL/SQL performance tuning to improve the execution speed of queries. - Implement bulk collect operations to enhance data retrieval efficiency. - Optimize the compilation of procedures for better code execution. I'm seeking someone with extensive experience in PL/SQL, particularly with performance tuning and bulk collect operations. Proficiency in procedure compilation optimization will be a bonus. Your expertise will play a crucial role in achieving the project's goals.

We have a website developed in PHP & MySQL database. We need to add news section in the home page. The same should be available to be edited from the Admin Section for the user to change contents in the News Section.

I require a skilled Python programmer to craft a script that would allow me to login into my account on and download all the videos stored there. The details are as follows: - The operating system this script will be running on is Windows - The script should also classify the downloaded videos into different folders on my PC, labeled according to the team name each video corresponds with. - The hired freelancer may have to study Veo's UI for this purpose. - I'd need this task completed ASAP. Ideal skills and experience: - Previous experience with Web Scraping and handling Video files - Extensive knowledge of Python with specific experience writing scripts - Understanding of Video download and organization, preferably with the Veo platform - Quick execution without compr...

I have a list of URLs stored in Mongodb. The link connects to specific web pages and I need the underlying data from: 1. Line charts 2. Bar charts All the data that is required to be captured is in the webpage code. There are specific rules on data capture that have been specified and a prior scrap project has this already setup and the code (Python) could be re used. The data scraped needs to be stored in Collections on MongoDb. The scrap program needs to run on an Amazon Light sail Linux instance. Please only apply for the role if you have experience with this work and have successfully completed such project before. An advanced knowledge of scrapping and Mongdb is essential. A detailed specification has been developed and will be shared with genu...

I need an expert to create a comprehensive Excel report and sheet using the 7QC Tool. The main purpose of this project is to analyse process data, identify quali...the 7QC Tool. The main purpose of this project is to analyse process data, identify quality problems, and improve process efficiency. Key Project Details: - The Excel report and sheet should incorporate data analysis, financial calculations, and performance metrics. - The type of data to be stored in the Excel sheet will be sales data, employee information, and inventory records. The ideal freelancer for this job will have a solid understanding of the 7QC tool, advanced Excel skills and knowledge in data analysis. Experience with managing sales data, employee information, and inventory records within Exc...

...buttons into my existing shopping cart system. PayPal's documentation for the legacy buttons is not helpful. My add-to-cart button gets information from a mySQL database, but I'm unable to get the add-to-cart and view-cart buttons to work together. These used to work on an older web site. Key Requirements: - The main functionality is to enable my shopping cart to be able to process payments via PayPal. - The integration should direct customers to the PayPal website for payment processing. - I am looking for a manual coding integration, so experience in this is a must. Your Skills: - Proficiency in PayPal integration - Experience in manual coding for shopping carts - Attention to detail to ensure a seamless integration I look forward to working...

I'm seeking a reliable freelancer to import vendor pricing data into Sage. The data is currently stored in a CSV formatted Excel spreadsheet, with data cleaning required prior to import. The project will entail: - Cleaning the vendor pricing data as required - Successfully importing clean data into Sage Ideal Skills: - Proficient in Excel and its functionalities, especially CSV format - Experience in data cleaning - Demonstrated proficiency in Sage, particularly in data import functions - Attention to detail is crucial for this task This task requires a freelancer with the right blend of skills in Microsoft Excel and Sage software to ensure smooth, error-free integration of vendor pricing data.

I'm seeking a skilled developer to build a professional and user-friendly dashboard using NextJS Ideal Skills: - Proficiency in NextJS for building feature-rich, responsive dashboards. - Experience with Paddle API integration, particularly for subscription management. - Strong knowledge of MySQL for robust database functionality. - A keen eye for UX design to ensure the dashboard is intuitive and user-friendly. - Ability to work efficiently and communicate effectively throughout the development process.

I'm currently looking for a skilled and experienced developer for backend CMS development. Key responsibilities: - Develop a Content Management System using PHP, Laravel, MySQL, and Python. - Design, implement and maintain python-based backend application. Essential Skills: - Proficient in PHP, Laravel, MySQL, Python. - Extensive experience in backend development. - Knowledge in CMS development and implementation. - Strong understanding of data structures and algorithms. Your analysis skills will also be put to good use to solve complex problems in this role. As an experienced backend CMS developer, you can expect to work closely with me to deliver a robust, performant, and scalable system.

I'm looking for an experienced...for an experienced full-stack and OAuth expert to integrate OAuth authentication for Tiktok , TikTok into existing React.js applications. You are responsible for implementing a seamless user authentication experience that allows users to connect their social media accounts to our platform. If authentication is successful, the user's social media profile information should be safely stored in the database. For example, when the user presses the "Tiktok connection" button, the Tiktok user information input field using Auth0 appears, and when entered, the information is changed to the "connected Tiktok". If you successfully complete this task, I will award you development of all parts of this project. I atta...

... The customizations required are as follows: - Adding new functionality: - Creating a new user auto-filled commission - Allowing a 'Rol' option for subagents created by agents in their account - Showing the assigned sales agent in the list view of users - Modifying existing features: - Ensuring sales agent visibility in the list view of users The ideal candidate should have experience in: - Expertise in Wordpress plugin development - Understanding of user roles and permissions - Proficiency in PHP and MySQL for plugin customization - Previous experience in CRM system integration would be a plus Please only apply if you have relevant experience and can deliver quality work within a reasonable timef...

...then will request approval from the sector responders. once the document is approved, the status will change to Approved, Then the document number will be automatically generated, and the review date will for 2 years after the document is approved. 5, In any document library users can post by a power automate script (a form that at least has "the sector" and "document type") their document or PDF to KMS, then the file will be copied to KMS as a Draft, then an email approval will be sent Sector responder 6, KMS admin can trigger a power automate in the KMS policy to send an Employee Policy Acknowledgment email to the the email should have the link of the policy document and an agree and acknowledged link back to the power automate for the record. 7, On...

I am seeking a skilled PHP developer to create a distance calculating sript for me. This script will be responsible for calculating the distance between multiple coordinates stored in a MySQL database. No user interface required as the coordinates will be retrieved from the database directly. Key requirements for the project include: - Create a script that can fetch the coordinates from a MySQL database - Calculating the distance between these multiple coordinates accurately If you're a developer with experience in MySQL PHP and distance calculations, I would love to hear from you.

Perfect english is needed. You need to be able to teach and tutor me in relational data bases and sql. You must be able to share screen and communicate quickly and fast. You must be available from today till 24th of May. I'm looking for an experienced database professional to assist with a relational SQL database project. You will need to assist me to answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The complexity level of the project is intermediate, foc...

...the user's actions. - Data Display: The app should be able to read and display data from the ESP32 device. This data should be stored on an SD card, and include GNSS data from the u-blox module. The ideal candidate for this project should have experience in: - Android Studio: Proficiency in Android app development is crucial for this project. You should be able to create an intuitive user interface that allows for seamless control of the ESP32 device. - ESP32: An understanding of the ESP32 platform is necessary in order to facilitate communication between the app and the device. This includes the ability to send and receive data. Android Studio: Proficiency in Android app development is crucial for this project. You should be able to create...

Prepare a comprehensive documentation on payment gateway project and docking new payment channel * Make a comprehensive documentation on environment setup, backend project run procedure, frontend project run procedure * Documentation on how to dock a new payment channel

...websites that we would like to scrape specific data from, and have them put into a set of MySQL Databases (or maybe something else). The website that we would like to scrape data from each contain thousands of articles, and we would also want other metadata, such as Author name, article date, number of views, or any other metadata that we can take from the pages. Please bid, and we can discuss the first website, you can tell us how long you think it'll take to write the scraper. There are maybe 50 websites to begin with that we would like to do this for, in this one project, and we also have another couple of similar projects. Ideally, the scraper will run form a program, so that we can run it again in future, and it will get the newest articles that haven&#...

...can find emails from LinkedIn Sales Navigator URLs. The emails need to be in Excel format. What I Need in Excel: - Name of the person - Email - Location - Designation Procedure: - I shall enter sales navigator ulr where multiple leads in pagination format displayes. - Software will pick each person url and find out his email (personal/professional) - Add that record along with above fields in excel sheet. Make sure software must not stuck, and i shall clear the payment after testing couple of days. Ideal Skills: - Proficiency in Python. - Experience in web scraping, particularly with LinkedIn URLs. - Familiarity with data manipulation in Excel files. This project is ideal for someone with a strong background in Python...

...materials should cover all essential areas of the platform, ensuring that user data is handled responsibly and in compliance with the necessary legal standards. - The platform includes features for event planning and coordination, venue selection and booking, and budget management. Therefore, the documentation must reflect these functions. Ideal Skills and Experience: - Prior experience in drafting legal documents for digital platforms, particularly in the realm of event management, would be highly beneficial. - A thorough understanding of privacy laws and regulations, particularly in relation to user data collected and stored by online platforms. - The ability to convey complex legal concepts in a clear and accessible manner, given that the au...

...seamlessly transferred to an offline copy. The source website has about 20-30 pages. Key Requirements: - The source website is REACT-based, so I need someone with experience in handling such websites. - The backup should focus on preserving all pages, their content as html and the related css and image files. - Backup should be usable as offline browsable pages with out react scripts - main url will be provided - Result should be stored in folders according to original url structure - Deliver result as zip archive Ideal Skills: - Proficient in website backups. - Familiarity with JavaScript-based websites. - Expertise in preserving website structure and content during migration. - Attention to detail to ensure all elements are accurately backed up. ...

I need a professional NextJS dashboard created that integrates Paddle for subscription management and MySQL as database Key requirements: - Create a NextJS dashboard: The design needs to be clean and professional. I'm not looking for something overly complex, but rather a streamlined and user-friendly interface. - Integrate Paddle for Subscription Management: This functionality is crucial for the success of my project. I need the dashboard to seamlessly handle subscription management through Paddle. Ideal skills and experience: - Proficiency in NextJS: You should have a good understanding and experience working with NextJS. - Experience with E-commerce integrations: Ideally, you have previously worked on projects that involved integrating billing systems like Paddle. ...

I'm currently in need of a proficient backend developer who specializes in Node.js. Key responsibilities include: - Developing user authentication - Integrating the database - API Development The chosen candidate will preferably be experienced in and MySQL, although this isn't obligatory. knowledge is a bonus. In light of a tight deadline, applicants who can start as soon as possible will be prioritized.