Send query Jobs
...not a beginner's playground. Key functionalities: - Deployment of a large django platform to GCS - servers / containers are already set up - Implementing and managing user authentication and payment processing using the Stripe API - this too is already set up its just part of deployment. - the ability to consider, discuss then apply simple solutions to issues known to us regarding excessive query load within the system - We have cloud run for deployment, the containers with all our users data are already in google cloud. Ideal Candidate: ******* Must have a working camera on their local machine****** As you will be given access to client secrets and sensitive information - we require someone who we can at least meet and see and talk with. - Should have strong hands-on e...
I have 1 short page causing 5 errors in my error log although the page is functioning as designed. I need one Freelancer who can look at the supplied page and supplied 5 errors and fix. Must be able to spot the MySqli Database connection problem without bugging me for server access. I will upload and test. $15.00 Job
...adjust the timing, for example, to every 6 hours. The Java project must include Docker and MongoDB to enable deployment on a hosting service with Docker support. While not required, documenting the project with Swagger will be viewed favorably. technical definitions of the gateway api. 2 main endpoints: -idealista -fotocasa Query param: -String operation (sale|rent). Path parameters: -String id (optional) -String location (required) Examples: GET idealista/valencia Query parameter: alquiler Return all rental properties in valencia GET idealista/valencia/1 must return the property in valencia with id 1 otherwise 404 will be returned. We can discus later some small things about the development. predefined Milestone (I have to review ur gitrepository, github or bitbuc...
I'm looking for an Elastic Search expert who can efficiently implement a full-text search feature for a huge set of product data. The expert will take responsibility for the development of an effective method of full-text search across my English language product data. Skills and Experience requirements: - P...remain the same for the selected attribute group when using DYNAMIC attributes that cannot be hardcoded, i have a function that works correctly on predefined ones but not dynamic attributes which i need help with. Here is the current function + data example. PS only an elastic search / ecommerce expert can fix this, many have tried, none have succeed up till this point. Check the attached demo and query. Please pm me with possible solutions after you have checked the...
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
...Refactor or redesign algorithms to improve efficiency without sacrificing accuracy. 3- Database Indexing: Implement proper indexing strategies in the MySQL database to enhance query performance. Identify key fields for indexing based on the search patterns and data access requirements. 4- Code Refactoring: Review the existing PHP codebase to identify areas for improvement, such as redundant operations, unnecessary loops, or inefficient data structures. Refactor the code to streamline execution and improve readability while maintaining functionality. 5- Query Optimization: Optimize SQL queries to leverage MySQL's query optimizer effectively. Utilize appropriate SQL clauses, such as WHERE, JOIN, GROUP BY, and ORDER BY, to minimize data retrieval and processing ov...
I'm looking for an experienced Neo4j developer to write a Cypher query that can efficiently perform identity matching. Specifically, I need the query to match against social security numbers. Key Responsibilities: - Understand my existing data structure - Write a Cypher query for a neo4j database - Ensure the query performs identity matching effectively Ideal Skills: - Strong knowledge in Neo4j graph database - Proficient in Cypher query language - Experience in identity matching algorithms - Understanding of social security number data handling
I'm aiming for some fresh functionality to be integrated into my current Laravel website. Although I chose to skip clarifying the nature of this functionality in an earlier query, I'm willing to discuss this in detail with interested freelancers. Ultimately, the aim is to enhance and expand the features our website offers. Skills and Experience: • Proficient in Laravel Development • Previous experience in creating new functions on existing sites • Strong communication to grasp and implement new features creatively When applying, freelancers should include: • Examples of past work, especially similar projects • Their experience with Laravel projects • A detailed proposal outlining how they plan to achieve the project’s primary goal. A...
I have an instance running WHM and cpanel on Amazon, but I can't send emails because the server has port 25 blocked by Amazon. How to fix sending emails through this server?
I'm in search of a proficient mobile application developer to design and develop a new and innovative application. The platform for the application needs to be iOS and Android. Due to a skipped query, the specific key features are not precisely stated, but I anticipate having to explore some typical mobile application functionality during the project discussions. That said, creativity and innovative suggestions are highly welcome. The timeline for the project is within a month. Ideal candidates should have: - Proven experience in iOS & Android app development - Proficiency in cross-platform app development tools - Innovative mindset and willingness to bring forward creative ideas - Ability to adhere strictly to a set timeline.
Hi Need to send and receive e-Mail from G-Mail. Need to use oAuth2
...**Project Requirements:** - **Custom Chatbot Development:** Develop a chatbot capable of understanding and processing user inputs on tour dates, countries of interest (or cities) The chatbot should be able to handle multiple parameters and return the most relevant tour package suggestions. - **Database Integration:** Seamlessly integrate the chatbot with our existing database of tour packages to query and fetch data in real-time. - **User Interface:** Provide a simple and intuitive interface for both our customers and staff to interact with the chatbot across our website and potentially other platforms. - **Direct Linking:** Implement functionality for the chatbot to offer direct links to the suggested tour package details, enabling users to access the information or make a ...
I require a data expert to migrate a medium sized dataset (100MB-1GB) from MS Excel to a MySQL database. Additionally, the database requires optimization to improve query performance and enhance data retrieval speed, improving overall efficiency and usability. Upon completion of the migration and optimization, the development of a desktop application is also required. This application is to assist with data browsing, editing, and filtering in a user-friendly manner. Ideal candidates should have: - Proven experience in migrating data between different platforms - Extensive knowledge of MySQL optimization techniques - Proficient in developing desktop applications with data browsing, editing, and filtering functionalities - Good understanding of data architecture and management - De...
I would like to create and develop a computer game, and I welcome some suggestions from you. Here is the full description of the required game: Game Objectives: - To assess the abilities of children with autism in their response to information. - Point of view: Top-down. Scenario: 1- The child enters a market or supermarket. 2- The child has a specific amount of money. 3- ...know the cost of the work and the time frame as soon as possible. But the most important thing for me is to get a preview of the game within one day, even if the preview is just a few seconds, this will help me choose the right deal. These are the materials that will be worked on:
I'm seeking a seasoned SQL developer with specialized skills in: - Database design - SQL query optimization - Data modeling Main tasks will include optimizing my existing MySQL database and modifying current queries. Proven experience in MySQL is crucial, and an ability to effectively optimize and streamline existing databases is required. Show me your magic touch in transforming my current setup into a well-optimized machine.
...site should be built using Zustand, Typescript, React-query, Tailwind, and Axios. Key Features: - User registration and authentication functionality. Proficiency in handling user data securely is required. - Clean code and structure. - you will be given a list of apis that can be used to make the website full functional as expected - And NO CSS OR SCSS in the project There is no requirement for integration with any third-party services at this moment. The Project Timeline: This project should be completed within a month. Hence, I would prefer someone who can dedicate significant time and effort to this project. Ideal Skills: - Strong proficiency in NextJS and its core principles - Proficiency in Zustand, Typescript, React-query, and Axios - Knowledge of Tailwind f...
I am looking for someone who can transfer my current VBA code into GCP Big Query stored procedure. This basic VBA code is readily available for conversion. Primary Requirement: - Maintain the 'IF ELSE CONDITION' functionality of the current code during the conversion process. Ideal freelancer: - Experienced in converting VBA code into GCP Big Query stored procedures. - Skilled at preserving specified functions through the conversion process. - Good understanding of basic VBA code structures. - Excellent problem-solving skills in case any issues arise during the conversion process. Your expertise in this area will not only help in preserving the original functionality of my code but also enhance it using GCP Big Query's features.
I am looking for someone who can transfer my current VBA code into GCP Big Query stored procedure. This basic VBA code is readily available for conversion. Primary Requirement: - Maintain the 'IF ELSE CONDITION' functionality of the current code during the conversion process. Ideal freelancer: - Experienced in converting VBA code into GCP Big Query stored procedures. - Skilled at preserving specified functions through the conversion process. - Good understanding of basic VBA code structures. - Excellent problem-solving skills in case any issues arise during the conversion process. Your expertise in this area will not only help in preserving the original functionality of my code but also enhance it using GCP Big Query's features.
I need a proficient Microsoft Access developer to assist in upgrading my database from Access 95 to Access 2010. Key Tasks: - Database upgrade - Query optimization; to ensure optimal performance of the updated database. - Design forms and reports; to match our specific business needs. Ideal Skills: - Previous experience in upgrading old versions of Microsoft Access databases. - Proficient in database management and query optimization. - Understanding in designing Access forms and reports. Hands-on experience and a proven record in handling similar tasks would be a major asset.
Bitte melde dich an oder Loge dich ein um Details zu sehen.
...address. We need to correct this so that address line 2 accurately displays the address information. Improved Search Logic: Enhance the search logic to better match user expectations. When a user searches for a business, they might include both business name/category and address information in their query. We need to search for the business name/category in their respective fields and the address information in both address line 1 and address line 2. One suggested approach is to split the search query at the occurrence of the word "in": Search the part before "in" in business name and category. Search the part after "in" in address lines 1 and 2. Only display results where both parts match accordingly. Firestore Notification Integration: We...
I'm seeking assistance with my Microsoft Access project involving the creation of queries, forms, reports, and a comprehensive description of the database. The specific responsibilities include: - Developing 3...and a Subform. The main form is to be designed for data entry. - Devising 2 reports based on set requirements (to be disclosed upon project initiation). - Crafting a detailed written description of the entire database system using a provided template. Ideal assistance would come from someone with proven experience in Microsoft Access, SQL, VBA, and database development. A deep understanding of query development, form creation, and ensuring data integrity within Access databases is crucial. Your ability to communicate effectively to explain complex systems will also ...
I need someone who can send 10,000 cold emails for my agency. Email Deliverability: It’s important that the emails reach the recipient's inbox and do not fall into the spam folder. Ideal freelancer: - Has related experience in bulk email sending. - Well knowledgeable of CAN-SPAM Act and GDPR. - Understands email marketing sequencing/campaigns. - Emails have been verified. - Email copy will be provided. - You can use spintax if needed. - Need () personalization included (data field) I want NO open tracking Reply email needs to be my email (so that I get ALL replies) Here's the setup/sequence I want... 1. I will give you 1,665 verified emails 2. I want to send original email message ONCE 3. Then send 5 follow-ups ("bumps") 2 days apart T...
...line 1081 DoctrineDBALConnection->getWrappedConnection() /var/www/html/lib/private/DB/ line 261 DoctrineDBALConnection->executeQuery( "SELECT * FROM `oc_appconfig`", [], [], null ) /var/www/html/3rdparty/doctrine/dbal/src/Query/ line 337 OCDBConnection->executeQuery( "SELECT * FROM `oc_appconfig`", [], [], null ) /var/www/html/3rdparty/doctrine/dbal/src/Query/ line 377 DoctrineDBALQueryQueryBuilder->executeQuery() /var/www/html/lib/private/DB/QueryBuilder/ line 280 DoctrineDBALQueryQueryBuilder->execute() /var/www/html/lib/private/ line 421 OCDBQueryBuilderQueryBuilder->execute() /var/www/html/lib/private/ line 187 OCAppConfig->loadConfigValues() /var/www/html/lib/private/ line
I'm seeking an experienced Database Developer to build a Relational Database Management System (RDBMS) with a focus on product data. The system would rely on Structured Query Language (SQL), designed to execute simple queries. Key Responsibilities: - Developing a RDBMS using SQL - Ensuring the system can manage and interpret product data effectively - Crafting and implementing simple queries within the system Ideal Experience: - SQL development - RDBMS creation and management - Experience working with product data.
...header section. This tool will leverage AI capabilities, specifically utilizing ChatGPT in conjunction with our existing Meow AI engine plugin and an OpenAI ChatGPT Plus API token. Functionality Requirements: 1)User Query Input: The tool must allow users to input queries for baby name suggestions (can be easily achieved with Meow AI Engine). 2)Results Presentation: The generated baby names should be displayed on a separate page, not on the homepage. 3)Interactivity: The displayed names must be clickable. When a user clicks on a name (e.g., Robert), the tool should make a further query to OpenAI to fetch and display detailed information about that name in a popup or another dedicated page. 4)Integration: Ensure seamless integration with the current website (wordpress) and...
We are looking for a driven and autonomous Front end developer to build the Front end of a simple SaaS application that will interact with the Ethereum blockchain. Your skills will be t...in React.js & Redux Toolkit. - Minimum 2 years of experience building dApps that interact with EVM chains. - At least 1 year hands-on in TypeScript. - Experience with handling JWTs & refreshtoken mechanism on the front end. - Experience building responsive user interfaces. - Experience with a Material UI or another major UI library (please specify) - Experience with Front-end caching using RTK query. - Excellent knowledge developing scalable and user-friendly SaaS apps. - Ability to understand user behaviour, and provide results that are production-ready. - Ability to be self-managing and ...
I'm seeking a skilled Oracle database specialist to perform various tasks such as data migration, performance tuning, and query optimization. Your experience and past work will be essential, so please include detailed project proposals. The database plays a crucial role in storing and managing data, analyzing and reporting, and integration with other systems in my project. Key Requirements: - Proven Oracle database management experience - Expertise in data migration, performance tuning, and query optimization - Ability to analyse data and produce clear reports - Expertise in integrating databases with other systems Please make sure to detail your Oracle DB experience, including any past projects you've worked on - especially if they are similar to the scope of ...
I have a Twilio account with sip trunking set up, and I've install Asterisk on Arch Linux, I've attempted to set up the config but have not been able to. I'm looking for someone to set up a basic config where I can send and receive phone calls. The details don't matter, I just want to get it working so I can adjust it once the simplest config is working. If interested please bid the amount you are able to do this for, and include the word "briefcase" in your bid so I know you've read the description and can complete the project for the amount bid.
I am looking for a skilled Shopify expert to re...product descriptions and the checkout process to ensure they are streamlined and user-friendly to encourage customer purchases. - Integration of upselling and cross-selling strategies: This means recommending related products or services to customers to increase the average transaction value. - Adding special features: Implementation of functionalities like live chat support for immediate customer query handling, a wishlist feature for boosting repeated sales, and personalized product recommendations to enhance the customer's shopping experience. Ideal candidates should be proficient in Shopify platform, have knowledge in UX/UI, an understanding in conversion optimization, and experience in implementing upselling and cross-sell...
... The primary function of this tool is to provide users with baby name suggestions based on their input queries. Upon receiving a query, the tool should interact with OpenAI's services to generate relevant baby names. These names should then be displayed not on the homepage but on a separate, dedicated page for the results something similar to this - Instead of these grids we could have ai generated baby images as a background for each name. These names need to clickable. For example, if the tool suggests names such as Robert, Mia, Sia, and Leon, clicking on one of these names (e.g., Robert) should prompt a further query to Open Ai gather and display detailed information about the chosen name on yet another page. my url -
I urgently require a SQL query for my php code. It should basically delete rows from two tables
Hi, we have our server down due to an error on the DB. DB query failed: SQLSTATE[HY000] [2002] Connection refused MariaDB is offline. We are using Plesk. We are requesting restoration and maximum attention to the DB. Please note that we do not "open" Milestone. Payment is only made upon perfect resolution.
...data files which are individually copied to our home office and merged to contain data from all locations. We want to move to a cloud database model, using Azure, and need an Interface Layer between these custom C++ and Java applications and the cloud storage. The cloud storage is likely PostgreSQL but is negotiable in the design process. The Interface Layer will have a well-defined API to query, access, read and write to the cloud database(s). The API will be available from C++, Java, and Python applications. The architecture must be able to locally cache data/commits in the event access to Azure is temporarily unavailable, as to not interfere with production. The data will automatically be pushed to Azure when connectivity is restored. The type of data includes traditional ...
...is utilised as a reference during an API call. File types: To include: pdf, ms word, Excel, CSV, text, XML, JSON User acceptance: To be able to query openAI about the file and get responses that relate exclusively to the reference file. Code: Native JavaScript. Can use external libraries. Should run on any server without installing plugins. Specifications: - The file constitutes mixed data, encompassing both numerical and textual information. - The system should seamlessly interact with the entirety of the file. - The primary task involves integrating the API to fetch data from the stored file, read and analyse it as required, and send appropriate responses. Ideal Skills & Experience: - Robust knowledge about APIs, specifically in relation to Excel integration...
I'm urgently in need of a skilled PostgreSQL coder for query optimization. My project requires immediate attention and must be expedited due to its pressing nature. Key Responsibilities: - Query optimization in PostgreSQL Ideal Candidate: - Has extensive experience in PostgreSQL - Ability to start immediately - Has a deep understanding of query optimization - Prior experience with database performance enhancement Please specify your prior experience with query optimization in PostgreSQL and your availability to start the project.
I have built out an Alteryx web scraping model that mostly works, however, there are some issues, i think it's due to something related to the latitude and longitude requirements of the API perhaps, some cities work and others don't. I am looking to query by city to see which dental services are available in that city. Within the attached model i have provided the list of cities, the website to query, some additional customizations required and some details on the issues. I mostly just want the Download tool configured to pull from all cities, i can cleanup the JSON outputs myself, though feel free to do that :) I would like to scrape the Sunlife Lumino Website.
I urgently require a proficient and experienced tax consultant to address personal income taxes, focusing on property. Unfortunately, I skipped the previous query about whether I'm after tax planning advice or assistance in filing tax returns, but I'm very open to discussing both services. As this is rather pressing, I need support to begin immediately. Ideal candidates should have: - Vast experience in tax consulting, specifically personal income taxes and property - Exceptional skills in income tax planning and/or assisting with filing of tax returns - Availability to start at once and prioritise this project If you possess these qualifications, please get in touch. Looking to move swift with the right expert.
I urgently require a proficient and experienced tax consultant to address personal income taxes, focusing on property. Unfortunately, I skipped the previous query about whether I'm after tax planning advice or assistance in filing tax returns, but I'm very open to discussing both services. As this is rather pressing, I need support to begin immediately. Ideal candidates should have: - Vast experience in tax consulting, specifically personal income taxes and property - Exceptional skills in income tax planning and/or assisting with filing of tax returns - Availability to start at once and prioritise this project If you possess these qualifications, please get in touch. Looking to move swift with the right expert.
I am in need of an SQL wizard, specifically well-versed in MySQL, who can dive into my database schema to rectify some complex queries. ...queries. This will require a profound understanding of JOINs, subqueries, stored procedures, and other advanced SQL concepts. - Performance tuning of SQL queries: Your task is not just to make them work, but optimize these queries. This will include ensuring they run efficiently, making suitable indices, tuning any other aspects of query execution. Necessary skills include: - Strong experience in writing complex SQL Queries - Excellent Knowledge in MySQL query optimization - Proficiency in reading and understanding others code to ensure your queries efficient and readable Anticipating your proactive engagement in discussing database d...
...SQL query that will dump the details of all the users enrolled via the new plugin (User ID, enrolled course, amount paid, date of enrolment etc.) Relevant example : --------------------------------- This type of work has already been done for other payment gateways like Paytm, and PayU. There is also a plugin for the Razor Payment gateway on GitHub. However, that throws an error. You can use the Paytm plugin also as a reference. However, there should be a clear way of exporting all the users who are enrolled through this plugin. Deliverables & Milestones : ---------------------------------------------- [1] Demonstrate the working plugin on your Moodle ( 4.0 ) installations with the Razorpay sandbox. [2] We complete 75% of the agreed payment via Freelancer (Milestone 1) [3]...
In need of an SQL/PLSQL developer proficient in writing intermediate SQL queries, specifically JOIN operations and subqueries. The project involves manipulation of numerical/textual data. The ideal candidate should have: - Strong experience in SQL/PLSQL development - Proven track record of writing advanced SQL queries including JOIN operations and subqueries - Excellent understanding of numerical data manipulation - Demonstrated ability to deliver efficiently and accurately This is a short-term project with the potential for future collaborations. Your responsiveness and attention to detail will be appeciated.
I need a skilled developer with a strong background in PHP and API integrations. Specifically, I'm aiming to incorporate the Wolfram|Alpha LLM API into my chatbot. - Main Task: The developer should facilitate natural language processing, data retrieval, and query execution via the Wolfram|Alpha LLM API. - Platform: My chatbot operates on PHP, so proficiency in this language is necessary. - Additional Information: Currently, my chatbot already possesses user intent recognition, so understanding and preserving this feature during the API integration process is crucial. The perfect candidate would provide seamless integration without disrupting existing functionalities. Your expertise and suggestions on how to best execute this would be greatly appreciated.
I've penned down a content book story and need stringen...down a content book story and need stringent proofreading for the same. The total word count of this piece doesn't exceed 2300 words. - Freelancers with a keen eye for detail and a knack for spotting grammatical errors are most suitable for this job. - Experience in proofreading similar documents will be a strong advantage. - Genre: The genre of the book is uncertain as I skipped answering that query. However, it shouldn't notably impact your proofreading strategy. The appropriate freelancer would have proficiency in English and an understanding of diverse writing styles to maintain the authenticity of the content while making necessary corrections. A prompt delivery is highly desirable, as the document is of...
As a seasoned professional, I'm seeking assistance for an important task — improving an existing analytical tool in Excel using Power Query. This tool currently partially functions but needs some notable improvements. • Existing Database: I have all the static information ready. The data is spread across five tables, which you need to account for. • Enhancement Focus: The following areas need fixing & enhancement: 1. Data Visualization: Current graphics aren't illustrating the data as lucidly as I'd like. 2. Processing Speed: The tool is very sluggish and its speed should be optimized for efficiency. 3. Data Entry & Management: I'm seeking improvements in data entry protocols and general data management procedures. 4. Tak...
As the project lead, I'm looking for freelancers with firm know-how in MS SQL and Intermediate skills i...Intermediate skills in DevExpress XtraReports. Key Responsibilities: - Produce custom reports using MS SQL and DevExpress XtraReports. - Make moderate changes to the layout of existing reports using standard interface and VB.net scripting. Ideal Skills and Experience : - Prior experience in using DevExpress XtraReports - Hands-on experience in SQL report creation and editing - Proficiency in query optimization - Ability to deliver moderate-level layout changes This project would greatly benefit from someone experienced in the data migration aspect. Knowledge in database design is also highly desirable. Exhibit your ability to create compelling reports and join us i...
I would like a bot to track my padel performances. The bot, using gpt-4 will recognize the score, time, date of the match as well as other data that I will upload each time I play. The bot needs to have a database system attached to it so that it can store data and be able to retrive and query them at any time.
I'm currently having an issue with HTML not taking media query. I'm not sure if it's related to specific devices or screen sizes, but it's definitely an issue worth investigating and I need expert assistance with it. Here are some details to help you understand what I'm looking for: - Browser Compatibility: The code intended for this project is to run on Google Chrome, Mozilla Firefox, and Safari; hence your experience in these platforms will be required. - Media Query Issue: I'm not exactly sure whether the problem stems from device specifications or screen size differences, so your ability to diagnose and rectify such issues will be beneficial. - No CSS Framework: I'm only working with plain CSS, therefore proficiency in raw CSS is need...
I have a number of JPEG images that contain SQL queries. I need these queries to be accurately typed and saved on a digital format for my convenience. To successfully complete this task, you should: - Be proficient with SQL, specifically with creating queries that include joins and sub-queries, as this is the complexity level of the queries you'll deal with. - Have keen attention to detail to ensure the queries are accurately translated from the photographs. - Be able to work without direct oversight as there are no specific naming or formatting conventions to follow. Please note that you do not need to execute these SQL queries, just type them out. Let's make database management easier, shall we?
Require an experienced Microsoft SQL Server Database Administrator to help optimize my database, specifically focusing on improving its performance through Indexing, Query Optimization, and Data Caching. Key Details: - Several stored procedures are currently experiencing performance issues, requiring urgent optimization to ensure peak functionality. Note that we have DB of minimum 10GB. - This may involve revisiting our database architecture or restructuring the data model if need. - In addition we need Backup and Recovery Mechanisms, Database Health Check, partition and index Your primary objective will be to enhance our database procedures to facilitate rapid data retrieval. You will guide us through the administration process, offering expertise to maintain optimal performance...