Oscommerce sql faster query jobs
I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration
I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.
I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Manag...agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the ability to design an aesthetically pleasing interface. Requirements can be asked if you are interested, you can build with any framework, preferably javascript based frameworks. Minimal SQL is required, a...
In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Set...framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for this role would include: - Proficient in ActiveMQ and JMS messaging - Previous experience in setting up asynchronous messaging systems - Familiar with SOAPUI and its capabilities for message testing - SQL developer for database queries and validations Please bid on this project if you're confident in your ability to deliver on...
Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database
I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployment info...
...interested in optimizing call to action buttons to boost user engagement and ultimately, conversions. - Server Deployment for Enhanced Performance: The new server deployment should prioritize faster loading times. A significant aspect of this project is to ensure that the website works seamlessly on the new server without any disruption to its functionality. Ideal Skills: - Proven experience in website redesign with a track record of increasing conversion rates. - Proficiency in UI/UX design and a strong understanding of user behavior. - Technical expertise in server deployment, particularly in ensuring faster loading times. - Strong communication skills and a detail-oriented approach to guarantee all aspects are covered. If you have a keen eye for design, a solid under...
Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.
I am seeking a full stack PHP developer to assist me with my project. I'm l...you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this project is for you. Your ability to work both independently and collaboratively will be key to our success. Ideal skills and experiences include: - Proficient in PHP and related frameworks - Strong knowledge of HTML, CSS, and JavaScript - Familiarity with SQL and database management - Experience in user authentication and payment processing - Understanding of project management and problem-solving - Excellent communication and time management skills I am looking to commence this project at the earliest convenience, so please get in touch if you're avail...
...experiencing issues with the search bar on my site. It suffers from slow loading speed and provides irrelevant results, causing a less than ideal user experience. The existing search feature has been built using PHP. To improve the functionality and user satisfaction, I'm seeking a professional with vast experience in PHP who can implement critical improvements. - Autocomplete Function: For faster and user-friendly search queries, incorporate a reliable autocomplete function. Having this feature can save users' time and enhance the browsing experience. - Enhanced Filtering Options: Alongside the autocomplete feature, the search bar needs to have advanced filtering options to serve the most relevant results to the users. This will not only speed up the site navig...
...hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Perso...
...appealing. • Live Chat Support: Integrate a live chat feature for real-time assistance and guidance to potential clients. • Enhanced Testimonial Page: Improve the testimonial page for credibility and social proof. • Scroll Bar Placement: Move the scroll bar to the top of the website for an immersive viewing experience. • Website Speed Optimization: Enhance website speed with a sleek loader for faster loading times. • Footer Design Update: Revise the footer design for improved aesthetics and functionality. • Technical Optimization: Implement cache management, Google Analytics, meta tags, and backlinks for enhanced website performance and visibility. • Homepage Enhancement: Update the design of the homepage to be more interactive, resp...
I'm looking for an expert with experience in converting GAN models to TensorRT models. The purpose of this conversion is to deploy the model on an Nvidia Orin device. The primary goal of ...make it compatible, but to ensure that the model's performance is significantly improved and the memory usage is reduced. Key requirements: - You should have a solid understanding of GAN and TensorRT - Proven experience in model conversion - Ability to optimize for faster inference without compromising on performance In your application, I would like to see a detailed project proposal that includes your approach to the conversion, any relevant experience you have and how you plan to achieve basic optimization for faster inference. Feel free to share any past work that i...
...with the services I provide. - Adding New Features: I'm open to suggestions here. A few ideas could be online appointment booking system, product catalog, or live chat support. Additionally, there are a few key areas where I'm seeking recommendations: - SEO Enhancements: The site should be optimized for search engines to attract more visitors. - Performance Improvements: I need the site to be faster and more responsive. - Mobile Optimization: It's crucial that the website looks and functions flawlessly on mobile devices. Finally, I will also need a detailed breakdown of the cost involved in the revamp. I'm looking for a freelancer who has: - Proficient experience with Bluehost and WordPress. - A proven track record in website redesign and content updating....
...where all accounts to be invited will be listed in the following format: @jacksparow @did738 @simao79 @wiro … The user file will contain anywhere from 1000-2000 users thats why i need script to be multithreaded and add Users from 10 Telegram API’s simultaneously because Telegram has limit on how many users you can add. You can offer your workaround if you know which would allow to add users Faster?(Perhaps using interface or other ideas)...
I have an issue that needs resolving urgently. I'm having difficulties with the visibility of my Instagram account. My trouble is essentially with account settings—I'm unable to set it up correctly. I am looking for someone with in-depth Instagram technical knowledge and a keen understanding of issues r...ideal candidate should can solve these kinds of issues swiftly. Patience and precise communication skills are also highly desired, as I would love to understand the problem and the solution, to prevent a recurrence. All in all: • Should have Instagram expertise • Should have problem-solving skills • Need excellent communication skills • Must be patient and willing to educate me on the solution The faster this is solved, the better. Please reach o...
I would need a script written in nodejs where a USB NFC reader (specifically the ACR122U or the ACR125U) wait for a NTAG424 DNA tag. Once an NFC tag is tapped write a URL data into the tag as well as encryption keys. Make sure the URL contains query parameters which are mirrored uid, counter, and cmac that are all encrypted. Part of this is to write a nodejs script to validate the above parameters from the URL and decrypt the uid/counter (or some Rust that can do the same)
...---------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need look up the `11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico/template-parts/project/ to show the Booknetic category based on the game.
...Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Cloud Memorystore): Log Redis operations. - Collect and store logs centrally using GCP's Stackdriver Logging. - Set up log rotation and retention policies. 3. HTTPS Domain...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% randoml...
We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78,...
...ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be straightforward, requiring only an email and password for access. Ideal Skills and Experience: - Proficient in Laravel - Experience in creating admin dash...
We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.
Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.
...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 Integration: Connect the backend with the frontend using APIs. The APIs should be well-documented, secure, and efficient, allowing seamless communication between the backend and frontend. Requirements: Proven experience with CodeIgniter 3 and 4. Strong knowledge of SQL query optimization. Expertise in identifyin...
looks 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 databases and their tables from S...
wordpress needs updated and the health pages errors fixed. woocomerece and plugins website is slow, need to make it load faster
I'm in need of a marketing specialist to help with a B2B product marketing project. The main objectives for this campaign are: - Increasing brand awareness - Generating leads - Boosting sales Your focus should be on creating an strategy with clear execution steps and compelling content to update the website and also for email and content mar...companies and funds) to find the perfect investor match within seconds. Investors can now source the most exciting opportunities whether they are private companies, funds or even other Investors, for their primary and secondary share sales. Financial Advisors and Broker-Dealers can now gain access to issuers and investors from anywhere in the world who are unknown to them, to close their deals faster, or grow their busine...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
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.
Hi, I am looking for expert to connect SQL database togoogle looker studio so we can analise data and creat reports, it is a long term coopartion. Please provide implementation cost and hourly charge. Best.
...programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation fro...
...offering rewards. I’ve been a successful award winning world-class professional painter & printmaker for decades. However (as mentioned in my campaign) Redundancy in my “Visual Arts” profession (due to circumstances unrelated to job performance) that I never could have anticipated has severely reduced the demand for artwork created by the human hand (by artists like me) in favor of computer generated faster/cheaper AI images. The conversion and restoration of old slide images of my artwork using software programs to remove dust, discoloration, etc. is very labor intensive before the artwork image will be ready for digital printing and marketing online which will generate an income from digital prints. I cannot borrow the money we need to fix the roof &...
We are seeking an experienced freelance developer to design and develop an online service booking platform targeted at legal professionals. The project includes creating both a web application and a mobile application for service providers. Responsibilities:Design and develop an intuitive user int...booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in front-end and back-end technologies (e.g., React, Node.js).Experience with SQL or NoSQL understanding of UX/UI design to meet deadlines.
...standards of code quality and push for continuous improvement. **What You Need:** - BS/MS in Computer Science, Engineering, or related field. - 2-3 years of full-stack development experience, with significant focus on mobile apps. - Strong proficiency in Flutter or similar, front-end technologies (HTML5, CSS3, JavaScript), and backend development (Node.js, Django). - Experience with databases (SQL & NoSQL), cloud services (AWS, Google Cloud, Azure), and versioning tools like Git. **Why Join Us?** - Flexible working hours and a chance to work in a dynamic, fast-paced environment. - Continuous learning and professional development opportunities. ? **Apply Now!** Send your resume, a cover letter, and work samples/portfolio demonstrating your expertise relevant to the role. ...
I require a mobile application for fish/meat/poultry product sales just like the freshtohome mobile app. Priority for cheap and faster applications (persons those who already have such modules will be more convenient)
...user login/signup, in-app messaging, push notifications, photo and file upload. Advanced features should also include GEO Fencing, QRCODE/Barcode scanning and face recognition. The app should be supported by SQL and allow user details to be saved and retrieved from a database. Furthermore, the app needs to integrate with Google services like Maps and Calendar. The design of the app should be minimalistic but seamless for easy user interface. Therefore, a developer with design skills would be perfect for this task. - ESSENTIAL SKILLS: - Android app development - Knowledge of SQL - Minimalistic app design - Experience in GEO Fencing, QRCODE/Barcode scanning, Face Recognition - API integration with Google services This project will require rigorous testing to...
I'm in need of a competent WordPress developer to assist me in make the site is in to two language English and Thai. You need to create multi language button. Customer able to switch back and forth between two language. I also need developer to update all new current plugin and make the site load faster. Need SEO plugin install and social networking login.
I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The p...Search Functionality: The application will have a search feature that allows users to find specific content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that demonstrate your expertise in these areas. I'm looking for a reliable, communicative individual who can deliver a high-quality...
...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 SQL - Experience with ER diagram creation - A...
...Starter: $359 500 business cards 4 Yard Signs 250 Flyers (8.5 x 11) 250 Post Cards (4 x 6) Advance: $449 1000 business cards 6 Yard Signs 500 Flyers (8.5 x 11) 500 Post Cards (8.5 x 5.5) Pro: $ 599 1000 business cards 10 Yard Signs 1000 Flyers (8.5 x 11) 500 Post Cards (8.5 x 5.5) 1 Post Sign (18 x 24) Title of the flyer should be Attention real estate agents and byline Let's AIM to help you sell faster! Create the best layout, I will also advertise With some content on the backside too on the backside EDDM and Direct mailing services and also design services I'm in need of a talented graphic designer to create a modern and sleek flyer to advertise my product/service to professionals. Key Aspects: - Design: The flyer must have a modern and sleek design to ensu...
I'm looking for a seasoned AWS Data Engineer with over 8 years of experience to support me in handling data extraction and transformation tasks. Key Responsibilities: - Data Extraction: The engineer will be responsible for extracting structured data held in SQL databases. - Data Transformation: You will be required to transform the extracted data into a usable format for our analytics and reporting. Skills and Experience: - 8+ years of experience as an AWS Data Engineer. - Proficient in working with structured data, in particular, SQL databases. - Extensive experience in data transformation. - Expertise in AWS services, especially Amazon S3 and Glue. Your support will be essential in ensuring the smooth flow of our data processes. Please provide examples of your past ...
I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration ...be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are high...
i 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'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...
...availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen courier to confirm the shipment. Automate File Transfer Based on Client and Project: Implement a system that automatically transfers the transport query from one file to another in the local drive based on the client and the current project folders. Project Goals: Automate Courier Selection: Develop a way to automatically select suitable couriers from the database based on predefined criteria (distance, size, location). Automate Communication: Automate the process of contacting couriers via Outlook, including sending inquiry emai...
