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 (모바일웹, 앱) 기술 우대
I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The number of column...
Follow directions in video. Maidstone and Unity - Janessa and Kenzie Turtleford/Shellbrook/North Battleford - Juan David and Eduardo Meadow Lake - Cody/Tristan
I am urgent...in need of a freelancer with skills in web scraping, data extraction and web crawling. Your task will be to gather specific information from an online directory of race events throughout the world. Key Responsibilities: - Set up a weekly automated web scraping process. - Extract and deliver the following data points: Event name, Event date, Event location, online registration page, contact form page, and contact information along with some other info that we can grab. Required Skills and Experience: - Proficiency in web scraping and data extraction. - Capable of setting up an automated weekly process. - Ability to perform the task ASAP. - Strong attention to detail to ensure accuracy of information. Please note that timeliness and data a...
...which brings six Gulf nations together, i.e., Bahrain, Kuwait, Oman, Qatar, Saudi Arabia, and the United Arab Emirates. Introducing GCC Tax Laws GPT GCC Tax Laws GPT leverages the power of Generative Pre-trained Transformers (GPT) technology to create an intelligent and user-friendly solution for GCC Tax Laws compliance. Here's how it will work: • Automated Data Analysis: GCC Tax Laws GPT will be trained on vast amounts of GCC Tax Laws data, enabling it to analyze invoices, receipts, and other financial documents accurately. • Personalized GCC Tax Laws Guidance: GCC Tax Laws GPT will analyze your company's specific GCC Tax Laws profile and generate customized reports and recommendations for optimized GCC Tax Laws compliance. • Reduced Errors: GC...
...transform the unstructured data I receive from vendors into structured data and then stores it in a MySQL database. Key Components: - Unstructured Data: The quotes come in the form of text documents and images. The images have price information marked on them. The system should be able to interpret both types of data. - ChatGPT Integration: You'll be responsible for integrating GPT-3 or similar to process the received data. - Structured Data Storage: The structured data should be stored in a MySQL database. - Automated Database Updates: While batch updates are acceptable, the ideal system will be able to automatically update the database whenever new data is received. Require...
...facturas y entrada de productos: Registrar las facturas de compra y la entrada de productos al almacén para mantener un registro de todas las transacciones. Entradas y salidas: Permitir realizar entradas de productos al almacén (por ejemplo, desde proveedores) y salidas de productos (por ejemplo, para clientes o para uso interno). Migración de la base de datos MySQL del aplicativo anterior: Si hay un aplicativo anterior con una base de datos MySQL, necesitarás migrar esa base de datos al nuevo aplicativo para garantizar la continuidad de los datos....
...or 21, MySQL Usecase: 1. As a super admin I would be able to onboard a new tenant(example: school). Whenever superAdmin does that then new new database can be created dynamically in mysql. And the user_details, product, services tables need to be created. 2. There should be a table "tenant_master" which should have information of all tenant databases. like hostname, port, username, password, connection_string, tenant_name, status. One entry should come to this table when we are onboarding a tenant. 2. Need to configure the Spring Security with JWT authentication. 3. I can be able to login as school admin and JWT token need to generated accordingly. 4. When I request endpoints by sending the JWT token, system should connect to the respective databa...
I need an experienced Python MySql backend programmer to provide support for a web app I'm building. The tasks will include: - Database design and implementation - Query optimization - Data migration - Hands on GoDaddy cPanel Hosting The web app will require the following functionalities; - User registration and authentication - A well-designed Customer Relationship Management (CRM) system - Data fetch by API and Post on API Ideal skills and experiences include Python, MySQL, backend development, and experience with implementing user registration, authentication, and CRM systems. Experience in web-based applications is crucial for this project.
...maintenance of my websites built with core PHP and MySQL. Key Tasks: - Website changes: Regular content updates and design changes are anticipated, so the candidate should have flexibility and be comfortable with changes. - Feature Additions: I'm looking to extend the functionality of the websites, so the candidate should be able to implement new features. - Bug fixes: It's essential for the candidate to have a keen eye for identifying and fixing bugs that may arise within the websites. - Security updates: The candidate should be able to stay up-to-date with the latest security trends and ensure the websites are secure. - Performance optimization: A deep understanding of PHP and MySQL is required to optimize the performance of the website. Availa...
...facturas y entrada de productos: Registrar las facturas de compra y la entrada de productos al almacén para mantener un registro de todas las transacciones. Entradas y salidas: Permitir realizar entradas de productos al almacén (por ejemplo, desde proveedores) y salidas de productos (por ejemplo, para clientes o para uso interno). Migración de la base de datos MySQL del aplicativo anterior: Si hay un aplicativo anterior con una base de datos MySQL, necesitarás migrar esa base de datos al nuevo aplicativo para garantizar la continuidad de los datos....
I need a server pro to help me install and configure a Wisp game panel on my Ubuntu 22.04 LTS server. The server is a hosted bare metal se...version of Pterodactyl Panel. The setup should include the installation of the following gaming eggs: - Minecraft - Tmodloader - V for Vampire - Pal World Set up local backup on the second drive located on the server. Set up a full redundant backup with AWS S3 (or another storage solution) Ideal Skills and Experience: - Proficiency with Ubuntu 22.04 LTS or other Linux based server OS's - PHP, MySQL, curl, react - Setting up Linux users and securing root and access - Experience in installing and configuring game panels, specifically Wisp or Pterodactyl Panel - Familiarity with Minecraft server setup - Capability to install and set up ga...
I want to develop a website similar to and https://www.abasteo.mx. The goal is to automate daily updates of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology...
...of a skilled MySQL professional who can smoothly transition my old database into the new one for my website. There are some extra columns in certain tables in the new database, so understanding the essence of the project is pivotal. Here's what I need assistance with: 1. Importing Data: I have a detailed list of specific tables and columns which need to be brought into the new setup. Your work will heavily rely on this list. 2. Data Combination: While importing the data, some of it requires merging. I won't be able to guide you on how this should be done, so it will fall under your professional judgment. Your proven experience and innovative strategies will come into play here. I am hoping to find someone who has extensive...
We're looking to automate our timesheet comparison process. Our current timesheet data is in two online platforms and the automation workflow needs to run on a weekly basis and compare the 2 timesheets. Key Tasks and Requirements: - Create a data entry automation flow that will extract data from our current online platforms. - The data has to be extracted for 2 pay periods from platforms - 1st to 15th and 16th to End of Month for every month. - compare the 2 data sets by employee and date. if there is a mismatch, it needs to be flagged. - send email to the employee and reporting manager about the mismatch. - send highlevel email to operations head about all mismatches so that he can followup with the managers. - Schedule this automated ...
I'm ...Video Consultations - Enables real-time video consultations for convenient and quick veterinary advice. * Prescription Requests - Grant clients the ability to request medication for their pets. * Vaccination Reminder - Automatic reminders for pet owners about upcoming vaccinations. * Database - A structured database for storing all application data, for which MySQL will be used. Ideal Skills and Experience: * Proficiency in iOS, Android, and Web application development. * Proven experience with MySQL database design and implementation. * Familiarity with implementing robust video consultation systems. * Previous work with appointment scheduling features and notification systems. Please provide evidence of any similar projects or rele...
I'm looking for an experienced Wikipedia editor to create a page for my company. We already have a website so the information will be derived from there. The page should be a basic summary of the company, highlighting our key offerings and what distinguishes us in our industry. It should be well-researched and comply with all Wikipedia guidelines. The ideal candidate will have: - Proven experience in creating Wikipedia pages for companies - Strong research skills to extract relevant information from our website - Excellent writing skills to summarize the information in a concise and engaging manner - Comprehensive understanding of Wikipedia guidelines and policies If you have experience with similar projects, please provide examples of your work. Looking fo...
I am in search of an experienced full stack development team to create a job board. Both PHP and MySQL, as well as Ruby on Rails should be familiar technologies for the successful candidate/team. The features I require include: - Job search engine - Resume submission capability - Creation of employer profiles Equally important to functionality is design. The job board must have a modern, sleek aesthetic while remaining user-friendly and intuitive. Moreover, the platform should be customizable and flexible to accommodate future expansion or changes. A successful history in similar projects is highly desired for this task. Proven design skills and a keen eye for UI/UX will also be highly advantageous. Note: Read the attached document for more details
Saloon Management in the following tech: 1. Laravel 11 2. Livewire 3 3. Filament 4. MySql Having following features: 1. Customers Management 2. Agents Management 3. Services Management 4. Booking Management 5. Agents Commission Management 6. Trend Charts
Saloon Management in the following tech: 1. Laravel 11 2. Livewire 3 3. Filament 4. MySql Having following features: 1. Customers Management 2. Agents Management 3. Services Management 4. Booking Management 5. Agents Commission Management 6. Trend Charts
I'm looking for a skilled data scraper who can help me extract contact information from Website 1 and deliver it in Google Sheets. Key Requirements: - Scraping: The primary task is to scrape contact information from Website 1. - Data Delivery: I prefer the scraped data to be delivered in Google Sheets. Ideal Skillset: - Web Scraping: A strong understanding of web scraping techniques and tools is essential. - Data Handling: Proficiency in handling and organizing data in Google Sheets is preferred. Please ensure that you have prior experience with similar projects and can provide a sample of your work for review.
...relational database design. The primary goal is to deepen my understanding and skills in E-R modeling, functional dependency theories, and database norms, particularly: * Identifying entities and relationships * Applying E-R modeling and normal forms for a well-designed relational database. The chosen candidate should be proficient in the aforementioned areas, plus have the capability to clarify how to use these skills to identify performance issues, validate data integrity, and evaluate scalability. The project scope encompasses E-R modeling, identifying entities and relationships, and applying normal forms. Ideal Skills: * Advanced knowledge in RDBMS * Proficiency in E-R modeling * Understanding of functional dependency theories * Experience in applying...
I am seeking a PHP developer who is experienced in frontend development, and an expert in PHP frameworks and MySQL database integration. The focal point of the project is database management. • Main responsibility of the PHP developer will be to build new databases, thus experience in this is essential. • A background working with PHP frameworks and MySQL is crucial for success in this role. • The role also entails some front-end development tasks. Successful applicants will illustrate these skills throughout their portfolio in relation to past projects. If you are a self-starter with a penchant for database management, I look forward to receiving your bid.
I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.
I am seeking a skilled freelancer to manage my MLS listings. Your responsibilities will include: Propli task: New Development upload Requirements: we are looking for a data entry team to upload and update the details of new development constructions project on the Costa del Sol (southern Spain) As a starter project, we will provide you access details to one developer’s website (Nvoga) where they have 11 different projects listed. Your “intro” job will be to extract the information from the “Salvia” development (No.3 on the page) in that site and insert it into our site. We have also provided a few videos showing a complete walk-through of the process 2 of the projects which you should be able to use as a reference. Once we have checke...
Crawl, extract, build and publish all Docker Hub, , GitHub, BitBucket, GitLab, Snapcraft, Flatpak, AppImages, DC++, eMule, BitTorrent and SoulSeek as deb packages (APT repository), from ISO, container images, and source code files. Also will run a web server. More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Detailed project proposals How soon do you need your project completed? No time limit
It will crawl and extract all itags from all images from Docker Hub, , AWS ECR Public Gallery, Snapcraft, Flatpak, AppImages, Bundles, BitTorrent, EDonkey2000, SoulSeek and DC++, and it will build and publish deb packages (as APT repository), and it will also run a web server. More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Detailed project proposals How soon do you need your project completed? No time limit
It will crawl and extract all itags from all images from Docker Hub, , AWS ECR Public Gallery, Snapcraft, Flatpak, AppImages, Bundles, BitTorrent, EDonkey2000, SoulSeek and DC++, and it will build and publish deb packages (as APT repository), and it will also run a web server. More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Detailed project proposals How soon do you need your project completed? No time limit
...areas: database design and query optimization. Key Responsibilities: - Database Design: I'm looking for assistance in designing the database to ensure it's well-structured and optimized for performance. - Query Optimization: I need an expert who can help in fine-tuning our queries to ensure they're efficient and have minimal impact on our database. Key Skills and Experience: - Proven experience in MongoDB database design and query optimization, especially for small datasets (less than 1 GB). - Solid understanding of indexing strategies and their role in improving query performance. - Ability to communicate effectively and work collaboratively to understand our specific needs and tailor solutions accordingly. - Familiarity with perfor...
I'm in need of a very simple and lightweight website that is able to display PDF files and perform a variety of functions on the extracted text. Key Requirements: - Display PDF files: The website should have a viewer that can display PDF files. - Extract OCR text from PDF: The website should be able to extract and display text from PDFs that have FRACTUR font. - Translate OCR text: The extracted text should be automatically translated to Polish. - Text input: The website should also feature a text box where users can input text. Ideal Skills and Experience: - Proficient in web development and PDF handling. - Experienced in OCR text extraction. - Familiar with translation APIs for automatic translation. - Strong understanding of UX/UI for imp...
I'm seeking an experienced PHP developer to help me address some pressing issues with my website. Key responsibilities include: - Resolving error messages that are currently present on the site - Adding a new function to the website: specifically, facilitating the editing of existing customer information in the database The ideal candidate for this role will have: - Proficient in PHP and MySQL - Prior experience in resolving error messages - Knowledge of and experience with customer database management Please provide your bid, along with your relevant experience, for this project.
...wanna create script in extracting or scraping the subscriber data from a large Telegram channel and groups. The ultimate goal is to invite these subscribers to my own channel. Key Results: - Extract or scrape customer data from specified Telegram channels or Groups. - The type of data required is mainly (phone number - user) - Extracting data from private channels or groups - Provides a complete list of extracted customers - Ensure customer data is ready to easily import into my channels for invitations Ideal Skills & Experience: - Proficiency in web scraping tools and techniques - Experience with Telegram algorithms - Experience with Telegram API or similar platforms - Proven track record in handling and managing large amounts of data...
I'm seeking an experienced PHP Symfony developer with expertise in Doctrine ORM and MySQL, to help build various functions within our SaaS. - Objective: The main goal of this project is to build up several functions within our existing SaaS platform. - Design Guidelines: You are required to follow specific design guidelines that are already in place for this SaaS platform. Ideal Candidates: - Proficiency in PHP and Symfony with a focus on building and extending SaaS platforms. - Experience with Doctrine ORM and MySQL is a must. - Strong understanding of security principles especially around key/token use. - Experience building headless systems that are for integration with over API. - Ability to follow existing design guidelines while implementing the required functio...
The project would be to read product data from the magento 2 api, send it to the rocketsource api, process the data and with that processed data save, save it to magento 2 using their api. It would not be all the data, it would be some attributes depending on some specific rules. Extract data of magento (api) -----> Send to Rocketsource (api) ----> Save selected data to magento (api) All in one process.
Please read the entire job post, before you bid. I'm in urgent need of a skilled PHP developer to create a comprehensive user registration form for a website. The form should feature essential capabilities such as: - User Registration: The form should allow users to register for the website in the MySQL. - Data Validation: The form should include robust data validation to ensure that all fields are correctly filled in. - Email Confirmation: Following registration, an email confirmation system should be in place to confirm the user's email address. Notes: User selects a username, this must not be in the DB already. Email and phone should also be unique in the DB. Also there is a need to check if the username of a referral exists in DB. Page ...
I need a professional data extractor to extract leads from websites on a weekly basis. Key Requirements: - Extracting email id and mobile numbers: The task involves scraping textual data only, and not images - Websites as source: The data should be scraped from various websites, so a good understanding of web scraping is crucial. - Weekly updates: The extraction will need to be performed every week, so the ability to automate or efficiently manage unique scraping is essential. Ideal Skills and Experience: - Web scraping: Proficiency with tools and techniques for web scraping, especially for textual data. - Automation: Experience with automating scraping processes for repeated extraction. - Accuracy and reliability: The extracted data must be co...
I am looking for a data scraper to extract information from the JazzCash agent locator list available on their website (). Key Requirements: - I need the data to be delivered in an Excel spreadsheet format. - The specific details that I require for each Jazz locator are the Name and Address, along with the Services offered. - The scraping needs to be done only once; it will not be recurring. Ideal Skills and Experience: - Proficiency in web scraping, particularly using tools like Python's Beautiful Soup or Scrapy. - Experience in extracting data from websites with dynamic content. - Strong attention to detail to ensure accurate data extraction. - Previous experience with similar data scraping projects will be an advantage. I am parti...
I'm in need of a comprehensive business owner database specifically in Tamilnadu, Chennai. The database should include detailed information of business owners Contact number, Email ID from various industries like GST Filling Database, Distributors, Industries, Dealership and more
...microservices architecture from scratch. The project will involve the following key components: - User Authentication and Authorization: The microservices should have robust user authentication and authorization functionalities to ensure data security and privacy. - Real-time Communication with WebSockets: The developer should be able to implement real-time communication using WebSockets, allowing for instant updates and notifications. - Integration with Third-party APIs: The microservices need to seamlessly integrate with various third-party APIs, ensuring smooth data exchange and interoperability with external systems. The ideal candidate should have: - Extensive experience with and building microservices architectures from scratch. - Strong understanding of user auth...
I need a fast turnaround to correct error messages in my PHP code and database. The main goal of my PHP application is to upload content to the database and ensure the site displays it correctly. Key Responsibilities: - Fixing error messages in PHP code - Addressing database issues - Ensuring smooth content uploading functionality - Ensuring the site can retrieve and display content from the database Ideal Skills and Experience: - Proficient in PHP - Strong understanding of database management - Prior experience in troubleshooting and fixing error messages - Ability to work fast and deliver under tight deadlines.
I'm looking for a task-oriented individual who can assist me with saving documents from an online database. Your assignment would primarily revolve around focusing on documents and seamlessly saving them off. Key responsibilities: - Download documents with my full permissions. - Make sure that all downloaded files are in audio file format and labelled correctly. The ideal candidate will have: - Relevant experience and proficiency in saving files to dropbox. - Excellent attention to detail ensuring the correct files are stored. May be 1-2 days of work.
...in need of a website and customer portal. The website is an informational site, but the customer portal is the heart of the project. It should be designed to handle our Software as a Service (SaaS) licensing. The main functionalities required are: - **Payment Processing:** The portal needs to process payments from our clients. - **License Management:** The portal should manage our SaaS licenses. Ideal candidates for this project should be well-versed in web development, particularly in creating user-friendly and efficient customer portals. Experience with integrating Square and Zoho Books is a plus. It's crucial that the website and portal are secure and scalable. A good understanding of SaaS models would also be beneficial. Additional Requirements IoT Hybr...
I'd like to extract the phone numbers of real estate agents from a particular website Key Requirements: - Extract agent contact information Ideal Skills and Experience: - Proficiency in web scraping - Experience with data extraction and automation - Strong understanding of data privacy laws and regulations Please note that the data is intended for internal use only and will not be shared with any third-parties.
Description: I am looking for a talented and detail-oriented data analyst who is highly skilled in R programming to assist with a couple of important projects. If you have a passion for statistical analysis and can transform complex datasets into clear insights, this opportunity might be perfect for you. Projects Details: Project 1: This project requires deep statistical analysis and simulations involving various probability distributions. Your task will include creating insightful visualizations and interpreting data accurately. Project 2: This project involves calculating conditional probabilities and analyzing normal distributions. Precision and an analytical mindset are essential for success. Required Skills: Expertise in R Programming: You should be adept at writing e...
I have a PNG file that I need the text extracted from and accurately transferred into a Word document. This is to preserve the text and make it editable for future use. The key requirements for this job include: - The extracted text must be precise, with no paraphrasing. - The text should be structured into two continuous columns, which are to be part of a table. The ideal freelancer for this project should: - Have experience in text extraction and document formatting. - Be proficient in Microsoft Word and capable of using its advanced features to meet the specified formatting requirements. - Have an eye for detail and a commitment to delivering work accurately and efficiently. By providing this service, you are helping me to efficiently and effectively convert a non-editable file i...
I'm seeking a proficient ArcGIS Python specialist to help me with a project that involves data analysis and geoprocessing. Key tasks: - **Data Analysis:** You will be responsible for analyzing medium-sized data (1 GB to 10 GB), using ArcGIS Python. Your ability to extract meaningful insights from this data is crucial. - **Geoprocessing:** I need assistance with efficiently processing this spatial data. Your geoprocessing tasks should be meticulous and well-documented. I'm specifically looking for an expert who can create custom GIS tools that can streamline these processes. Ideal Skills and Experience: - Strong proficiency in ArcGIS Python - Extensive experience in data analysis, particularly with medium-sized dataset...
...crucial database issue with my website built on Node.js. There are certain missing tables that cause the application to crash whenever specific buttons are clicked on the site. Key Details: • The crashing issue is experienced when the Login button, Submit form button, or the Add to cart button is clicked. • Due to these unsolved errors, the terminal indicates that a certain table name is not found. Ideal Skills and Experience: • Solid background in solving database issues in Node.js platforms. • Experience in working with missing tables and rectifying database errors. Application Requirements: Freelancers interested in this project should include detailed descriptions of their previous and related experiences in their application. T...
