Mysql large projects jobs

...test server to production server. 3. ONDC TSL implementation with the vendor. I am in need of a Php yii1 and MySQL expert to tackle some key tasks on my existing project. Immediate tasks include: - Bug fixing: We have some lingering issues that need to be resolved to optimize functionality. - Adding new features: We require new elements added to enrich the user experience, which is currently our area of greatest need. - Improving existing features: Amplify current features for better functionality and seamless user interaction. The successful freelancer should have significant hands-on experience with Php yii1 and MySQL. Only those with evidence of previous, relatable projects will be considered. While all three task forms are important, the focus will be on ...

PLEASE DON'T ASK FOR SAMPLES OF THE GRAPHIC DESIGN, THE LINK BELOW HAS ALL THE FILES AND SAMPLES YOU NEED. I need a large quantity of sticker designs, 1 design per week, 52 designs in 1 year. They are designs for collectible toys. The designs have to be high quality like the samples provided. I have provided the blank canvas PDF along with many samples of the designs. The designs you create must be different than the samples. I need creativity. Here is the file folder with the BLANK CANVAS PDF, many SAMPLE GRAPHICS, and the 6 CAR COLORS. I will need the RAW Photoshop file. Successful winner of this bid will have a contract to produce 1 new design every week. You can view all the files here:

I require a skilled artist to create a gorgeous piece of pen work on a large clear glass frame. The frame should be 16x20 inches in size which provides a good amount of space for your creativity. I want the drawing to be line-pen work. More details: I want a drawing of a young girl (whom I will provide a photo of) drawn in line work with a pen, a drawing of her face and hand holding a rose - it will be a real small rose which I will send into you ! Also, I have pieces of broken glass that I want incorporated onto the drawing in a beautiful way, maybe outlining the girl, maybe covering the rose, up to you... Please let me know if you are willing and able! Please include samples of similar work when applying. This project will require both artistic skill and technical precision, so...

I'm in urgent need of a skilled PostgreSQL DBA to take on various tasks and enhancements in my database system. The database is currently large, ranging from 10GB to 100GB, and requires immediate attention to migrate it to a more scalable solution. Key tasks include but are not limited to: - Database performance optimization - Backup and recovery implementation - Database migration to a more scalable solution - Database upgrade with near zero downtime - Repmgr configuration and troubleshooting - Ora2pg oracle to Postgres migration The ideal candidate should be an expert in PostgreSQL with experience in handling large databases. You should have a deep understanding of database performance optimization techniques, demonstrated expertise in backup and recovery, and a pro...

I'm in need of a clean and simple website capable of bulk SMS sending. The primary goal is to achieve fast and accurate transmission speed. Key Functionalities: - Bulk SMS sending: The site must be able to reliably send SMS in large quantities. This is a core requirement. - Minimalist Design: The site should have a simple and minimalist design, allowing for a user-friendly experience. - High Performance: The SMS transmission speed should be fast and accurate. Skills and Experience: - Prior experience in developing SMS websites is highly preferred. - Expertise in web development and design, specifically in creating simple and minimalist interfaces. - Knowledge of SMS gateway services would be beneficial, although not a strict requirement. Please note that while a specific S...

I'm in need of a talented web designer familiar with SEO strategies, particularly On-page, Off-page, and Technical SEO. My primary objective is to enhance my website's visibility to a business audience. Redesign website to reflect our commercial services of Facilities Maintenance, Signage and Lighting. Create more of a simplified feel (somewhere between Mom & Pop and large group, want to feel like a less expensive option and hometown.) Would like page to be dynamic, if possible, to morph to the city of the searcher. I would like specific landing pages to target the market of LED parking lot lights and Sign work, later I would like to add our facilities arm of Plumbing, Electric, General, HVAC. I would further like to be number 1 for searches in the state of Florida ...

...provided. Project will be developed by Phases(milestones). Selected team will be having opportunity to work for long term! Skills and Experience: - Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Strong understanding of web development principles and best practices - Ability to work on a large-scale project and deliver high-quality results - Excellent problem-solving skills and attention to detail - Database Design & Management: The ability to design and manage a highly organized, efficient database is crucial. Skills that would be beneficial: - Thorough Laravel expertise - Proven track record in creating reporting and analytics solutions !!!*** - Understanding of Gi...

...development platforms such as iOS (Swift) and Android (Java/Kotlin). Experience with cross-platform development frameworks like React Native or Flutter can be beneficial for building apps that work on both iOS and Android. 2. Backend Development: Strong understanding of backend development technologies and frameworks like Node.js, Python (Django/Flask), or Ruby on Rails. Knowledge of databases such as MySQL, PostgreSQL, or MongoDB for storing user data, ride information, and other relevant data. 3. Geolocation and Mapping: Familiarity with geolocation services and APIs for tracking user location and providing real-time navigation. Experience integrating mapping and routing APIs such as Google Maps or Mapbox for displaying maps, calculating routes, and estimating ride times. 4....

Please Sign Up or Login to see details.

...Animal Therapy Nutritionist Services Autism Specialists Required Skills and Qualifications: Demonstrated experience in research, especially within the healthcare or medical sectors. Strong understanding of data collection techniques and database management. Excellent attention to detail and commitment to accuracy. Proficiency in Microsoft Excel or similar spreadsheet software, capable of managing large datasets. Knowledge of data protection laws and a commitment to ethical data handling practices....

Job Overview: We are seeking a detail-oriented and experienced researcher to compile a comprehensive directory of leading doctors specializing in autism recovery for children across London, India, and the US, this...encountered. Requirements: Preferable track record in healthcare research, particularly in identifying medical specialists and therapists. You must be able to provide high quality databases with a proven methodology behind it Advanced research skills, including the ability to use digital tools and databases effectively. Strong organizational skills with meticulous attention to detail. Ability to manage large datasets and meet strict deadlines. No placeholders, just bids to provide the 200 well researched names , No web scrapping this must be a well researched task based...

We are looking for a qualified specialist to test international A2P (Application-to-Person) SMS traffic by generating messages to mobile numbers. I have a large amount of data and am ready to provide all the necessary information and tools to complete the task. The work is very simple, its essence in a nutshell is to generate messages to numbers (I will provide them) with the help of services (I will also provide them)

I'm seeking a proficient graphic designer with a knack for minimalism to create an engaging and straightforward logo for my company, Blue Oaks. Here's what I'm envisioning: - Main Theme: A simple silhouette of a large oak tree on a blue background. I’m interested in exploring different shades of blue, so don't hesitate to present a few options. - Colors: Predominantly blue with a contrasting white silhouette. Note: I'm open to suggestions for a secondary color if you think it could enhance the design. - Text & Font: I've no specific font preference. However, it's essential that the company name, Blue Oaks, is visibly positioned under the tree. The font should complement the minimalist style of the logo, and maintain clear legibility ...

I'm seeking a skilled developer with expertise in React.js, PHP, and MySQL to create an e-commerce website for me. The website will require a shopping module, account module, and a cart. Key Features of the Shopping Module: - Product search and filtering - Product categories and subcategories - Product recommendations Account Module Functionality: - User registration and login - Account settings and profile management - Order history and tracking Cart Module Implementation: - Add to cart functionality - Quantity adjustment - Seamless checkout process I will need the full source code once the project is completed. Experience in e-commerce website development and with the technologies mentioned is a must. Prior work samples or references are highly appreciated. Looking forwa...

I'm looking for a skilled designer who can work in both Canva and PowerPoint. The project involves creating a range of designs for various audiences and purposes. Key Requirements: - Proficiency in Canva and PowerPoint - Experience in creating engaging Social Media Graphics, Presentations, and Marketing Materials - Must be able to tailor designs to suit a variety of audiences including Business Professionals, Students, and Creative Professionals Ideal Skills: - Expertise in graphic design and layout - Understanding of different design types across social media, marketing, and presentations - Ability to adapt a design to suit various target audiences - Excellent communication and collaboration skills Looking forward to your creative input and designs.

I'm requiring an experienced deployment specialist for Odoo 17 on Google Cloud. As a company owner, I possess an active Google Cloud account hence you won't need to facilitate that. For the database system, we'd like to incorporate MySQL, necessitating a strong knowledge in this area. Key skills needed: - Familiarity with Odoo 17 - Expertise in Google Cloud operations - Proficiency in MySQL configurations Cease this opportunity to work on a highly professional project and bolster your profile.

We're looking for multiple competent native English editors to trim content and help us improve English language usage across a large batch of tutorials. Starting with a paid trial. Please bid $18.

...on promoting app downloads. Key Requirements: - Minimalist Design: I'm looking for a modern and minimalist style that is sleek and professional. - Home Page Focus: The main focus of the website will be the home page, with a single scroll design. - App Download Links: The primary goal of the website is to showcase app download links in an engaging manner. - Few Pages: The website won't have a large amount of pages, just enough to present the necessary information in a clear and concise manner. - New Design: The design should be fresh and in line with the current trends. I'm not in a hurry to get this done, so there's no strict deadline for completion. However, I'm looking for a freelancer who can deliver a high quality, professionally designed, minimal...

I'm seeking a skilled developer with expertise in .NET and Angular to take part in my ongoing web development projects. The main goal of the project is to enhance an existing application. Requirements: - Proficiency in .NET for backend development - Strong experience with Angular for frontend development - Excellent understanding of SQL Server and MongoDB databases - Previous work with DevExpress is essential Your responsibilities will include: - Developing APIs using .NET for enhancing the application - Integrating Angular for improving the frontend - Ensuring seamless operation with SQL Server and potentially MongoDB Ideal candidates should have a strong understanding of web development and be able to contribute effectively to enhancing the current state of the applicat...

...a skilled developer who is experienced in both React.js and Node.js to implement an Echart tree diagram in our application. Our project has specific requirements that you need to keep in mind: - Customizable node color and style: I need the freedom to customize the color and style of individual nodes within the tree structure. - Ability to handle large data sets: The tree diagram should be able to efficiently represent and navigate through large amounts of data without sacrificing performance. - Interactive features like drag and drop: The diagram should support interactive features such as drag and drop. The main objective of implementing the Echart tree diagram is to help us in: - Visualizing hierarchical data: The tree diagram should help us represent and understan...

I have a set of 190 images that I need edited. The main task is to eliminate the dirt and blemishes on the photos, making them appear much whiter than they currently are. Key Requirements: - Your primary task will involve removing dirt and blemishes from the images - The final edited images shoul...primary task will involve removing dirt and blemishes from the images - The final edited images should look much cleaner and whiter than the originals - You will need to deliver the final images in JPEG format Ideal Freelancer: - Experience in professional photo editing - Proficient in using tools like Photoshop or Lightroom - Attention to detail to ensure a high-quality finish - Ability to handle a large volume of images efficiently - Understanding of color balance and image brightness...

I am looking for a talented interior designer who can create my portfolio and resume and help in the completion of my unfinished projects. I have several 3D rendering, Sketchup, and Vray projects that need to be completed and incorporated into my portfolio and resume. Specific tasks include: - portfolio and resume making - Creating 3D renderings - Creating Sketchup models - Completing Vray renderings Ideal Skills / Experience: - Proficiency in 3D rendering, Sketchup, and Vray - Experience in creating professional portfolios - Ability to adhere to a minimalist design aesthetic Applicants are required to include examples of past work in their application, especially those related to 3D rendering, Sketchup, or Vray. Applicants with a minimalist design style are preferred.

As an online business owner, I'm experiencing slow loading times, large file sizes, and high server response times on my Wordpress site, and would like to do everything possible to improve my page speed score. To address these issues, I have already implemented some performance optimization techniques, such as minifying CSS and JavaScript files, enabling caching, and compressing images. For this job, I'd highly value your expertise in: - Additional Wordpress page speed improvements - Identifying areas that I might have overlooked - Further technical optimization techniques Being familiar with Litespeed Cache - the plugin I have used - would be a big plus. I am hoping to find a meticulous, experienced freelancer who can quickly and effectively enhance my site's perf...

...model development, and natural language processing to bring an image recognition project to life. Specifically, I'm looking for your contributions to: - Thoroughly analyze large quantities of data and draw insightful conclusions from it - Develop advanced machine learning models to fulfill our needs - Apply natural language processing techniques for improved project outcomes - Design and develop AI models to meet project requirements - Convert AI/ML models into APIs that other developers can use - Perform statistical analysis on big data sets - Manage project infrastructure and the development of AI models and projects - Work with other machine learning engineers, data engineers, and AI engineers to develop machine learning models Below are the qualifications expec...

I am looking for a freelancer to assist me with specific data cleaning and transformation tasks in Microsoft Power BI. Skills and Experience: - Strong proficiency in Microsoft Power BI - Experience in data cleaning and transformation techniques - Ability to work with large datasets Data Output: - The preferred format for the data output is data sets Data Collection: - I already have the data, so the freelancer will not need to collect it.

I'm having issues with my Helios 2 program, which is written in Python. The primary problem is that it's producing incorrect output. Key Project Details: - Program Type: The codebase is for Helios 2. - Language: The program is coded in Python. - Issue: The primary concern is with the output...Language: The program is coded in Python. - Issue: The primary concern is with the output being incorrect. I need a professional who is adept at debugging in Python to identify the root cause of the problem and subsequently correct it. The ideal freelancer for this job must have: - Extensive experience in Python programming - Strong background in software debugging - Previous experience with large codebases - An understanding of the Helios 2 program or the ability to quickly lear...

I'm in need of a talented UX designer to help me bring my product idea to life. It's an early stage concept for a mobile app focused on enabling communication. The demo is to showcase one use case for a new product that helps large scale land owners use satellite data to generate fresh insight about soil moisture levels in order to allocate water resources more efficiently. Key Responsibilities: > wireframe the screens > source photos & icons & digital assets required to make a prototype > create a clean visual look & feel > create a clickable Figma prototype of the use case The level of interactivity I'm looking for is basic - simply click through static screens. Ideal Skills: - Proven experience in UX design - Prior work on communi...

I'm currently encountering connectivity issues with my existing Azure Virtual Networks specifically with connecting to the MySQL database. I have a main Vnet with my mysql database in there. I have a virtual machine in there too which can connect to the database I have a second vnet which is peered to the main vnet. I have a virtual machine in this vnet too. It can talk to the virtual machine in the main vnet, but cannot connect to the database. I need it to be able to, and I cannot figure out why. You can tell me how to do it and I can test, this doesn’t need to be a long project!

...if you contact me I will explain what is missing My project involves interacting with an API (specifically Yahoo Finance) to collect information about stocks or mutual funds. I use the venv environment along with Python to accomplish this task. Subsequently, the goal is to display this data on the screen using React. The application will have a search function that will allow users to access a large amount of information. Additionally, there will be a section where users can enter multiple stocks for comparison purposes. The program will analyze these inputs to determine the best investment option. Additionally, the app includes several display options, such as graphs, to display these comparisons effectively. Additionally, I intend to incorporate a user authentication system. ...

...designer who can create stunning 2D animations and engaging kinetic typography for a premium mobile accessories reseller. The graphics are intended for use in an outdoor LED wall, for brandwareness and product showcase, so visual appeal and visibility are key factors. Key Requirements: - Proficient in creating captivating 2D animations and kinetic typography. - Experience in designing content for large outdoor LED walls is highly preferred. - I will provide 3D video / png sequence for certain timeframe The project is a short one, less than 30 seconds in duration, which makes it crucial for the designer to be able to convey messages effectively in a limited time frame. If you have a strong portfolio that demonstrates your expertise in both 2D animation and kinetic typography,...

...shopping cart feature to streamline the buying process - A product search tool to allow easy navigation and exploration of my wide range of products - A customer review section under each product listing to build trust with potential buyers and encourage sales As the online store will initially feature more than 100 products, the ideal candidate for this job should have prior experience with large-scale e-commerce platforms, excellent understanding of usability principles, and proficiency in the necessary web technologies (HTML, CSS, JavaScript, etc.). For the successful execution of this project, experience in creating visually appealing and user-friendly websites in the beauty niche will be highly regarded. Also, knowledge about SEO and improving website load performance wou...

...professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Basic statistical analysis - Prior experience in medium-sized da...

I need a specialist who can significantly improve the loading speed of my WordPress e-commerce website. • The major issues slowing down my site are large image sizes, render-blocking resources, and slow server response time. • The focus should be on these areas, though any other ancillary issues which may be found should be addressed as well. • Ideally, I'm looking for a professional with extensive experience in web performance optimization, particularly those familiar with the inner workings of WordPress and Woocommerce. • Remember, I'm only willing to pay for achieved results and problem resolution.

...will be retrieved. There are already existing web apps that do this, for example [India fillings search]() [quick company company search]() [MCA portal]() However, these don't allow bulk input. I want users to be able to input a large list of company names and receive an output in a downloadable Excel sheet. Although I initially explored utilizing an [API from ](), I encountered difficulties with downloading data or obtaining an API key, possibly due to issues with their website. but was able to find [this csv file on kaggle](

I consider my self a linux user with more than 10 years of experince. I have having some issues with a linux server running mysql. From time to time it stops responding. I am unable to find the root cause. Therefor i need a linux guru to connect to my anydesk/teamviewer and debug with me till we find the error and fix it. We have various logs in the system so it will be helpful to debug

I'm looking for a creative designer to convert a JPEG image into an AI format. The purpose of this conversion is to allow for further editing, scaling, and color customization. Additionally, I need the designer to create two distinct color schemes for the image: - Green and Light Green - Dark Navy and Navy - Logo font to be changed to Thai Power TP - Make into large resolution file

The task involves modifying an existing STL terrain model to add a raised line that will accurately represent multiple hiking paths on a rugged terrain when the model is manufactured. The hiking paths will be slightly raised above the terrain so they are visible when the file is 3D printed or CNC carved on a small-scale model. The STL file will be provided. The map of the hiking paths will be provided and you will need to accurately overlay the paths onto the terrain model. No text is required, only the lines of the hiking trails. An image of the carved model and map of the hiking trails is attached. Please reply with questions if more information is needed.

Here is a list of zip files on a US Govt website. You must write a Python program that uses a network library to download each zip file on this site, then find each .csv file in the zip archive, and copy each .csv file in each zip archive to a hard drive directory on the local windows machine. The directory will be "C:/MedicareDownloadFiles". The files cover the years 2017 to 2024. You may not hardcode file names ... you must extract the filenames from the above https URL. The fee for this will be $30. You must have it done within 60 minutes. Thanks for participating!

As a large-scale, multinational cold chain company, I'm looking to refine our operations and increase efficiency through the application of artificial intelligence (AI) and machine learning (ML). Key Areas for AI/ML Implementation: - Predictive Maintenance: Using equipment maintenance records to develop systems that can predict machinery servicing needs. - Demand Forecasting: Analysing sales and inventory data and establishing accurate, timely prediction models for better inventory management. - Route Optimization: Using GPS and transportation records to create route optimization models for improved transportation planning. Ideal Candidate: Should have relevant experience in AI/ML implementation, with a focus on predictive maintenance, demand forecasting, and route optimizat...

I'm looking for a professional logo that is easy to read, even from a distance. The logo will be used for billboard signage, business cards, and even on t-shirts. Key Requirements: - Easy Readability: The logo should be clear and legible when scaled up or down. - Versatility: It should be suitable for various applications, from large billboards to tiny business cards. - Simple Graphic: The design should incorporate a simple graphic that represents a pressure washing company. - Company Name: "Lufkin Pressure Washing" Ideal Skills: - Graphic design experience, particularly in creating logos for various formats. - Understanding of the nuances of readability in design. - A strong portfolio that showcases versatile, professional logo designs. If you have experience ...

...publication. I'm searching for an artist to create a unique Tarot deck to my specifications, inspired by the Biblical Gospel verses. I want this project to intertwine elements of spirituality and artistry, to create a beautiful, meaningful tarot deck. I have a 30,000 word book that has gone through a professional edit. And a large publisher willing to talk without an agent. The project specifics include: - Art Style: Sparse, dramatic, sketches, and watercolor wash. - Size: Large size cards (3.5" x 5.75") instead of the usual tarot dimensions. - Emphasized Elements: The deck will focus on Gospel scenarios, symbolic items, and illustrations of Gospel verses. Repeating characters to create cohesion throughout the deck. I see it as quick, dramatic, and spar...

...connect patch cables (provided) to the switch (need screwdriver). 5. Test Internet device provided by ISP and provide our helpdesk with SSID, password. 6. Cameras were already set up by the construction contractor. Need to connect and configure NVR, connect the cameras to jacks via patch cables and work with our helpdesk to configure DVR. 7. A Raspberry Pi PC will need to be connected to a large TV that is used to scroll advertisements. Assist in connecting it to power, LAN and Display port and provide our help desk with access do the device. 8 Remain on site until our help desk confirms that the job is completed. Freelancers who bring the following skills and experience are preferred: - Extensive knowledge and hands-on experience in both hardware installatio...

I'm seeking a highly skilled and experienced Google Ads and Facebook Ads expert to join our team on a freelance basis. The ideal candidate will be proficient in creating, analyzing, optimizing, and reporting on campaigns for our diverse range of clients. Projects will vary in size and scope, and compensation will be based on agreed-upon hourly rates between myself and the client, making the assignments hourly-based rather than per project. The chosen candidate will work closely with me, as I will share information and closely monitor all activities and progress. Regular reporting on planned actions will be required to ensure alignment with project goals and expectations. Applicants must have a proven track record of success in Google Ads and Facebook Ads, with extensive exper...

I'm looking for a skilled graphic designer to create a backdrop banner design for a trade...be able to translate our brand image and key messages into a visually appealing, high-impact trade show backdrop. - Ideal size understanding: The banner dimensions are 102 x 96 x 0.4 inches. You must understand how to work with these specs and make the design pop in such a large scale. - Market understanding: You should have a good understanding of the trade show market and how to design a backdrop that will grab the attention of potential customers. We're looking for a designer with a strong portfolio in similar projects and a good understanding of branding and marketing. Your design needs to be professional, eye-catching, and memorable. If you have experience with trade ...

I'm looking for a skilled developer to migrate our Java-based desktop application onto the AWS cloud. The project involves: - Hosting the existing Java-based desktop application on an AWS cloud instance. - Implementing a multi-user access system. - Integrating a MySQL database component. - Developing a Python-based web interface for users to change settings. The ideal candidate should have: - Proficiency in Java, Python, and MySQL. - Prior experience with cloud hosting, particularly on AWS. - Knowledge of user access control systems, particularly Discretionary Access Control. - A good understanding of desktop-to-cloud migration. - Strong communication skills and attention to detail. We need a developer who can take a Java based desktop application and host it on a...

As a web development team, we have a solid foundation but lack in-dep...web3/blockchain technology. We crave for a senior blockchain engineer to bolster us, especially on Ethereum and Bitcoin projects. • Skills and Experience: The ideal candidate will be proficient in Solidity and Ethereum Virtual Machine (EVM), and have extensive experience developing smart contracts, implementing token creation and integration, minting, and staking. • Responsibilities: The engineer will closely collaborate with our team and jump into our ongoing projects. Long term collaboration is desired. Expect to make significant contributions from sprint planning to deployment. We are excited about the potential advancements blockchain technology can bring to our projects and loo...

I need assistance in extracting or scraping the subscriber data from a large Telegram channel ONLY (NOT GROUP). The ultimate goal is to invite these subscribers to my own channel. Key Deliverables: - Extracting or scraping the subscriber data from the specified Telegram channel - Providing a comprehensive list of the extracted subscribers - Ensuring the subscriber data is ready for easy import into my channel for invitation Ideal Skills & Experience: - Proficiency in web scraping tools and techniques - Experience with Telegram API or similar platforms - A proven track record of handling and managing large volumes of data - Strong communication skills to provide detailed project proposals Please ensure that your application contains a detailed project proposal. Note. ...

Please Sign Up or Login to see details.

I'm after a professional statistician who can assist with analyzing my large-scale survey data. The survey received a university Ethics approval. Key Points: - Data Type: The survey data includes both Likert scale and open-ended questions. It's crucial that you're proficient in inferential statistics for a comprehensive analysis. - Objective: The main goal of this analysis is to help me understand the opinions of the surveyed audience.

I have worked with a designer and now have the step and stl files for an item I would like to move into the mfg stage. Format is 18*24" rougly and 3d print was welded together. Would like to prototype and mfg a few at first then possibly move to large orders. Think of a doggie door basically,