Sql server database project tutorial jobs

...an experienced developer to bring my SQL codes with the triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this project should have: ...

I am seeking a Java expert to build a simple and efficient Java Servlet application that will seamlessly connect to my Oracle 19c database via JDBC. Key requirements for the project: - A Java Servlet application tailored to connect to Oracle 19c database - The application should be able to execute both read and write operations on the database. - The solution should be robust, secure, and optimized for performance Ideal candidate for this project should have: - Proven experience with developing Java Servlet applications - Strong background in working with Oracle databases - Proficiency in JDBC and database management - Familiarity with database read and write operations - Ability to deliver a high quality, efficient and well-documented so...

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

We have an internal database with about 2000 European investor profiles from the last 20 years. I'm looking for a skilled developer to integrate OpenAI GPT to allow users to search for suitable investors in our database without needing to input a specific format, but normal text. the GPT then translates this text into a format of our database and based on a matching / scoring algorithm will select the best 10 investors for our set of 2000. The user should be able to go on our website. ask a question leave an email and get an answer with the top 10 list as an email attachment. That person needs to leave his contact details which will be automatically added to our Zoho CRM with a trigger action to setup a call for one of our sales people. Key Project Deta...

Error establishing a database connection This either means that the username and password information in your file is incorrect or that contact with the database server at localhost could not be established. This could mean your host’s database server is down. Are you sure you have the correct username and password? Are you sure you have typed the correct hostname? Are you sure the database server is running? If you are unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress support forums.

Seeking an expert to restore my website stored on an AWS server. The main goal is to recover lost data; specifically, substantial MySQL database information which unfortunately went missing. Key Skills and Experience: - Experience with AWS and MySQL is critical. - Proven track record of effective database recovery. - Proficient in database management and data retrieval. If you are adept in these areas and can ensure a successful recovery of my data, I would be interested in discussing further.

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

I need a simple app developed using Microsoft Power Apps. Th...the employees in our organization. There are a few reference tables like Project, Category, Expense type, etc and then there is a main table called Expenses which has project, category, expense type, quantity, price as the columns. These tables are currently available as part of my azure SQL database but I am open to suggestions if you want to store this data differently. The main screen would show a list of projects on the left. The right section will show details like total expenses, expense per category chart of the selected project. Upon clicking inside the project you will see a list of expenses. This screen should have functionality to add a new expense. There should also be sc...

I'm looking for a seasoned server administrator to set up a dedicated server for container-based provisioning. My web application will be a JavaScript library-based app, such as Node, , or React. Key requirements: - Proficient in Linux server administration, as the operating system is not yet defined. - Experience with container platforms like Docker or Kubernetes since I'm yet to determine my preference. Operating System: You can use Ubuntu Server, CentOS, or any other Linux distribution of your choice. Web Server: Nginx or Apache HTTP Server. Git: Version control system to manage your website's source code. Node.js: If you're hosting static sites or using JavaScript-based build tools. Let's Encrypt: For SSL/TLS ce...

I am eager to learn about setting up TSplus on a Windows operating system, with a strong focus on understanding Application Publishing. Coming from a beginner's standpoint, I anticipate assistance that can help me comprehend the basics and gradually build upon them. Ideal skills and experience for this task include: - Deep understanding of TSplus and its functionalities - Experience in setting up TSplus on Windows - Proficiency in Application Publishing using TSplus - Proven ability to deliver instructions in a comprehensive, beginner-friendly manner

My primary focus is on YouTube and my aim is to create dynamic tutorial videos. These videos will be centered around teaching software skills. It is crucial that the videos are not simply informative but that they also entice viewers to want to learn more. Ideal Skills and Experience: - Extensive experience with video editing and content creation - Experience with educational or tutorial video production - Familiarity with software instruction - Ability to create engaging and captivating content Responsibilities: - Conceptualize, film, and edit software tutorial videos - Create content that aligns with brand and viewer engagement goals - Review, refine and iterate on videos based on viewer feedback and analytics. Looking for someone who can bring my vision to life...

I need a simple code to conect a accdb file with password in visual basic 6. It´s very simple. I need a code working with Visual Basic 6 SP6 The connection need to be by code.

I need an experienced professional to move my existing website from its current subdomain to the live server on WHM. With missing specific information at this moment, it would be best if you are knowledgeable in various platforms such as WordPress, Joomla, or Drupal for versatility. Your responsibility includes: - Safely migrating the site without affecting the existing content - Assuring the website functionalities are working seamlessly after migration - Resolving any potential glitches after migration Essential skills: - Extensive experience in website migration - Familiarity with WHM - Proficient in WordPress, Joomla, and Drupal - Proactive in solving unexpected problems during and after migration - Strong communication skills Make sure to put forward any questions befor...

I need a skilled web developer who is proficient in HTML/CSS, JavaScript, and PHP to help transfer my custom coded website from the test server to the live server using terminal. Having deep knowledge in server migration, DNS and terminal operations is crucial for this task. The key tasks will include: - Safely transfer all site files and databases. - Ensure site layout and functionalities are consistent with the version on the test server. Please only bid if you are confident in your skills to prevent any downtime or data loss during the migration. Experience in similar jobs will be a major advantage.

data base design (model, sql) 590 laravel auth customized for phone (ALMOST DONE) 2360 Referral logic 2360 referral page register configuration Event Script (creates new even every 3 min will be a cron job for linux) 3540 Additional Pages 2478 { withdrawal page 708 Account details 472 Recharge page 708 Contact us page 826 } Betting Page 4720 includes the following { time and result feature 2000 betting feature 1000 events feature 500 my history feature 500 } Admin Panel 8378 withdrawl 1600 user manage 2000 manage result 1700 past events 800 earnings 1000 TOTAL 21950

I urgently need a professional who can access my Windows Server 2016 VPS and enable the execution of custom applications for me. Due to some technical problems, I am currently unable to open any programs. Key Responsibilities: - Access my VPS server and troubleshoot the issue preventing program execution - Enable the successful execution of the custom applications Ideal Candidate Should: - Have extensive experience with Windows Server 2016 - Be proficient in troubleshooting and resolving technical issues - Be able to work quickly and efficiently to resolve the problem ASAP Please reach out if you possess these skills and can assist me with this urgent task.

I'm in need of a PostgreSQL script that will loop through my table and update certain columns of the rows t...row. This script should be designed to handle the following requirements: - The script will be used to filter and update specific rows based on a static condition. This condition will remain unchanged. - The script needs to efficiently loop through the entire table and update only the rows that meet the specified condition. Ideal skills and experience for this job: - Proficient in PostgreSQL and SQL scripting. - Experience in writing complex queries and scripts for data manipulation. - Ability to understand and implement static conditions within a loop. - Clear communication to confirm understanding of the specific requirements and ensure the script meets the necessar...

I'm in need of a skilled server administrator to manage my Linux server dedicated to web hosting. After moving to Dedicated Server AMD Ryzen 9 we have seen that the server goes down so often and we have to restart it. Key Responsibilities: - Ensure the server is running efficiently and troubleshoot any issues that arise - Manage and maintain the server's security, including setting up a firewall, implementing malware protection, and installing SSL certificates - Monitor server performance and make recommendations for improvements Ideal Skills and Experience: - Proficient in Linux server administration - Experience with web hosting servers - In-depth knowledge of server security measures, including firewall setup, malware ...

I am seeking a Python expert with experience in Django-ninja and Flet to create a comprehensive tutorial on integrating these with ChatGPT. The aim is to build a knowledge bot for educational purposes. Key requirements of this project include: Creating an Interactive Tutorial: - Guide users on how to enhance and develop chatbot capabilities using Python, Django-ninja, Flet, and ChatGPT. Understanding ChatGPT Integration: - Show how ChatGPT can be integrated with Django-ninja and Flet to improve customer support. Skills and Experience: - Advanced Python programming skills. - Solid experience with Django-ninja and Flet. - Familiarity with ChatGPT and AI chatbot technologies. - Strong ability to create interactive, educational content. Please note that Django and Dja...

I need a skilled web developer who is proficient in HTML/CSS, JavaScript, and PHP to help transfer my custom coded website from the test server to the live server using terminal. Having deep knowledge in server migration, DNS and terminal operations is crucial for this task. The key tasks will include: - Safely transfer all site files and databases. - Ensure site layout and functionalities are consistent with the version on the test server. Please only bid if you are confident in your skills to prevent any downtime or data loss during the migration. Experience in similar jobs will be a major advantage.

The Panel must be developed in PHP8, develope...Panel must be developed in PHP8, developed with best practices using PSR. If developed with Framework, Laravel (latest version + AdminLTE) must be used. All libraries used in the project must be in the public domain and if they are not properly updated, a new fork must be created and updated. Multiple user management is your permissions Manage multiple GRE Tunnels servers - Register, Update, Delete - Each GRE Tunnel server will receive a /40 or up to /29 IPv6 allocation. - Each server can deliver different sizes of IPv6 allocations (/56 to /29), in a configurable way. The professional to carry out this project needs the following characteristics: - Linux Systems Administrator - Network administrator - Extensi...

I need a well-structured informational website built. Although it won't be focused on e-commerce, I plan on featuring over a 100 products to keep my users informed about my collection. Therefore, a comprehensive database to catalog these items is essential. The ideal candidate would have: - Proven experience in website creation with a focus on data presentation - Ability to design intuitive UI/UX - SQL or similar database management skills - Strong attention to detail as accurate presentation of all product information is crucial - Experience with JavaScript, CSS and HTML - SEO optimization knowledge is a plus. The timeline for completion is to be discussed. Please include examples of similar projects you've completed in your proposal.

: logo with display menu: select option: Subdomains Directories sensitive parameters 4. SQL Testing 5. xss Testing 1- : (use this open source code) Options: -d, --domain: Specify the target domain. -b, --bruteforce: Enable subdomain bruteforcing. -o, --output: Specify the output file path. -h, --help: Display help information. example subdomain -d -o /home/Desktop/ This option leverages various search engines like Google, Bing, Yahoo, DNSDumpster, VirusTotal, SSL, etc., to discover subdomains associated with the target domain. 2- find Directories: (use this open source code) Options: -u

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

...technically adept developer well-versed in NextJS and Tailwind CSS to create specific pages for my project layout. These include: - Homepage - About page I need a tutorial-type website similar to W3Schools or Tutorial Point, specifically designed in Next.js. For this, I only need the layout, including dummy header, footer, and sidebar. The main focus should be on making the sidebar fully responsive. To explain with a direct example, you can visit w3schools.com. I need a frontend layout where there's a component folder containing files for static sidebar placement manually. In the 'pages' folder, this sidebar should be imported along with the header and footer in such a way that if, for example, I need a tutorial on HTML, there should be a side...

I'm in need of assistance for setting up a PostgreSQL database on my backend GitHub website. The primary purpose of this database is to store user data. Given the nature of my website, it's essential that the database supports concurrent access efficiently. The ideal professional will have: - Proficiency in setting up PostgreSQL databases. - Experience with integrating databases into backend GitHub projects. - Knowledge of concurrent access management in databases.

I need an expert freelancer for the migration of my Trend Micro Apex One server. The current Apex One server, running the 2012 version, is located on-premises and operates with Windows Server 2012. Key Task Elements: - On-premises server migration. - Handling Trend Micro Apex One 2012 version. - Compatibility with Windows Server 2012. Ideal Skills: - Previous experience with Trend Micro Apex One Server Migration. - Expertise in handling on-premises server migration. - Ability to ensure seamless transition with zero data loss. - A deep understanding of Windows Server 2012.

We have existing wordpress woocommerce and C# MSSQL inventory win application db in azure db I am looking for a developer for backend operations and experience in MSSQL, WordPress wooCommerce and API integrations. The primary task deduct stock in azure ms sql stock table when order placed in wordpress woocommerce display item list in woocommerce based on mssql stock table create comand to generate order in inventory system when order placed in wordpress woocommerce Key Skills Required: - Strong experience with MSSQL, WordPress woocommerce, API - Expertise in inventory management system e-commerce integrations who have done same work earlier plesae bid I will share explaining video, if you are able to do than you need to work on remote zoom or ultraviewer plesae let me know...

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

...proficient expert to help establish, configure, and visualize data using a Power BI server. The data for visualization will be pulled from several resources such as SQL Server, SharePoint, Excel Spreadsheets, and Teradata. Key Responsibilities: - Setup and configure the Power BI server - Connect the server to mentioned data sources - Implement interactive data manipulation capabilities into the Power BI reports Ideal Skills and Experience: - Proficient in Power BI server setup - Experience with SQL, SharePoint, and Teradata - Excel data management skills - Competence in interactive data manipulation and visual analytics - Familiarity with report generation and data analysis Please note that this project requires an emphasis o...

I need an experienced Node.js developer to create an automation script for my server deployment. - Automation Task: The script should automate routine server deployments, keeping my operations efficient and consistent. - Server Deployment Activities: The core function of the automation is to handle financial transactions, particularly trading activities. Proficiency in financial systems and trading platforms is necessary. - Financial Transactions: The successful candidate should also have experience with the handling of financial transactions within Node.js applications. The ideal candidate should have brilliant knowledge with Node.js, experience in automating server deployments, and a strong understanding of financial trading systems. Looking to kickstart t...

Are you looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripting, and more. **Why Choose Me?** - ...

I'm in need of a professional who can create a straightforward database with a user-friendly GUI for Windows. Key Requirements: - The database should be able to store and retrieve data efficiently. - It should feature a GUI for easy interaction. Ideal Skills and Experience: - Proficiency in Windows database development. - Prior experience in designing user-friendly GUIs. - Strong knowledge of data storage and retrieval techniques. Please let me know about your relevant experience and a rough estimate of the time and cost required for this project. Thank you.

A reliable database migration specialist (with previous email campaign setup skills) with their own computer and internet to work from home. You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Stud...

I'm looking for someone experienced with Asterisk to help me set up a SIP server for educational and testing purposes. The SIP server will be used with a Jio SIP trunk. Key requirements: - Configure Asterisk as a SIP server on the operating system of your choice - Set up a Jio SIP trunk - Create a demonstration of simple dialing using an open source SIP client Ideal skills and experience for this project: - Proficient in Asterisk server configuration - Experience with setting up SIP trunks - Strong knowledge of open source SIP clients - Good communication skills to help guide me through the setup and demonstration process. My budget is not very high ..

As a beginner level MySQL user, I am seeking someone to sit with me (virtually) for approximately 2-3 hours to aid me in running certain MySQL commands with some provided databases. Beyond this, I need assistance in creating a new database from scratch. The session will be conducted via Zoom, and it's vital that you have the requisite MySQL software and databases already installed on your own device. My needs during the call include: - Writing MySQL commands - Understanding MySQL commands - Creating a fresh MySQL database Ideal freelancer for this task would have a strong command of MySQL and proven experience in teaching or tutoring, as well as excellent communication skills in English.

As an established business relying heavily on a comprehensive tech stack, I'm in need of a seasoned .NET developer for a variety of tasks. Key responsibilities include: - Review and optimization of existing front-end, back-end, and database systems - Ongoing maintenance, troubleshooting, and improvements to enhance system performance Ideal candidates for this project should have prior experience with: - Front-end development utilizing HTML/CSS - Backend technologies such as SQL Server and Entity Framework - A strong grasp of the .NET framework This role is crucial to the successful functioning of our systems, so a proactive, detail-oriented approach and excellent problem-solving skills are must-haves. Your ability to communicate issues and improvements ...

I'm in need of a versatile software that can record video from endo...record video from endoscope cameras and facilitate the creation of a database from each video. Key requirements: - It should be compatible with Windows and Mac operating systems. - I prefer storing the database locally on the same device. - The software must support video formats AVI and MP4, which are the formats the endoscope cameras I use record in. The ideal freelancer for this project should have experience with: - Developing video recording software - Implementing database management systems - Proficiency in working across Windows and Mac operating systems - Knowledge of AVI and MP4 video formats Please submit your proposal with relevant experience and a clear explanation of ho...

I'm looking for a skilled developer to create a Tibia server with specific requirements. I would like one like it Key Requirements: - Multiclient Tibia 13.3 with built-in support for Tibia 10 (magebot, elfbot) - A system similar to with the website at least matching this quality - Integration with new quests and monsters to enhance gameplay - Implementation of cast system - Completion within a month Ideal skills and experience: - Prior experience in creating custom Tibia servers - Proficiency in programming languages necessary for this task - Strong understanding of Tibia gameplay mechanics - Ability to implement new quests and monsters - Experience in creating a cast system - Prior history of delivering projects within tight deadlines If you

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

WordPress & Database Speed Optimization required : 1- Database optimization as one of my plugins is sending queries to DB - some time causing connection Error - or unreachable host Error. 2- Without CDN if possible 3- Including Premium plugin - I have 10 web booster Pro subscription. - If required. 4- Automatic Photo Optimization 5- Permanent solution. 6-Minification - if required. Urgent start up required, who is free and can finish asap.

I'm looking for a skilled Matlab expert who can create an interactive tutorial for beginners. Key Requirements: - The tutorial should focus on simple algorithms and functions. - It should be interactive, with a mix of explanations and practical tasks to reinforce learning. - The material should be specifically tailored for those who are new to Matlab. Ideal Skills & Experience: - Proficiency in Matlab. - Prior experience with creating educational content or tutorials. - Ability to explain complex concepts in a beginner-friendly manner. - Familiarity with fundamental algorithms and functions in Matlab. Your role will be to create a step-by-step guide that is both engaging and educational. The aim is to help beginners grasp these concepts in a hands-on and inter...

I've built a web application using .NET for the backend, Angular for the user interface, and SQL database. Now, I'm looking for someone to help me publish this website on the cloud and make it live. It's a small web app designed for a local business, with a limited number of users (around 15-20). Because of this, I'm aiming to keep costs as low as possible. I'm open to suggestions on which cloud platform would be best suited for this project. If you're interested in taking on this task and helping me get my website up and running, please reach out. Thank you!

I’m looking for an expert with MySQL skills to help me write a query...the sum of items across three tables.. The complexity lies in filtering the said items between a certain date range and by a specific field value. Ideal Skills & Experience: • Proficient in writing SQL queries • Knowledge on MySQL, specifically on data manipulation among multiple tables • Excellent understanding of database design and principles • Problem solving ability to handle complex programming scenarios. Please note, I didn't provide the names of the fields to be summed in each table. So, the chosen freelancer will need to work with me and understand the complex structure of my database in order to pull this off. Therefore excellent communication and patie...

I'm looking for a skilled developer to create a custom Tibia 8.6 server that integrates various unique features, aimed at attracting and retaining a significant player base. Key Requirements: - Development of a Tibia 8.6 server with integrated bot, automatic events, and a custom map containing numerous cities. - Inclusion of custom monsters, additional quests, improved PvP system, cast system, hunted system, and tasks for players. These elements are crucial for enhancing the game's depth, challenge, and appeal. Key Skills & Experience: - Extensive experience in Tibia 8.6 server development, including the integration of bots, event systems, and unique map creation. - Strong understanding of game design and mechanics, particularly in the context of MM...

I am in need of a detail-oriented individual to help with a data entry project. This involves manually entering alphabets into an Excel spreadsheet to create a comprehensive database. For this task, you should have: - Excellent attention to detail, as the entered alphabets should be strictly in lowercase. - Proficiency in Excel, as the data will be used to compile an Excel spreadsheet database. - Ability to work diligently on a potentially repetitive task. Your primary responsibility will be to manually input the alphabets into the spreadsheet with absolute accuracy. As it's vital that each data entry is correct, having strong attention to detail is paramount for this job. Experience in data entry and Excel is a must.

**Project Scope** Seeking skilled Data Analyst specializing in PUBG Mobile to elevate our team's performance using data insights. Project goals: * Performance Baseline: Deep understanding of our team's key metrics (individual players & team stats). * Competitive Benchmarking: Analyze opponents to uncover strengths, weaknesses, strategic tendencies. * Optimal Rotation Analysis: Decipher winning map rotation patterns from videos. Find areas we can improve. * Data-Driven Recommendations: Provide clear report on insights and suggest changes to team composition, drop spots, in-game decisions. **Project Deliverables** * Structured dataset in Google BigQuery with our team's gameplay stats + relevant opponent data. * SQL queries designed for meani...

Please fix my task that we spoke about

...help me with an intermediate level project. The ideal candidate should have experience in these areas and be comfortable starting a project from scratch. I will give you a dump from my MySQL table. From which I need an interactive HTML interface, based on Perl, HTML, HTMX to this table. I need to be able to search, add, edit and delete entries as well as combine two entries into one, all via one HTML::Template file with a single perl script as interface to the MySQL table. I do want an active submit button for all changes, as well as a single interactive upload button for each field of the MySQL table. also each field needs to be validated via a given specification. All code needs to be well documented and commented. Perl based database interaction needs be "...

... Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experience in creating forms in MS Access - Ability to understand and implement a specified design for forms - Strong attention to detail and commitment to delivering high-quality work This is an ongoing project, so a commitm...