How to use mysql in node js jobs

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.

Looking for a Full Stack Developer >6 years of experience in agile development of scalable SaaS apps in the cybersecurity area: Improve our app (URL Risk assessment) Improve our app (Domain Typosquatting) Improve our project (Darknet Monitoring) Create an app "hackerview" for passive attack surfave enumeration Create an app for detecting spoofed social media profiles Create an app to scrape ransomware threat actor website and maitain stats about those sites Improve an existing app to monitor paste sites Mininmal Tech Experience: MERN, REST API (JWT), Django, Python, Github, CI/CD, Celery, Redis, Linux, Postgress, Kubernetes, Docker, Nginx, JS, HTML5, Protocols (DNS, SMTP, SSL, HTTP..).Detailed app specifications will be shared at a later...

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...

...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: Excell...

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 ...

...can effectively utilize d3.js to create a custom bar chart that shows growing indebtedness after a series of catastrophes. The data to be represented are income and debt that span across three years. Required Skills: - Proficiency in JavaScript and d3.js - Experience in data visualization - Ability to organize and clean the data for the chart Project Goals: - Develop a d3.js bar chart displaying income and debt balance over time - Ensure the chart maintains both readability and aesthetics, as well as the custom hover over explanations that need to go along with it - Functionality to update chart with new data for future years Please apply if you are an expert with d3.js and have previous experience in...

I'm looking for a skilled WordPress designer to craft a high-converting landing page and success pages. The primary goal of this project is to generate leads from professionals aged 25 to 40, so it's crucial that the design is tailored to this demographic. Key responsibilities include: - Designing a visually appealing landing page that effectively captures leads - Integrating Facebook Pixel for tracking and retargeting purposes - Ensuring the speed and responsiveness of the pages for a seamless user experience Some of the essential elements that I want included in the landing page are: - A contact form for lead collection - Testimonials to build trust with our audience - Call-to-Action buttons to guide the visitors to...

Join us in building a cutting-edge slot booking engine from the ground up! This project 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 dynami...

I'm seeking a skilled Node.js backend developer with expertise in real-time applications and , for a project with chat and graph features. Requirements: - Develop a robust backend in Node.js - Implement real-time chat functionality - Handle graph visualization using Ideal candidate should have: - Proven experience in Node.js backend development - Strong understanding of real-time applications - Previous work with - Proficiency in data visualization, specifically graph data structures Please note that this project requires an expert who can deliver efficient, scalable, and secure code.

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 ...

...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 va...

I'm looking for an experienced SEO specialist to implement on-page SEO strategies for my website. This position is for you to implement it so you have to have knowledge on SEO and HTML and coding like The ideal candidate should have a strong understanding of SEO best practices, and be able to deliver measurable results. Please share your past work experience and results in your bid.

Thumbnail for my monetized/commercial/personal use YouTube video

...looking for a designer to create a funny, bright and colorful T-shirt design that incorporates popular memes. - You should be able to leverage existing popular memes in a fresh and creative way, resulting in a design that's both visually appealing and sure to make people smile. - An understanding of color theory and how to use bright and colorful palettes is a must to ensure the design pops on the shirt. - Experience with designing for print on demand services or T-shirt printing is a plus, as the final design should be easily translatable to a physical product. Please share your portfolio demonstrating your experience with both humor and color, and ideally, any previous T-shirt design work you've done....

...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...

...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. - Excellen...

I'm in need of a skilled SEO specialist with a strong Next JS development background to help me address a specific issue with my website's file. Key Requirements: - Solve a exception error: The current setup is causing search engine crawlers to be unable to access any of my dynamic Next Js website pages. This needs to be fixed promptly to enable my site to be crawled effectively. - Ensure All Pages are Crawled: The fix should be applied to enable search engines to crawl through all pages on the website. Ideal Candidate: - Proven track record in SEO: You should have extensive experience in SEO and be familiar with the best practices for Next JS websites. - Strong Next JS ...

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. - Azu...

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 Exp...

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'm in need of a skilled developer, who can create a minimalistic, clean and efficient landing page to help me generate leads. The page will have a focus on simplicity without sacrificing the essential elements needed for lead generation. Key Points: - Aim: The ultimate goal of this project is to effectively capture the interest of potential clients and gather their contact information. - Form Fields: The page must include form fields to collect users' name, email address and phone number. - Aesthetic: The design needs to be minimalistic and clean, with a strong focus on usability and user experience. - Functionality: In addition to the lead generation form, the page should be coded in a way that ensures it's responsi...

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...

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.

Project: Configuration of the eCash node and mining pool The Pool will only be for use by local machines Description: I need an experienced professional to set up a complete mining environment for eCash (XEC). The work includes: 1. Configuring an eCash node on the server (LocalHost). 2. Installation and configuration of ckpool mining software on the same server. 3. Configuring ASICs to connect and mine through the pool. 4. Ensure continuous connectivity and proper functioning of the eCash node and mining pool. 5. Troubleshooting issues related to network connectivity and hardware configuration. Requirements: - Proven experience with cryptocurrency mining, especially SHA-256. - Knowledge in installing and configuring cryptocurrency ...

I'm seeking assistance to install a Laravel Vue JS Inventory script on my local Windows 11 PC. - I need help to install npm and Node.js on my system before proceeding with the script installation. - The script is specifically designed for Laravel with Vue JS, so I require a freelancer with expertise in these technologies. - Familiarity with XAMPP is a plus, as it will be used to run the script on my local server. - The ideal candidate should be able to walk me through the set-up process and provide any necessary troubleshooting support.

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

...looking for a skilled AWS expert with experience in blockchain development, particularly Solana. The primary task at hand is setting up a node on AWS, specifically for Solana's RPC. Key Requirements: - Proficient in AWS: The ideal candidate should be well-versed in setting up nodes on AWS, ensuring optimal performance and security. - Blockchain Experience: Knowledge of blockchain technology is a must, and specific experience with the Solana network is highly preferred. - Monitoring and Alerting: In addition to the node setup, I require comprehensive monitoring and alerting to be put in place. This includes proactive monitoring to ensure the node is running smoothly and the ability to respond to...

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.

...architectural and design services for a mixed-use property project. This entire space covers 35k sq ft with a front of 130*275. It's divided into three units and a 100 * 100 ft commercial complex. 1 st unit 4 master bed room ,1 kitchen with extra food space and wash area ,1 hall ,Pooja room (jk),jakusi, 2 nd 5 master bed room ,1 kitchen with extra food space and washing area ,Pooja room jakusi,1 hall ,1 room for office 3 Rd home theter,Jim , swimming pool ,table tennis 4 garden ,badminton court ,car parking Lazy river and whole home surrounded by water naturally - 5 Servant and guard rooms The commercial complex design should be modern, practical and appealing to businesses. Ideal skills and experience: - Proven experience in designing mixed-use,...

im looking for an expert smart developer for wordpress who can work with JS, Ajax, PHP, CSS and html. full stack developer who is smart and active not lazy and delay work, i need for long term business.

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

...developer who can create a personal college website for me. I want the site to be similar to my college's official website, but with some unique features. Key Features: - Course Information and Syllabus: I expect to have a section where I can upload all the necessary information regarding the courses I'm taking. - Student Login and Registration: There should be a secure login system for students to access the personalized information. - Grades, Student Education History, Fee Details: The website should allow me to keep track of my academic performance, educational history, and fee details. - Time Table: A feature that allows me to maintain my schedule and plan my time effectively. - Downloadable Documents: Users should be able to...

I am looking for an expert React developer to help me with front-end development and state management. I am new in react. i am using adminity html template for react. after converting to jsx. when i am login then dashboard sidebar design scrumble due to some js but component navigation working fine but if i reload the dashboard page then scrumbled design is ok as per template but if i click on navigation then it reloaded complete page. I want Single page Application buth somehow it load complete page when navigate to other page. Some JS loading issue Budget INR 600-800 Anydesk work only..

I am interested in finding software or a website that produces flowcharts (for an example see attachment file ). It must allow me to upload a file containing the definition of a flowchart and it creates the flowchart (see attached files and ). It will probably also allow me to manually create the flowchart one step at a time. There are three possibilities below: A (write app), B (find app) and C (find website). For B and C I will: 1. Milestone $5 and immediately release it to pay your FL fee when I hire you. 2. Milestone $10 for you to provide B or C below. 3. Release the $10 when you produce B or C. 4. Repeat 2-3 for each additional B or C that I need. For B or C you might have to ask the vendor/website for an example of a flowchart and a fi...

I'm looking for a professional who can develop a Chrome extension that will automatically respond to all WhatsApp messages. Key Requirements: - Operating System: The extension should be designed for Windows. - Message Response: I need the extension to send a simple "hello world" message in response to every message received on WhatsApp. -Logs: store logs - User: The final product will be used for personal use, so no team functionality is necessary. Ideal Freelancer: - Proficient in Chrome extension development. - Experience with the WPPconnect wa-js listener. - Strong understanding of WhatsApp's API for message reception and sending.

I am in need of a skilled professional who can help me install OpenStack on an Ubuntu server. Specifically, I am looking for support in setting up a multi-node (1-5 nodes) OpenStack environment. The primary purpose of this cloud will be for development and testing. Ideal skills and experience for this job include: - Expertise in working with OpenStack - Proficiency in setting up and configuring multi-node environments - Strong understanding of Ubuntu server systems - Ability to optimize the setup for development and testing purposes. - Ability to create Windows and Linux images to build VMs - Fault-tolerant control plane

I'm sea...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 candidate should underst...

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, creat...

Website Designer , Php , E Commerce having knowledge of MySQL

I'm in urgent need of an experienced web developer to create a simple interactive website. The site should be designed in a modern and simple style, with a consistent colour scheme (i will tell you what colours). The main features of the website should include a login, sign-up, and user profile functionality and a unique feature which is the map using Google API. The website is about exploring castles in Edinburgh, England with the core feature being an interactive map, where users can click on castle names/icon and a pop up of a castle image will show up on the map. They can also save castles to favourites. Key Expectations: - Create a modern, interactive website - Use HTML, CSS, and JavaScript with any UI framework or JS library o...

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.

...designer/developer to create an engaging and interactive Squarespace website. The primary objective of this website is to showcase my products/services. Key requirements include: - **Interactive Elements:** I'm keen on incorporating hover effects and interactive elements throughout the site to engage visitors and make the showcase lively. - **Specific Color Scheme:** The website should align with a specific color scheme I already have. This will require attention to detail to ensure consistency and harmonious color transitions. Ideal candidates should: - Have a strong understanding of Squarespace and its capabilities. - Be proficient in creating interactive website elements. - Demonstrate experience in working with and adhering ...