How to write sql query in shell script jobs

Hi, I need a script that scrolls down page and clicks mail buttons then clicks next page then does the same. I think python maybe?

I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are highly appreciate...

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

I kindly ask for payment that I did up to here: - Inspect the code and remove Invisible mode section on profile page for mobile and desktop theme - Enable/fix youtube video's sound for desktop version of script

...for a Python expert to help me create a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that will find the op...

I'm looking for someone to integrate an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse rac...

...I'm unable to send messages. The automation is running on Windows and the script is written in Node.js. Key requirements: - Diagnose and fix the issue: The core problem lies in the inability to send messages. As such, the ideal candidate should have a strong understanding of OpenCV and related concepts, as well as experience with automation on WhatsApp. They should be able to quickly pinpoint the issue and implement the appropriate solution. - Windows proficiency: The automation is running on a Windows platform. The ideal candidate should be familiar with the quirks and intricacies of automation on this OS. - Node.js expertise: The script is written in Node.js. The freelancer should have comprehensive experience with this ...

Please develop a Python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should specifically target restaurants that have a phone number but *without* a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (meters) - Restaurant Type (including catch all types in the "Food and Drink" category) Key Data to Retrieve, output in a .CSV: - Name - Address - Phone Number - Google Maps URL Ideal skillset: - Proficient in Python - Strong experience with Google Maps/Places API - Ability to deliver results promptly and efficiently - Attention to detail to ensure accurate data retrieval

I'm looking for a talented 2D animator who can create 3 engaging and entertaining videos, each lasting between 45-60 seconds. The primary goal of these videos is to captivate and entertain the audience. Key Responsibilities: - Develop 3 separate videos in a minimalist animation style - Ensure the videos are engaging and entertaining throughout - Incorporate the ready-made script seamlessly Ideal Freelancer: - Proven experience in 2D animation and motion graphics - Capable of creating entertaining and engaging content - Proficient in working with ready-made scripts - Prior experience with minimalist animation is a plus Brief Documents for 3 Video's Below: Video 1 - Annuity Payout Options: Video

I'm in need of a skilled and experienced developer that can assist me in automating several tasks, organizing files and data on Google Drive using Google App Script and Java programming language. Key Tasks: - Create scripts to automate Folders and files - Improve file organization and management on Google Drive - Develop custom solutions using Java Ideal Skills: - Proficient in Google App Script and Java - Strong background in automating tasks - Proven experience in organizing and managing files - Prior experience with Google Drive is a plus Your expertise and knowledge in these areas are crucial for the success of this project. Looking forward to collaborating with a proactive and skilled developer.

Please Sign Up or Login to see details.

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

I need a web scraping professional to create a script to extract specific data from , a popular online marketplace for trading cards, please check attachement to get the idea. Key Requirements: - Scrapping: The primary task is to scrape the following information from the platform: - Card properties 1. Hero score for last 7 days 2. Hero rank for last 7 days 3. Stars 4. Rarity 5. Name 6. Quantity listed to purchase 7. Inflation data 8. Minted count - Buy prices List Price Last Price Order book (price and quantity see picture attached) - Bidding details bids book (bid and quantity see picture attached) - Twitter activity per card View Views+ Likes Likes+ Retweets Retweets+ Replies Replies+ Quotes Quotes+ Bookmarks Bookma...

...Python script that can scrape a popular review site. Key details to extract: - Review text - Star rating - Date of review - Reviewer name - Star-ratings for sub-categories - Review ID - Reviewed person - Reviewed product name The site does not use captchas, so it should be reasonably straightforward. All reviews for a given provider should be scraped. It would be good to have an option to start with the newest and stop at a certain date. The specific review site can be seen in the sample URL in the attached PDF. I can send further details in a private message including screenshots. Preferred frameworks would be Beautifoulsoup 4 / Scrapy if sufficient and Selenium otherwise. Please state which one you plan to use. Note: it sho...

...looking for a skilled developer who can create a custom trading script in Pinescript on the TradingView platform. This script will be based on identifying and monitoring market trends. Key Project Details: - The script should be able to accurately identify a trend based on the definition of "higher highs and higher lows". - When a trend is identified, the script should take no immediate action but continue to monitor the market conditions. Ideal Skills and Experience: - Proficiency in Pine Script and experience with TradingView platform. - Strong understanding of technical analysis, particularly in the context of identifying trends. - Previous experience in developing trading scripts or bots is hig...

Create a tradingview script that: Show a candle from green >red>green and vice versa but the condition that second candele cannot close lower or higher than prior third candele cannot close under previous open.

...looking for a skilled developer who can create a custom trading script in Pinescript on the TradingView platform. This script will be based on identifying and monitoring market trends. Key Project Details: - The script should be able to accurately identify a trend based on the definition of "higher highs and higher lows". - When a trend is identified, the script should take no immediate action but continue to monitor the market conditions. Ideal Skills and Experience: - Proficiency in Pine Script and experience with TradingView platform. - Strong understanding of technical analysis, particularly in the context of identifying trends. - Previous experience in developing trading scripts or bots is hig...

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

There are 89 simple phrases and the recording would take about 15 mins. the speakers need to be: - Native Italian speakers from Italy. - Age from 18-55. - Both professional voiceover or amateur Budget: $8 per speaker. We reserve the right to reject any recordings that do not meet our quality standards. (the pronunciation) Feel free to contact me if you are interested in this project. Best Regards Libby

I am in need of a skilled professional who can develop a Rhino Grasshopper script for a pipe network. This script. Check attachment for specs. Ideal skills and experience for this project include: - Proficiency in Rhino and Grasshopper - Strong background in architecture and structural engineering - Experience in developing similar scripts. Please note that the specifics of the script are outlined in the document that will be provided upon engagement. I am looking for a professional who can deliver high quality work within the specified requirements.

...information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data ma...

I'm looking for an expert in Microsoft Power Apps to develop a canvas screen for me. The screen will enable the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable wo...

As a diligent user of Google Drive, I'm seeking a proficient developer who can create a program using Google App Script to arrange my Google Drive files in a hierarchical manner. Let's make searching and organization efficient and automated! the specific features I am looking for well be explained in private The ideal freelancer for this project would have extensive experience with Google App Script and an understanding of how Google Drive works. You should have created similar file management tools previously, and have a knack for creating user-friendly interfaces. Efficiency is key, as is the ability to work on a tight timeline. I look forward to working with a problem-solver who can make my file management efficient a...

...creator who can assist in building my YouTube channel from the ground up. Here are the specifics: - Content Type: Personal lifestyle vlogs. This includes creating content around daily activities, fun facts, popular trends and any engaging life experiences. Show your versatility as a creator by transforming simple, everyday moments into captivating content. - Audience: The channel is specifically targeted at young adults aged 18-34. I'd love to see how you've previously delivered appealing content to this age group. Ideal Skills: - Video Editing: Skilled in video editing software like Adobe Premiere Pro or Final Cut Pro. Enhancing visual aesthetics and ensuring smooth transitions will be key. - Creative Writing: The ability to ...

...Power BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Pr...

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

...a professional content creator skilled in human development to provide me with 30 video scripts and ideas for my business centered on getting rid of old block how nervous system control you, personal growth, overcoming fears, and building self-confidence. Each script should be educational and informative, while maintaining a concise length of 1-3 minutes. Key Requirements: - A solid understanding of human development, personal growth, and related topics - Proven experience in creating concise and engaging video scripts - Ability to convey complex information in an easy-to-understand manner - Strong writing skills with a focus on educational content - Previous experience with similar projects is highly preferred Your work will pl...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design princi...

I'm looking for a Unix shell scripting expert to help me with my project. Here's what's required: - Automating file transfers: I need a script that can download specific file types from a directory on my server and then upload them to an SFTP server. - Handling specific file types: The script needs to be able to recognize and transfer only files of specific types, rather than all files in the directory. Ideal skills and experience: - Proficiency in Unix shell scripting - Experience with SFTP - Expertise in handling specific file types in scripts - Familiarity with file transfer automation - Good communication and problem-solving skills If you feel you have the required skills and experienc...

...all to be done on a new Linux STAGING ONLY server. 1) Linux staging server setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the...

Vanakkam Editing Enthusiastic, I hope this ...Enthusiastic, I hope this message finds you well. I'm reaching out because I'm in search of a talented YouTube editor based in Bangalore for a Tamil cooking channel who knows Tamil language both read and write. Here's a brief overview of what I'm looking for: Experience in editing cooking videos, particularly Tamil cuisine. Proficiency in latest video editing software and AI tools. Ability to add subtitles in both Tamil and English. Creativity in enhancing video quality and engagement. If this opportunity interests you, I'd love to discuss further details, including compensation and workflow. Feel free to reach out if you have any questions or if...

I'm in immediate need of a skilled web developer to tweak an existing custom-built script for my car rental website. The script that I am using is this: I am looking for a professional with a high level of expertise in web development to make these adjustments quickly and effectively. The priority is the rapid completion of this project, so it is critical that the selected freelancer has the bandwidth to dedicate to this task immediately. Experience with custom-built scripts is a must. Your portfolio should demonstrate your capability to work on existing structures and adapt them to new requirements.

...PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. To qualify you must be full stack and work PROFICIENTLY ...

...arm 3d models and would like to find someone who's able to modify those models, cut into smaller parts and convert into CAD format. I will use the parts for 3d printing. The original model is in 3ds, fbx and obj format. Image of the model is attached and I only need you to work on the arm and upper body parts, which is circled in red. Key deliverables: - The final mechanical parts should work be compatible with standard CAD software, such as SolidWorks, Onshape. STEP or SLDPRT format works for me. - The final model should be as close as possible to real human body size, The total height of this woman will be 165cm. - I only need the 3d parts to be a shell, no need for inner mechanical structure, but each pieces of the ...

I am seeking an experienced Python developer to improve the functionality of a current script by adding new features, specifically automated tasks. The upgrades will involve: - Analysing and understanding the existing Python script. - Enhancing the script by adding automated task features to streamline operations. - Testing the script to ensure it performs as required with the new features. Ideal applicants will have: - Proficiency in Python, with a focus on script optimization. - Experience integrating automation functionalities into Python scripts. - A keen eye for detail and error detection. - A proven track record improving and maintaining Python script performance. I am looking forward to working with s...

...for a skilled developer to help integrate the DropzoneJS library into my project in full. I have integrated demo vesrion only. The primary goal is to improve the user experience by allowing for drag and drop functionality for file uploads. Key Requirements: - Implementation of drag and drop functionality using DropzoneJS - Ensuring DropzoneJS supports multiple file uploads at once - Do not need integration within the existing project structure. PHP Upload script working just fine. - Adherence to best practices for user interface design and user experience Ideal Skills and Experience: - Proficiency in JavaScript and relevant libraries, particularly DropzoneJS - Proven experience with front-end development and UI/UX design - Ability to i...

...developed a strategy in Amibroker AFL that I need converted into TradingView Pine Script. The primary function of the current code is to execute trading decisions based on the conditions of the market. **** 1 MORE CONDITION TO BE ADDED MENTIONED IN TXT FILE ATTACHED******* ***** FIXED PRICE RS. 3000/- ONLY ******* Key requirements: - Conversion: The Amibroker AFL strategy needs to be converted to TradingView Pine Script. The converted script should retain the functionality and logic of the original. - Optimization: The Pine Script should be optimized for performance on the TradingView platform, ensuring efficient execution and minimal latency. - Strategy understanding: It's crucial that the freelancer understands...

I have a 15-minute script in progress and I'm seeking a professional Turkish male voice-over artist to bring it to life. The project involves recording the script in a professional tone. Key requirements: - Male Turkish voice-over artist - Previous experience in long-form voice-over - Ability to deliver a professional tone - Strong communication skills I'd appreciate someone who can collaborate with me on this project, offering input on pacing and intonation where necessary. I'm looking for a voice that is clear, engaging, and professional. Please provide samples of previous work in your bid.

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Deliver...

I am in need of expert skills in 2D animation to create a short, engaging video that encompasses a unique process. Requirements: - The animation should be 2D. - Experience with creating short, impactful animations is essential. - The completed video should be less than 1 minute in duration. - I will provide the script for the animation. - Grasp on translating text to visual imagery is invaluable. Ideal freelancers will possess exceptional 2D animation skills, strong communication, and an ability to work efficiently to create a punchy, less than a minute video from the provided script.

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeVal...

...visual effects animator to create engaging rear projections for a theater production. The play lasts for a duration of 1-2 hours. The animations should be visually stunning and creatively incorporated into the play. The ideal freelancer should have the following skills and experience: - Expertise in creating 3D animations, particularly visual effects. - Ability to animate flying effects and magic effects. - Knowledge and experience in theater productions or similar events are a plus. - Strong understanding of timing and how visuals can enhance a live performance. Your task will be: - To design and animate distinctive 3D flying and magic effects. - To work with the director to ensure the visuals align with the script an...

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

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

I am in need of a talented script writer who can create engaging, Hindi language horror scripts for YouTube. The scripts are for short films, with each video being less than 10 minutes. The focus of the horror should be more psychological thriller than supernatural or slasher. Key requirements for this project include: - Fluency in Hindi - Proven experience in scriptwriting, particularly for the horror genre - A deep understanding of the psychological thriller subgenre - An understanding of the dynamics of YouTube content and how to captivate an audience in a short span of time. The ideal candidate will be able to weave a compelling narrative that keeps viewers on the edge of their seats, all while maintaining a distinctly Hindi...

Choose one of the concepts and edit a short video clip for my ad. There are about 10 options to choose from. I will buy more than 10. Watch this loom: Edit the videos for my ad: Link to document: We want to add different beginnings to the VSL ad that is already working: VSL ad video that is working: Script for the ad: Script for the ad We want to use viral images to attract more people’s attention. Format: Beginning of the ad is a viral meme + cut to my recording + cut to body of the edited ad (old body that works) Beginning of the ad is a viral meme GC | Viral Memes + Middle of the

i have Indicator tradingview code i need to fix the jason message to send alert in telegram group fit with cornix

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

...skilled developer to create a custom script for Jira Cloud. The script should modify the behavior of a select field within the platform. Key Features: - Dynamic Select Field: The select field should dynamically change based on the values chosen by other issues in the project. This means that as the field is selected, it should update to exclude values already in use by other issues. - Hide Values Already In Use: The script should ensure that the select field does not present options that have already been selected by other issues in the project. - Customize Form Behavior: The script should also allow for custom form behavior in Jira Cloud. This project requires a developer with experience in Jira Clou...

I'm looking for a talented native English speaker to paraphrase a script for a video. The script is intended for a general audience, so I need the content to engage and connect with viewers. The tone should be energetic. Key Requirements: - Native English speaker - Experience in script paraphrasing - Able to adapt content for a general audience - Capable of infusing an energetic tone - Understanding of video script writing nuances I'm looking for someone who can take my existing script and elevate it so it resonates with a wider audience. If you've got a great understanding of language, are creative, and can bring energy to your writing, this could be a perfect fit for you.