Mysql latvian jobs

I am urgently in need of a SQL expert proficient in MySQL. I require assistance with writing data definition queries. Work Expectations: - Writing proficient data definition SQL queries. - Extensive knowledge of MySQL. Below is my query. Need to modify the query and get the count as 0 for the column srce_syst_paty_i SELECT COUNT(*) FROM ( SELECT CASE WHEN PATY_IDNN_BK LIKE '%SAP%' THEN SUBSTR(PATY_IDNN_BK, INSTR(PATY_IDNN_BK, '+') + 1) WHEN PATY_IDNN_BK LIKE '%BCB%' THEN SUBSTRING_INDEX(PATY_IDNN_BK, '~', -1) END AS srce_syst_paty_i, * FROM dev_enr.cpln_svrq_paty_detl WHERE day = '02' AND month = '06' AND year = 2023 ) src INNER JOIN ( SELE...

Please apply only if you are willing to work on Zoom screensharing only. This is long term project lasting for years. Must have good skills in Javascript, PHP, Mysql/Nosql database and API integrations. As the person in charge of this project, I am seeking a skilled PHP/Javascript developer to handle various tasks, including: - Database integration: I anticipate needing to ingest, organize, and manipulate data regularly. Therefore, you'll need strong database skills with a focus on integration points between the site and the back-end databases. - Custom coding: We anticipate some unique challenges in the development of our website that will call for custom codes. You should be a problem-solver who can think on their feet and write custom code as required. For this project, ...

...is crucial for creating the user interface components and ensuring a responsive design. Knowledge of React.js is recommended for dynamic updates and interactive features. Backend Development: Experience with Node.js and is necessary for building the server-side logic and RESTful API endpoints to handle user requests and data manipulation. Database Management: Skills in working with MySQL for storing and retrieving trade data are essential. Understanding database schema design, querying, and optimization techniques is necessary for efficient data management. Authentication and Security: Familiarity with JSON Web Tokens (JWT) for user authentication and implementing secure authentication mechanisms to protect user data is required. Real-time Updates: Knowledge of WebSockets fo...

i have a mysql query i need to add some JOIN or WHERE / AND condition i tried but not working help call first to show the issue then once i award u u will work in real time live must be done realtime live

I'm in immediate need of a skilled php mysql html5 javascript developer to finalize two forms for my php script. The purpose of these forms is for invoice information capture. Ideal Skills: - Proficiency in PHP, MySQL, HTML5, and JavaScript - Experience in form creation and data management - Quick turnaround time Please note, as this is urgent, I need the project completed ASAP. Looking forward to your bids.

Fair Playfields is a web-based sports match management system designed to streamline the organization and coordination of sports events, like football. The platform aims to provide a user-friendly interface for players, organizers, and administrators to ma...resolving queries. Performance Tracking: Develop a performance tracking system to record player statistics, match results, and personal ratings. Allow players to view their performance history and compare their stats with other players. Technology Stack: Backend: PHP (Laravel framework preferred) Frontend: HTML, CSS, JavaScript (with a modern frontend framework such as React or Vue.js) Database: MySQL Authentication: JSON Web Tokens (JWT) or OAuth for secure user authentication Version Control: Git for code management and col...

I'm in need of a SQL expert who can assist with some tasks on my MySQL database management system. The exact tasks are still being finalized, but it is essential that you have a wide range of skills and expertise in the field. Here's a potential list of tasks you might be working on: - Query optimization - Database design - Data migration Ideal Skills: - Extensive understanding of SQL and MySQL - Previous experience with query optimization, database design, and data migration - Strong problem-solving ability When applying, please ensure you include details of your past work. I'm keen to see examples of SQL tasks you've successfully completed, specifically in MySQL. Please be as comprehensive as you can be in your application. Your prior experi...

Does anyone have a license for Stellar Repair for MySQL (Version 8+). I need you to recover a DB for one time use. Please start with "stellar" to be considered

I am seeking an experienced HTML5 (or REACT) and JavaScript developer to create a user registration, login (with change and forget password) system and one special form for my project. It should be simple, clean, and user-friendly. Your respon... clean, and user-friendly. Your responsibilities will include: - Creating a user registration and login interface. - Implementing change and retrieve password functionalities. - Designing a special form with moderate complexity, including validation and rules. - Designing MySQL database structure - APIs to communicate between UI and MySQL database The ideal freelancer for this project should have extensive experience in: - HTML and JavaScript programming. - Developing user-focused interface designs. - MySQL Database ...

I have a similar project that I could use your help on. We need to sync QBO customer records into MySQL. Is that something you'd be interested in helping with as well?

I own a Python script that I want to transf...Python script that I want to transform into a SaaS-based web application. I am seeking a Django developer with experience in user authentication, authorization, and MySQL database integration. The finalized application should offer these capabilities: - User Authentication & Authorization: The platform needs to include secure access for both admin and subscriber roles. Admin users should have higher privileges compared to subscriber users. - Database Integration: The application should be integrated with a MySQL database to manage and store user data. The ideal freelancer should have a solid understanding of Python, Django, MySQL, and user access control mechanisms. Experience in creating SaaS applications will be co...

...desire a more unique look that separates my marketplace from others. - Enhancing User Profiles: Users should have more detailed, functional profile spaces. Web: Seller: Admin: Ideal freelancer should have knowledge and experience in advanced search functionality techniques and user authentication systems, full stack developer, PHP, mysql, backend php, laravel, working with custom scripts. Preference will be given to those with direct experience in similar projects and a thorough understanding of full-stack development. Applicants are encouraged to provide a resume, a portfolio showcasing previous work, and specifically highlight any experience with freelancer marketplace platforms or related projects. Important: Looking for a

...proficient in HTML/CSS/JavaScript, PHP/Python/Ruby, MySQL/PostgreSQL/MongoDB. It's a feat if you've dabbled in the realms of DevOps Engineering and API Development. Create a secured, scalable and user-friendly Pentesting platform where users can register, authenticate, and scan their websites for active/live IP, website, hostname, server, workstation or laptop. The platform will interact with OpenVAS for scanning and then filter and present the reports in an accessible manner within the user's account. The scanning operations are managed through a RESTful API hosted on a VM. Ideal Skills: - Expertise in HTML/CSS/JavaScript - Proficiency in backend languages such as PHP, Python, Ruby - Familiarity with database technologies like MySQL, PostgreSQL, MongoDB...

Thank you for looking into my project. I'm in urgent need of an expert PHP and SQL Developer who can assist me with my PHP code file. You...I'm in urgent need of an expert PHP and SQL Developer who can assist me with my PHP code file. Your primary task would be: - Extract the UPDATE queries from my existing PHP code file. Create the sql quart form the pho file. The freelancer I am looking for ideally has: - A strong background in PHP and SQL - Extensive experience extracting and optimizing SQL queries - A deep understanding of MySQL databases Please submit your proposal detailing your experience with the tasks listed above and how you plan to accomplish it. Your ability to communicate clearly and effectively will play a factor in who gets awarded this job. Looking f...

...transportation reality. Both reports should include data about the Monthly fee collection. The successful freelancer will ensure that this information is accurately recorded and retrievable in a breeze. I require this project's completion ASAP, so a demonstrated ability to deliver on tight schedules will be a major advantage. The ideal freelancer should have significant experience with PHP, MySQL, and particularly the CodeIgniter framework. Please place your bid only if you think you can flawlessly handle this project's requirements. I look forward to reviewing your proposal....

I'm in search of a seasoned Laravel/Vue Developer for a custom application project. This project requires both full time and part-time developers, and specifically those with a minimum of three years experience. Key Responsibilities and Experience: - Expertise in Laravel, Vue3, MySql, MariaDB, Linux - Capability to implement user authentication - Experience with payment gateway integration - Ability to implement real-time chat functionality - Proficiency in working with MariaDB The developers should be able to leverage these skills and others necessary to create a custom application. Only individuals with proven track records in meeting these specifications should apply. I look forward to seeing your proposals and discussing the project further. Please provide your quote, 1)...

Working as an Software Development Intern at Simplyphi. skills used: mysql, xml, .net, c#

I am in need of a talented developer who can design and build a RESTful API with a focus on several specific functionalities. As the ideal candidate, you are skilled in multiple programming languages (Python, Java, JavaScript) and databases (MySQL, PostgreSQL, MongoDB), in order to deliver the best fitting solution to our needs. The central features that the API should possess include: - User authentication: An integral feature to ensure only verified users gain access - Data encryption: To secure the data and safeguard privacy - File upload/download: This functionality will aid in seamless data transition The idea of the job is to create an interface with our internal système to the format data in a simple an easy to understand format for the web. To do so we ex...

I have a SWIFTUI file created in Xcode. The purpose of the file is to click on an annotation displayed on the map (already done), and then when clicking on the info, a detailed view appears (already done also). This works. The problem i'm having is that it seems like it works for ONE (1) annotation, but not the others. And sometimes picks up random data. Looks like the declaration isn't made in the right place, but cannot find out where. Essentially i would need the detailed view, to be a UIView opening a URL with the variable (ie : location name) passed to the link. I have attached the JSON file and the Swift file as well. Thanks

Required skilled developer who specializes in payment gateway integration. Our tech stack is pHP, CI and MySQL - Implement Braintree Drop-In formobile app and website to accept online payments - Safeguard the site access to ensure users' financial information are securely transacted - Design an intuitive and user-friendly process Time is of essence and require this to be designed and completed within 3 day of award with testing to follow and bug-fixing. You will design and submit each of the 3 scenarios and testing will start for each use case as its completed.

## Automated / copy - paste bids will...## Open for freelancers from INDIA only ## Fullstack MERN Developer Mid-Level (5-7 years) Requirements:  Experience with front-end code in HTML5, CSS3, JavaScript, ReactJS or similar.  Experience in frameworks such as , NestJS, or proven ability to learn on the job.  Exposure to collaboration tools like GitHub, JIRA, Confluence.  Understanding of Sql and NoSql Databases i.e., MySQL, Mongo DB etc.  Proven track record of building scalable, high-quality software solutions.  Experience of working at a product-oriented company.  Thorough understanding of agile software development methodology, and ability of proactively manage task, projects and issues.  Experience with Elasticsearch, Redis, Memcached will be a plus

...FluentNHibernate MySql Server WCF Services GItHUB for source control Azure hosting on dedicated server. The website consists of a client accessible website for sales, support and information. Also a backend admin section where customer accounts are Services are also used for secure communication with Windows Client Software. We require an experienced full stack developer with experience in the above technologies to - Upgrade the various components in the projects from NuGet to the more recent versions of the frameworks e.g. .Net, Nhibernate, etc etc - Upgrade to MySQL 8 - Set up a working Development Server on Microsoft Azure with Visual Studio, IIS Web Server, MySQL Database and required configurations - Set up a working Test Server on Microsoft Azure with Web...

I am looking for an experienced Full Stack developer who can create an e-commerce like site based on Node.js backend and React.js frontend with database as MySQL (I am ok with Laravel backend but if you can commit website speed) with all standard security features and with some custom features. Specifically, the custom feature I want is a customized "add to cart" feature that allows multiple users to buy together for a group deal. Key features you will need to implement include but are not limited to: - Need Mobile phone and website both views. - SEO friendly URLs - Easy One page checkout process - User and Vendors login using a phone number and OTP - Payment gateway integration - Admin dashboard --( Full privilege) - Supervisor dashboard --( Limited privilege) -...

...://:// • To build a similar website to Datapad, you will need to have some skills and tools, such as: • A web development framework, such as Laravel, Django, or Ruby on Rails, to create the backend of your website and handle the logic, data, and security. You will also need to choose a database, such as MySQL, PostgreSQL, or MongoDB, to store and manage your data. • A web design framework, such as Bootstrap, Tailwind, or Materialize, to create the frontend of your website and handle the layout, style, and interactivity. You will also need to use HTML, CSS, and JavaScript to create the web pages and elements. • A data integration platform, such as Hevo Data, , or Zapier, to connect and

I'm currently seeking a technical leader with a diverse set of skills that include web development, mobile app development, and database management. The main goal of this project is to manage and optimize a MySQL database. Your tasks will include but are not limited to: - Optimize MySQL database to improve efficiency and speed - Develop and troubleshoot mobile apps - Craft beautiful and responsive web interfaces Ideal candidates are those with extensive experience in: * Web and mobile app development, particularly in fluid, responsive designs * MySQL database management and optimization * Interest in leading technical projects. This role requires a self-starter who can collaborate with my team, manage projects independently, and deliver on timelines. Expres...

My Wordpress website is curr...details concerning the project: * The error revolves around the database connection * I have not checked my database credentials in my WordPress configuration file * So far, no recently updated plugins, WordPress updates or modifications to the MySQL database seem to have caused the issue * I'm seeking someone with extensive knowledge of AWS, Wordpress and MySQL to solve this The ideal candidate for this project would have: * Proven experience in troubleshooting and resolving database connection errors * Extensive expertise in AWS, WordPress, and MySQL * Ability to effectively communicate the root cause of the problem and its resolution. Your help, time, and expertise on this matter will be greatly appreciated as time is of the ess...

I'm currently dealing with a PHP and MySQL errors in 2 different files that urgently needs to be resolved. - In the first file, I get the following error message: Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 8192 bytes) in ........ on line 71 - In the second file, i get a timeout error message sometimes, but not always. The content takes very long to load though. The problem requires an experienced PHP developer with strong diagnostic skills, who is not averse to confronting an undefined problem. As the issue and error message arising from running the PHP code are uncertain, applicants should be: - Highly proficient in dissecting PHP errors and MySQL queries - Capable of troubleshooting and fixing a range of PHP errors, such as Pa...

...significant Oracle to MySQL database migration. My existing database is extensive, well above 10GB, and encompasses structural components including schemas, data, stored procedures and triggers. Key elements of the project include: 1. Migrating Schema/Data: Careful movement of all schema definitions and data is essential to ensuring seamless transition without loss. 2. Transferring Stored Procedures: Stored procedures currently in place within the Oracle database will need to be assessed and recreated effectively in the MySQL environment. 3. Triggers Implementation: All triggers in use within your Oracle setup will also require migration. While the size of this project is substantial, there's no need for top-tier performance once everything's migrated ove...

I need a serious PHP developer to do some work on my SMF 2.0(.17) Forum Software. The URL of the website is If you are not familiar with SMF you can find an unaltered Stock Version to download here: ;filename= But please note: MY SITE IS HEAVILY CUSTOMIZED. That is why I need a seasoned PHP developer. I do not wish to waste your time nor do I wish you to waste mine. Therefore: 1. This project is for expirienced PHP developers only! This software is written in PLAIN PHP. NO FRAMEWORK! If you are a WordPress, Magento etc. developer then this is most likely NOT your cup of tea, you have no clue of how a message board / forum works then this is not your project. 3. No coders from India please. My expirience with Indian coders was bad 99% the time and I am not on a trip to look for th...

I require an experienced MySQL expert to help with data recovery. My database, which primarily held transactional data, has become corrupted, and unfortunately, I don't have a backup. Specific requirements are: • Expertise in MySQL data recovery, especially with transactional databases. • Demonstrated experience handling corrupted databases. • Must possess solid problem-solving skills to determine the source and extent of the corruption. • Ability to take immediate action is essential as the data is quite critical. Please note that this is an urgent request so the ideal candidate should be ready to start immediately and provide regular updates.

...candidate should have a minimum of 8 years of hands-on experience in JavaScript and a strong proficiency in the following technologies: NWJS, NodeJS (backend) JS, TypeScript, HTML, CSS, JQuery, MYSQL, WordPress, and AWS. The candidate should possess excellent communication skills, both written and verbal, and be capable of working with minimal supervision. Responsibilities: -- Develop and maintain robust and scalable SaaS and desktop applications using NWJS, NodeJS, JavaScript, TypeScript, HTML, CSS, and JQuery. -- Ensure the technical feasibility of UI/UX designs and implement them accordingly. -- Work with MYSQL databases to handle data storage, retrieval, and manipulation. -- Utilize AWS services for deploying and maintaining applications in the cloud. -- Manage and e...

...management, user interface design, and system integration. The ideal candidate will have prior experience in developing similar solutions and a portfolio showcasing their work. Requirements: Proven experience in developing ERP, CRM, and/or Asset Management software. Proficiency in relevant programming languages (e.g., Java, Python, C#). Strong understanding of database management systems (e.g., MySQL, MongoDB). Ability to design intuitive user interfaces. Experience with system integration and API development. Excellent communication skills and ability to work collaboratively. Responsibilities: Develop comprehensive ERP, CRM, and Asset Management software solutions. Collaborate with stakeholders to gather requirements and define project scope. Design user-friendly interfaces ...

Project Overview High quality web scraping script required to scrape data and images off specific webpages & store data of each listing & new listings in our existing MySQL DB. The script essentially monitors for new listings on various pages & scrapes this data. Then we also need 2 simple API endpoints that output data from the table in simple application/json format.

I'm struggling with performance issues on my Moodle platform. Specifically, I'm encountering error messages during usage, especially http error 500 which denotes server errors. This indicates a likely issue concerning site performance. • e...which denotes server errors. This indicates a likely issue concerning site performance. • error issue: The site is not functioning as expected resulting in http error 500 indicating a generic server error. This makes the website unusable. Knowledge of troubleshooting server-related issues will be ideal for this project. I am looking for someone with expertise in Moodle, softaculus PHP, and MySQL. Experience with server handling and debugging is also necessary to identify the root of these problems and restore the site ...

I am looking for an experienced PHP (CodeIgniter) & MySQL developer to create new modules and functionalities for my existing web application. We are looking for a collaborator, an expert in PHP (CodeIgniter) and MySQL, for a long-term collaboration. This collaboration involves the following: 1. Modification of some modules from existing applications - in the sense of adding custom menus/functionalities. CodeIgniter only. 2. Creating new applications (from scratch)t. CodeIgniter only. 3. Availability for a minimum of 16 hours per week. 4. Accepting that the work be supervised through AnyDesk (or similar) - first of all, to be able to intervene in real time in this custom programming 5. Our collaborator must be an expert in CodeIgniter. In other words, we will not pay f...

I am in need of a specialist proficient in mySQL workbench and API integration. The main goal of the project is data retrieval from an external web service. 1 coingecko API connection paid plan 2 import daily data into MYQ workstation We use remote Windows desktop. The freelancer needs to ensure maintenance, testing and improvement of this data retrieval API after the initial set-up is done. An ideal candidate will have solid experience with similar projects and advanced knowledge of mySQL workbench, API and JSON. Payment $200

I'm currently in need of assistance with a MySQL query task; specifically how to make use of a subquery in order to yield accurate results in a Select statement. The main purpose here is to fetch data. **** All SQL files are attached to the files for this project. What I am Seeking: Help with the attached query. The query joins two tables. A header and details table. The intent of the subquery in this statement is to find/match a SINGLE "Invoice Date" value in the inv_details table that matches a "PO Date" from the po_details table in the subquery using the main queries currently matching "item" , "ship to city" and "customer name". Using "distinct" in the subquery generates an error (subquery returns more than on...

I'm seeking an expert in Google Form and database development. I need a Google Form created that automatically fills in the city, state, and P.O. details ...not been predetermined. 2. Set up and populate this new database with customer details. 3. Develop an automated system on Google Form that will pull specific data from the database when the customer enters their pincode. The ideal candidate should have an extensive background in database development and implementation, Google Form automation and expertise in one or more database tech such as MySQL, PostgreSQL, or MongoDB. The ability to work independently and problem-solve is crucial. Please apply if you have the right set of skills and experience. Not sure about a few details for this project? I'd love to discuss ...

I am looking for a Laravel expert to aid with the implementation of multi-authentication in my application. Key Requirements: - Profound Laravel experience: You should have extensive knowledge regarding Laravel framework, its functionalities and how to leverage them. - Expertise in User Authentication: You should have previous experience with implementing various types of user authe...backoffice site where backoffice user can access and administrate players. i want to re-use laravels auth function for both user types so that it uses same table for user authentication but i dont want to modify the internal laravel controllers too much, since it will break system when you upgrade laravel. my dev environment is laravel herd. my prod environment is laravel forge,running (octane/redis/...

I am in urgent need of a proficient backend developer. Your main task will be integrating my project's frontend with the backend. Please, it's important you have proficiency in: - MySql and Mongodb database technologies, as both will be used extensively - Setting up integrations with frontend technologies such as React, Angular, and Vue. Experience with Postman API and Node is highly essential. Your expertise in these areas will make the integration process seamless and enhance the overall functionality of the project. A strong knowledge of server settings will also be a great asset. If you possess these skills and technologies, then this could be your next successful project! I’m excited for us to collaborate on this exciting task.

For my company, I am searching for a highly competent freelancer or organization to design a MySQL database. My requirements are as follows: - The first priority is to be able to securely store and retrieve data efficiently and effectively. We're dealing with over 500 tables and data points, so the design must be optimized for extensive data handling. - Second, the database should be capable of analyzing the data and generating reports. Thus, applicants with a strong background in data analysis will have an advantage. - Last but not least, the system must integrate perfectly with our existing systems to allow smooth data transfer and operation. Skillset and Experience: - Proficient in MySQL DB design, data modeling, and optimization - Skilled in data storage a...

In my project, I'm seeking a Docker expert skilled in creating and configuring custom Docker images per my...configuring custom Docker images per my specific requirements. Key details include: - Operating System: The process will be conducted on Linux, so a great understanding of this OS is necessary. - Docker Compose Version: I require the latest version of Docker Compose to guarantee the up-to-date functionalities and securities. - Custom Docker Images: Unlike using preset images like NodeJS, Ruby or MySQL, this project demands the creation of custom Docker images. Your proficiency in Docker Compose and Linux, along with your expertise in creating custom Docker images will be integral to this project. Competence in problem-solving and working under minimal supervision wil...

simple work, i need correct this component and make adjust perfect to mobile view, easy task, se picture for understend about i talking. and need fech the rest of tables in the database (i will geve u full database whit the data for do the job more easy) IF DO A FAST AND GOD WORK WHE HAVE MORE JOB ON THIS PROYECT PHP 7.4 MYSQL BOOTSTRAP DESIGN

I need a proficient developer to create a migration script for my PHP-based freelancing platform (WordPress). This task entails resetting the trial date for all users currently on the platform. Key tasks involve: - Spotless understanding and execution of PHP and MySQL - Generating a script to reset every user's trial period to a span of 5 years Experience in working with PHP and MySQL databases is a must. Please, an understanding of freelancing platforms and user management would be highly beneficial. This project requires precision and attention to detail to ensure every user's trial date is updated correctly without causing interruptions to our platform.

A new classifieds site in Laravel wants to USE the database data from an old template. I need you to COPY the old data to the new database. Create (if necessary) new fields and connect each of them to the new template already installed. All information from the old database needs to appear in the new Laravel template (front and also in the admin). 1) Example FIELDS: 2) Attached are the two database models: old and new 3) Please, your final bid price! Regards, Ramos.

setup linode server with phpMyAdmin and MySQL for laravel.

...duration of stay of the reservation. If there are no rooms available, then notice the user about that. When these rooms are displayed, make sure also display images for different type of rooms available. It shall list price per night and the total cost for the stay period. A user can choose the room type they want. The information of the available rooms shall be retrieved dynamically from your backend MySql database rather than hard code. After user submit the request, your system should store reservation information to your database. There is a confirmation page which contains fields for user to enter his/her name and correspondence information such as address, street name, city, state, phone number, email address. The room type, stay period and cost of the stay will be summariz...

I am in need of a PHP developer with extensive knowledge and experience in Inventory Systems, particularly Stocky Full POS and MySQL DB. The task will include: - Hiding the "Cost" column on the following pages: "Purchase", "Products" and "New Products". - Adding a "New Report" button that can read data from MySQL DB, specifically for Super Admin usage. This task needs to be completed as soon as possible. Ideal candidates will have: • Proven experience with PHP, specifically relating to Stocky Full POS. • Extensive knowledge in MySQL DB. • Good understanding of user roles and permissions, especially Super Admin functionalities. • Ability to deliver quickly and efficiently. Your proposal should...

I require a highly skilled System Administrator with extensive knowledge of Magento 2, Linux, and MySQL. Your tasks will be to: - Install Magento 2, elastic search and import code and DB into new server. - I'm open to your recommendations on the Magento 2 version that would best suit our project. Successful applicants should have: - Proven experience with Magento 2 installations - A deep understanding of Linux server management Please, note that effective communication and strict adherence to deadlines are crucial for this project. I'm looking forward to your bid.

Please Sign Up or Login to see details.