Oracle database administrator tutorial jobs

...our Oracle 19c database through JDBC. The primary goal of this project is to incorporate essential data operations into the application, mainly including reading, writing, and updating data in the database. Key Responsibilities: - Establishing a secure connection to an Oracle 19c database using JDBC. - Implementing CRUD operations (Create, Read, Update, Delete) features within the application. - Ensuring the application is optimized for efficient data handling and processing. Security Requirement: - The application must be able to securely access the database using username/password authentication. Ideal Candidate: - Proficient in Java and Springboot framework development. - Experienced with Oracle database SQL and JDBC connect...

I'm currently seeking an Oracle SQL developer with exceptional proficiency in creating logics. This task requires: - Writing an SQL code for data extraction purposes. - The code needs to be written as quickly as possible, with a time frame of 1-2 hours. - The solution should deal with the joining of multiple tables and creating doing some further order by, group by codes Decent knowledge of Oracle and experience in handling similar tasks would be ideal for success in this project. Your ability to deliver accurately and timely will be greatly valued. The code should be written using simple statements. I am not sure how to set up a connection to our datapool though. I can show couple of other related codes that can help

...and Hibernate with Oracle Database. Key Tasks: - Help build a prototype emphasizing data integrity in transaction management. - Ensure that all database operations are handled in an atomic manner. Ideal Skills and Experience: - Proficiency with Spring, Hibernate, Narayana JTA, and Oracle database integration. - Solid understanding of transaction management, with a specific focus on data integrity. - Experience with building prototypes and handling complex queries and procedures for database interaction. - Ability to ensure database operations across multiple databases are atomic. - Ability to think creatively to find a solution most advanced than most training material sand community forums typically show - Strong track record of ensur...

I'm currently seeking a proficient Nginx server administrator to assist with both maintenance and optimization of our Linux server, as well as deploying new websites and applications. Key Responsibilities: - Regularly maintaining and optimizing our Nginx server on Linux, ensuring it runs efficiently and securely. - Deploying new websites and applications on our Nginx server. This might involve setting up virtual hosts, configuring DNS settings, etc. Desired Skills and Experience: - Profound experience in managing and optimizing Nginx servers on Linux. - Prior experience in deploying websites and applications on Nginx servers. - Familiarity with web hosting best practices. - Knowledge of security and optimization strategies for Nginx servers. - Adept at documentation and clea...

We are looking for a MILVUS devOps expert who will know how to recommend and install the best Milvus hosting server. We are also looking for someone who has done this before MANY MANY times. The end goal is to 1/ recommend which Milvus install plan is best (K8, simple Docker, etc...) 2/ install Milvus and 3/ write detail documentation on how it was done. Then we may want to give you the chance to support and maintain the install. FOR us to consider your submission (WITHOUT the answers to these questions your submission will be automatically deleted) Question 1: Please let us know how many times you have configured and install Milvus. Question 2: Please describe the best architecture you recommend to install and host Milvus. Question 3: Will you be able to demo at leas...

Please Sign Up or Login to see details.

* Proxmox, hetzner. task is to update the servers, set up zabbix (or similar), and take care of the VPN wireguard. Time to time to configure new VMs, change configurations and improve certain things. Servers are on linux and windows server. In the future, we want you to run hosting server with DirectAdmin.

I need a detailed tutorial that shows how to automatically link Jira tickets to Confluence tags and update Jira tickets when Confluence tags are added. Key Points: - The automation should be based on ticket keywords. I want the process to run smoothly without manual intervention. - The tutorial should focus on including the ticket title in the Confluence tags. This will help in maintaining consistency and clarity across both platforms. Ideal skills and experience for this job: - Proficiency in Jira and Confluence: The freelancer should have a deep understanding of both platforms to effectively demonstrate the automation process. - Automation Expertise: Experience in automating workflows between different tools would be a big plus, especially in the context of project manage...

I am in search of a proficient data entry specialist to integrate data into my online Microsoft Access database. Key Responsibilities: - Entry of a large volume of data accurately and efficiently - Verify the integrity of data before entry into the database Ideal Skills and Experience: - Proficiency with Microsoft Access - High attention to detail, precision and excellent organizational abilities - Prior experience with large database data entry is a plus Please note, the spreadsheet format requirement was skipped and so any standard format is acceptable. Only apply if you are proficient, accurate, diligent, and can meet deadlines.

I'm looking for an experienced PHP developer to work on a new E-commerce website. The project involves: - **Website Development**: You'll be responsibl...E-commerce website. The project involves: - **Website Development**: You'll be responsible for creating a complete E-commerce platform. This includes setting up the necessary pages, product listings, and a user-friendly interface. - **Database Management**: Besides building the site, you'll also be in charge of managing its database. This involves ensuring data integrity, proper storage, and efficient retrieval. Ideal candidates for this project should have: - Proven experience in PHP development, specifically in E-commerce platforms. - Strong database management skills. - Understanding and e...

I'm in need of a professional who can efficiently handle data entry tasks into a database. The source of the data will be a mix of physical documents, digital files, and potentially web sources. Key Requirements: - Experience in online data entry. - Proficiency in database handling. - Strong attention to detail. - Ability to work with a variety of data sources. Your primary responsibilities will be: - Entering data accurately into a database from various sources. - Ensuring the integrity of the data being entered. The ideal candidate should be able to demonstrate a high level of focus and accuracy while working at a reasonable pace.

I am looking for an experienced 2D animator to create a short, up to one-minute, animation. This will guide users on how to conduct an inspection. ...not exceed one minute. - Inspection Guide: The animation will be used as a guide on how to conduct an inspection. The main deliverable is a high-quality animation that is engaging and informational. The animation will be used to demonstrate a step-by-step process. Ideal skills and experience: - Proficient in 2D animation and creating engaging content - Experience in creating instructional or tutorial videos - Strong understanding of visual storytelling and ability to simplify complex concepts. The ideal candidate should be able to understand and visualize the inspection process effectively, creating an engaging and informative sh...

...have less than 10 columns, as I believe this will keep the sheet concise and easy to manage. The level of automation I am looking for is manual data entry with some formulas. This will help reduce manual work and ensure the data input is accurate. Ideal skills and experience for this job would include: - Proficiency in Excel: A deep understanding of Excel and its functionalities is essential. - Database Management: Experience in handling databases will help in setting up the product list and other related data. - Inventory Control Knowledge: Understanding of inventory control principles is a plus. - Report Generation: Experience in creating reports in Excel will be beneficial. Your goal is to create an efficient, user-friendly, and reliable Excel sheet that will help me manage...

I need a step-by-step video created to walk our website visitors through a process. The video's primary purpose is to enhance user experience on our website. It should be engaging, informative, and easy to follow. Key Requirements: - Video Type: Step-by-Step - Platform: Company Website - Goal: Walkthrough a Process Ideal S...The video's primary purpose is to enhance user experience on our website. It should be engaging, informative, and easy to follow. Key Requirements: - Video Type: Step-by-Step - Platform: Company Website - Goal: Walkthrough a Process Ideal Skills: - Video Production - Video Editing - Script Writing - Web Design (for seamless integration) Experience: - Previous experience with explanatory or tutorial videos is a plus - Good understanding of user ex...

...integration of generated license keys with my existing Excel templates. * Each license key must validate properly in Excel Template PRO. Besides, your work must include: * Order form * Implementing a MySQL database to store all generated license keys. * Building a response system that displays license keys on a 'Thank You' page after purchase. * Setting up an automated email system that sends emails to the customers with their unique license key and a download link to Excel Template PRO. * The email system should also forward invoice details to the buyer with a copy to the site administrator. + The Coder has to create a Macro in my Excel Template to validate License keys connecting to our DB. Ideal applicants will possess: * Proficiency in Python and MySQL. * ...

...making some changes to the the user interface of my healthcare database website. The primary goal of the changes is to significantly enhance the user experience and make it more userfreindly. This is not a "redesign" task! The staff have learnt how to use the database and I don't want them to have to need to learn their way around a whole new database... not requesting any major changes, but a few points which are mostly related to the way the information is displayed not being user friendly. I need specific changes made. Please see document attached. I'm hoping to work with someone who has experience in both database website development and user interface design. It's important to me that you understand that the way the databa...

Seeking an experienced PL/SQL developer to assist with multiple tasks in my project. This includes: - Oracle database management - XML table manipulation - JSON parsing - Dynamic SQL operations - Development of PL/SQL objects - Utilization of collections and arrays in PL/SQL The project will also involve intricacies such as: - Error handling and exception management - Performance optimization - Crafting of database triggers and stored procedures - Harmonious integration with other systems - Performing data migration and transformation tasks Ideal freelancers for this project should be adept in PL/SQL and Oracle development, with particular skill in SQL*Plus and PL/SQL Developer tools.

I'm looking for an Android app developer to help me create a food delivery application for a restaurant. The app will have a variety...User registration and login system - Menu browsing and ordering functionality - Order tracking system for users - Time selection for order placement (morning or evening) - Ability to choose a pickup point - Three interfaces: one each for administrator, delivery boy, and user Payment Integration: - Credit/Debit Cards - Mobile Payments - Cash on Delivery Ideal Skills: - Proficiency in Android app development - Experience in integrating payment gateways - Knowledge of user interface design - Ability to create a multi-interface app - Strong understanding of database management for order tracking - Prior experience in developing food deliver...

? Seeking Participants for a Focus Group Survey and WhatsApp Activity! ? Are you a user ...survey and 5-day WhatsApp group activity! Activities: -Focus Group Survey: Participate in a 2-hour online focus group session to share your insights and experiences with Associates Management Software. -WhatsApp Group Activity: Engage in daily 10-minute discussions on WhatsApp over 5 days. Requirements: Current user of Associates Management Software (examples include): -SAP SuccessFactors -Oracle HCM Cloud -Workday HCM -BambooHR -Namely -ADP Workforce Now -Paycor -Zenefits -Able to commit to the full duration of both activities. -Must have access to WhatsApp. Benefits: Compensation: RM 150 upon completion of both activities. Opportunity to directly influence software development and imp...

I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid...

I have a project that involves entering text data from printed documents into a database. Ideal Skills and Experience: - Proficiency in data entry and accuracy in transcription - Experience working with printed documents - Knowledge of database management - Attention to detail to ensure complete and accurate data input Key requirements for the job include: - Efficiently entering text data from printed documents into a database - Ensuring the highest level of accuracy in transcribing the information - Organizing the data in the database in a logical and coherent manner - Completing the task in a timely manner without compromising accuracy. Your understanding of the importance of this task in the overall project and your commitment to quality and efficiency w...

I'm in need of a skilled freelancer who can help me build a customer database based on sales transactions. Key Points: - Purpose: The primary objective for this database is to establish a detailed customer database. - Information Required: I need to include name and contact information of each customer in the database. - Data Collection: All the information will be collected from sales transactions. Ideal Skills: - Proficient in data management and database building. - Good understanding of customer data privacy and protection. - Experience in extracting information from sales transactions.

I'm in need of a skilled freelancer who can help me build a customer database based on sales transactions. Key Points: - Purpose: The primary objective for this database is to establish a detailed customer database. - Information Required: I need to include name and contact information of each customer in the database. - Data Collection: All the information will be collected from sales transactions. Ideal Skills: - Proficient in data management and database building. - Good understanding of customer data privacy and protection. - Experience in extracting information from sales transactions.

...pandas, numpy, scikit-learn, and matplotlib. Key Topics: - Thorough insight into SQL commands and functions - Comprehensive knowledge on data cleaning with pandas - Expertise in Machine learning with scikit-learn Purpose of The Content: - Strive to educate, serving as a tutorial guide - Adequate for usage in documentation Ideal skills: - Advanced expertise in SQL and Data Science libraries - Exceptional writing skills with the ability to communicate complex ideas simply - Proven experience in creating educational, tutorial, and documentation content. Please ensure your bid reflects your understanding of these requirements and your past experience in these areas....

I'm seeking a skilled developer to help build a dynamic and secure social registry database. The primary purpose of this database will be to store specific categories of user information, making it a critical data backbone for our social business operations. Key features will include: - Storage of Personal Identities: User's demographic and identity-related data. - Interaction Histories: Tracking user interaction data for better service delivery. - Location Data: Storing user location data to improve geographically targeted offerings. Moreover, I envision a flexible data entry process encompassing: - Manual Data Entry by administrators: Option for admins to input data manually, ensuring the correct configuration and verification of user information. - Automated Da...

I have a recent backup from 4/1/24 on a hard drive attached to my new computer. My previous computer died, the motherboard went out and somehow my SQL Server data was not saved on the original hard drive. I need to pull the data from a ".DATA" file, or find the missing SQL Server backup files and copy them into my existing program for use. Can anyone help?

...MySQL 8 Community edition. Lot of queries are stuck in "executing" state without any kind of database table locking. Most of the queries stuck are all "SELECT" queries. The queries itself is fully optimized using joins and indexing for better performance and those are regular queries which are executing just fine without any issue since many months. If you have a VAST amount of AWS experience, reply with the text "I have a vast amount of AWS experience and I am available right now to help." Thanks! --- Comments below are from AI -- I am in urgent need of AWS server administrator to resolve critical issues with my EC2 and RDS services. The server is currently experiencing performance degradation, database connection errors, and serve...

I am looking for an expert in MS Excel and navigating a website. We will provide a list of certain colleges and universities in the United States, 258 of them. Go to and type the name of the school, then type “athletics staff directory” and hit enter/search. The first site listed will be the staff directory for the athletic department. Scroll down to the Football staff. For every member of the Football Staff who has an email address listed, you need to enter that staff member’s information (School Name, First Name, Last Name, Title, Email Address, Twitter) into the spreadsheet. This is a single project that would need to be completed each year. Pay would be made upon completion of the project. Mode of communication is English.

I need an adept Teams Administrator to set up and manage Powerbi report access and Share OneDrive accounts for the upper echelons of my company. The desired individual should ideally have experience handling Teams Administration for medium-sized groups (10-50). Details: • Allocate Powerbi report access: The task involves granting read-only access to Powerbi Reports for the Executive and Management teams in my organization. • Share OneDrive accounts: You will also need to set up Share OneDrive accounts specifically for these segments. Ideal Candidate: • The ideal candidate will have proven experience in Teams Administration. • Proficiency in managing and configuring Powerbi and OneDrive • Experience working with medium-sized teams of 10-...

...Team, especially Louis Garoz, with administrative tasks related to content creation. ? Viral Content Researcher: Providing Louis Garoz with weekly write-ups of viral content ideas, focusing on value-based or controversial topics. ? Department Manager: Managing the performance and output of all departments, including Clip Coordinators, Trimmers, Editors, and Social Media Managers. ? Notion Administrator: Organizing Notion workspaces across all departments daily, ensuring tasks are properly assigned and statuses updated. Requirements: ? Fluent in English. ? Male. ⏰ Full-time availability with flexibility for 8-hour workdays. ? Self-sufficient and coachable. ? Content and management experience. ? Knowledgeable in Western culture and politics, particularly controversy. Ready to ...

Looking for Social media marketing for tutorial class advertisement class 1 to 10 on what's app and Instagram on local level

I'm looking for a professional to help in setting up an SQLite database which will store and manage moderate data with multiple attributes. Key requirements: - The database should be optimized for storing and retrieving moderate data, such as an inventory system with multiple attributes. - No complex data analysis is necessary, just a user-friendly system for managing and retrieving stored data. - Basic search and filter functionalities are required. Ideal skills for the job include: - Proficiency in SQLite database design and management. - Experience in setting up databases for inventory systems or similar systems. - Ability to implement basic search and filter functionalities.

I'm currently experiencing slow performance from my WordPress database that appears to be most apparent when using Mysql/MariamDB which is affecting my admin and dashboard areas. Ideally, I'm seeking assistance from a professional with substantial experience in WordPress and database optimization. The main skills and experience required include: - Knowledge and skills in MySQL/MariaDB - Expertise in WordPress database management - Experience working with websites having more than 20 plugins. Your task will include performing necessary optimizations to significantly enhance the performance of the website, specifically the admin and dashboard areas. Please, include examples of similar projects you've worked on when bidding.

I am in immediate need of a comprehensive database containing information about IT professionals with 2-3 years of experience. This is crucial for a current initiative, thus I need it ASAP. The database should provide: - Name - Phone Number - Skills - Educational Background - Work Experience - Salary Precision is of utmost importance to me. Therefore, an ideal freelancer for this task should have proven experience in data collection and data entry, with a keen eye for detail to ensure the accuracy of the database. Experience in the IT or HR industries would be a significant advantage.

...data into a database. While the data entry itself isn't particularly complex, a certain level of basic data cleaning will be required. Key Requirements: - Data Entry: The main task is to accurately input data from PDFs into a database. The data is mostly textual, so typing proficiency and attention to detail are essential. - Database Organization: The entered data needs to be organized in a clear, logical manner to ensure it's easily searchable and can be efficiently used. - Basic Data Cleaning: The data will need to be reviewed and cleaned up to ensure accuracy and integrity. This will involve identifying and removing any duplicate entries. Ideal Skills and Experience: - Proficient in Data Entry: Experience with data entry tasks, particularly those inv...

Directions are provided sequentially in order of proximity based on your location. If you specify 5 places to visit, 1,2,3...you specify 5 places to visit, 1,2,3,4,5~ Directions: Sequential execution guidance Places visited Memo function Search results Places to visit are marked in blue Pending Yellow Red Visit Completed Select 3 colors to indicate whether a place has been visited or not Directions to unvisited places Map API provided by Korea connection join the membership Service available to members Unavailable Administrator Member Options It's a very simple service. Search for a restaurant on the map When dozens of restaurants appear, select the one you visited among them. When you visit a store with directions, leave a store note Only you can see the notes Web mobile vers...

I'm in immediate need of an Oracle developer. My requirements are specific: Skills and Experience: * Proficient in Database Management * Expert in SQL programming * Experienced in PL/SQL development Project Scope: * Design and implement a new database * Optimize and tune an existing database * Capable of writing complex SQL queries Please note the project must be completed as soon as possible. So, only apply if you're ready to take on the task immediately.

I'm in immediate need of an Oracle developer. My requirements are specific: Skills and Experience: * Proficient in Database Management * Expert in SQL programming * Experienced in PL/SQL development Project Scope: * Design and implement a new database * Optimize and tune an existing database * Capable of writing complex SQL queries Please note the project must be completed as soon as possible. So, only apply if you're ready to take on the task immediately.

I'm urgently in need of a skilled professional who can swiftly deploy a database server for me. Key Responsibilities: - Establishing a server primarily intended for databases - Choosing the suitable database management system (DBMS) Ideal Competencies: - Extensive experience with multiple DBMSs as I'm not yet decided on which one to use - Ability to work under pressure and deliver swiftly since the project is urgent - Prior experience with server deployments will be highly advantageous.

I’m experiencing a persistent issue with lagging or delayed replication in my SQL Server database. The primary problem revolves around the replication process not effectively happening in a timely fashion. Ideal Skills-needed: - Solid skills in SQL Server management - Proficient understanding of database replication processes - Excellent problem-solving and diagnostic abilities in the context of database administration The ideal freelancer for this project will be able to not only identify the source of this issue but will provide a solution to improve the replication time. It's crucial that you have managed SQL Server databases before, ideally in a high-transaction environment, and have a deep understanding of data replication.

...an Access database that can primarily handle generating reports and analytics. The main goal is to keep track of internal data for further analysis and reporting. Key Features and Functions: - **Reports & Analytics:** The database should have the capacity to generate comprehensive and insightful reports from the data gathered. It's crucial that these reports are insightful and easy to understand. - **Data Tracking:** The database will be used for tracking internal data. This needs to be done with precision and the ability to link data for comprehensive tracking. - **Data Input & Updates:** The system should allow for easy input of data and updating when needed. This will facilitate the generation of accurate and updated reports. Ideal Skills: - Pro...

? Seeking Participants for a Focus Group Survey and WhatsApp Activity! ? Are you a user ...survey and 5-day WhatsApp group activity! Activities: -Focus Group Survey: Participate in a 2-hour online focus group session to share your insights and experiences with Associates Management Software. -WhatsApp Group Activity: Engage in daily 10-minute discussions on WhatsApp over 5 days. Requirements: Current user of Associates Management Software (examples include): -SAP SuccessFactors -Oracle HCM Cloud -Workday HCM -BambooHR -Namely -ADP Workforce Now -Paycor -Zenefits -Able to commit to the full duration of both activities. -Must have access to WhatsApp. Benefits: Compensation: RM 150 upon completion of both activities. Opportunity to directly influence software development and imp...

I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

I'm looking for a proficient person that can go into links and write emails and phone numbers. There are 15,000 Records to revise. Work needs to start asap and be completed with a good team. This is not a one person job. I need all records completed real time from a file on google drive. Must be complete with 24 hours Currently, I'm using Excel spreadsheets, which is proving inefficient. I require an effective solution to input data and offer functionality that makes the information more accessible. Your Tasks: Go into profile and extract email, phone number , link in the bio and also any nics in the bio Required Skills and Experience: - Understanding of search functionalities - Data Entry - Knowledge in data export would be a plus. You should have a strong track recor...

I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp

There will be additional $50 for any who completes this project fully. The aim of this project is to compare three types of databases(Any relational database, mongoBD and Neo4J) in terms design approach, implementation, query composition, and performance. The data is about texas hold em poker game The stages of the project are 1. Look at the details of the data 2. Come up with an ER diagram and a relational schema for the data 3. Create a database in any relational db and tables 4. Create a python script to read the txt files and populate the db 5. Test the queries 6. Populate the other(mongodb and neo4j) databases and test the queries Then test the queries below on the databases QUERIES 1. Separate players by their style of play/Group players with a similar style of play ...

I've been experiencing some difficulties with my MS Access database. Error messages appear indicating missing or broken files namely, ‘’ version 7.0 and ‘’ version 1.0. Some occur as soon as I try to open the application. No recent changes have been made to my computer's operating system or the MS Access software. Ideal applicants for this task should be proficient in MS Access, troubleshooting, and database management. You'll need in-depth knowledge of system files and how they might impact the functionality of the application. A knack for solving complex technical problems is also important. In turn, you should be capable of providing a lasting solution to prevent the recurrence of these errors. Cheers!

...Integration between Canva and Xibo: The freelancer should be able to connect Canva with Xibo, allowing for an automated update process. - AWS and Linux server management: Experience in managing AWS and Linux servers is a plus, as the Xibo system is self-hosted on an AWS Ubuntu server. We are getting this error when try to integrate: {“error”:0,“message”:“API configuration problem, consult your administrator”} We need the solution to be documanted and step by step to resovle it in future. Ideal skills and experience: - Proficiency in Canva and Xibo: The freelancer should have a deep understanding of both platforms to facilitate a smooth integration. - Experience in API integration: Knowledge of APIs is crucial for creating a connection betwe...

I am looking to get this done in two weeks. Please see the included specs and html wireframe layout before bidding. I need someone who is skilled in ASP.NET and experienced with mobile apps. I would rather have the app developed with cross-platform software but it will for now be used in iOS.