Mysql database designdela
...theme, which is the Classic theme, ensuring that there is no loss of functionality or design during the transition. We're also facing a database upgrade. Currently, we size MySQL as our primary database for the application. We expect you to expertly manage the database's migration, ensuring our data is perfectly intact post-upgrade. Subsequently, we have several portlets functioning primarily for content display. These need to be carefully updated to be fully compatible with Liferay 7.4 Community Edition. Ideal Skills: - Proficiency in Liferay upgrade process. - Experience in theme development and database migration. - Proven record of successful portlet upgrades. - An excellent understanding of MySQL and content view. By working s...
I'm in need of an expert who can assist me in replicating my entire SQL database. This task is primarily aimed at data distribution. The specifics of the project include: - The replication method to be used has not yet been decided, this is something I will need your expertise with. - The replication should cover the entire database. It's essential to ensure that all data is accurately copied and nothing is left out. Ideal Skills and Experience: - Strong experience with SQL databases - Proficient in various SQL replication methods - Previous experience with large scale data replication - Detail-oriented and capable of ensuring data accuracy - Sound knowledge of data distribution techniques Please bid if you meet these requirements and are confident you can effec...
**Please do not ask me to pay you outside of freelancer & please don't use an AI generated proposal** This is a simple jQuery and Ajax/MySQL project. I have a list of <div> items which are ordered 1, 2, 3, etc. based on records in a MySQL database. I want to make the <div>s draggable so they can be re-ordered in a smooth drag and drop. Once a <div> is moved, the MySQL database is updated with the new ID of the DIV which corresponds with the position in the list. Potential for lots of future work.
As an enterprise looking to develop an interactive website, we require a proficient PHP developer experienced in Laravel and CodeIgniter. The successful candidate will have the skills to: - Develop a user-friendly website using Laravel and CodeIgniter frameworks. - Integrate an efficient database into the website that supports our business needs. - Implement a Payment gateway API to facilitate online transactions. - Incorporate a Reporting API to generate comprehensive reports for our records. Extensive knowledge in API integration is a plus, as we are looking for efficient, seamless functionality. Prior experience working on similar e-commerce platforms will also be a strong advantage.
I'm looking for a freelancer who can help me with a significant Data Entry operation. The job involves generating a database of venture capital firms based in North America. But, it's not just any database; I specifically need the names and email addresses of representatives from these firms. To better highlight the requirements, here they are: - The database should cover venture capital firms in North America. A wide net is preferred to ensure maximum coverage. - The database will only include the name and the email address of a representative from each firm. You are not required to find out additional details such as the company name or investment criteria. - The final database should be provided in an Excel spread sheet format. This will mak...
Google Maps / OSM – Annotate Map in various ways. This will be a created to be dropped into an existing website – this needs to be responsive design so that I can also work from a cell phone screen. (see: “” this will be similar to the end product expectation) Using this video as an “example” Start video around 2:30 Map Features required: 1. Create a “new” Map annotation (New Preplan) – which will save everything about the map icons and annotations. 2. Search and pan/zoom to a specific address 3. Ability to toggle between several different map tile & theme views ( Google Map/ Google Sat / OSM ) views (dark mode, custom tiles?) 4. Draw “footprint” polygon of the “building” a. If a building p...
...security, with a particular emphasis on preventing unauthorized database access. The ideal candidate will have a deep understanding of PHP, MySQL, security best practices, and experience with affiliate systems. #### Core Responsibilities: - **Security Audit:** Conduct a thorough security audit of the existing script, with a special focus on closing loopholes that could allow unauthorized database access. - **Bug Fixes:** Identify and resolve existing bugs in the script to improve stability and performance. - **Feature Development:** Collaborate with our team to understand our requirements for new features and implement them accordingly. - **Database Security:** Implement robust security measures to safeguard our database against SQL injection,...
I'm searching for an experienced developer to work on a software for a charity organisation. The goal of this project is to design a comprehensive software to manage our member's digital ID with incorporated pictures and generate a debit credit balance sheet for each member. Key Skills: - Database programming - Coding - Familiarity with financial software - UI/UX Design - Experience in secure data solutions Project Scope: - The software will maintain separate image files linked to each member's ID. This requires a software solution that effectively organizes and retrieves image data. - Transaction details for each member will be comprehensive. This includes the amount, date, purpose, and method of payment. An existing understanding of how to manage fin...
...to upgrade and perform regular updates on our current database. The refresh will include improved performance, enhanced security features, and additional functional elements. The specific area of improvement sought after is: - Performance: We expect considerably reduced response times and highly improved scalability features throughout the database. Your task will be to devise strategies that allow faster processing to facilitate smooth operations without compromising on the system's stability or integrity. In terms of security, the project commands: - Enhanced Security: We are currently not meeting data privacy compliance requirements, hence solutions are needed to correct this discrepancy. Your responsibility will be to both design and implement more sophi...
I'm in need of a dedicated and skilled app developer who can help create a sports database app that caters to football, basketball, baseball, hockey, volleyball, rugby, The app should include: - Detailed player profiles: These need to contain multiple data points as well as integrated video features. - Comprehensive player statistics: A clear, user-friendly presentation of player data and stats is key. - Player and Member Login: A secure login feature for players and members to access personalized content. - Age and category leaderboards: This feature should allow users to see top performers in each age group and category. - Efficient search tool: Users should be able to quickly and easily find the information they need with a robust search feature. - Image capabilities: Th...
...searching for an expert in Arduino who can adeptly program it to work with 20 sensors for the purpose of data collection. Will prefer freelancer who already have Arduino board and sensors. You should be comfortable in setting up these sensors to interface with an API (to a MySQL database) running on Azure. The API which you put in place should be designed to transmit real-time sensor data, or at a minimum data every one minute. Key Skills & Experience Needed: - Proficiency in Arduino programming - Strong understanding of MySQL - Prior experience with API creation and implementation - A solid understanding of collecting real-time data from sensors (Convert temp to voltage, gyro work etc.) This project provides an exciting opportunity to put your Arduino p...
I am in need of a developer skilled in PHP and MySQL who can assist in completing a few pages that are currently in their early stages. Key Tasks: - Create and fill 3 pdf forms with existing data, must be able to view and then print. -Auto fill some parts in 2 existing pdf forms and be able to view and then print - Create notifications for a couple of things. - Create a pdf417 barcode scanner where a barcode can be scanned and a form auto filled with the data. Mobile as well as upload a picture to scan. This project therefore requires someone with: - A strong background and proven expertise in PHP and MySQL - Proficiency in troubleshooting and debugging - Creativity to recommend and develop new features for the pages. I am eager to collaborate on this, and am open to ne...
I am looking for a developer to create an AWS Glue and Pyspark script that will strengthen the data management of my project. The task involves moving more than 100GB of text data from a MySQL RDS table to my S3 storage account, on a weekly basis. Additionally, the procured data needs to be written on parquet files, for easy referencing. The developer will also need to send scripts to deploy the AWS Glue pipelines on Terraform, fitting all parameters. Skilled expertise in AWS Glue, PySpark, Terraform, MySQL and experience in handling large data is required. There is no compromise on the quality and completion timeline. Effective performance on this project will open doors to more work opportunities on my various projects.
Example suppose i have a list of names Joe Peter Tim Anne Loretta i want to paste them into a text box in the same way above in a vertical fashion 1 per line then press submit after pressing submit these will be entered into a DB (table) called clients the table structure will have 2 columns table name is clients client_id client_name after pressing submit on the example above i wil then check to see the data has been inserted correctly and it should look as follows client_id client_name 1 Joe 2 Peter 3 Tim 4 Anne 5 Loretta then suppose i run it again and i want to add Penelope Victor then after submitting my table should look like client_id client_name 1 ...
I'm looking to upgrade a static website using PHP and MySQL. The main goals are to improve data management, integrate with a CRM for easy content management, and fix any issues like broken forms or errors. We also need to create new pages in the CRM for managing website forms. If you're skilled in PHP via laravel, MySQL via Phpmyadmin, and simple CRM integration, this project is for you!
Hi iIt’s a migration project: Form oracle to Postgres database. This support will be on zoom meeting which we will provide you and you will support on my consult 12$/hourly indian time 10:30 pm to 12:30 am Monday to Friday. Payment every Friday after support done ple pay
I am in need of an expert who can develop a WordPress post filter using three specific taxonomies: Category, Tags, and Custom Taxonomy. Key Features: - The filter needs to be designed to work with multiple t...Features: - The filter needs to be designed to work with multiple taxonomies simultaneously. - Importantly, the filter should impact the main query on the website. Ideal Skills: - Extensive experience in WordPress development, particularly in creating custom functionalities. - Solid understanding of taxonomies and filters within the WordPress environment. - Strong proficiency in PHP, JavaScript, and MySQL. This is a challenging task that requires an adept understanding of WordPress workings. If you pride yourself as someone who can take on such a task, this project might b...
...2- MySQL Db will be installed and used. 3- customer and status (Active/Inactive) B. Insert DID C. Routing DID D. Enable/Disable recording on specific numbers. E. Caller ID set/modify for specific numbers. F. CDR synchronization from Freeswitch to the SQL-based application. G. Delete DID (When DID is going to be deleted then we will delete routing as well). H. Update DID. Note:- Primary key we will use customer ID in all tables. If a customer is inactive then the server will drop the call with the CDR status account inactive. It's crucial to note that all these tasks will initially be carried out on test DIDs. Once testing is successfully completed on both Freeswitch and application sides, we will proceed to migrate live DIDs from the current file to the Freeswitch da...
I have a need for a detailed financial report on profit and loss. Your task would include: - You will be given report query or table schema - You will be given report schema - You need to develop report using Jasper studio, Java springboot, mysql and reactJS front end. - Report details - Pending orders, Order errors, Holding Report, Profit and Loss report. - Web based interface would provide user to give filter for all of above reports to filter user and generate HTML report from which user can download PDF format of same report being show. - Report format shall have header include company name / logo etc...
I'm currently facing an issue where reCAPTCHA isn't displaying on our corporate website, which is built on PHP MYSQL. Ideal Skills: - Experience with PHP MYSQL - Extensive knowledge of reCAPTCHA implementation This project involves: - Analyzing and diagnosing why reCAPTCHA isn't showing up on our site - Implementing a solution to ensure reCAPTCHA correctly displays going forward - Ensuring users can be accurately validated using reCAPTCHA on our site Given your expertise in the field, I'd appreciate your proposal on a potential solution, timeline, and quote.
WordPress Themes and Pugin Create, we are already built in PHP and need WordPre...edit, del ) - Disawar ( add, edit, del ) - Weekly Patti (add/update Panel, add/update open close, Add/ update Jodi) - guessing post (add, edit, spam keyword manages) - Notice ( one signal msg , text update ) - Lucky number ( add 2 types – golden ank – Final Ank ) - Game zone ( Types single triple, Jodi ) - Admin ( add , edit , del ) role for admin mange - Old chart upload ( CSV to upload MySQL DB ) - Settings ( personal details ) password change SEO - Themes - 3.0 connect - Disclaimer (add, update ) - auto_result_api (manage ) - ads manage - sms_settings (WhatsApp API, telegram API) - Content add, update - Website maintenance manage website shutdown mange - Fronted web...
We need help with our Spring Boot backend. We have 2 Entities defined: Client and Dossier. Each client can have multiple dossiers and each dossier can be assigned to one client. Client: @OneToMany(mappedBy = "client", fetch = ) @Getter private List<Dossier> dossi...custom query @Query("SELECT c FROM Client c WHERE = :uuid"), but also the dossiers are fetched. It looks like is not working. We want to manage this behaviour, since we are building an application which handles a lot of data and a lot of JOINs. So: by default just fetch the client. If asked, fetch dossiers and other JOINs, like addresses and phone numbers. Database engine: we tried both MySQL and Postgres, but no result. We want to implement clean and less code in our app...
The selected candidate should possess in-depth knowledge about database development and management, and a profound understanding of GST and loan processing. Skills and Experience: - Proven experience in database development - Proficient in integrating the database - Excellent at manual data entry - Capability to import data from CSV files
I'm seeking an experienced PHP developer with familiarity in CodeIgnitor. The primary objective is to add specific ...Transport Expenses: Include capabilities to produce transport expense reports. While the focus is on transport, the project also includes a fees collection feature. Note, detailed specifications about the fees feature were skipped, more information will be provided during the project discussion. Skills & Experience Needed: - Proficient in PHP - Experience with CodeIgnitor - Solid understanding of MySQL - Experience with online payment integration is a plus Availability is key. I need someone who can start immediately and deliver the project ASAP. Your bid should include your proposed timeline, and any questions or clarifications you might have. Thank you...
...invoices that are professional and compliant with my business branding. - Store data in database - **Invoice Content:** - Each invoice must feature my company name and logo prominently, ensuring a professional appearance. - Client details (such as name and contact information) and product details (including descriptions and individually priced items) must be integrated into the invoice template. Ideal Skills and Experience: - Proficiency in PHP and MySQL, with experience in generating PDF documents programmatically. Note: Already build the application, so client details, products, services details available, only selecting - customer name, products and service based invoice have to generate. Database structured already done. It's a small one day task...
I am looking for a skilled Code Igniter 4 Full Stack Developer to work on part-time basis for a duration of 1 month or more....interfaces and enhance the user experience - Develop and integrate Google Authentication & Maps - Generate QR Code, PDF & CSV - Optimize application performance and ensure scalability - Troubleshoot and debug issues as they arise - Paypal integration Requirements: - Proficiency in Code Igniter 4 framework - Strong knowledge of PHP, HTML, CSS, and JavaScript - Experience with database management systems, such as MySQL - Ability to work remotely and effectively communicate - Detail-oriented and able to meet project deadlines If you are a talented Code Igniter 4 Full Stack Developer and are available for remote work, please apply with your po...
I am currently operating on a Windows system and am seeking a mySQL expert with extensive experience on the InnoDB database engine. This project revolves around the optimization of database performance, ensuring a seamless and efficient system operation. Key responsibilities: - Comprehensive review of our current database structure - Identify performance bottlenecks - Implement efficient database optimization strategies Ideal candidates have: - Deep knowledge and understanding of InnoDB engine - Proven record in database performance optimization - Proficient in Windows operating system. Your expertise will ensure we have a high-performing database that meets our operational needs.
I'm looking for an experienced developer to integrate CRUD operations into my KendoReact Grid using a REST API. Successful execution of the job involves cr...experienced developer to integrate CRUD operations into my KendoReact Grid using a REST API. Successful execution of the job involves creating, updating, and deleting data seamlessly on the grid with NextJS. A MySQL database will be used to store the manipulated data. If you have never worked with KendoReact grids, DO NOT BID!!! Key Responsibilities: - Integration of REST API for performing CRUD operations. - Seamless data manipulation on the KendoReact Grid. - Store data in MySQL database. Ideal Skills and Experience: - Proven experience with KendoReact and REST APIs. - MySQL database...
...previously developed in the old PHP version using MySQL/MySQLi which consists of approximately 275 files. I am currently seeking an experienced PHP developer to upgrade the website to PDO. Regrettably, I didn’t list specific functionalities and design preferences in my questionnaire as I aim to maintain the original features and look, just strengthening the technical foundation and ensuring the updated version runs swiftly, securely and efficiently. My budget is tight so please work with me. Your responsibilities will primarily be: - Upgrade the old PHP version to PDO - Retain existing website functionalities - Maintain website aesthetics Experience and abilities needed for this task include: - Proficiency in PHP and PDO - Experience in MySQL/MySQLi - Stro...
I am in need of a seasoned backend developer who can track user shareing behavior using Blockchain technology into my existing for social media share2earn,view2earn webapp . I have a webapp that allow user to earn coin by engaging on the content which i want to implement sharing mechanism for greater reach. I want someone who can help me implement ability for user to share conten...implemented Please note: that i have frontend dev already Ideal Skills: - Proficient with various blockchain platforms, especially Deso, or Steem, or Hive blockchain - Proven experience as a backend developer - Familiarity with creating and managing social media API integrations - Understanding of content sharing mechanisms on social media platforms Technology Used: Laravel Vue JS Tailwind CSS MySQL...
As the client, I need assistance in creating a PHP website. However, I have not yet specified the required features, the information freelancers should include in their application, or the website's intended purpose. Key Requirements: - Familiarity with PHP and MySQL - Versatility in dealing with various website types and functionalities, as the specifics are currently undecided - Eagerness to adapt to new requests and changes Ideal Application: Freelancers interested in this project should lay out their experience and past work, particularly in PHP. Please submit a detailed proposal for the project, even though the requirements are currently vague, I am open to suggestions.
...among these issues is a bug that arises every time I try to publish a post (critical error). Instead of seamlessly updating as it ideally should, the site ends up crashing. This troublesome bug is hampering the day-to-day operation and management of my site. Desired skills and experience: - Strong proficiency in WordPress especially in debugging and problem resolution - Proficiency in PHP and MySQL which are essential to WordPress customization - Understanding of website optimization concepts, especially in relation to WordPress platform - Proven capability in restoring crashing websites to normalcy Your role is clear-cut: resolve the publishing error so that the site doesn't crash every time I publish a post, make necessary updates and clean up the site. Due diligence ...
I'm looking for a seasoned SQL developer with an extensive background and demonstrated expertise in MySQL. My project involves pinpoint optimization of specific tables in my database system. Ideal candidates should: - Have a mastery of query optimization techniques in MySQL - Have a keen eye for identifying inefficiencies within tables - Be able to implement successful solutions to enhance performance Individuals with extensive experience in analyzing and improving the performance of specific MySQL tables will be more suited for this task. This is not a general optimization assignment; hence, a careful, detail-oriented approach is paramount.
...website, a strong knowledge of user authentication, frontend templating, and database management will be beneficial to the successful completion of this project. What I need from you: - Display your expertise in Laravel and share samples of your past work. - I'm particularly interested in how seasoned you are in this field. - A detailed project proposal will go a long way in making your application appealing. Given that I skipped the main goal of the Laravel project, the ideal Laravel developer will need to be flexible, versatile, and able to adapt to any form of project whether it's building a custom website, developing a web application, or enhancing an existing Laravel project. Expertise in PHP, JavaScript, MySQL, and familiarity with the Laravel ecosy...
Hello We are looking for hotel database having following Name of the hotel/ cottages/ Resort Category 2 star/ 3 star etc Location Reviews Hotel contact no Hotel email I'd I need all verified and in Excel sheet
I am a skilled web designer and developer with expertise in HTML, CSS, JavaScript, MySQL, PHP, and Bootstrap. With a strong foundation in front-end and back-end technologies, I create dynamic and visually appealing websites that are both functional and user-friendly. My proficiency in responsive design ensures seamless experiences across various devices. I am committed to staying updated with the latest trends and technologies in the ever-evolving field of web development, allowing me to deliver high-quality solutions tailored to meet clients' needs and exceed their expectations.
I am currently using WhatTicket with some modifications to suit my needs. Just thinking about scaling I have been having huge problems in relation to the PostgreSQL database which is very slow. I need to change my database to MongoDb so that I gain performance
...experiencing critical errors across 4 WordPress sites, each having different issues affecting its functionality. These range from the notorious White Screen of Death, database connection failure to displaying the wrong theme. Thankfully, I can still access the admin panel on all 4 sites. Here's where your expertise comes in: - Trouble-shooting and resolving each unique error - Ensuring all themes are displaying as intended - Restoring website stability and functionality The ideal candidate for this job: - Has adept knowledge and experience of WordPress sites - Possesses sound problem-solving abilities - Is skilled in PHP and MySQL databases - Able to work meticulously to avoid loss of any website data Your experience gives you a keen eye for finding and squash...
I need help designing a database for sensor logging. and then setup the database at some cloud providers servers. After setup and design, I need performance testing done, so you also need to be able to make a simple script (etc. coded in C#, I will review and compile the code my self) bombarding the server with data, to simulate real life situations. please see attached documents for further details. Database EER file will be sent in PM later in the process.
We're seeking an experienced developer to integrate MySQL with an ongoing Angular project. Our current needs are straightforward: - Our MySQL database schema for this project is simple, consisting of one to a few tables/relations. - The principal intention of this integration is the storage of user data, allowing for a seamless user experience. Qualifications: - Proficiency in Angular and MySQL - Experience with simple database schemas and backend development - Demonstrated ability to efficiently handle user data within Angular frameworks. Ultimately, we need this integration task to proceed smoothly, to keep our development timeline on track. Clear communication of progress and potential obstacles is essential for this role.
...integration with a relational database system (MySQL), ensuring seamless data flow and storage. The ideal candidate will have a strong background in IoT devices, database management, and comprehensive error handling. Key Responsibilities: Design and implement an efficient data transfer protocol from Wemos D1 mini to Firebase, ensuring data integrity and security. Develop and manage NoSQL databases in Firebase and integrate them with MySQL relational tables, ensuring seamless data synchronization and storage. Design a comprehensive error handling system to manage and mitigate data transfer errors, device connectivity issues, and database integration problems. Collaborate with the development team to understand project requirements, contri...
This is a simple, small job. I have a MySQL database that runs a schedule. The schedule works from the recurrence column, with seven numbers (0 or 1). These numbers represent the days of the week (Monday to Sunday). 1s will trigger an event, 0s will not. For example, if the recurrence column has 1000000, the task will only trigger on a Monday. 1100100 will trigger on Mondays, Tuesdays and Fridays There are also fields for start date and end dates. I would like to view on a website what events in the schedule are coming up next. The events in the schedule also have a start and end date. I would also like to be able to add / edit information through the website. Uploaded SQL code. Example table Recurrence Startdate Enddate Descrption 1000000...
There are issues with the automated update of Personal User data in our MySQL database. The ideal candidate for this job is one who: 1. Has outstanding proficiency in MySQL and database management. 2. Has competencies in managing and rectifying update issues, especially within automated systems. 3. Understands data entries associated with user's personal details. In this task, you'll be tasked to diagnose and fix the problem to ensure accurate and prompt updating of data. Past experience dealing with similar issues will be an added advantage.
Hello We are looking for hotel database having following Name of the hotel/ cottages/ Resort Category 2 star/ 3 star etc Location Reviews Hotel contact no Hotel email I'd I need all verified and in Excel sheet
We're in the process of enhancing our custom in-memory database system and require an experienced developer to implement and optimize indexing. Your task will involve creating indexes for improved data lookup efficiency on various columns, beyond the primary key. This role demands a deep understanding of indexing strategies and their impact on database performance. I will share you our existing system as well. Skills Required: Strong proficiency in database design and optimization Experience with indexing and query performance enhancement Knowledge in handling large datasets and memory management Proficiency in Python or relevant programming languages used in our project Familiarity with version control systems, preferably GitHub Your contribution will be...
Hi there, I'm in need of a skilled .NET developer who can dedicate 2-3 hours each day to help with both front-end and database tasks. This is a long-term project and therefore, not being rushed. Ideal Skills: - Extensive experience with .NET - Strong front-end development capabilities - Database management experience There's no specific framework you need to be familiar with, I'm looking for someone who knows their way well around .NET. Your main duties will include: - Working on the user-interface - Managing and upgrading the existing database These tasks likely require daily attention, hence the need for 2-3 hours of consistent effort each day. I am flexible with time and can give remote access to my system for patch work. New development can be d...
I am on the hunt for an expert full-stack developer/network admin with good communication skills and who enjoys teaching others, to provide me step-by-step walk-through tutorials for various aspects of network admin and coding tasks that I need to get done for my own personal projects. To put it simply, I'm an amateur network admin/web dev with a lot of "surface-leve...in explaining complex information in easy-to-understand language is a must, as the end goal is to enhance my foundational and advanced skills in network administration and coding. Looking forward to your proposals! Below is a list of the tech stack I'm currently working with: Web Management: ISPmanager, cPanel, CyberPanel SaaS Platform: Laravel, PHP, WordPress, Javascript, HTML, CSS Databases: MySQL ...
Please see the attached screenshot. I have a stack of sortable <div>s which are pulled from a MySQL database. They are ordered from 1, 2, 3 onwards based on the ID number in the database. I would like to make it so that when you drag and drop the <div>, it updates the MySQL database with the new orders of the <div>s. This is basically a quick jQuery function with Ajax. Opportunities for further projects if well suited.
I need an experienced MySQL developer to upgrade my website's database from MySQL 5.7 to MySQL 8.0. The database is relatively small, less than 1GB. Currently, when we move the site from a server running MySQL 5.7 to a server with MySQL 8.0, the site no longer loads the items from the database. Ideal Skills: - Strong MySQL experience, particularly with versions 5.7 and 8.0 - While I'm not currently interested in any specific features of MySQL 8.0, the new version must be fully functional, and all website features should perform as expected after the upgrade.
