Database scripts jobs

I'm seeking a skilled developer who ...main responsibility on the design front involves refining my site's navigation. This implies that you'll need to understand how the navigation menu is currently arranged and accurately remove specific items. - Database Optimization: I am excited to augment the performance of my website. For this, I require optimal reformation of the existing database structure. This task demands proficiency in managing Laravel databases and an understanding of optimization best practices. The ideal candidate for this project is detail-oriented and exhibits a strong understanding of Laravel, database optimization techniques, and UI/UX principles. Knowledge of the latest design trends and how to selectively prune menus for user-frie...

I need an expert to design a DICOM database specifically for storing and retrieving radiology images. Key requirements are: - Comprehensive understanding of DICOM Standards - Proficiency in database design and administration - Experience in handling medical images, particularly radiology The proposed database should support retrieval of images via Unique Identifier Codes (DICOM's UID). Being well-versed in medical systems integration will be considered a great advantage. This project will require strict adherence to privacy regulations and standards.

I need a proficient data specialist to compile a comprehensive database of Romanian companies. - Compatibility: The database must be compatible with Windows and Mac platforms. - Specific Details: Every company's record in the database must contain the company's name, phone number, and email address. - Extent of Database: Aim for a sizable database that contains information about 100,000 companies. Ideal candidates will have experience in data mining and database management, and an understanding of Romanian market dynamics. Strong accuracy and attention to high-quality data is a must.

I'm looking for an experienced freelancer to create a Postman script t...for without requiring any manual intervention. Here are the key details of the project: - You should be able to simulate entering the email and password, clicking the login button, and retrieving headers for subsequent actions on the front. - Upon successful login, the output data format should be in JSON. Ideal Skills and Experience: - Proficiency in working with Postman and creating scripts for automation. - Strong knowledge of HTTP methods. - Experience with handling and parsing JSON data. - Familiarity with cookies and headers in HTTP requests is a plus. Please note that the successful delivery of this project requires meticulous attention to detail and a solid understanding of web security best pr...

...scriptwriter who can create engaging, research-based motivational scripts for a YouTube channel. Key Requirements: - The scripts should centralize around the themes of personal and business growth. - Rather than a lecture style, interactive dialogue, or purely inspirational story format, I want the scripts to be based on relevant and inspirational case studies; in essence stories with a practical application to viewers. - Each script must be comprehensive enough to fill a 15-20 minute video content. Ideal Skills: - Excellent research skills. - In-depth understanding of personal and business development concepts. - Proficiency writing engaging and motivational content. - Previous experience writing case study based scripts. - Fluent in Hindi. Looking for...

...Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data with target data structures. ETL Development: * Develop and maintain ETL (Extract, Transform, Load) processes using standar...

...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Exp...

...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Exp...

I'm in need of a proficient database specialist to manually collect email addresses and phone numbers, and compile them into an efficient and reliable database system. The leads to be collected are specifically from the Social Media industry. Ideal Skills and Experience: - Proven experience in data collection and management. - Exceptional research abilities, particular in the social media landscape. - Ability to use manual collection methods efficiently and effectively. - Knowledge and understanding of database management and lead generation. - Accuracy and attention to detail in dealing with phone numbers and email addresses. Roles: - Locating and collecting required data from specific direct websites. - Organizing the data into a systematic database...

I'm seeking an expert in Entity-Relationship Modelling and Rational Database Design. Key Requirements: - I need an expert in this particular area. Please only apply if you have a proven track record in both Entity-Relationship Modelling and Rational Database Design. - I'm looking for a high-level overview of the Entity-Relationship Diagram. This means I don't need every minute detail, but rather a clear and concise depiction of the core entities and relationships. - Experience is key. Please share your past work in this field. Ideal Skills: - Proficient in Entity-Relationship Modelling - Experienced in Rational Database Design - Strong track record in this particular project type - Excellent communication and understanding of client needs. Pleas...

...May or early June. - Should have hashtags support, like in Twitter/Insta, if we type hashtag, it should automatically convert it into a link (I will take care of the backend) - Autocomplete links: Shouldn't be difficult, but using regex or whatever you like, when you see a text URL auto convert it into hyperlink - Block tags: Auto block and remove certain tags, like someone is trying to insert scripts, block 'em. Preferrably Inline editor like Gutenberg. The current setup of everything being at top is a bit old fashioned though completely functional. A block-based system with modern inline editor would be really great. - Shortcuts: It should support shortcuts. Obviously things like bold, italics, and underline should work (duh, it should be obvious). But, we also use CT...

I need a skilled individual who can install a PHP script on a hosting platform. The installation needs to be done as soon as possible. I'm in a bit of a rush, so I'm looking for a professional who can quickly and effectively handle this task. Ideal Skills and Experience: - Proficient in PHP - Experience in installing PHP scripts - Efficient and able to work swiftly on urgent tasks

I am seeking a skilled freelancer proficient in JavaScript and HTML. I currently possess a React filter, accessible via this GitHub link, that functions adequately. However, I aim to transform this React application into HTML and JavaScript to ensure compatibility with WordPress. Consequently, I require a freelancer capa...skilled freelancer proficient in JavaScript and HTML. I currently possess a React filter, accessible via this GitHub link, that functions adequately. However, I aim to transform this React application into HTML and JavaScript to ensure compatibility with WordPress. Consequently, I require a freelancer capable of seamlessly rendering this React application into HTML, accompanied by the necessary scripts, and integrating it into a WordPress plugin. App link: ,net

I need a skilled professional to assist with a data entry task. The project involves the following: - The task is primarily image data entry. - The images will be provided in digital photo format. - The entered data should be compiled into a database. Ideal candidates should have experience with data entry, particularly with image data. Proficiency in database management is also essential. A keen eye for detail to ensure accurate data entry is a plus.

...statistical analysis and simulations. The project involves developing and optimizing simulations and calculating probabilities for different theoretical scenarios. Tasks Include: Writing, debugging, and optimizing R scripts to perform simulations and analyze data. Producing clear documentation of the methodologies, code, and results. Ensuring accuracy and efficiency in all computations and simulations. This project requires a focus on R programming and data analysis without the need for creating extensive reports or presentations. The final deliverables will be well-commented R scripts and concise summaries of findings. Skills Required: Proficient in R programming Experienced in statistical analysis and probability calculations Skilled in creating simulations Ability t...

i need someone who are good about create any projects with python especially checkers emails to use for marketing

We are in search of the next flight to build different scripts in Apify. You must have experience with puppeteers and bypassing captchas and using different IPs. Thank you

Join Us: Freelance Faceless Video Script Writer Wanted! Are you a creative storyteller with a passion for YouTube content? We're searching for a skilled Content/Youtube Faceless Video Script Writer to join our team. Requirements: - Experience crafting scripts for YouTube faceless videos. - Ability to deliver 15 to 20 scripts monthly (1200 to 1500 words each Script). - Proficiency in meeting weekly deadlines. - Offer creative and engaging narratives. - Provide a portfolio or examples of previous work demonstrating proficiency in scriptwriting. Benefits: - Flexible freelance schedule. - Competitive compensation: $10 USD per script. - Collaborate with a passionate team. - Incentives offered upon reaching script goals. Below We have Provided Some Faceless Tech Youtube Vi...

...to complex scripts which are currently slowing down the site. Key tasks for this project include: - Identifying and optimizing complex scripts: The primary issue affecting the site speed is complex scripts running in the background. Your role will involve assessing these scripts and making necessary modifications to streamline their performance. - Implementing image optimization: While the primary concern is on the script side, there is also a need for image optimization. In this regard, we are looking for a solution that can automate this process for us while still maintaining image quality. The ideal candidate for this project will have a strong background in Shopify development, with particular expertise in improving site performance. Experience workin...

I am seeking a talented copywriter to help with a marketing campaign for my business-to-business (B2B) radio station. The aim is to attract more B2B clients through engaging radio advertisements and promos. Ideal Skills and Experience: ...for a business audience. - Understanding of how to write for the ear, considering the auditory nature of radio. - Experience in the radio industry or with radio advertising is a definite plus. The project will involve: - Crafting impactful, concise, and clear copy that can be spoken on air. - Ensuring the messaging aligns with the nature and target audience of B2B radio. - Creating different scripts for various radio spots, keeping the overall marketing campaign cohesive. - Revisions and adjustments as needed to fully capture the essence of our ...

...you gave yourself that rating: 1. Wordpress 2. Divi 3. Wordpress plugins (can you or have you ever built one?) 2. SEO experience 3. Javascript 4. Node.js 5. Angular 16 6. API development 7. HTML / CSS 8. PHP 9. Python 10. ERP systems 11. Tailwind 12. TaigaUI 13. Chrome Extensions (please rate yourself and provide any examples you might have) 14. Google Add-on 15. Keyword research tool 16. Web scripts 17. AI / ChatGPT experience 18. Web scraping 19. Logo design Next, please answer these "get to know you" questions: Why are you interested in this job/project? What's your favorite stack? How many & what other projects are you currently working on? Do you work with a team, agency, or as an individual? Why should I choose you? How can you make it better or...

I'm seeki...calculations. Key Requirements: - You must have a deep understanding of Google Sheets and its formulas, particularly complex statistical functions. - Experience creating custom scripts or automation in Google Sheets to interact with Google Docs is a plus. Your main tasks will involve: - Assisting me in creating complex statistical functions and calculations in Google Sheets. - Building custom scripts or automation to interact with Google Docs, allowing for seamless data sharing and manipulation between the two. Ideal Skills: - Advanced proficiency in Google Sheets and its functions - Experience in creating custom scripts or automation - Strong background in statistical functions Please, only apply if you have prior experience in these areas and ca...

We are seeking a team of Database Engineers who can combine multiple sources of data into an Azure MySQL database on an automated basis. The operation must comply with HIPAA regulations under an organizational development environment (VDE). All VM's and databases will be deployed through Azure.

I am in need of an investment website that allows users to buy and sell stocks. Key Features: - Database Integration: This website should include a database to facilitate and record stock transactions. - Buying and Selling: The primary function of this site is to allow users to buy and sell stocks. - User-friendly Interface: The site should be intuitive and easy to navigate, ensuring a seamless user experience. Ideal Skills: - Web Development: Experience in developing dynamic websites with database functionality is crucial. - Financial Knowledge: A basic understanding of the stock market and investment is advantageous to ensure the site meets the required standards. - UI/UX Design: A good eye for design and user experience is important to create an engaging and...

I've built a form, which has around 8 custom fields. However, numerous questions weren't coded using the appropriate HTML form objects and therefore, I'm in need of a developer who can update the form to ensure that it ha...relevant form objects and submits correctly. Once the relevant form objects have been completed a JS script should be written to send the form submission data to a PHP script, where it should be printed. All the while the CSS of the form should be retained. Preferred Skills & Experience: - Proficient in HTML and PHP - Familiar with creating HTML forms - Experience in passing form data to PHP scripts - Knowledge of field validation (since multiple unique fields are involved) - Attention to detail to handle diverse form content successfully. Co...

I'm seeking a Pine Script expert to assist with debugging simple indicators within the next 8 hours. Key Requirements: - Proficiency in Pine Script: Prior experience with the language is essential. - D...within an 8-hour deadline. Your main task will be to identify and correct any issues in our basic Pine Script indicators. This will involve a systematic approach to pinpointing and rectifying any errors or inconsistencies within the script. The urgency of this task means effective communication and prompt delivery are paramount. Your expertise in Pine Script, particularly in debugging simple scripts, will be highly beneficial in ensuring the swift resolution of the identified issues. If you're confident in your skills and can commit to the tight turnaround time, I'...

...this project involves building scripts and automations, mostly complex integrations with multiple APIs. You should heavily use LLMs to code faster and better. We are a team of only developers so can recognize talent or lack there-of. Example of a project: Integrate with Linear's API to build a bot automatically tweeting changes./ Your skills in Node.js will be crucial for creating these scripts and automations. I'm looking for someone who can not only write code, but also think outside the box and come up with creative solutions. Key requirements: - Proficient in JavaScript (please share your github) - Hacker spirit - Strong experience in Node.js - Known how to use AI to code faster - Ability to handle complex automations - Familiarity with building scr...

...WordPress website's database. The primary reason for this is to lower hosting costs. Key Areas for Optimization: - **Back-end Operations Speed**: The site's backend is significantly slowed down due to the large database. I need a solution that will significantly improve the speed of my back-end operations. Data Types to Address: - **User Data**: The large volume of user data on the site is a significant contributor to the database size. I need to find ways to optimize or archive this data without compromising its integrity. - **Media Files**: The site is media-rich, and the files are taking up a lot of space in the database. I need to find a way to reduce the size of these files without compromising the images or videos' quality. - **Logs an...

I'm in the process of preparing a whitepaper that aims to attract investors or partners to our project. In this regard, I'm looking to convert code scripts from my project into text format for inclusion in the whitepaper. Key project details: - I need the code scripts to be converted into a readable and engaging format for potential investors or partners. - The code scripts can be in Python, Java, or JavaScript, however, I'm open to other languages if it can better serve the purpose of the whitepaper. - The primary goal is to clearly communicate the technical aspects of the project in a way that is easily understandable to non-technical readers. - Ideal candidates should have a proven track record of similar projects and be able to provide samples of ...

...and is capable of working under a tight deadline. Key Responsibilities: - Fix navigation issues, which might involve making links work correctly, displaying the menu properly, and ensuring page scrolls function effectively. - Address layout problems, such as making sure all elements are well-aligned and responsive. - Resolve any functionality errors, ensuring that all interactive elements and scripts are working as intended. Ideal Skills and Experience: - Proven experience in HTML/CSS bug fixing and troubleshooting. - Strong understanding of web design principles, including responsive design. - Ability to work efficiently under tight deadlines. - Good communication skills and ability to follow instructions. If you meet the above criteria and are confident in your ability to ...

We need a good database of Qualified and experienced candidates resumes for us to hire in a Megawatt Solar Clean energy project. Database should be live and good up to date database with full Resumes of the interested candidates.

I need a freelancer well-experienced in VBA to automate the generation of reports for my business, specifically in Gmail. It's critical for this project to be completed as soon as possible, and here are the specific needs: - Develop VBA scripts that will automatically generate and send specified reports. - Must have a deep understanding of Gmail infrastructure in order to correctly implement the automation process. - Must demonstrate a proven track record in completing similar automation tasks. Your expertise in ensuring efficiency and accuracy is important. If you believe you're the perfect candidate and can deliver this project promptly, please reach out.

...failure. I require a professional who can: - Evaluate these error messages - Resolve these issues in a time-efficient manner It's critical that all downloads only consist of "zip" and "tar gz" file types from Google Drive. I expect clear communication and updates throughout the progress of this job. The ideal freelancer for this project would have: - Proven track record working with bash scripts - Experience directly interacting with Google Drive through a command line - A deep understanding of error evaluation and problem-solving - Knowledge in handling "zip" and "tar gz" file types. - Understand spanish language for better comunication...

I'm looking for a skilled and experienced professional to create a comprehensive Farsi database for advanced language learning purposes. This database will be used as a refrence for a text generator Ai Key Project Details: - The focus of this database should be on advanced-level language content - Content should include a mix of literary texts, technical documents, everyday conversations, as well as other forms such as books and poems. Ideal Skills and Experience: - Proficiency in Farsi language - Experience in creating educational content, particularly for advanced learners - Ability to source and organize a variety of content types, including literary and technical material - Strong understanding of language learning methodologies and best practices - Familia...

...connection errors that have arisen on my Windows-based Sal server. The server is primarily used for database management. Key Responsibilities: - Investigate and pinpoint the root cause of the connection errors. - Implement necessary fixes to ensure a stable and reliable database management system. Ideal Skills: - Proficiency in Windows server environments. - Extensive experience in database management, particularly in resolving connection errors. - Strong analytical and problem-solving skills. - Excellent communication to ensure the process is transparent and educative for me. Please provide an overview of your relevant experience and your approach to addressing connection errors in database management systems. Looking forward to working with an individu...

I am looking for a knowledgeable freelancer with solid experience in Android development, particularly in the field of business process optimization apps. Primary Requirements: - Implement bug fixes in User Interface and Database Management. - Optimize pages for enhanced performance. Ideal Freelancer: - Should have extensive experience working with Android applications. - Proficiency in UI enhancements and Database Management. - Knowledge of business process optimization apps is beneficial. Please make sure you can commit time to promptly address and resolve these issues. Let's make my app better together.

Project Description: I am urgently...involving atmospheric data analysis. This task requires checking if all project requirements have been met, verifying the accuracy of data analysis, and ensuring the integrity of the outputs. The ideal candidate will be proficient in R programming and able to critically assess both code and the accompanying report. Responsibilities: Review the completed R scripts and report to ensure all project requirements are specified. Conduct tests on the R scripts to verify their functionality and the accuracy of the data outputs. Provide a detailed assessment of any discrepancies, errors, or areas for improvement. Confirm that the analysis methods and results are robust, valid, and correctly interpreted. Document feedback and suggest necessary revi...

I'm looking to automate a series of web scraping tasks using Puppeteer, and wish to build an API to manage and trigger these tasks. I plan to use AWS Lambda to execute these scripts and API Gateway to provide access to the functions. Key requirements for the project include: - Setting up AWS Lambda to run Puppeteer scripts for web scraping. - Configuring those scripts to automate data gathering and downloading. - Creating an API on API Gateway to manage the tasks, trigger the scripts, and return results. -it should bifurcates any social media links on the website - it should return a json with website text, links, social media texts. The ideal candidate would be a developer with: - Experience in AWS Lambda and API Gateway. - Prior work with Puppeteer for ...

I'm looking for an intermediate Excel expert to create a user-friendly database system for managing contacts and tracking outgoing information. Key Requirements: - Develop a simple yet effective database system within Excel. - Design a user interface that is intuitive and user-friendly. - Ensure the system is structured to manage contacts efficiently. - Implement a feature to track when and what information is sent to each contact. What I'm looking for: - A freelancer with a proven experience in working with Excel and developing databases. - An intermediate level of proficiency in Excel. Advanced skills are not necessary, but a basic understanding won't suffice. - Ideally, I'd like the freelancer to have experience in designing user interfaces, or at lea...

I'm seeking professionals to collaborate on a 2D animated Minecraft series. The project is ...animated Minecraft series. The project is set to span four engaging seasons, ideal for a teen/adult audience. The necessary expertise for this project includes: - Anime-style 2D animation: It is crucial that the animation matches the visual style typical of anime. Experience in this specific style is a must. - Scriptwriting: A crucial component of this project is the creation of compelling scripts that align with the Minecraft universe and appeal to teens. - English voice-over: English-speaking animators should also be able to help with the voice-over work for the series, so experience in this area is highly preferred. Please send your portfolio or relevant samples of your work...

...experienced developer with in-depth knowledge of creating and tweaking cookies. Key Tasks and Requirements: - Design and write a single-page script. - The script must efficiently add and modify cookie values. - Ensure compatibility across multiple web browsers, including Google Chrome, Mozilla Firefox, Safari, Opera, and Edge. Skills and Experience Needed: - Proficiency in writing and optimizing scripts. - Solid understanding of cookies and how they work across various browsers. - Ability to work without the need for specific instructions or criteria for adding or modifying cookie values. This project does not require the creation of any specific criteria for cookie alterations. However, a keen eye for detail and robust testing across different platforms is crucial to ens...

...statistical analysis and simulations. The project involves developing and optimizing simulations and calculating probabilities for different theoretical scenarios. Tasks Include: Writing, debugging, and optimizing R scripts to perform simulations and analyze data. Producing clear documentation of the methodologies, code, and results. Ensuring accuracy and efficiency in all computations and simulations. This project requires a focus on R programming and data analysis without the need for creating extensive reports or presentations. The final deliverables will be well-commented R scripts and concise summaries of findings. Skills Required: Proficient in R programming Experienced in statistical analysis and probability calculations Skilled in creating simulations Ability t...

I'm seeking a Google Sheets expert to assist me with creating a dynamic client database with a functional search button and also save and modify button . Key tasks will include data analysis, spreadsheet automation, and formula creation. The database needs to store specific information like client name, accountant name, bank names, and sort, amongst others. Ideal freelancers should have extensive experience in Google Sheets with a knack for complex formula creation and automation. Strong data analysis skills will also be useful for this project. Familiarity with creating searchable databases is highly desired.

So glad you're here! I am on the prowl for a skilled video creator who can bring to life a set of online courses...concepts and procedures in a manner that is easy to understand. 3. **Video Length**: Each video should ideally run for a moderate length of 5 to 15 minutes, condensing information while ensuring comprehensive knowledge transfer. You'd be perfect for this role if you have: - Prior experience creating educational course videos - Excellency in creating detailed animations - The ability to work with scripts and shape them into engaging visuals - A knack for breaking down complex information into digestible content. If this sounds like your kind of gig, let's chat! I'm excited for us to collaborate and create a powerful learning resource aiding self-r...

We already have a database built in Air Table and would like to go back to Access. It would be a fairly straightforward process to see what we have and work to recreate in Access. Prefer English speaking and US resident for ease of communication.

I'm experiencing some issues with my Access database. The data seems to be missing or incorrect. Moreover, I need to add new functionality. The additional function is generating reports. Although I haven't specified the type of reports, I expect freelancers bidding for this project to possess experience in various types of reporting functions. Skills required are: - Proficiency in Microsoft Access - Experience in fixing data errors - Expertise in implementing reporting functions in a database It's crucial that the freelancer grasps the issues and rectifies them, and demonstrates an understanding of database reports functions to add onto the system. Bids from freelancers with relevant experience and skills are welcomed.

Hello, there? I have done the project. We can process as our promise. Is it possible to award? I will wait for you.

As an individual looking for a seasoned developer, I am keen on creating a script to store and show 1000 Telegram IDs as online all the time. This script should ideally: - Keep each ID online 24/7 - Have the capability to run seamlessly on a server (server environment not specified) - Require no specific monitoring for each ID Experience in chatbot scripts and a strong knowledge of both telegram platform and server management are preferred. The script needs to perform reliably and be robustly built, as there won't be constant monitoring of each ID's activities or their online status. A solid understanding of automated systems and online status maneuvering is vital for this task.

Looking For An...with GREAT benefits such as bonuses and raises based on quality work and performance! You will be responsible for writing 1-2 3,500 word intriguing scripts weekly. Below are links to my competitors' channels for you to refer to that will give you a better understanding of the level of quality we need from you. 1. @TriniTEA_/videos Requirements: 1. English expert 2. Reasonable turnaround time 3. In-depth research and accurate information, uses clips and visual evidence to support research in the script 4. Willing to work long-term and grow with the team 5. Has existing experience with other celebrity channels (10 Scripts For $300) Please provide samples of previous work to be considered for the position! Looking forward to receiving your work.

I need a talented Python developer with Selenium expertise to create automated scripts for a series of complex web tasks. Key responsibilities: - Writing Python scripts to automate complex web interactions that include conditional logic - Ensuring the scripts are reliable, efficient and scalable Ideal skills and experience: - Proficiency in Python - Solid understanding of Selenium - Experience in developing automated scripts for complex web tasks - Knowledge of best practices for writing efficient and maintainable automation scripts - Good understanding of web technologies and how they interact, including conditional logic The successful candidate will need to demonstrate their ability to deliver high-quality, robust and scalable solutions within tigh...