Firestore query example jobs

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

"Seeking experienced developers for an innovative AR-based social media and dating app called NEAR. We need: Flutter Developer: Build cross-platform front-end using Flutter Integrate AR components from Unity Implement user interfaces and interactions Firebase Developer: Set up and manage Firebase for the app Implement Firebase Authentication, Cloud Firestore, Cloud Storage Integrate Firebase services with Node.js backend The app combines AR, social media, and dating aspects for Gen Z and millennials. Experience with cross-platform development, AR integration, and building scalable backends is a plus. Passionate developers interested in working on cutting-edge technologies are encouraged to apply."

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

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

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

...Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in 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 t...

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

...with these tools to be fairly self-directed once given access. My web/marketing manager can give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that th...

I'm seeking a skilled data architect for providing consultation and recommendations on a Statement of Work (SOW) that involves data warehousing, ad hoc reporting, complex SQL format...recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills, including complex query formation - Familiarity with streamlining and enhancing data storage - Experience in supporting monthly data integrations Your insights and guidance in this project are crucial for our lon...

...with these tools to be fairly self-directed once given access. My web/marketing manager can give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that th...

...developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  Optimize database performance through indexing, query optimization, and other performance tuning techniques.  Develop and enforce data standards and best practices to ensure data integrity and security.  Provide technical guidance and mentorship to junior developers.  Troubleshoot database issues and provide timely resolution.  Stay up-to-date with the latest trends and technologies in database management and architecture. Ski...

...experienced course creator to develop a comprehensive video tutorial focused on Microsoft Power Query. Key Features: - User-friendly interface - Capabilities to import data from various sources - Customizable course structure The ideal candidate should have the ability to break down complex concepts and make them easily understandable. The course content should cater to beginners and intermediate level learners. Course Duration: Each video course module should be crafted with the target of a total duration amounting to 3-4 hours. This could be composed of several shorter lessons or modules, for easy consumption and better learning experience. Required Skills: - Strong knowledge of Microsoft Power Query - Proven experience in creating video courses - Excellent communi...

...facilitate data literacy within the organization. Continuous Improvement: Stay updated with the latest Power BI features and healthcare industry trends. Continuously seek ways to improve reporting processes and tools. Qualifications: Proven experience as a Power BI Specialist, preferably in the healthcare industry. Strong proficiency in Microsoft Power BI, including DAX and Power Query. Experience with healthcare data and understanding of healthcare metrics and terminology. Excellent analytical and problem-solving skills. Strong communication skills, with the ability to explain complex data concepts to non-technical stakeholders. Experience with data integration from various sources such as EHR systems, practice management software, and patient feedb...

I'm searching for a proficient Go coder to develop a software application tailored for the Linux platform. Key requirements include: - Proficiency in the Go programming language - Proven experience in s...requirements include: - Proficiency in the Go programming language - Proven experience in software development - Keen understanding of the Linux operating system - Network programming - Geneve encapsulation - CoreDNS development Looking for Go programmers with strong networking background to write a DNS handler plugin for CoreDNS which can receive Geneve packet from client, decap the underlying DNS query in UDP or TCP or DoH preform DNS resolution as normal through the built in forward plugin. On the response side the plugin must be able to encap back to Geneve and res...

I need a concise and informative PowerPoint presentation done on the Disabled Facilities Grant (DFG) in the UK. This will be presented in PPT and should run for 8 minutes, no AI: MAIN QUERY OF TASK: "The DFG team currently has a large backlog of cases, both children and adults, that need to be dealt with and processed promptly and efficiently. We will be undertaking a process review to enable us to achieve eliminate the backlog. What suggestion would you have to update the process, and the service, ensure HBC compliance, and ultimately customer satisfaction? Key Task: - Conduct Research: The main focus of this presentation will be the process review of the DFG application process in the UK. The ideal candidate should have a strong background in thorough research and experienc...

I am in need of an expert React Native developer to upgrade my existing app running v0.59.9 and bring it up to date with the latest version of React Native v7.0+ In addition to the platform upgrade also need to: - Upgrade Facebook SDK for FB login to continue working - Adjust query in 'My Activities' to only show activities created in the past, while 'Latest Activities' should only show future activities from all users within radius Skills and Experience: - Proficient in React Native - Experienced in upgrading apps to support multiple platforms - Familiar with the latest version of React Native

We using o365, copilot studio, Azure ai applied. We need to create a chatbot in teams and webpage using copilot studio which can be use azure ai feature and able to seach the internal SharePoint site documents. 1,Azure ai chat bot(suppot continue query), 2,documents lookup and learning from SharePoint documents, 3,can be acces from website (sso login required), 4,can integrate in team chatbot

Perfect english is needed. You need to be able to teach and tutor me in relational data bases and sql. You must...answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The complexity level of the project is intermediate, focusing on tasks like joins and subqueries. Ideal candidates will have: - Extensive experience with MySQL databases - Strong SQL querying, schema design and query optimization skills - Proficiency in working with relational databases - Experience in databa...

App Developers Query - Template Hi, We're currently seeking a talented app developer who shares our vision and passion for creating a platform helping users improve productivity to achieve their hobbies. If you have experience in start up app development and interested in collaborating with us bringing Hobbi to life, we would love to hear from you! About Hobbi: Hobbi's an innovative solution designed to assist time management enabling maximum productivity to achieve desired goals of hobbies. Our app aims to revolutionise the way our customers interact with their hobbies and self-development. We believe that there is a gap in the market for a comprehensive, user-friendly application that offers a way of planning, tracking and sharing achievements of your hobbies. Key Fe...

...for the pre and post development area for the roof of 205sqm. 3. Please include calculations demonstrating how the stormwater discharge will be restricted to pre development rates for the 205sqm. Note: The pre development roof area of the existing building is 90sqm pre renovation Engineering for the area has been submitted and was thought to be finalised though they came back with the further query above. Happy to supply all existing calculations and stormwater management plans Thanks for your help!...

A. give users interfaces that would allow them to do the following: 1. Build unlimited number of customized questionnaires, by adding all common form elements, plus Conditional fields. 2 build unlimited customized search/ query screens by adding same common form elements as their questionnaire. 3. Build customized output/ report screens to present search results. B. All of the above are build on a 100% normalized MySql database, which will become the centralized database for all future data collection, search, and report generation for third party or custom made plugins/apps.

...APIs, web scraping, and web page reengineering processes to extract information and structure it in the expected format. The system should generate a record of each query made, indicating whether results were obtained, no results were obtained, or if the source was not available. A document detailing all the sources of information from which data should be extracted will be provided. Main Features: 1. Automatic Querying of External Sources: Perform queries to multiple external sources according to the provided specifications. 2. Data Structuring: Process the obtained information and structure it in the required format. 3. Query Log Generation: Create a detailed log of all queries made and their results. 4. Response Handling: Identify and record whether results were obtain...

AI Chatbot Saas of existing with only rebranding (colors, logos, fonts etc.) The existing can be found at 7 Days support included after delivery for any query . Duration 5-7 days.

This project focuses on configuring an existing high-performance computer to process and query large datasets using the Llama3 (70b) language model. The objective is to enable efficient data handling and querying capabilities on the local system. Configure the existing computer with the following specifications for optimal performance: CPU: Intel Core i7-12700F GPU: Nvidia RTX 3070 Memory: 32GB DDR5 RAM Storage: 1TB SSD Operating System: Windows 11 or Linux Set up and optimize the Llama3 (70b) language model on the local system. Process 2,300MB of data to be optimized for use with the Llama3 model. Develop a user interface or command line utility to facilitate local data queries using the Llama3 model. Deliverables: Con...

things to be include in that - Register and login option with forget password and reset password with sendinblue email integration - After login redirect to dashboard (empty page, only need to show user name) - If user open login page a...email integration - After login redirect to dashboard (empty page, only need to show user name) - If user open login page and he already login must be redirect to dashboard and wise versa - Profile page -> with image upload Needed basic UI for frontend, we will use boostrap, no other UI lib with mysql must use with proper middleware must be secure way of write the database query need to create from scatch, do not use any ready made template No un-necceeory plugin install Auth must be handle is proper, if requires use redux, no context

we can do a task in different ways: I want to extract text from images with but I have a vulnerability error code which concerns , firestore and others I don't see any report but that's it for me prevents us from going further to remove these vulnerabilities? or maybe a multimodal llm (I used the most famous one and had very good results) but I would like an open source llm (I use lm studio but I am open to other suggestions) rather specialized in this task who can offer me this rare gem and/or who implemented this type of solution?

I need a minimal flutter example app for android. The app must scan Bluetooth Ibeacons. I do not need a complete UI, simply a button to start scan and another to stop scan. The information obtained from beacons can be showed in a textbox. The monitoring of beacons mut be "Ranging" (each transmition of beacon must be received and showed) Is very important the scan continue in background. When the app is minimized or out of focus, the app must launch a foreground service (or the foregrounn service can be allways active on all the life of app) when te foreground service is running, a permanent notification must be showed (android policy to allow foreground service). The app must request all permitions required to user on start. When the app is minimized, and the foreground...

...structures. ......" ] } 1 1 (b) s2/s2 : All the 100 queries. Each query has 2 fields: i. qid: The unique id of the query ii. query: The text of the query Some query entries from the file are: { "qid": "1", "query": "deep learning" }, { "qid": "2", "query": "artificial intelligence" }, { "qid": "3", "query": "information retrieval" }, . . . (c) s2/: The relevance values of research papers for each query is given in this file. The columns are: i. qid: id of the query for which the relevance value is marked ii. docno: document id of the research paper for which the relevance is marked iii. relevanc...

I'm in need of a skilled FlutterFlow developer to create a web application that can generate PDF reports from documents stored in Firestore. Key Requirements: - Platform: FlutterFlow inside an already existing app. - PDF Customization: The reports need to have a moderate level of customization with specific layouts. - Generation Frequency: The reports should be generated within the app on-demand by the user. Skills and Experience: - Proficiency in integrating Firestore as a database for document retrieval. - Prior experience in creating PDF generators from specific document layouts. - Understanding of user-triggered, on-demand report generation. - Knowledge of building Custom Functions or Actions within FlutterFlow. - Ability to advise on the best implementation stra...

Google big query - for writing sql queries for the complex data

...Lite model for short video recommendations in a Flutter app, using Firebase Firestore as the database and Firebase ML for deployment. # Requirements:* 1. Recommend videos based on user's liked videos, excluding watched videos. 2. Include popular content to prevent user from getting stuck on the same topic. 3. Use Firebase Firestore to store video data and user interactions. # Workflow: 1. Fetch video data and user interactions from Firestore. 2. Calculate similarity scores between liked videos and remaining videos. 3. Include popular content in recommendations. 4. Train and deploy the model using Firebase ML. # Deliverables: 1. TensorFlow Lite model for video recommendations. 2. Integration with Firebase Firestore and Firebase ML. 3. Documentation on ...

...skilled freelancer who can develop an AI-based search engine tailored towards the customers and employees use for a company. The key features required for this project include: -Natural language processing: Understanding and interpreting human language effectively is crucial. -Relevance ranking: The system should be capable of ranking search results based on their relevance to the search query. -Personalized recommendations: The ultimate goal is to personalize user experience, thus the engine should be capable of generating recommendations based on user behavior and preferences. In terms of data sourcing, the AI engine should primarily draw information from databases. A background in data mining and database management would therefore be advantageous. Proven experien...

I am looking for an experienced Python developer to create a scraper for Lazada. The ideal candidate must be skilled in web scraping and should reverse engineer API from mobile app because lazada blocks and throws captcha on web website is lazada . The script should work like i enter something in search box and it should scrape all the products from that search query Key Responsibilities: - Extract the following information: product names, prices, descriptions, stock, images, seller information, and product URLs. This list encapsulates the attributes you need to pay the most attention to. - Organizing the scraped data: The data, once scraped, must be organized in a well-structured CSV file. Ideal Skills: - Strong experience with Python. - Proficiency in web scraping tools. -...

we can do a task in different ways: I want to extract text from images with but I have a vulnerability error code which concerns , firestore and others I don't see any report but that's it for me prevents us from going further to remove these vulnerabilities? or maybe a multimodal llm (I used the most famous one and had very good results) but I would like an open source llm (I use lm studio but I am open to other suggestions) rather specialized in this task who can offer me this rare gem and/or who implemented this type of solution?

...cost efficiency, laying the groundwork for more advanced features in later phases. The app leverages the MarketCheck API for automotive data and employs AI technologies to enhance the car buying experience. == Requirements *Must-Have (MoSCoW Method)* - Continue development off an existing FlutterFlow project with provided screenshots. - Efficient data handling and querying in Firebase Firestore with required indexing. - Integration with MarketCheck API for real-time automotive data.() - Utilization of pre-trained AI models with contextual awareness, similar to SalesGPT or CrewAi (search Github). - build tools for AI agents so they can utilize Voice, Email and update CRM. (i.e. for voice) - If possible, use GoHighLevel to provide back office operations for

...Standardization: Perform equivalences to standardize information received from APIs. 4. Simultaneous Search in Multiple APIs: Activate search across all configured and active APIs with clear indicators of success or error. 5. Results Visualization: Display results in a table viewer for easy comprehension. 6. Temporary Data Storage: Save information in memory and delete it when performing a new query. Technical Requirements: 1. Experience in frontend development with AngularJS to create interactive interfaces. 2. Proficiency in backend development with Java or Python for handling API requests. 3. Ability to implement temporary storage systems in memory or cache for sensitive data. 4. Capability to create files for automatic deployment in Lambda functions, Docker containers, or a...

...Standardization: Perform equivalences to standardize information received from APIs. 4. Simultaneous Search in Multiple APIs: Activate search across all configured and active APIs with clear indicators of success or error. 5. Results Visualization: Display results in a table viewer for easy comprehension. 6. Temporary Data Storage: Save information in memory and delete it when performing a new query. Technical Requirements: 1. Experience in frontend development with AngularJS to create interactive interfaces. 2. Proficiency in backend development with Java or Python for handling API requests. 3. Ability to implement temporary storage systems in memory or cache for sensitive data. 4. Capability to create files for automatic deployment in Lambda functions, Docker containers, or a...

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.

I'm looking for a skilled software engineer. THis task is too large for excel power query, however i want it to operate in a similar fashion. The main purpose of this project is to develop a self-updating database of every racehorse in the state of NSW, Australia, via the website. Key tasks and responsibilities: - Determining the best platform for the software (Web-based/Desktop-based/Mobile application). - Creating a software solution that will automatically update and manage a database of racehorses. Skills and Experience: - Proficiency in at least one high-level programming language i.e., Java, Python, C++ - Experience with automation software - Familiarity with database management - Ability to recommend best software platform based on project requirements. Thanks :

...handle real-time data processing and CRM updates based on interactions within the app. Tasks: 1. Advanced Voice and Text Search Integration: • Enhance the app with both voice-to-text and text-to-speech functionalities for seamless user interaction. • Implement AI-driven prompts to help refine and perfect property searches based on user input. 2. MongoDB Integration: • Develop backend logic to query MongoDB effectively with parameters derived from GPT-processed queries. • Ensure real-time data fetching and updating capabilities. 3. CRM Integration: • Automatically populate CRM systems with details from interactions (both text and voice) conducted via the app. • Ensure data consistency and accuracy for effective client management. 4. Testing and Depl...

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.

I am looking for an experienced Flutter developer to create a minimal example that can effectively scan iBeacons for Android. This should be a simple, text-based UI that can display the UUID, major & minor values, as well as signal strength of iBeacons. Furthermore, it's important that the scanner remains functional in the background via a foreground service, providing a simple text notification when interacted with. The detection process must be constant (ranging). Key requirements for the project: - Develop a minimal Flutter app for Android - Ability to scan iBeacons and display UUID, major and minor values, and signal strength - The app should continue to work in the background - Use a foreground service for background function - Provide a simple text notification from...

Description: I am looking for an expert in SQL and R programming for a detailed data analysis project. This project involves extracting, analyzing, and reporting on data from a sophisticated relational database setup. The ideal candidate should have a solid background in data science, with specific skills in SQL and R. Responsibilities: Efficiently query and manage data using SQL from a SQLite3 database. Apply R programming techniques for advanced data cleaning, analysis, and visualization tasks. Ensure data integrity and optimize data processing workflows. Analyze results to derive actionable insights and compile detailed reports. Document all processes and code in a clear and comprehensive manner. Requirements: Profound knowledge of SQL with experience in handling large-scale ...

I am seeking a proficient Python programmer who can create a web scraper for Lazada. Key Responsibilities Include: - Develop a Python program that will enter query in search box and scrape Lazada for the following data: product name, images, price, description, seller, and URL. - The scraper should be able to handle pagination plus also bypass captcha using 2captcha api Ideal Skills and Experience: - Proficiency in Python and web scraping frameworks. - Familiarity with the Lazada's web structure and data extraction. - Experience creating scrapers for e-commerce platforms. Website lazada .