Mysql create table longtextJobs
I'm looking for a professional with extensive experience in database systems to assist in replacing our legacy system (Lotus Approach) with a more modern solution, ideally LibreBase/MySQL. This project is projected to last over the course of one year, with completion in stages alongside our internal team. Key Goals: - Develop a system that is compatible with current operating systems and tools - Enhance our data management and reporting capabilities - Ensure seamless migration of all existing data to the new system Ideal candidate should have: - Proven experience with LibreBase/MySQL, including Macro/script and Query Windows - Excellent understanding of data management and reporting systems - Strong skills in data migration - Ability to work collaboratively with an int...
I'm looking for a professional who can develop an online platform that provides automated sports betting odds. The odds should be in decimal format and sourced from a reliable third-party API. Key Aspects of the Project: - Development of an online platform that generates sports betting odds - Use of decimal odds exclusively - Integration with a third-party API for real-time odds data Ideal Skills and Experience: - Proficiency in web development and API integration - Familiarity with sports betting and odds calculation - Experience in creating automated systems Please note that the specific sports for which the odds will be generated have not yet been determined, so the system should be flexible enough to accommodate a variety of sports. I look forward to your proposals.
More details: Is this project for business or personal use? For starting a new enterprise What information should successful freelancers include in their application? Past work How soon do you need your project completed? ASAP
Task list for recreating the folder design in Illustrator: 1. Open Illustrator and create a new document 2. Import and scale folder image: - Place the folder image into the document - Scale it to the correct size for the hardboard 3. Create background pattern: - Design or import the background pattern element - Create a 3x2 array of the pattern 4. Align pattern with folder: - Position the pattern array to match perfectly with the top and bottom of the folder 5. Vector trace folder outline: - Use the Pen tool or Image Trace to create a vector outline of the folder - Use this outline to create a clipping mask for the background pattern 6. Create text and shipping label backgrounds: - Draw rectangles for text and shipping labe...
I'm looking for a creative professional to design a new flyer for our company. The main objective of this flyer is to promote our products. Key Requirements: - The flyer should be 'fun and colorful', appealing to a broad range of potential customers. - It should effectively show the different prodcuts catagories we offer. - Prior experience in flyer design or promotional material for product/service marketing is a plus. Ideal Skills: - Graphic Design - Marketing Knowledge - Creativity - Attention to Detail Tekst on the flyer needs to be in Dutch language The flyer should show our catagories: - Dogs (Onze hondenfamilie) - Birds (Vogels) - Farm animals (De boerderijdieren) We would like to show the following tekst: De mooiste metalen versieringen, wandd...
I need a seasoned developer to enhance a Codecanyon script with several new features and logic. Key Requirements: - Implement multiple job types with unique logic. - Each job type requires a different application process. - Ability to set unique display rules...timezones compatibility. - Establish withdrawal rules accessible via the admin panel. - Integrate a VPN blocking API. The highest priority for this project is to implement and enhance the 'Job Types' feature. The ideal candidate for this project would be someone who is proficient in PHP, JavaScript, and MySQL, with a strong understanding of Codecanyon scripts. Experience with VPN APIs and creating custom admin panel features would be highly beneficial. A keen attention to detail and ability to create comple...
I'm seeking a seasoned VB.NET developer to create a comprehensive Library Management System using Visual Studio 17. The system should facilitate efficient resource management, employing MySQL for data handling. Key Features: - User Management: Implement two levels of access - Admin and Standard Users. - Forms: Create forms for managing book details, categorizing by genre, and handling library users' data. - UI Elements: Use DataGridView for record display and operations, and PictureBox for adding images like book covers. - Database Integration: Execute CRUD operations using MySQL. While the project will not initially incorporate a search functionality, reporting tools, or a notification system for due dates, these features may be considered for futur...
I need to create a custom marketing and sales CRM and dashboard using data from the following data sources: Quickbooks (uploaded by excel) Google Analytics Google Search Console Facebook Ads Google Ads Jotform Wordpress The reports need to have pie charts and line charts with year-over-year and month-over-month views. The data needs to be easy to import and manage for a non-tech team.
I'm looking for a skilled freelancer to update the Table of Contents (TOC) in my Word document. Tasks to be completed: - Adding 4-6 new sections to the TOC - Structuring the new sections to follow the existing format Ideal skills for this project include: - Proficiency in Microsoft Word - Attention to detail - Ability to follow specific formatting guidelines.
NEed someone to design injection mold for a project of mine. Only apply if you can work on adult toy industry project. IF you have religious constraints or any other reasons to not work on such projects, please dont apply.
Description: Perform data migration from a PostgreSQL database to MySQL using Docker Compose to configure containers. Develop ETL scripts in Python to manage the extraction, transformation, and loading (ETL) process, including data cleaning to treat missing, duplicate, and inconsistent values. Use a Kaggle database as a source, prioritizing large and complex datasets. Kaggle: Tasks: Configuring Databases in Containers: Configure PostgreSQL and MySQL in different containers using Docker Compose. Create databases and tables in two databases, ensuring compatibility for migration. ETL Development: Extraction: Import data from the selected database in Kaggle to PostgreSQL. Transformation: Perform cleansing and standardization, addressing:
...9.3.3 installation to a local environment on my Mac using MAMP Pro. Background: I have already completed the following steps: Backed up all site files. Backed up the database. Created a new configuration in MAMP Pro. Imported the files into the local environment. Imported the database. Updated the file with the new database credentials. Updated the store URLs in the core_config_data table. Cleared the cache. Magento appears to respond, and the browser redirects to the default page, but it does not load. Instead, I encounter the following error: "The requested URL was not found on this server." Scope of Work: Connect to my Mac remotely using TeamViewer. Analyze and identify the root cause of the issue preventing the local Magento installation from functioning. Resolv...
We are launching an exciting new podcast called "The Deal" and are seeking creative and talented freelancers to design its branding. The podcast explores unique, humorous, and intriguing deal... social media, promotional materials). Include a color palette that conveys sophistication and creativity (open to your suggestions). Then we can go over: Podcast Cover Art: Must include the podcast name, "The Deal", and the tagline (to be provided). Dimensions: 3000x3000 pixels (required for podcast directories). Incorporate a premium vibe with elements like cigars, whiskey, and a large table to hint at the show’s theme. Supporting Graphics: Social media banner (for platforms like Twitter, Facebook, and LinkedIn). Instagram post and story templates for prom...
I'm seeking a professional to create detailed 2D design files for a small device case. The case and 3D files already exist. Key Requirements: - Create 2D specification files for 3D design (top and bottom, 2 pieces) - Files must be ready for submission to production manufacturer Ideal Skills and Experience: - Proven experience in creating protective device cases. - Proficiency in CAD software or similar design tools.
I'm seeking a proficient developer to replace my current SQL database and modify the PHP Laravel code that interacts with it. Key ta...modify the PHP Laravel code that interacts with it. Key tasks include: - Migrating data from an Excel sheet into the new SQL database. - Redesigning the database structure to accommodate the data. - Updating the existing PHP Laravel code to function with the new database structure. - You will do this for 8 pages Ideal candidates for this project should: - Possess extensive experience with MySQL and SQL database management. - Exhibit strong problem-solving skills to assess and modify unknown code segments. - Communicate effectively, explaining changes and updates in a clear manner. - Be patient and detail-oriented, ensuring every aspect is...
I'm seeking a skilled web developer to create a dynamic, editable database table on my WordPress site. This table should allow front-end users to make changes from a mobile browser, specifically editing existing entries. Key Requirements: - The table should be visually appealing and user-friendly, rather than a simple mirrored database of rows and columns. - The interface for editing entries should utilize modal windows/pop-ups. - I am open to suggestions for the styling or framework of the front-end interface, but it should be clean and responsive. Ideal Skills and Experience: - Proficiency in WordPress and MySQL. - Experience with creating dynamic, interactive web elements. - Familiarity with modal window/pop-up interface design. - Knowledge of ...
Hello, I am looking for a VPS Manager to help me upgrade my current SSD plan to an NVMe plan on Contabo. I aim to transition to a higher-performance plan efficiently and at a reasonable cost. I currently use CWP Pro Web Panel and wish to continue with it without switching to another panel. The current versions of my software are: Apache: Apache/2.4.56 PHP: 8.2.24 MySQL: 10.4.30-MariaDB It is crucial that my email accounts and all emails are retained during the migration. Additionally, I need someone who can ensure that all data and server configurations are fully restored and functional after the upgrade. My website is a custom-functionality marketplace software, so ensuring a smooth and seamless migration is critical. If you have experience with such upgrades and meet these req...
I have ongoing work related to our previous project 'Create a Festive and Eye-Catching Christmas Box Design'
...sending commands and storing the responses in a MySQL database. The application should have a user interface and implement Microsoft Active Directory for user authentication. Key Requirements: - Develop a Django web application - Enable the application to send commands to a firewall and store responses in a MySQL database - Create a user-friendly interface - Implement Microsoft Active Directory for user authentication - Develop a robust error handling system to manage failures in communication with the firewall - Implement real-time command execution to the firewall with immediate response display - Maintain audit logs of all commands sent to the firewall and responses received Ideal Skills: - Proficient in Python and Django - Experience with MySQL - Famil...
...Secure payment gateway for online transactions. Report Management Dynamic and customizable reporting system for sales, inventory, and revenue. Visual dashboards for quick insights. Export reports in multiple formats (PDF, Excel). Technologies Used Frontend: React.js / Angular.js for a responsive and interactive user interface. Backend: Node.js / PHP for seamless server-side operations. Database: MySQL / MongoDB for efficient data storage and retrieval. Others: API integration, RESTful services, and third-party payment gateways. Outcome Enhanced production and inventory efficiency by automating manual processes. Increased online sales through the integrated e-commerce platform. Simplified billing and report generation for business transparency and decision-making. Why Choose Me...
Create a revit family edit with add rlenclouser design
I'm looking for a database engineer to design and develop a MS SQL database containing 3 tables. This database will primarily be storing sales data and transaction details. Key requirements: - Design and develop a database with 3 tables, approximately 8 fields per table based on a provided list. - Populate the tables with synthetic data post-design, based on provided guidance. - The final number of records should be determined in discussion with the database engineer, but will fall between 200 to 500 records. - Implement One-to-Many relationships between the tables. Ideal skills and experience for the job include: - Proficiency in MS SQL - Experience in database design and development - Skills in generating synthetic data - Understanding of One-to-Many relationships The e...
I'm seeking an experienced (will need to see labels that you have designed in the past) graphic designer to create a label for one of my food products. The label should be attractive, eye-catching, and comply with relevant food labeling regulations. The label should be suitable to cover a 500gm as well as a 1kg Jar. The product is food, dairy based. Ghee. Please see the an AI based label that I created for inspiration. The label needs to convey the product is targeted towards - Health conscious consumers - Foodies - local produce - UK Please ask questions and do clarify your ideas before working on this. Answers to commonly asked Questions - 1. What are the dimensions. Answer - H 8cm x W 24cm AI Generated images will be REJECTED. If you are really interested pleas...
I'm looking for a UK-based API integration specialist to help with a crucial project. Scope of work - Implement secure, real-time API integration between my Zapier data table (containing customer contact details) and CloudTalk. - Set up necessary security protocols including authentication via API Key. This is a project that requires immediate attention and involves real-time data transfer. The ideal candidate will have a strong background in API integration, specifically with Zapier and CloudTalk. Please note: I can only consider applicants based in the UK for this project. No need for logging and monitoring real-time data transfers.
I'm looking for a professional with expertise in AI, Django, Python, and UI to enhance my application aimed at collecting data from various sources. Key Responsibilities: - Primarily focusing on extracting text from PDFs - Implementing a data cleaning process to remove unnecessary information before it's added to the database - Optimizi...attention to detail and ability to enhance the application's efficiency and effectiveness in gathering and processing data from various sources. The application should provide visual data representation features for better data insights. The primary goal is to achieve faster data processing. The application should handle medium-scale data collection efficiently. The application should integrate with MySQL and PostgreSQL for scalabl...
I require a website to be developed to market our Inspection Software called InspectaMate. The software is can be used for recording images and details on any type of building. It's main uses are: - Building Defect/Snag Inspections - Real Estate Agent rental inspections - Hotel maintenance records - Recording detail in homes for insurance purposes An old template for the site as at:
I require a website to be developed to market our Inspection Software called InspectaMate. The software is can be used for recording images and details on any type of building. It's main uses are: - Building Defect/Snag Inspections - Real Estate Agent rental inspections - Hotel maintenance records - Recording detail in homes for insurance purposes An old template for the site as at:
...September, 2021; Pay_Amount_2 = amount paid in August; …; Pay_Amount_6 = amount paid in April. Using the above dataset prepare a classification model for predicting payment default. Choose features, create a new feature (or several new features) based on the past pays and check the importance of variables. Check the distribution of the dependent variable. If needed, balance your data. Based on the problem/data characteristic try out several techniques and hyperparameter settings. Evaluate the models and report the results. Choose the most appropriate classification method/algorithm. The file is a table of 30,000 rows. Submission • All the steps in Altair AI Studio should be included in one single process, which you should describe in the report and export [F...
We're looking for a Google Cloud Engineer to perform ad-hoc tasks related to our GCP server setup. We provide a SaaS that runs on a typical LAMP stack in Google Cloud. The first task will be to create a duplicate of our production VM, which we will be using as a development and testing environment. Examples of other upcoming tasks are: - Resize the root partition and file system, so any increase to the storage disk will reflect correctly. - Revise version numbers of architecture, such as MySQL version, PHP version, Debian version, PHPMyAdmin version etc., and upgrade them when necessary. - Revise relationship between Xampp and Cloud SQL server communication, to identify 'breaking points' of number of users. - Revise accesses, both via IAM as well as Linux use...
...attentes et envies. - Ses compétences et savoir-faire actuels. - Ses préférences pour un business ou demande des suggestions à l’IA. --- **Technologies requises :** - **Frontend :** HTML, CSS, JavaScript (React ou Angular pour une interface dynamique). - **Backend :** Node.js, Python (Django/Flask) ou PHP (Laravel) pour la gestion des données et des utilisateurs. - **Base de données :** MySQL ou MongoDB pour stocker les informations utilisateurs et formations. - **IA :** Intégration de l’API OpenAI (par exemple GPT-4) pour la personnalisation des formations et l’assistant virtuel. - **Hébergement :** AWS, Google Cloud ou tout autre service cloud. --- **Compétences recherchées chez ...
I require help to migrate my website from Wordpress 3.9.40 to 6.7.1. The site is currently down due to a recent theme installation. Key Tasks: - Migrate the site including 192 posts in 2 languages (Spanish, Catalan), ...plugin on the new WordPress. - Use a standard theme post-migration. You won't need to update the theme, I will handle that. - No need for performance optimization post-migration, I will manage that. Technical Details: - The site is hosted on a server that currently offers PHP5.3, but can be upgraded to 8.3 at any moment. - I can provide access to mySQL and FTP. Ideal Skills: - Extensive experience in WordPress migration. - Proficiency in PHP and MySQL. - Familiarity with multi-language WordPress plugins. - Ability to implement standard WordPress theme...
Key Responsibilities: Design, develop, and maintain interactive and user-friendly Tableau dashboards and reports based on business requirements. Work with stakeholders to understand business requirements, and translate them into effective data models, visualizations, and reports. Create data extracts, work with large datasets, and optimize the performance of Tableau reports and dashboards. Integrate data from multiple sources, such as SQL databases, Excel, APIs, and other systems, to create comprehensive views of business data. Perform data analysis to ensure accuracy, identify trends, and provide actionable insights through visualization. Develop and optimize complex SQL queries for data extraction and preparation. Ensure the security and accessibility of Tableau reports by ...
...implementing secure data collection forms. MILESTONES: 1. Product Catalog and Availability Product Listings: The customer accesses a complete catalog of electronic products available for rental. Each product listing includes: Name, detailed description, technical specifications, and images provided directly by the supplier. Monthly rental price, calculated dynamically based on a predefined pricing table. Real-Time Updates: Product availability and images are updated in real-time via XML files provided by the supplier. The website periodically imports these files, ensuring the catalog reflects only products that are currently in stock. If a product in the cart becomes unavailable before checkout, the customer is notified and can replace or remove the item. 2. Cart and Minimum ...
...design and API development. Ensure mobile-first, responsive design principles are followed. Integrate third-party APIs and tools for automation and fintech services. Debug, troubleshoot, and improve existing software. Ensure data security and scalability. Skills Required: Frontend: React.js, Vue.js, or similar frameworks. Backend: Node.js with , Laravel, or Django. Database: MySQL, PostgreSQL, or MongoDB. APIs: RESTful API development and integration. Other Skills: Cloud hosting (AWS, Azure, Heroku). Git version control. Familiarity with AI/ML tools is a plus. Preferred Experience: Proven track record in SaaS platform development. Familiarity with code-less or low-code platforms. Experience in fintech and B2B solutions is a bonus. Why Join Us: Be part of an
I'm seeking a seasoned technical engineer with strong Microsoft Word skills to help me create a polished, professional project proposal for a prospective client. Your tasks will include: - Reviewing the provided files and restructuring the content for clarity and coherence. - Ensuring uniformity in fonts, headings, and the overall formatting. - Crafting a precise and detailed table of contents. I appreciate a keen eye for detail, prior experience in proposal development, and the ability to produce high-quality, professional documents. If you fit this profile, I would be eager to hear from you! Please include your relevant experience and examples of similar projects in your application. Our preferred proposal style is formal and corporate, though we will provide specif...
We are seeking an experienced developer to build a cross-platform VPN solution, including: • VPN Client for Windows, Linux, macOS, iOS, and Android. • VPN Server based on WireGuard. Requirements: • Proficiency in C# development for Windows (Frontend and Backend). • Experience with WireGuard or similar VPN protocols. • Ability to develop cross-platform applications. • Strong knowledge of networking protocols and security. • Familiarity with the architecture of Windows, Linux, macOS, iOS, and Android. Responsibilities: • Develop a modern and user-friendly interface for the VPN client. • Configure and develop a server based on WireGuard. • Integrate the client with the server. ...
I need a Windows-compatible program that can execute a DOS .bat file, read values from .txt files after its execution finishes, and insert them into a MariaDB SQL table Has to be able to be "scheduled" to auto-executed each 12 hours. Could be a resident, a Windows Service, or via Windows Task Manager Ideal Skills: - Proficiency in programming for Windows - Experience with SQL, specifically MariaDB - Familiarity with DOS .bat files - Ability to read and process .txt files for config (IP of the DB, user, pass, table, fields, etc) - Ability to read and process .txt files (xml style) 4 variables will be readen from the .txt files 8 fields will be updated at the DB (4 for the variables, 4 time-stamps) The successful freelancer will be able to efficiently connect the...
...Addon plugin for my print-on-demand (POD) marketplace. The goal is to enhance the design upload process, integrate additional fields during product setup, and streamline order processing. Scope of Work 1. Design Upload & Storage Customization Modify the Lumise Dokan Addon in the design upload step so that when vendors upload a design to a base product: The design is saved in a dedicated database table with the associated WooCommerce product ID for easy retrieval. Ensure the system supports multiple design uploads and proper organization for each product. Integrate the stored design into the WooCommerce order details when an order is placed. Ensure the admin can access the design file directly from the order details page for download and printing. 2. Pricing & Details S...
We are looking for an experienced programmer who can help me with a Discord bot that can send our DM to different Discord servers to all there members.
...Addon plugin for my print-on-demand (POD) marketplace. The goal is to enhance the design upload process, integrate additional fields during product setup, and streamline order processing. Scope of Work 1. Design Upload & Storage Customization Modify the Lumise Dokan Addon in the design upload step so that when vendors upload a design to a base product: The design is saved in a dedicated database table with the associated WooCommerce product ID for easy retrieval. Ensure the system supports multiple design uploads and proper organization for each product. Integrate the stored design into the WooCommerce order details when an order is placed. Ensure the admin can access the design file directly from the order details page for download and printing. 2. Pricing & Details S...
Standard: - We will create 800 High quality backlinks + 20 Keywords = charge 5000 INR (Off page)
P...customer support through chat or call options. Admin Panel (Optional for Business Management): Manage products, pricing, and inventory. View and process customer orders efficiently. Technical Stack Framework: Flutter or React Native (for cross-platform compatibility). Backend: Node.js, Python (Django/Flask), or Firebase for scalability and real-time data handling. Database: Firebase Firestore, MySQL, or MongoDB for storing user and order information. Authentication: Firebase Authentication or Twilio for OTP-based login. Payment Gateway: Razorpay, Paytm, or Stripe for secure payments. Benefits Ensures your sweet shop has an engaging digital presence. Enhances customer experience with effortless ordering and promotions. Helps you maintain customer loyalty through timely updates an...
I'm seeking a professional to develop an MLM binary system with a CRM module. The primary focus is on user registration and network management, which should include automated user onboarding. The automated o...associates track their performance, commissions, and downline growth. Technical Requirements: 1. Backend Technology: The system can be built using a backend technology such as Node.js, Ruby on Rails, or Django. 2. Frontend Technology: The system can be built using a frontend technology such as React, Angular, or Vue.js. 3. Database: The system can use a relational database management system such as MySQL or PostgreSQL, or a NoSQL database such as MongoDB. 4. Security: The system should implement proper security measures, such as encryption, secure authentication, and a...
...optimización y desarrollo de páginas web, además de conocimientos avanzados para implementar una herramienta de cotización personalizada. Requisitos principales: • Diseño web responsive y atractivo, optimizado para SEO. • Dominio de HTML, CSS y JavaScript para personalización visual y funcional. • PHP o Python para desarrollo backend y funcionalidades avanzadas. • Gestión de bases de datos como MySQL para almacenar cotizaciones. Conocimientos deseables: • Experiencia en OpenAI API para integrar funcionalidades inteligentes. • Mejora continua, monitoreo y generación de informes de rendimiento. • Adaptabilidad a nuevas herramientas y tecnologías según las necesidades ...
I'm seeking a talented designer to create a logo for my startup company. The desired style is modern and minimalist, with a monochrome color scheme. The logo should incorporate my company's initials or letters. COMPANY NAME : SuSiBa Engineering Pvt Ltd. Ideal Skills: - Graphic Design - Logo Design - Experience in modern minimalist design - Proficiency in monochrome palette - Creative in typography and letter design
I'm looking for a designer to create 4 eye-catching, bold and colorful web banners for our landing page. These banners will be the first thing our customers see, so they need to be creative and engaging. Key Requirements: - Integrate provided store photos into the design. - Focus on promoting our products through the banners. - Convey an energetic and fun tone. Ideal Skills: - Graphic design - Web design - Brand promotion Our website is Banners to include Banner 1 - wall image of crickets bats (see attached). And our address 4/4 New Street, Frankston, Victoria and phone number +61 1300 448 846. Include google map image of new stores location or link to this. Banner 2 - image of store (see attached), brands behind sold (see webpage). Words, Your Local Cricket
Create a UI design similar to that of telegram
I need a skilled PHP developer to enhance an existing PHP page with AJAX functionality. The page reads RSS links from a database table and opens each link in a URL. Key Tasks: - Implement AJAX functionality to submit data from a textarea where a user manually pastes RSS feeds. - Ensure the AJAX code allows for seamless transition to the next RSS link after submission. Most of the code is already written; I just need assistance with the AJAX part. This is a small project, and an ideal freelancer would have: - Proficiency in PHP and AJAX - Experience with RSS feed integration. Please note, the format of the RSS data when copied into the textarea is not specified, so flexibility and problem-solving skills will be valuable.
