The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
# 2013년6월 ~ 2013년12월 : 고양시 상수도 블록시스템 - 고객사 : 고양시청 - 근무사 : (주)제이앤씨시스템 계약직 - 사용기술 : Java, Spring, Oracle, ibatis, amchart, eazy-ui # 2014년1월 ~ 2014년3월 : 고양시 상수조 블록시스템 GIS적용 - 고객사 : 고양시청 - 근무사 : (주)제이앤씨시스템 계약직 - 사용기술 : Java, Spring, Oracle, iBatis, O2Map, OpenGIS # 2014년4월 ~ 2014년11월 : 주유소 누유관리 모니터링 시스템 - 고객사 : (주)에스티모빅 - 근무사 : 프리랜서 - 사용기술 : Java, Spring, MySql, MyBatis, jqgrid, bootstrap, daum map API, plot-chart # 2014년12월 ~ 2015년2월 : 생산관리 ERP설계 - 고객사 : (주)금강이엠씨 - 근무사 : 프리랜서 - 사용기술 : mockup UI tool # 2015년3월 ~ 2014년4월 : 블루투스 BLE 비콘통신 Android 개발 - 고객사 : (주) 바이트시스템 - 근무사 : 프리랜서 - 사용기술 : Android (블루투스 BLE 비콘통신, 서버 소켓통신) # 2015년7월 ~ 2014년8월 : 임베디드 리눅스장비 웹관리 프로그램 - 고객사 : (주)제이앤씨시스템 - 근무사 : (주)제이앤씨시스템 계약직 - 사용기술...
php, mysql, word press, bootstrap, jquery , ajax, html5 (모바일웹, 앱) 기술 우대
...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 fr...
I am looking for a skilled Elasticsearch expert to help with data indexing and analysis for a large dataset. The data to be indexed is primarily textual and it is sourced from database entries. Experience with database management and textual data analysis is a crucial requirement for this project. The primary tasks include: - Analyzing and indexing a large dataset from database entries - Setting up Elasticsearch for efficient data analysis - Implementing indexing strategies for textual data Proficiency in Elasticsearch, data indexing, and database management is benefit for this project. Familiarity with handling large datasets and textual data is a must.
I'm seeking a data entry specialist with a knack for precision to type data from PDFs into an online database. Key Requirements: - As a data entry specialist, you will be responsible for the accurate and timely entry of data from PDFs into our online database. - The data format should match the original PDFs, with no specific validation rules needed. - The ideal candidate will be detail-oriented, with a proven track record of data entry. If you're someone who enjoys working with data and has an eye for detail, this could be an ideal project for you.
I'm looking for a skilled professional who can meticulously guide me in video call through setting up a VPN using Google Cloud and OpenVPN. The primary aim is to ensure secure remote access to a MySQL database from my Windows laptop. Key requirements: - In-depth knowledge of Google Cloud and OpenVPN - Proven experience in configuring secure VPNs - Expertise in MySQL database security and remote access Your role will be to provide detailed, step-by-step instructions on how to properly configure the VPN to meet my security needs. Please bear in mind that I may require access to the MySQL database from multiple remote locations, but most likely will only need it running from 1 remote laptop - the VPN should be flexible enough to accommo...
We are seeking an experienced freelance developer to convert our existing CodeIgniter backend to Laravel 11. The successful candidate will be responsible for maintaining the existing database structure, preserving the current logic, and ensuring no data is lost or details are overlooked during the transition. The key responsibilities include: Conversion of CodeIgniter Backend to Laravel 11: Migrate the current backend code to Laravel 11 while ensuring functionality and logic remain unchanged. Database Optimization: Optimize MySQL queries for improved performance without altering the existing database structure. Bug Fixing: Identify and fix any existing bugs to enhance the overall stability and performance of the application. API Output: Ensure the new Laravel b...
I want someone who can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purchase order, I ...
Build an ISO for a raspberry pi (with cellular notecard) to scan for unique cell phones in a specific range and log the unique phone ID and timestamps/ping (distance) from the raspberry pi and store in mysql database using cellular adapter.
...backend developer who can build a robust REST API. The ideal candidate should be proficient in MySQL, and have experience in user authentication, data retrieval, and data modification. Key Requirements: - Develop User Authentication: The API should include secure user authentication functionality. - Implement Data Retrieval: The API must be able to retrieve data from MySQL database as needed. - Data Modification Capability: The API should also support updating and deleting data in the database. Additional Needs: - Third-Party Integrations: The API will need to integrate with a payment processing system and also be able to send WhatsApp messages. If you have a strong background in Node.js, MySQL, and building REST APIs, I'd like to hear from yo...
I am in need of a PrestaShop expert to assist with the specific task of importing products via cvs into my PrestaShop store. The ideal freelancer for this project should: - Have proven experience in working with PrestaShop - Be highly proficient in importing products via cvs into PrestaShop - Be well-versed with the complexities of ecommerce product data The product data that needs to be imported is relatively simple, including basic details like product name, price, and category. In your application, please include your experience working with PrestaShop and specifically with product imports. Your experience in managing product data in e-commerce platforms will be a significant advantage.
I am in need of a skilled professional who can a...the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). - Enable and Teach me to Use Odd's OCR feature to fetch pdf data from invoice to transfer it to software Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to working with a professional who can deliver these requirements effect...
I need a talented full-stack developer with experience in PHP and MySQL. You'll be designing and creating a platform that supports 360-degree videos, similar to YouTube. Deployment in the cloud will also be required. Key Responsibilities: - Develop the front-end and back-end of the platform. - Design the platform's layout (the design concept is yet to be decided). - Enable 360-degree video support. - Implement features for video uploading, sharing, and rating. - Enable user account and profile creation. - Include a commenting system. Ideal Skills and Experience: - Proficient in PHP and MySQL. - Experience with cloud-based deployment. - Good understanding of user-friendly design concepts. - Familiar with user account management systems. - Experience in developing v...
I'm in search of a skilled Python PHP developer with experience in backend development. If you have a good grasp of Python and backend systems, this project is for you. Essential skills and experience: - Proficiency in Python PHP - Proficiency in Firebase MySQL - Experience in developing real-time features like live chat and notifications Ideal candidates will have: - Strong communication skills - Experience in developing and maintaining a reliable backend system - A keen eye for detail and the ability to troubleshoot and solve problems quickly If you think you're a good fit for this project, please get in touch. I'm excited to see what you can bring to the table.
...Subcategories for different model types (e.g. cars, interior, nature, food, furniture, electronics, appliances, weapons, clothing, jewelry) Each texture and model thumbnail should display a preview image and name Texture and Model Functionality Textures should be draggable and droppable onto objects in the 3D viewport to apply the texture Models should be draggable and droppable into the 3D viewport to import the model directly into the scene For each texture and model, there should be an option to select the resolution (8K, 4K, 2K, 1K) Other Requirements The addon should be well-organized, easy to navigate, and load quickly without slowing down Blender The textures and models should be high-quality and professionally created The addon should be regularly updated with new content...
...complete but due to some error while connecting to the database some code is missing and the connection is not completed. You have to find out where the problem is and fix it properly. I will help you in everything ******* I'm seeking a skilled PHP developer to assist with a project that involves fixing a PHP file and combining a Php ,MySQL database. The main tasks for this project include: - Resolving a database connection issue in the PHP file. - Combining the MySQL database in the backend of the PHP file. Your role will be crucial in ensuring that the database is correctly integrated into the PHP file and that the database connection is stable and error-free. The PHP file should be able to successfully communicate wi...
...creating an ER diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQ...
I am excited to apply for the part-time Software Developer position. As a third ...effectively to your projects. Technical Skills and Expertise Front-end Development: Skilled in HTML, CSS, and JavaScript, with experience in and Tailwind CSS. I focus on creating responsive and visually appealing user interfaces. Back-end Development: Proficient in Python and Node.js, with a track record of building robust APIs and microservices. Database Management: Experienced with MySQL and MongoDB, capable of designing efficient database schemas and performing queries. Full-Stack Development: Able to integrate front-end and back-end systems seamlessly, handling state management, authentication, and real-time data. UI/UX Design: Knowledgeable in using Shadcn and other tools to enhanc...
...complex backend development and database integration tasks and run code as offline. Key Responsibilities: Develop, test, and maintain robust, scalable, high-quality software solutions. Design and implement new features and functionality. Write clean, maintainable, and efficient code. Develop RESTful APIs to support front-end functionality. Integrate user-facing elements developed by front-end developers with server-side logic. - In-depth understanding and experience of backend operations using Python Django. - Managing and integration of the database with the application. - Maintenance and improvement of existing codebase for optimal functionality. Desirable Skills: - Proven experience in Python Django for backend development. - Hands-on experience in database ...
I am an exporter in need of a proactive sourcing agent to help me establish connections with potential buyers in the United States, European Union, and UAE. My focus lies in the exportation of: - Basmati rice (11...procurement of potential buyers - Market research regarding the demand for these products - Effective communication with buyers regarding product specifications and negotiation of pricing The ideal candidate should have: - Prior experience in sourcing and exporting goods, ideally within the specified regions. - Excellent communication and negotiation skills - An extensive network of contacts in the import industry - Knowledge about Basmati rice (1121) and guar gum powder will be a clear advantage If you have the necessary skills and experience, I would love to connect...
I've compiled a comprehensive global leads database with 8 million entries. The database includes a variety of details such as name, email, contact number, website, profession, and even Instagram username. - **Purpose**: This database is specifically designed for sales leads generation. It's meant to help businesses and organizations reach out to potential customers and grow their sales. - **Categorization**: The leads are not just categorized by one specific filter. Instead, they're a mix of different categories from various industries, countries, and professions. This eclectic mix provides a wide range of opportunities for potential buyers. - **Delivery Method**: I'm looking to sell this database through a CSV file, online access to the...
...Features: - User authentication - Push notifications - Payment integration - Job posting and Employee Profile creation - In-app chat and Whatsapp integration - Bookmarking and job/profile sharing functionalities - Premium membership that enables additional contact features - MySQL database schema design - Integrated Google Admob Advertisement Backend Work: - You'll develop a RESTful API with PHP+MySQL to support app functionalities. The ideal candidate will have significant experience in Flutter Development, PHP, and MySQL, coupled with a strong understanding of RESTful API design and integration. Please bid if you're capable of delivering high-quality, efficient code and can prove past experience in developing similar applications. Your abilit...
I'm seeking a skilled individual who can help me implement an IoT solution within a month timeframe. Key Aspect...MQTT (Message Queuing Telemetry Transport) and how to use it to integrate various IoT devices. - Data Collection & Analytics: Proficiency in handling data streams from these devices, ensuring seamless collection, storage, and basic analytics. - User Interface & Experience: Creating a clear, intuitive UI to monitor and interact with the IoT data is essential. Ideal Skills: - Proficient in Java, MySQL, and Tomcat - Experience with MQTT and IoT SCADA is a plus - Strong background in designing user-friendly interfaces - Able to deliver quality work within a tight timeframe Go through the PDF file attached to understand the flow . For Gateway and Sensors Deta...
...inventory management app using Google AppSheet and MySQL. The app will cater to a user base of less than 50, but it needs to be designed and optimized for scalable growth. It should be intuitive, easy to use, and have a professional interface. Key features that need to be incorporated into the app include: - Real-time inventory tracking - Sales and purchase order management - Product barcode scanning As the app will be handling crucial data for my business, security and reliability are of utmost importance. The developer should have experience in creating and integrating secure databases, as well as a track record of building robust, scalable applications. The successful freelancer should have: - Proficiency in Google AppSheet and MySQL - Experience in developing inve...
Commercial real estate agency database of GCC
About Plesk hosting upgrading the database from MariaDB 10.1 to 10.3 i would like to upgrade the database from MariaDB 10.1 to 10.3 for my hosting however, my hosting have a lot of client website in it, just would like to know if this upgrade will not affect the existing database thanks
Self Managed Home Care Providers Database
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
I'm seeking a data entry specialist with a knack for precision to type data from PDFs into an online database. Key Requirements: - As a data entry specialist, you will be responsible for the accurate and timely entry of data from PDFs into our online database. - The data format should match the original PDFs, with no specific validation rules needed. - The ideal candidate will be detail-oriented, with a proven track record of data entry. If you're someone who enjoys working with data and has an eye for detail, this could be an ideal project for you.
...an admin dashboard for an e-commerce site. This will involve managing callback values for various e-commerce events such as sales, cancellations, and renewals. These values need to be stored in a MySQL database. Additionally, email notifications need to be sent to both the admin and users, triggered by specific e-commerce events. Key Requirements: - Develop an admin dashboard for managing callback values - Utilize a MySQL database for storing the callback values - Implement a system for automated email notifications upon e-commerce event triggers Skills & Experience: - Strong proficiency in MySQL - Extensive experience in e-commerce site development - Proficient in creating admin dashboards - Skilled in implementing automated email notification ...
Hello, look for an expert programmer to import data from a json, there is a lot of data that includes various data, image, title, categories, tags, etc. and some go in custom fields. I want to take the images from a folder within my own server or use them in that same folder. Please read the description carefully and tell me price and time.
I'm looking to create a comprehensive database of self-managed home care providers in Queensland and Australia to facilitate networking within the industry. Key requirements: - The database should include the provider's: - Name - Address - Email - Prime contact Ideal skills for this project: - Proficiency in data collection and database creation - Familiarity with the home care industry in Queensland and Australia - Organizational skills, to categorize the data by region - Excellent attention to detail, ensuring accuracy in information provided The data should be organized by region for easier networking. I may also require the database to be updated periodically. The collected information should be reliable, up-to-date, and include a diver...
I have an extensive .mbox mailbox file that I need to import into my existing Gmail account. Key Project Details: - The .mbox file is more than 5GB in size, so the job requires someone who is familiar with managing large data transfers. - The file was exported from Gmail, which means the importing process might have some intricacies that need to be navigated. Ideal Freelancer: - Proficient in working with .mbox mailbox files and Gmail. - Experienced with importing large data sets into Gmail without causing any issues. - Excellent problem-solving skills for potential roadblocks in the import process.
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 am in need of someone who can help me gather email addresses, websites, and phone numbers from the links in the attached spreadsheet. It's crucial that the information you provide is accurate and up-to-date. The test of accuracy will be me sending emails and verifying the company. Any wrong details will need to be collected again unless it is beyond your control (e.g. company has closed down etc.) Automated collection will be erroneous as the data needs to be collected in the following way. use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to click company logo and collect its email addresses, websit...
...minimalist design and robust functionality to manage the platform. Core Features: - Firebase Integration - Comprehensive Data Visualization - Content Management (Articles, Quizzes, Categories) - Feedback Management - Notification System (In-App, Push) Other Key Features: - Secure Admin Authentication - User Management (Roles, Permissions) - Content Packaging & Distribution - Content Localization - Import & Export Functionality - Settings & Integrations - Security & Compliance - Performance Monitoring & Optimization The ideal candidate should have: - Proven experience developing admin dashboards - Expertise in Flutter, Firebase, PHP - Strong design sense for clean UI/UX - Knowledge of user management, data viz, content systems - Ability to ensure secur...
Hi there. I'm running XCode 15.3 and I need a few pages done with simple, clean storyboards and View Controllers. I use Alamo Fire and Swift, so if you could use that to pull my data via my API links and display it in several pages that would be great. Categories > Collections > Items > Item Details You select one and it shows a list - Item Details is one record from a MySQL db I need each selected item to be a variable in the code of the ViewController so if I use the print function, I can see it at the bottom of XCode. I'll give you the 3 or 4 API webservice links. I can give you a super simple app to put it in too...
I need a proficient database developer (PHP Developer) to create a specialized system for my dental equipment repair company. The database will cater to a sizeable clientele of 5000 customers. The details to be incorporated include: * Equipment type (X-ray machines, Dental chairs, Autoclaves) * Maintenance history * Customer details (Clinic name, number, email address etc.) In order to succeed in this project, you should have: * Strong database creation skills with the ability to account for our unique needs * Experience in the healthcare sector, specifically knowledge of dental equipment * Excellent problem solving and critical thinking skills for effective database design * Understanding of confidentiality requirements given the sensitive nature of the cu...
...website. The ecommerce is up and running and fully operational and we need a FULL STACK developer that can code in ALL AREAS of the webapp. - Frontend: React (JavaScript) - Backend: Node.js - Services: Python - Database: MySQL RESPONSIBILITIES: - Integration of new B2B APIs - New payment gateway integration - - Implementation of bug fixes and performance improvements. - Regular software updates and security patches. - Feature additions and enhancements. Skills and Experience: - Proven experience in maintaining e-commerce solutions. - Proficiency in React, Node.js, Python, and MySQL. - Strong problem-solving skills. - Excellent understanding of software best practices and design patterns. - Ability to work independently and meet deadlines. - .NET and are a plus ...
We are seeking an experienced Flutter developer to integrate 's video and call streaming services along with Firebase database into our existing Flutter application. The primary tasks include implementing 's features for seamless video streaming and call functionality, as well as utilizing Firebase database for efficient data storage and retrieval. The ideal candidate should have prior experience with SDK and Firebase integration. Additionally, the developer will be responsible for updating the app to meet the requirements for submission to both Apple Store and Android Store. If you have the necessary skills and expertise in Flutter development, we'd love to hear from you.
We need the following combination of online database and data entry interface from users + a local MS access file. Online Database and web I terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must...
We need an experienced Magento developer to assist with updating third-party extensions when conflicts arise due to newer php/mysql versions. Timeline: Start on the first project on 20th May using remote desktop tools like UltraViewer or AnyDesk for real-time collaboration. Bidders must be highly proficient in Magento 2.4x.
I need a desktop application that can carefully monitor a MySQL database on my Windows system. The app should be able to perform the following functions: - **Monitoring MySQL Database**: The application should constantly monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the ap...
We are in the middle of migrating Django to a new server. - Both servers run Ubuntu 20.04, postgres 12, python2.7 - The Django Project is already transferred over - Nginx has been configured - Postgresql has been setup Our struggle is to get the actual application up and running again. Your job will be to: - help to perform a clean export of the postgres database on old server - help to import the postgres database on the new server - ensure the Django application is coming back up smoothly The work will be done using shared tmate ssh sessions.
We are in search of a skilled software integrator to help me integrate my personal deployment system with a...and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need access to final git repository Project Completion: 2 weeks This project is an exciting opportunity to work on a cutting-edge software integration and development. If you have the right skills and enjoy a challenging, innovative project, I'd love to...
I'm looking for an expert to create a web-based CRM database aimed at efficiently storing and managing information. The data I intend to keep include: - Customer contact details - Sales history - Communication logs - Course details - Course Refresher notifications This project also requires the creation of functionalities to: - Add new contacts - Update existing contact information - Track sales performance Ideal freelancers should have substantial experience in CRM database development, with knowledge of implementing web-based solutions. Familiarity with training or course-based entities would be a bonus. Your expertise ought to allow seamless additions, updates, and performance tracking of stored information. Demonstrable success in similar projects will be advanta...
I am looking for a proficient full stack developer to help with a personal project. Using NodeJs and NextJs with MYSQL DB, your skills will include: - Expertise in utilizing NodeJs and NextJs - Develop a user-friendly platform - The ability to brainstorm and bring creative digital solutions - Strong problem-solving skills - Understand project requirements and deliver high-quality work - Should be proficient in using Github with AWS and coordinate with infra team member for coordinated push - Understands and knows the importance of proactive communication Expectations: - Your primary responsibility will be to design and develop the application, and to coordinate with the rest of the team working on different layers of the project. - Daily commitment for a minimum of 4 hours f...
I have two websites that need to be merged with a main focus on consolidating information. The current websites are different in design and themes, and I'm looking for a professional who can successfully merge them into a cohesive, user-friendly site. Key requirements: -...link seamlessly Please let me know your experience with similar projects and your approach to this particular task. Your input on the best ways to consolidate the information and prioritize content is highly appreciated. Website language is: - Linux AMI > OS - PHP > web and back-end - NodeJS > ICS - > ICS & Warehouse App - Ionic v1 > Warehouse App - Apache > web server - Database: MySQL Aurora - AWS hosted, leveraging EC2, RDS and S3 - Front-end is custom framework ...
...several years old. For example Node JS 7.10.0 and MySQL 5.7.0. Everything needs to be updated to highest stable version that offers support and packages. For Node.Js that will likely be version 18 or 20 Moreover, this project offers an excellent opportunity for more development. **QUOTE: UPGRADE** -Please provide a quote for upgrade of website, iOS & Android apps, and admin panel. -The Framework described below. -Specify team size and roles. -Time frame for completion. **PLATFORM FRAMEWORK & DETAILS** Framework: React, Node, Express, React Native Frontend: React (website), Node + Express (APIs on server), React Native (mobile apps on iOS & Android), Bootstrap (making UI web responsive) Backend: Node.js (latest version), Express, MySQL Deployment:...
