Query mysql database unix scriptKazi

I am looking for an experienced CodeIgniter developer to upgrade my existing CodeIgniter 3 project to CodeIgniter 4. The project is currently live and needs to maintain the same database structure and functionality. The key tasks include: Upgrade CodeIgniter Version: Migrate the entire project from CodeIgniter 3 to CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. API Integrati...

...like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL database...

I am looking for a skilled Elasticsearch expert to help with data indexing and analysis for a large dataset. The data to be indexed is primarily textual and it is sourced from database entries. Experience with database management and textual data analysis is a crucial requirement for this project. The primary tasks include: - Analyzing and indexing a large dataset from database entries - Setting up Elasticsearch for efficient data analysis - Implementing indexing strategies for textual data Proficiency in Elasticsearch, data indexing, and database management is benefit for this project. Familiarity with handling large datasets and textual data is a must.

I'm seeking a data entry specialist with a knack for precision to type data from PDFs into an online database. Key Requirements: - As a data entry specialist, you will be responsible for the accurate and timely entry of data from PDFs into our online database. - The data format should match the original PDFs, with no specific validation rules needed. - The ideal candidate will be detail-oriented, with a proven track record of data entry. If you're someone who enjoys working with data and has an eye for detail, this could be an ideal project for you.

My Python script is intended to scrape specific Telegram groups, but it's not functioning as expected. I need a developer to address these issues, described below. - **Issue Description**: The script is crashing when scraping certain Telegram groups, which is likely due to the fact that it's not respecting selections. The error presented is “ AttributeError: 'MessageMediaWebPage' object has no attribute 'document'” I can provide the script if you want to check how it’s working. I am open to a whole new script being made. So long as it functions in a similar way. If not familiar you can view telethon api - **Expected Behavior**: The scraping script is supposed to collect data that matches specific regex...

I'm looking for a skilled professional who can meticulously guide me in video call through setting up a VPN using Google Cloud and OpenVPN. The primary aim is to ensure secure remote access to a MySQL database from my Windows laptop. Key requirements: - In-depth knowledge of Google Cloud and OpenVPN - Proven experience in configuring secure VPNs - Expertise in MySQL database security and remote access Your role will be to provide detailed, step-by-step instructions on how to properly configure the VPN to meet my security needs. Please bear in mind that I may require access to the MySQL database from multiple remote locations, but most likely will only need it running from 1 remote laptop - the VPN should be flexible enough to accommo...

We are seeking a skilled and motivated Cold Calling Specialist to support our digital marketing agency located in Canada, Kelowna. As a Cold Calling Specialist, your main responsibility will be following a script and calling businesses on Google Maps to get them to book an appointment with me. You will be provided with a list of leads on the goHighLevel CRM, and your task will be to reach out to these prospects via phone calls to introduce our services and secure appointments for our sales team. Skills needed: - Excellent communication skills - Proficient in cold-calling techniques - Fluent in English and Above - Able to work 30 hours minimum per week. - Familiarity with digital marketing services(Preferred but not required) - Book appointments on The CRM Your payment will be bas...

I have a medium complexity Pine Script that I'm currently using for backtesting on TradingView. I would like to convert this script into Python so that I can run backtests on my local machine. This Python script should produce the same results as the Pine script on TradingView, but handle different data resolutions (1hr to 1Day data). Key Requirements: - Convert a Pine Script into Python. - Ensure the output of the Python script matches the results produced by the Pine Script on TradingView. - The Python script should be able to handle different data resolutions from 1hr to 1Day. Ideal Skills and Experience: - Prior experience in backtesting trading strategies in Python - Proficiency in Pine Script and familiarity with T...

I need a skilled video creator to produce one mixed media promotional videos for my learning platform. The ideal candidate will be able to handle both animated and live-action elements seamlessly, including script writing. Actually what I wanted is to show a real person using my platform https://ooro.com.au. However, a 2D Animation with voiceover would be acceptable as long as rest of the requirements are met. Platform is designed so anyone with a skill or talent can register as a mentor. This includes actual teachers. And then if someone wants help with something they are learning, they can search for a mentor, who will use video call on the platform to engage with them. As an example, trying to imagine a video where people are getting assistance from a mentor using the plat...

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.

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

I have a Node.js script that I've been using to sort and verify emails. However, there are some issues that I need to be fixed. I'm looking for a professional who can assist me in enhancing the script. Requirements: - The script should be able to validate the existence of email mailboxes without freezing when processing a large volume of emails. - Email verification must be accurate and reliable, and the script should be able to handle a large list of emails efficiently. Key points for the project include: - Implementing a more efficient algorithm to handle large email lists without freezing. - Ensuring that the script provides accurate validation of email mailbox existence. Ideal Skills: - Strong proficiency in Node.js and email verificatio...

I'm seeking a skilled developer to create a script that can download the complete list of sanctions data from OpenSanctions database. Once the data is obtained, the script needs to perform a comprehensive database search, identify any country-specific sanctions, and provide a detailed report of these connections as well as a option to show a visual mapping. Key Requirements: - Download the complete list of sanctions data from Open Sanctions database - Conduct a thorough database search to identify country-specific sanctions - Create a report summarizing the identified connections The final report should be in an interactive web page format. The visualization should be clear and easy to comprehend, allowing for an intuitive exploration of the...

Tafadhali Jisajili ama Ingia ili kuona maelezo.

I am in search of a skilled 2D animation professional. You will be creating a 2D-style video for the primary aim of promoting my brand. The target audience for this video is primarily adults. Key Responsibilities: - Develop a visually appealing and engaging cartoon-style 2D animation video - Clearly convey the brand's message and values - Ensure that the video is suitable for an adult audience Ideal Skills and Experience: - Extensive experience in creating 2D animations, particularly in a cartoon style - Proven track record of developing successful brand promotion videos - Excellent understanding of adult audience preferences and sensibilities - Strong communication skills to understand and translate my brand's core values into animation Your engaging and professional animatio...

I have a Pine Editor script that I believe is in a good place, but I'm hitting some error messages that I can't seem to fix. I need someone who knows their way around Pine Script and TradingView to help me get this script running smoothly. Key Requirements: - Troubleshoot and debug script errors: The main issue I'm facing is error messages when I try to run the script. I need someone to go through the script, identify the root cause of these errors, and help me fix them. - Pine Script proficiency: The ideal freelancer for this project should have a good handle on Pine Script, as it's essential for understanding and improving the script. - TradingView experience: Since the script is set to work within...

i got my code pine script i need some when to add messge to the code and ill link it to webhook to send the signals Json signals fit to Cornix bot i need it asap in hours thanks

I've been working on a Python script that I'd like to make accessible online through a web interface. This would involve uploading the script to a suitable web server and setting up a simple user interface. Key Requirements: - Deploy my Python script onto a web server, optimization for best performance. - Implement a basic but intuitive UI for the script. - Ensure it can be accessed by anyone without requiring user authentication. Ideal freelancer for this project should have: - Strong experience in deploying Python scripts to web servers. - Proficient in creating user-friendly web interfaces. - Familiarity with various web servers, especially as I'm undecided on a specific one. If you have experience in deploying Python scripts online and can...

Hello, This is a $20 project. Looking for a freelancer to develop a python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should target restaurants that have a phone number and *do not* have a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (in meters) - Ensure the business/place is a restaurant, bakery, etc. Key Data to Retrieve, output in a .CSV: - Business Name - Address - Phone Number - Google Maps URL Thank you, trooper501

I'm in need of a skilled professional to help me create a data mining script. The task involves mining emails, data from a certain website and delivering the data in a raw text file format. Key Requirements: - Develop a data miner script that can effectively scrape email data from websites. - Ensure the script can handle multiple sources and is scalable for future needs. - Deliver the mined data in a raw text file format. Ideal Skills: - Proficiency in web scraping and data mining techniques. - Experience with developing scripts for text data mining. - Strong knowledge of scripting languages suitable for scraping like Python/BeautifulSoup, R, etc. Please provide samples of your previous similar projects or portfolio that demonstrate your ability in this area.

I'm looking for a skilled video editor who can help me create engaging review and how-to videos for products. Key Responsibilities: - Editing TikTok videos to be between 15 to 60 seconds long - Incorporating English voice-over. I will provide sample videos for you to use in the video. You can use snippets of the sample videos and cut them in small snippets for the final video. ...looking for a skilled video editor who can help me create engaging review and how-to videos for products. Key Responsibilities: - Editing TikTok videos to be between 15 to 60 seconds long - Incorporating English voice-over. I will provide sample videos for you to use in the video. You can use snippets of the sample videos and cut them in small snippets for the final video. I will provide the scri...

I'm looking for an Indian Python developer to create a script that can retrieve specific data from Telegram. Key Points: - The script should be able to fetch phone numbers and migration of users from Telegram. The ideal candidate should: - Have a strong background in Python development - Be familiar with working with API's - Have experience in web scraping - Have a good understanding of data privacy and security - Be able to deliver the project on a monthly basis. Looking forward to hearing from Python developers with relevant experience.

Tafadhali Jisajili ama Ingia ili kuona maelezo.

I'm in need of a skilled OpenCV programmer to help me with a bug in my WhatsApp automation script. Here's what you need to know: - The specific issue is that the automation isn't starting as expected. - The script is written in Node.js. - I haven't been able to locate any error messages or logs that might be related to the issue. You should ideally have experience with: - WhatsApp automation - Node.js - OpenCV Your task will be to identify the root cause of the automation failing to start and rectify it.

I have a YOLO v5 detection Python script, and I'm looking to turn it into an API-based web program with FastAPI. The API must support user inputs for 4 Twilio contact numbers and 4 RTSP addresses, and it should display the four video streams in a grid on a single page. Key requirements: - Convert the existing YOLO v5 detection Python script into a FastAPI-based web program. - Implement user input functionality for 4 Twilio contact numbers and 4 RTSP addresses. - Display the video streams in a grid layout on a single webpage. Ideal skills and experience: - Proficiency in Python and experience with YOLO v5 detection. - Strong knowledge of FastAPI for building web APIs. - Previous experience integrating Twilio for messaging. - Familiarity with displaying multiple video st...

I'm looking for an experienced and creative video creator who can generate an explainer video to introduce my company/brand. Key responsibilities: - Develop an original, compelling script from scratch. - Deliver an engaging video that effectively communicates our brand message. Ideal Skills: - Strong scripting and storytelling skills. - Experience in creating explainer videos. - Proficient in using video editing software. - Keen eye for details and creativity. - Understanding of branding principles. The ultimate goal of the video is to provide viewers a clear, appealing introduction to our brand. Looking forward to excellent pitches from skilled professionals.

I have a database containing over 600 serial numbers. Email serial number has an associated email address. Instead of listing the same email address multiple times, I would like a script to place all serial numbers by one email address. This will enable me to email the customer once with ALL of their serial numbers in one email. Example: Hannah Walker appears in the database 5 times, the script should remove the four duplicates of Hannah Walker and put all 5 serial numbers by her name.

I'm a highly fluent speaker of Chinese, but I lack the ability to read and write the language. I'm seeking a skilled...me bridge this gap and teach me how to read Simplified Chinese. Ideal Skills and Experience: - Proven experience in teaching Chinese, ideally to non-native speakers - Ability to assess my current language skills and design a tailored learning plan to improve my reading proficiency - Patience and good communication skills to guide me through the learning process - Knowledge of Simplified Chinese script - Understanding of how to structure lessons for effective learning The successful candidate should be able to provide a structured and engaging learning experience to help me achieve my goal of reading and writing in Chinese - my main focus is on reading an...

I'm seeking a skilled developer to create a trading script that leverages the trend following strategy. The specific indicators the script should use are Moving averages, MACD, Volume Profile, ATR, and VWAP. - **Trend Identification:** The script should be able to identify trends based on 15-minute data timeframe. - **Required Expertise:** I would ideally be interested in a coder with extensive knowledge of algorithmic trading, and experience in developing trading scripts. An understanding of trend-following strategies and the mentioned indicators is a must. This engagement will necessitate a strong knowledge of financial markets and trading. If you are a detail-oriented coder and familiar with the trend-following strategy, your skills will be id...

I'm looking for someone who can help me deploy my script on an Ubuntu webserver. Key Requirements: - Deployment: I need the freelancer to take over the deployment process as I'm not familiar with it. - Updates: I'm unsure about how to manage updates to the application. I'm open to suggestions and would like the freelancer to provide recommendations on this. - Server Configurations: I need assistance with setting up the Ubuntu 22.04 server for hosting the script. Ideal Skills and Experience: - Proficiency in and server-side technologies. - Extensive experience in web server administration, especially Ubuntu. - A proactive approach in suggesting and implementing best practices for application deployment and server configuration. - Good communication sk...

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.

...complete but due to some error while connecting to the database some code is missing and the connection is not completed. You have to find out where the problem is and fix it properly. I will help you in everything ******* I'm 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 wi...

...milliseconds. I am seeking a freelancer to develop a script that will run on the processor mounted on the RC plane, ensuring the video stream meets the desired latency requirements. Project Requirements: Objective: Develop a script to reduce video stream latency to 100-200 milliseconds. Ensure the script runs efficiently on the processor mounted on the RC plane. Integrate the low-latency video stream with the existing React Native Android application. Current Setup: RC Plane with an onboard processor and camera. React Native Android application for receiving video streams. Telemetry data transmission and other functionalities are already implemented. Deliverables: A script to be deployed o...

I'm in search of a skilled Pine Script editor to create a custom indicator for me on TradingView. The primary focus of the indicator will be centered around support and resistance levels which will use 10 candlestick pattern . The indicator should be able to effectively analyze and identify key levels, and I would expect it to provide clear signals for breakouts and bounces. Optimally, the indicator should be able to: - Accurately plot support and resistance levels on the chart - Generate clear, easy-to-understand signals for potential breakouts and bounces The ideal candidate for this project would be highly proficient in TradingView's Pine Script, with a strong background in developing custom indicators. They should also have an in-depth understanding of techn...

Project Overview: I am seeking to have a custom Google Sheets system created for a group within a GTA V roleplay server. Our group imports special items for other groups, and we need an efficient way to manage these transactions. Requirements: Main Sheet: Buttons: Treasury Deposit/Withdrawal: A button that, when clicked, presents a dialog or an input field directly on the sheet to enter the deposit or withdrawal amount. Shipment: A button that allows users to input the following details: gangName memberName itemOrdered itemQuantity weightUsed currentWeight weightAfter orderedBy Automatic calculation of the total weight and price for each item (a list of items, their prices, and weights will be provided). TreasuryDB: A dedicated sheet to track all deposit and withdrawal transactions. ...

As the project owner, I'm seeking a professional skilled in Pine Script with experience in retrieving code from private scripts on Trading view. The key objectives of this project include: - Extracting the Pine Script code from a specific invite-only script (the script name will be shared privately upon project commencement). Unfortunately, it's currently unknown which specific script to be used, but clarity will be provided as the project progresses. - Discern the implemented functions within the script. The functionalities mainly centered around recognizable trading indicators like Moving averages, Pivots, Fibonacci and MACD. - The code extraction should consider compatibility with variable timeframes. Whilst exact timeframes aren�...

...creating an ER diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQ...

I am looking for a team of talented individuals to support the growth and quality of my YouTube channel content. The core roles I am looking to fill are: - Script Writers (Telugu & English): You should have a strong command of your respective language and the ability to craft engaging scripts. The channel's content spans across Educational, Movies and Music genres, so an understanding or interest in these areas will be beneficial. The ideal candidate should be able to generate quality scripts on a weekly basis. - Marketing Expert: I am seeking a marketing professional who can strategize, execute and optimize plans to increase the channel's visibility and drive engagement. Experience in YouTube channel marketing and a strong understanding of the YouTube algorithm will...

I am excited to apply for the part-time Software Developer position. As a third ...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 enhanc...

...complex backend development and database integration tasks and run code as offline. Key Responsibilities: Develop, test, and maintain robust, scalable, high-quality software solutions. Design and implement new features and functionality. Write clean, maintainable, and efficient code. Develop RESTful APIs to support front-end functionality. Integrate user-facing elements developed by front-end developers with server-side logic. - In-depth understanding and experience of backend operations using Python Django. - Managing and integration of the database with the application. - Maintenance and improvement of existing codebase for optimal functionality. Desirable Skills: - Proven experience in Python Django for backend development. - Hands-on experience in database ...

As a Python Developer, I'm intent on automating specific repetitive tasks related to file management and organization. Key Responsibilities: - Develop scripts in Python to automate repetitive file management tasks. These tasks are slowing down our productivity and we need a solution to streamline them. - Implement an effective, reliable and user-friendly automated system that requires minimal manual intervention. - Ensure the system is highly secure and can handle large volumes of data effectively. The ideal candidate will have: - Proficiency in Python programming language and experience in automation.

I need an experienced programmer, highly proficient in Pine Script, to create a bot for Tradingview. This project involves: - Developing a bot that executes buy/sell orders The bot should be programmed to automatically manage my trading strategy, which will be discussed further upon commencement of the project. The ideal candidate should have extensive experience in Pine Script and understanding of the financial markets, especially within the context of day trading. Your skills should also include proficiency in creating alert systems within bots. I look forward to receiving your bids.

I've compiled a comprehensive global leads database with 8 million entries. The database includes a variety of details such as name, email, contact number, website, profession, and even Instagram username. - **Purpose**: This database is specifically designed for sales leads generation. It's meant to help businesses and organizations reach out to potential customers and grow their sales. - **Categorization**: The leads are not just categorized by one specific filter. Instead, they're a mix of different categories from various industries, countries, and professions. This eclectic mix provides a wide range of opportunities for potential buyers. - **Delivery Method**: I'm looking to sell this database through a CSV file, online access to the...

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

Commercial real estate agency database of GCC

About Plesk hosting upgrading the database from MariaDB 10.1 to 10.3 i would like to upgrade the database from MariaDB 10.1 to 10.3 for my hosting however, my hosting have a lot of client website in it, just would like to know if this upgrade will not affect the existing database thanks

I am seeking a professional to develop a software that can efficiently extract and present the scripts used on a list of URLs provided. The software should be able to handle up to 1000 URLs at a time and run specifically on Windows. Key requirements include: - Extracting scripts: The software should be able to seamlessly access the provided URLs and list the scripts used on each page. - Bulk processing: The software should be capable of handling a significant amount of URLs, up to 1000 at once. - Windows compatibility: It is essential that the software is designed to run on Windows OS. Website Accessibility: - Restricted access: Websites that require restricted access or login should be identified and reported separately. The software should skip such pages and indicate them as inaccessi...