Sqlite query graph jobs
I need someone who is proficient in web development to help with passing query parameter string into the SEO title page in a dynamic manner. For example, this is the URL of the framer pager I would like help with: However, when I pass the URL into to check if the query parameter is being passed in the SEO title, it fails and doesn't update. I would like a Framer expert who is also proficient in coding to help me with this project.
I'm in need of an expert server administrator with exte...Your role would be to assess the current setup, make necessary adjustments and ensure that the server is running optimally. - Troubleshooting: The primary issue I'm experiencing is a DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#' (Errcode: 2), query was: DESCRIBE `sessions`. Your expertise in diagnosing and resolving such issues will be crucial. Skills and Experience Required: - Proven experience in Plesk server administration, particularly in configuring and optimizing servers. - Strong troubleshooting abilities, particularly in resolving database query failures. - Ideally, experience in identifying and resolving security vulnerabilities and ...
...from 1) obtained using algorithms: greedy (the vertex order according to its number) LF method (ties are solved by the vertex number) SLF method (ties are solved by highest vertex degree, and if there is still a tie choose the vertex with the lowest number) the number of different C4 subgraphs the number of the graph complement's edges Input In the first line there's a number k of graphs. The following lines contain k graph data sets. A single data set contains a number n - the graph order - and n lists of neighbours for each vertex. A list contains the number of neighbours (s) and s neighbours IDs. Neighbours IDs are numbers from 1 to n. Output You should print k sets of responses. Each set should contain the designated parameters in the order in which...
I'm looking for a custom add-on for Perfex CRM. The add-on shall generate a graph that can be filtered by personnel and date. Key requirements include: - Display data: The graph should show the number of opportunities. - Chart style: The preferred style is a line chart. - Filtering: The graph should be filtered based on selected personnel and date ranges. Ideal skills for this project include familiarity with Perfex CRM, strong PHP and MySQL experience, as well as an understanding of charting libraries for graph representation. A professional who can work efficiently and deliver a user-friendly, visually appealing solution will be highly appreciated. There is a ready-made page similar to our needs in Perfex CRM. I just want it to be converted into a plugi...
...with customer data specifically. Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a major plus. Proficiency in using data visualization tools like Tableau would also be beneficial in conveying the results of the database analysis. The ultimate goal of this project is to use data effectively to inform business decisions regarding our customer base. If you find you have these ...
### Query: I'm looking to create a WebAR experience without incurring expensive monthly costs. Could you suggest some cost-effective solutions and the necessary requirements for implementation? ### Requirements: 1. **Open-source Libraries**: - ****: - Technology: JavaScript - Compatibility: WebXR, WebRTC - Cost: Free - **MindAR**: - Technology: JavaScript - Functionality: Marker-based AR - Cost: Free 2. **Frameworks**: - **A-Frame**: - Integration: - Cost: Free - Technology: Web-based framework 3. **Combination Solutions**: - ** with WebXR**: - Technology: JavaScript - Functionality: 3D graphics rendering, AR integration - Cost: Free 4. **Commercial Platforms
I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.
I have a Microsoft Excel assignment that needs expert handling. My needs include: - Data analysis: I want to make sense of my data, and uncover any hidden trends or correlations. - Formula creation: I require the creation of Excel formulas to automate data processing tas...to automate data processing tasks. - Graphs and charts: I need insightful visuals to represent my data. This will aid me in understanding and communicating it more effectively. While it's unfortunate I could not provide more detailed information, it's vital that the freelancer can work with a certain degree of ambiguity. Expertise in Excel-based data analysis, formula creation, and chart and graph creation are essential. An ability to uncover data insights, no matter how small the dataset, will b...
...meaningful by adjusting the bin size so you can see the shape of the histogram. Write several sentences explaining the process/steps by which you created this graph. -Create a histogram of the stock trading volume (in the column labeled "Volume"). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write several sentences explaining the process/steps by which you created each graph. -Complete the following for each of the four graphs: Make sure the x and y axis have appropriate labels—“Stock Price in USD” or “Date D/M/Y” for example. Change the title of the graph to communicated what the graph is communicating. Add options—color, trendlines, legend, other? Cal...
The website is already programmed ...it is necessary to simply create a second level of subcategories and the client cannot publish in subcategory level 2 only in level 3. The following is necessary: 1st. Create a second subcategory level linked to another subcategory. 2nd. In that second level of subcategory, at the top there appears an image of the category, a descriptive text and a graph that shows the evolution by month and year of the price from lowest to highest. That graph will take the price data of the ads in the subcategory. 3rd. Add an option to add a shipping cost to the products. 4th. There is already a search in the subcategories but we also want to put it on the front page of the website and show the results classified by main category, subcategory 1 and f...
...heavy loads, leading to frequent hangs and disruptions in our operations. To address this critical situation, we are seeking the expertise of an experienced Oracle Advanced DBA freelancer. We require a professional with the following qualifications and skills: - Extensive experience in Oracle Database Administration, particularly in high-load environments - Proficiency in performance tuning, query optimization, and troubleshooting - Familiarity with Oracle Enterprise Manager and other monitoring tools like aws performance insights The main responsibilities will include: - Diagnosing and resolving performance issues - Implementing best practices for database management and optimization - Ensuring high availability and reliability of the database - Providing recommendations f...
...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 necessary feedback will be given to the user during the payment and return processes. In addition, a simple test application ...
...accessible to admins and will be used to gauge user preferences and activity. * Incorporating real-time notifications. This functionality should alert users of new content, primarily new music uploads. An essential part of this project is the local storage and streaming of music files. These files need to be stored on our server and not sourced from external resources. They should be stored on a local sqlite database. Ideal candidates should have experience working with ASP.NET MVC, building user registration systems, implementing real-time notifications, and most importantly, handling local storage and streaming of multimedia files, preferably music. A robust understanding of data analytics and how to track user interaction is a plus. I have already started on the project and...
I'm in need of a developer proficient in Python who can create a video tutorial. The tutorial should showcase the process of building a user authentication login page for a web application using the Microsoft Graph API. The loging should just allow pre-registered users (from azure dashboard) to enter the app. Ideally the should build a little login page using streamlit! Key Requirements: - Expertise in Python: Comprehensive proficiency in Python is a must, as the tutorial is centered around this language. - Familiarity with Microsoft Graph API: The ability to leverage the Microsoft Graph API for user authentication is essential. - Video Creation: While I'm not looking for a professional video maker, the candidate should be able to record, edit, and produce...
I'm in need of a developer proficient in Python who can create a video tutorial. The tutorial should showcase the process of building a user authentication login page for a web application using the Microsoft Graph API. The loging should just allow pre-registered users (from azure dashboard) to enter the app. Ideally the should build a little login page using streamlit! Key Requirements: - Expertise in Python: Comprehensive proficiency in Python is a must, as the tutorial is centered around this language. - Familiarity with Microsoft Graph API: The ability to leverage the Microsoft Graph API for user authentication is essential. - Video Creation: While I'm not looking for a professional video maker, the candidate should be able to record, edit, and produce...
I'm looking for a design professional skilled in creating memorable logos...incorporate additional colors only if they blend well and look professional. The blue from the website is hex #087E8B The while from the website is #F7F7F9 - Style: The logo should have a modern look, steering away from traditional designs. The text on our website for headings is 'Nimbus Sans Extended' & the text is 'NEUE HAAS UNICA - Optional Symbolism: You could incorporate an upwards arrow or graph as a key element in the design to depict growth and progress. This element should be subtle yet explicit in its representation. We are open to seeing other symbols or none. Our website is: Please use this to get a feel of the existing branding, colours & approach of the busine...
I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and changes over time. Previous e...
As a tax accounting firm, we need a modern and minimalist brochure/front page template created on Canva. This design will be a vital part of our client communications, underlining our commitment to transparency and professional service. Key Features: - The template needs to have individual fields for 'Client Name', 'Financial Summary', and 'Tax Advice Tips' & a 'performance graph'. - The design should embody a modern and minimalist aesthetic, reflecting our firm's expertise and reliable standing. - We would want the content creator to assist in creating the content. Then we would want generic fields or a pivot table to input data that then flows to the brochure/template. So that each client receives a personalised brochure. I...
I'm looking for an experienced WHMCS developer to help improve an already developed financial history graph. I had a developer from before that told me he could improve the module by take order dates and other dates already in the database to fill in missing data of the graph. Right now the graph just records order and financial information in the database and displays it on the graph. Where there is no data the graph just shows a straight line as shown in the demo screenshot. So I want the graph to show the data that its table is missing by getting this information from the WHMCS database. The end result would fill in the missing data of the straight line and also show the history on the graph from the start of the database, right now ...
Simple application with database under hood Really, I have a first implementation. It's an app for foreign words learning with chat form and ChatGPT support Now I have * UI based on widgets * SQLite database * ChatGPT API functionality I use some flutter extensions. I'd like to finish the app during 3 weeks. I need some improvements and new functionality: * Working vocabulary * Logic for right calculation of time for words' repetition
I'm looking for a knowledgeable individual in the field of Mathematics, specifically Graph Theory, who can efficiently and accurately rewrite my research. The primary goal here is to create a fresh version with distinct wording while preserving the important findings and messages. The main section requiring your expertise is the Methodology. I expect a comprehension of mathematical concepts and a strong proficiency in interpreting and rewriting complex research methodologies in a clear, engaging manner. Key Skills & Experience: - Proficient in English - Mathematics, specifically Graph Theory - Exceptional writing and editing skills - Experience in research re-writing. - Solid understanding of research methodologies. Please only bid if you can demonstrate your cap...
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)
...Scan for Bluetooth beacons (iBeacon and Eddystone types). - Track the user's GPS position. - Each time a beacon message is detected, if there is connectivity, send a JSON message to a registration API (which I will provide) containing: detected beacon UUID, major, minor, RSSI, GPS latitude/longitude, and detection timestamp. - If there is no connectivity, the message should be saved locally (in SQLite). - If there is connectivity and there are messages in the local database, retrieve them, send them to the API, and delete them from the database. Permissions ----------------------- The app should request the necessary permissions to: - Scan for Bluetooth beacons. - Access GPS location. - Create and manage a local database. - Make API requests. - Create the Foreground servi...
I have a substantial Excel table and I am in need of a skilled data analyst to help with correlati...analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to enhancing my project. Looking forward to se...
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.
...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 identifying and fixing bugs and security issues. Experience with API development and integration. Ability to work with the existing database structure without alterations. Good communication skills and ability to provide regular updates. Deliverables: Fully upgraded CodeIgniter 4 project with all features and functionalities working as expected. Optimize...
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...
Flutter version: 3.22 We want to add our own Sqlite database to assets: assets/ name of table: kids Database included id – name – surname I can send my database. We need a file () that shows database information after clicking a button.
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.
I'm seeking a disciplined developer to convert my current WordPress website into a headless CMS with a frontend, giving it a new minimalist aesthetic. The intended functionalities include: - A contact form ...login functionality - Incorporation of JavaScript graphs The new design should exhibit a sense of clarity and simplicity, aligning with a minimalist approach. Please note, the frontend should also be responsive but optimized for tablets specifically. Ideal skills and experience: - Proven experience with WordPress and - Exceptional understanding of JavaScript, particularly JavaScript graph libraries - Astute UI/UX design skills with a minimalist preference - Good knowledge of responsive design, specifically for tablets. Looking forward to your promising proposals...
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...
...Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application Development Additional Notes: a. application will need to determine which template to use based on a query b. Must be able to create, edit templates in an easy wysiwyg way. c. naming convention based on db record. d. Ability to add an option password to the PDF required. e. The resulting PDF must be stored in up to 2 locations (one maybe a unc path with username and password required) f. must be able to use multipl...
I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused
The work will be done based on using segmentation and graph cut network
I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.
...file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weigh...
I'm seeking a skilled Node.js backend developer with expertise in real-time applications and , for a project with chat and graph features. Requirements: - Develop a robust backend in Node.js - Implement real-time chat functionality - Handle graph visualization using Ideal candidate should have: - Proven experience in Node.js backend development - Strong understanding of real-time applications - Previous work with - Proficiency in data visualization, specifically graph data structures Please note that this project requires an expert who can deliver efficient, scalable, and secure code.
...in need of a wireframe design for a front-end dashboard tailored for school teachers. This dashboard will have a range of essential features, driving a seamless user experience for educators. Requirements: - Incorporate attendance tracking, grade management, and lesson planning functionalities - Develop a graphical design that displays the daily and weekly progress of each student in a bar graph format - Each student's picture should be displayed as a profile icon next to their name on the screens - A base design with each lesson (math, science, reading, history), and all the data is linked via Chatgpt (GPT) backend process with an API - Detailed customizable report generation process Ideal Skills and Experience: - Proven experience in UI/UX design, particularly wi...
..."International Chinese Education Demand Monitoring, Prediction and Countermeasures Research based on Big Data", and create a website that can query the real-time popularity of Chinese learning language in all countries, the following is a website layout and function plan: ### Web Site name: Global Chinese Learning monitoring platform ### Website Layout: 1. * * Home page * * -Top navigation bar: contains the site name, search box, and user login / registration options. -Global map: 1. Identify the popularity of Chinese learning in different colors.2, Click each country, can feedback heat data, etc., you can jump to the second plate 2. * * National heat query * * -List of countries: arranged alphabetically for user search. -Search function: enter the name of the c...
I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?
Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.
I am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS
I'm in need of an expert to assist me with hosting my custom Laravel project on my Plesk panel. Key Tasks: - Setting up the Laravel project on my existing Plesk server - Ensuring that the server environment is compatible with a custom application - Make the project work in the panel exactly as it is running in my local machine - Configure SQlite also Ideal Skills: - Proficient in Laravel framework - Experience with Plesk panel setup - Ability to troubleshoot server-related issues - Knowledge of PHP extensions and versions Your expertise in Laravel and server management will be crucial for this project. Please include any previous similar projects you've worked on in your proposal.
...programming abilities Tasks: - Develop the User Interface: Design a user-friendly interface using SwiftUI. Implement UI components such as progress bars, buttons, and status indicators. - Implement Core Functionalities: Use Alamofire for handling firmware downloads. Utilize libimobiledevice for interacting with iOS devices to enter recovery mode, DFU mode, and perform restores. Use Core Data or SQLite for storing downloaded firmware files and application data. - Integrate Reactive Programming: Use Combine to manage asynchronous tasks and data binding. Update UI elements in real-time based on data changes and user interactions. - Leverage Machine Learning: Implement Core ML models to predict device issues and suggest solutions. Use NLP to develop an AI-powered assistant for us...
...a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices" by writing a query in a cell. For example, in cell A1, I should be able to write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriat...
I'm looking for a skilled developer to update...controllers in my Laravel backend for my React Native application. Specifically, I need help with a single task to start, and if that goes well will task additional items thereafter: 1. Laravel Backend has a 'ProviderController' which sends 'Provider' results to app based on distance within radius. There is a 'Mobile Only' option that when checked is not limiting results to within that radius. The query is a bit messy, but is likely where the change needs to be made (see attached). App is published to TestFlight already and should not need to modify React Native source to address this, but can provide if needed. Ideally looking for a developer who can fix this bug fairly quickly, then will have on...
