Query project jobber
...create a chatbot whatsapp business integrated with Mikrowisp The chatbot will serve as a tool for registered companies to interact with their customers. Key Features: - Options menu: The chatbot must provide the options menu, and a limit of queries to exit the chatbot and transfer the advisor. - Invoiced amount query: The chatbot must provide users with a simple way to find out the amount owed and due date. - Consultation of the user profile: The chatbot must respond to the contracted profile. - Spanish Support: The chatbot needs to be capable of interacting with users in spanish - Company Management: The ability to enable, disable, or delete companies from using the chatbot should also be integrated. Ideal
...highly dynamic REST API using the .NET 8 framework. The API will be designed to manage interactions with a database using a single, generic controller capable of handling all database tables. This project will involve implementing advanced features such as column selection, filtering, sorting, pagination, and complex table relationships like aggregations and master-detail references. Core Requirements: 1. API Framework: The API should be developed using .NET 8. I am open to using either OData or GraphQL for the API architecture, depending on what the developer finds most suitable for the project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a single, generic controller that can dynamically handle all table...
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.
...Development needed to accommodate the expected volume of registrations Development to prevent IP bans Detailed feature description: Member Login Sign-up Permission assignment Individual inquiry Immediate rank crawling Tracking target management Individual input Bulk Excel upload & download Keyword-based crawling On/Off Deletion Background crawling of tracking targets Naver Place keyword (1 daily query) Rank change history Generate a shareable URL (reset every week) Display in a popup from step 3...
I'm experiencing performance issues within my IoT-based platform, mostly coming from slow query response times, excessive storage consumption, and challenges with insert operations after compression. I'm looking for an experienced TimescaleDB expert to optimize this. - Optimize slow query response time - Reduce excessive storage consumption - Fix insert operations after compression The ideal freelancer for this project is someone who has extensive experience in TimescaleDB, particularly in query optimization and compression features. Unfortunately, I'm unable to provide the number of tables in the platform, but I need someone who is capable of handling extensive data and complex structures. If you've dealt with this before, you're t...
...Microsoft Access 2013 and I'm looking for a skilled freelancer to help me integrate a Dymo printer into my system. Here's a breakdown of the project: - **Integration**: I need the Dymo printer to work seamlessly with my Access 2013 database. The goal is to automatically print stock labels based on query results. This means you'll need to set up the system to take the query output and send it to the printer for label creation. - **Printing Specifics**: The labels I need printed are stock labels. The process should be automated, so the labels are generated and printed without manual intervention. The labels will be printed based on the results of a query in Access and some limited entry from the operator with such things as qty of labels and wh...
Having an integral project already in place, I'm in need of a skilled SQL Developer to contribute towards its further development. Specifically, the tasks I require assistance with include: - Query Optimization: Tailoring and enhancing the performance of our current queries is a significant aspect of this role. - Database Maintenance: Maintaining the overall health and efficiency of our SQL Server is also a necessity. Ideal candidate must have a comprehensive understanding of SQL Server, as well as notable expertise in query optimization and database maintenance. I prefer someone with a proven track record of successfully managing and enhancing existing projects. I look forward to seeing your bids.
I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.
...including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experience in designing visualization charts and custom query builders. - Strong analytical and data organizing skills. - Experience in converting independent Excel worksheets into a master file. - Knowledge in NDT industry would be beneficial but not paramount. The goal is to provide an automated and streamlined approach to handle inspection reports, making analysis and generation of summary statistics a bree...
Postgres data query system Docker across multiple servers
We are seeking a talented full stack developer to create a mobile application for a medical start up. The application will serve as a platform for patients to perform home based outdoors exercise, receive general information about their condition and communicate wit...and compatible with various devices and platforms - Conduct thorough testing and debugging to ensure high-quality and bug-free code Requirements: - Proven experience as a full stack developer - Familiarity with mobile application development, particularly in the medical industry - Strong programming skills in JavaScript, HTML, CSS, and relevant frameworks - Proficiency in database management and query optimization - Knowledge of RESTful APIs and best practices for integration - Excellent problem-solving and communicat...
Need a backend developer to implement bel...client's existing code base. 1. Feign clients 2. Request and the response interceptors 3. For opt in, only mobile number to be passed as param to the feign client's method - ("919999784665"); 3. For sending sms, only mobile number and msg to be passed as param to the feign client's method - ("919999784665", "Hey there I am using whatsapp"); 4. All other query params to be inserted via request interceptor 5. userid and password to be picked from yml file, they will be different for different environments. 6. For both the APIs we'll have response interceptors which will check if the 'id' given in 'response' corresponds to one of the error codes. If they do, then we...
I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.
I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS
There will be additional $50 for any who completes this project fully. The aim of this project is to compare three types of databases(Any relational database, mongoBD and Neo4J) in terms design approach, implementation, query composition, and performance. The data is about texas hold em poker game The stages of the project are 1. Look at the details of the data 2. Come up with an ER diagram and a relational schema for the data 3. Create a database in any relational db and tables 4. Create a python script to read the txt files and populate the db 5. Test the queries 6. Populate the other(mongodb and neo4j) databases and test the queries Then test the queries below on the databases QUERIES 1. Separate players by their style of play/Group players with a similar ...
Need a Windows program that logs into an account, allows the user to enter a 2FA code in a browser window, enters queries into a search from an input XLS file, and on output saves the search status for that query.
Se inicia un proceso sin fin que consume todos los recursos del servidor. Adjunto captura de la información que me brindaron desde el servidor. Mi objetivo es que mi web deje de caerse por excesivo consumo de recursos. A continuación, copio la query que genera el problema (ver captura para más información): SELECT SQL_CALC_FOUND_ROWS from vsnucam_posts left join vsnucam_term_relationships on ( = Vsnucam_term_relationships.object_id) left join vsnucam_term_relationships as tt1 on ( = tt1.object_id) left join vsnucam_term_relationships as tt2 on ( = tt2.object_id) left join vsnucam_term_relationships as tt3 on ( = tt3.object_id) left join vsnucam_term_relationships as tt4 on ( = tt4.object_id) where
...automated as much as possible. - It should have the capability to save both sent and received - The add-in should be efficient, ensuring that no emails are missed in the process - A simple yet effective interface that is easy to navigate and use is crucial The add in will: - query a SQL database and find clients linked to the sender/recipient and prompt the user to select the relevant client - Save a copy of that email to the relevant folder for the selected client - again based on a SQL query. The SQL query information can be provided to facilitate this. Ideal Skills and Experience: - Proven experience in developing Outlook add-ins. - Knowledge of Microsoft Outlook's functionality. - Strong attention to detail to ensure proper email categorizati...
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.
script for auto replying mail with attached files
This project is to develop a simple system that will help me manage following for my store, Inventory Sales Administration Inventory Inventory management and verification are the main reasons for developing this system. Each piece of inventory will be tagged with an asset barcode, so that I can track where each piece is and when it was sold at what price. Also need to be able to generate a barcode in a query and report. See Each week, inventory will be scanned, and a report generated to figure out variations between physical stock and what the system says. Inventory dashboard and reports like aging, velocity etc. Sales Should be able to create a customer from the sales order screen. Sales order will be created
I am currently looking to engage an experien...experienced Machine Learning professional for my project. I require analysis to be conducted on text data as well as numerical data. A strong understanding of Machine Learning concepts and analytical skills are vital. While I have not specified a particular focus area of Machine Learning, I am open to recommendations from the chosen freelancer based on the data provided. Key requirements include: - Proven track record in Machine Learning - Proven track record in Google Gemini and Google big Query ML - Proficient in data analysis and interpretation - Experience working with both text and numerical data Critical thinking and problem-solving skills with attention to detail will be necessary for the successful completion...
MS1: Solana Data INPUT: Solana contract address OUTPUT: (These may change in time. We are looking for only the snapshot at the time of the inquiry). 1. List of wallet addresses that have a non-zero balance of the input contract token AND no buy transaction for that token, at the time of the query. 2. Percentage of the total supply that these wallets under item 1 above hold collectively (%) 3. Percentage of the total supply under AMM (%) (Only Raydium is fine). 4. Mint authority info. - Must have: Mint authority revoked? (Yes / No) - Optional but great to have: Mint authority status (Permanently revoked, time-limited etc). 5. Liquidity info. - Must have: Percentage of the liquidity locked (%) - Must have: Liquidity burned? (Yes/No) - Optional but great to have: Liquidity lock autho...
...accuracy or integrity. WE WILL PROVIDE A PYTHON SCRIPT THAT CONTAINS MongoDB AGGREGATION PIPELINE Key Responsibilities: - Review and enhance the query performance - Optimize our large volume data handling - Analyze and understand the existing aggregation pipeline. - Identify potential bottlenecks and areas for optimization. - Implement efficient algorithms and techniques to enhance pipeline performance. - Ensure that the script returns data in less than 100 milliseconds. - Test and validate optimizations to ensure accuracy and reliability. - Document changes and provide recommendations for future enhancements. This project requires an expert with a deep understanding of manipulating and querying large datasets in a NoSQL environment. Requirements: Inte...
...functionality of the application. Key Responsibilities: - Identify the root cause of the pagination issue - Resolve the bug to ensure the pagination system functions correctly - Test the application thoroughly to verify that the issue has been fixed Ideal Skills and Experience: - Proficiency in PHP and Laravel framework - Prior experience with Laravel's built-in pagination - Strong knowledge of Query Builder - Ability to troubleshoot and debug complex issues - Excellent problem-solving and communication skills It's crucial that the freelancer I work with has a keen eye for detail and a track record of successfully resolving similar issues. The individual should also be comfortable with working in a fast-paced, deadline-driven environment. Here is a video that expla...
I need an SQL query to extract specific information from the Moodle database. The query should pull the name of the user, a list of activities they have completed, and the time they have spent on SCORM packages if they have interacted with any. Key requirements include: - Extracting user's name and completed activities. - Differentiating SCORM packages and calculating time spent on them. - Handling users with no completed activities by including them in the results with zero activity count. If you are familiar with PostgreSQL and Moodle database structure, and have experience writing efficient SQL queries, this project is for you. Your query should be optimized for general use, without specific version constraints. The ideal candidate for this task shoul...
We are starting a project to develop a QR code payment application called "Metropol Pay" that will run on the Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and informative, and the ne...
...the page should not lock up permanently or be flagged permanently with frequent use or fast refreshing of the page. INPUT: Solana contract address OUTPUT: (These may change in time. We are looking for only the snapshot at the time of the inquiry). 1. List of wallet addresses that have a non-zero balance of the input contract token AND no buy transaction for that token, at the time of the query. (This check intends to find out wallets with pre-mined tokens). Please have this list collapsed to item 2 below when the page first launches). 2. Percentage of the total supply that these wallets under item 1 above hold collectively (%) 3. Percentage of the total supply under AMM (%) (Only Raydium is fine). 4. Mint authority info. - Must have: Mint authority revoked? (Yes / No...
I am experiencing issues...database after moving the database file. After reconnecting the queries to the database, all but one tab of file updated okay. One tab is returning errors. The database is accessed through a desktop application. Key Requirements: - Resolve query errors in the database - Ensure the database functions properly within the desktop application - Investigate and fix any potential issues caused by moving the root file The ideal freelancer for this project should have: - Strong expertise in Microsoft Access - Proficiency in database management and query optimization - Experience in troubleshooting database errors - Ability to work with desktop applications Please include in your bid any relevant experience and your approach to troubleshooting a...
I'm seeking a proficient AI expert with the unique skill set in Generative AI and MongoDB. My goal is to automate the query generation process in my mongodb database radiating from chat inputs. WHAT TO DO: * Develop a Generative AI that will use chat inputs to automatically generate complex queries. * While we may have a gamut of queries, for now, we need all-encompassing technology that'll serve a broader purpose. I'm operating on a tight deadline, I need this project completed ASAP. If you're versed in AI and comfortable working with MongoDB, let's get in touch. I'm open to discussing any questions you might have about the project.
I am in need of a skilled developer who can create a real-time monitoring dashboard using MySQL. The dashboard will primarily be used for real-time monitoring. Key requirements: - Strong experience with MySQL: You should be proficient with MySQL and able to efficiently manage and query a large amount of data. - Dashboard development: You should have prior experience developing real-time monitoring dashboards. - Custom Date Range Report Generation: The dashboard should include the ability to generate custom date range reports. - Data visualization and real-time monitoring: Although the primary purpose of the dashboard is real-time monitoring, a good understanding of data visualization would be beneficial too. If you have prior experience with similar projects and are confident in y...
I'm seeking a dedicated person who knows data engineering and data ana...Experience with MS Fabric, specifically working with Lakehouses, Warehouse, SQL Endpoint, Data Flows, and Notebook - Proficiency with SQL Server, VBA, and SAS - Previous work with AI/ML algorithms - Exceptional knowledge of AWS services, including S3, Athena, and Glue - Familiarity with GCP storage and Big Query - Competence in using Power Query for data manipulation and transformation Your skills and experiences will play a crucial role in ensuring the successful delivery of this project, so please be sure to highlight your previous work history in similar projects and please send me you CVs and also please clearly state your price expectation and duration of work and also mention your avai...
...system to scrape data from the App Store. The system must collect information about apps based on specified search criteria, such as categories and keywords. References: 2. Main Functional Requirements 2.1 Scraping Features Category or Keyword Selection: Users should be able to choose a category or enter keywords to search for apps. Concurrent Query Execution: The system must support the simultaneous execution of multiple queries. Data Storage: Data on scraped apps must be stored for further access and analysis. 2.2 Data Management Viewing Scraped Data: Users can view a list of apps and detailed information about each app. Data Export: Capability to export data into a CSV file, including: App name App link Release date and last update Support
I need a refined and comprehensive database of the customers who submit a query on Car Dekho. My primary purpose is to conduct market research and analysis. Requirements: - The details I need are their full name and contact number. Please omit any other personal or private details. - This data should be provided in a CSV file format, which will be easy to import for various kinds of analysis. Ideal Candidate: - Expertise in data mining and extraction - Proven track record in collecting accurate, high-quality data - Familiarity with the automotive industry is a plus - Strict adherence to data privacy laws - Extensive experience with CSV files and data formatting.
I am struggling with a range of issues in my SQL database that are affecting my business operations. The primary challe...size of my database is substantial, significantly above 10GB, implying the need for a professional who can manage and improve large-capacity systems. The target areas for amelioration in the SQL database include: - Efficiency of the queries. - Table partitioning strategy. The ideal candidate should evidence expert skills and a successful track record in managing large SQL databases, improving query efficiency, and implementing effective table partitioning strategies. In-depth knowledge of comprehensive database performance tuning and optimization techniques, coupled with the ability to solve complex technical challenges like timeouts and deadlocks, is highly ...
I'm running a MySQL database and looking for an expert to help me optimize the query performance. Key responsibilities: - Analyzing the current database structure and configurations to identify areas that need optimization. - Implementing efficient indexing strategies and query tuning to enhance the query performance. - Providing insights and recommendations on how to maintain and keep the optimized database running smoothly. Ideal skills and experience: - Proven experience in MySQL database management and optimization. - Strong understanding of database performance metrics and monitoring tools. - Familiarity with indexing strategies and query tuning techniques. - Excellent problem-solving and analytical thinking capabilities. This role requires a profe...
Hi, We are looking for a developer to do the following tasks: 1. Index resumes in pinecone using langchain 2. Convert query from user into structured response in langchain. 3. Get responses from langchain and pinecone 4. Tank the resumes based on score 5. Test postman APIs for each of the above tasks. There will be two queries - one to fetch the relevant CVs and the other to rank a group of CVs. Ideally the score will be to use both one after the other and get ranked and relevant CVs. This can be written in Nodejs or python; we are okay with either. I will provide sample datasets and test with you. We are on a low budget for this - max - 1500-5000 inr. we want to work with individuals who are keen to learn and do this for the learning and not much for commercial gain. This woul...
I'm seeking an experienced WordPress developer with a specialty in MySQL databases to help me with optimizing query speeds. This personal project requires proficiency in both SQL database handling and WordPress development. Key responsibilities: - Analyzing my WordPress site's interaction with the MySQL database. - Tweaking and fine-tuning to enhance query speeds. - Testing and confirming the increase in performance. Skills and Experience: - Detailed knowledge of MySQL databases. - Extensive experience with WordPress development and optimization. - Proficiency in writing efficient SQL queries. - Ability to diagnose and optimize databases for better speed performance. This project offers the opportunity to showcase your skills in SQL optimization, wh...
I need a proficient Apache Airflow and SQL consultant to provide expert-level support, specifically focused on complex query formation. - Specific Project Tasks - Implementing Apache Airflow - Creating complex SQL queries - Handling financial transaction data The ideal collaborator should have: - Proven experience working with Apache Airflow - Proficient in SQL, with an emphasis on generating complex queries - Prior experience managing financial transaction data is highly desirable. The objective is to streamline the handling, management, and processing of large volumes of financial transaction data, ensuring efficient and accurate results.
...IS YOUR BUDGET". YOUR BID AMOUNT SHOULD BE THE AMOUNT YOU INTEND TO DO THE WORK FOR. PLEASE READ THE PROJECT DESCRIPTION COMPLETELY BEFORE BIDDING TO ENSURE YOU UNDESTAND THE TASK. *** Source files and API documentation will be provided when selected. I'm looking for a skilled PHP developer who can help me integrate a new functionality into my existing PHP application. Key Requirements: - The task involves enhancing a synchronization system with an external API. Ideal Skills: - Proficient in PHP programming - Experience with API integration - Familiarity with data synchronization techniques We designed a custom WordPress plugin to integrate with our supplier API to automatically query products in our WooCommerce database and update pricing for those items ...
I'm looking for a WordPress developer to create 2 custom pages First one will display a comparison table of school listings, more than 2k listings Key Details: - The page will require coding for a custom comparison form that displays a table for each query. - The comparison table should include listing details - the comparison table will include filters Second one is a statistic page that will show graphs based on filters choose by user, and will be based on listings Ideal Skills and Experience: - Proficient in WordPress development, with experience creating custom pages and forms. - Strong understanding of PHP, HTML, CSS and JavaScript for the coding of the comparison form. - Familiarity with mylisting theme Please bid with your final price. No placeholders. Please make ...
Assistance required to generate the Teams Call Queue reports into PowerBI. Sync between Teams Call Queues and PowerBI. Daily Usage reports required. Refresh and query data on the reporting side. If required, a test Call Queue will be made available for this exercise. Please only reply if you have worked on similar tasks. No time wasters please.
I am looking for a developer with strong knowledge in Node.js Express, PostgreSQL, and ES6. Specifically, I need assistance with the conversion and enhancement of my existing project to ES6 modules in order to improve code readability and maintainability. Specific tasks include: - Updating the routing and middleware for cleaner, clearer understanding. - Refining error handling and logging process to ensure consistence and easy debugging. Having a keen eye for detail and a thorough understanding of modern JavaScript features is fundamental for this role. This query requires a trustworthy and skilled professional to maintain the code’s performance and scalability. A deep understanding of Node.js Express and ES6 modules is essential for this enhancement task to also read...
I'm working with an older PHP project and need help with displaying data in a tabular format. Key Requirements: - Utilize PHP to print data in a tabular form on the presentation layer - No template system in place, so direct PHP manipulation needed - Experience with displaying database query results is a must This project involves integrating the existing PHP system with a tabular presentation layer. Knowledge of older PHP frameworks is an advantage, as well as familiarity with handling database query results. A pragmatic and efficient approach is key to ensure a smooth integration.
I am looking for a developer with strong knowledge in Node.js Express, PostgreSQL, and ES6. Specifically, I need assistance with the conversion and enhancement of my existing project to ES6 modules in order to improve code readability and maintainability. Specific tasks include: - Updating the routing and middleware for cleaner, clearer understanding. - Refining error handling and logging process to ensure consistence and easy debugging. Having a keen eye for detail and a thorough understanding of modern JavaScript features is fundamental for this role. This query requires a trustworthy and skilled professional to maintain the code’s performance and scalability. A deep understanding of Node.js Express and ES6 modules is essential for this enhancement task to also read...
...forecasts. So, if you’ve always wanted to play with weather data, this is your chance. Or maybe you have a school project that is a good match for this project. You can do anything that you want with your project as long as it uses our weather data, you release the code as opensource, and put it on a public code repository such as GitHub. How it works: 1. Take a look at our Weather API - 2. Come up with your weather project idea. 3. Reply to this offer with a brief description of your project (1 paragraph is fine) and a $150 bid. 4. We plan to accept many projects, so your idea has an excellent chance. 5. If we accept your project, we will create a $150 Milestone for you. 6. You will then write your code and make sure that it runs. A...
I need a developer who is well versed with MySQL. I have a database server that has thousands of databases. I need a query that will print the name of all the databases where a specific table has a specific row. For example, consider attached sql script. It creates 5 small dbs, I need a query that will print the names of DB where in sales_target table, there is a row where key=Q1 and value=100
I'm in need of an SQL query that can pull specific information from our SAP B1 database. The query will need to return Serial Numbers for the transactions in Sheet 1 of AR Invoices, AR Credit Notes and Sheet 2 AP Invoices, and AP Credit Notes, all filtered by Transaction Date. Key Requirements: - The query should return the following fields: Document Number, Transaction Date, CardCode, CardName, Item Code, Item Description and Serial Number. - The data should be filtered specifically by Transaction Date. - Transactions types to be included are AR Invoices, AR Credit Notes, AP Invoices, and AP Credit Notes. - Should not return duplicate serial numbers per Transaction type Ideal skills for this project: - Strong experience with SQL, particularly in the cont...
I need a proficient .NET developer who can handle the backend development and database management of my project. Key Requirements: - Proficient in C# for backend development. - Proficient in SQL for database management. - Experience with SQL Server database management system. Additional Information: - The focus is on the efficiency and reliability of the backend processes. - The database management will include schema design, query optimization, and ensuring data integrity. Please include relevant experience in your bid.
