Mysql use database command jobs

...into 350 copies Step 1: Open the PowerPoint file named "Adelya Expansion - Australia and New Zealand" Step 2: Open the Excel sheet named "Companies in whose name the file is to be saved " Step 3: Note that in the Excel sheet, the second name after Adelya is Tecmark Step 4: SAVE the Powerpoint file as "Tecmark Expansion - Australia and New Zealand" Step 5: Replace in Powerpoint (Keyboard command is Alt-E-E), the name "Adelya" with the name "Tecmark" Step 6: There should be 12 replacements, then you know you have done it right Step 7: Save the file once again as "Tecmark Expansion - Australia and New Zealand" Step 8: Save a second copy of the file in PDF version (Powerpoint will offer you an option called "Save as f...

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

...in the attached spreadsheet. It's crucial that the information you provide is accurate and up-to-date. The test of accuracy will be me sending emails and verifying the company. Any wrong details will need to be collected again unless it is beyond your control (e.g. company has closed down etc.) Automated collection will be erroneous as the data needs to be collected in the following way. use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to click company logo and collect its email addresses, websites, and phone numbe. 4. To manually check the result and collect Website name, Email address and ...

Hi there. I'm running XCode 15.3 and I need a few pages done with simple, clean storyboards and View Controllers. I use Alamo Fire and Swift, so if you could use that to pull my data via my API links and display it in several pages that would be great. Categories > Collections > Items > Item Details You select one and it shows a list - Item Details is one record from a MySQL db I need each selected item to be a variable in the code of the ViewController so if I use the print function, I can see it at the bottom of XCode. I'll give you the 3 or 4 API webservice links. I can give you a super simple app to put it in too...

I need a proficient database developer (PHP Developer) to create a specialized system for my dental equipment repair company. The database will cater to a sizeable clientele of 5000 customers. The details to be incorporated include: * Equipment type (X-ray machines, Dental chairs, Autoclaves) * Maintenance history * Customer details (Clinic name, number, email address etc.) In order to succeed in this project, you should have: * Strong database creation skills with the ability to account for our unique needs * Experience in the healthcare sector, specifically knowledge of dental equipment * Excellent problem solving and critical thinking skills for effective database design * Understanding of confidentiality requirements given the sensitive nature of the cu...

I'm looking for a skilled and creative animator to create engaging, high-quality cartoon themed animations using Blender. Key Responsibilities: - Creating and delivering one animation short per day, each around a minute in length. - Ensuring all animations are of high quality and adhere to the preferred cartoon style. Additional Requirements: - Good command over English is necessary due to the requirement of English voice-overs for the animations. - Previous experience with Blender software and cartoon-themed animations. React if you're enthusiastic to work in this dynamic project!

...website. The ecommerce is up and running and fully operational and we need a FULL STACK developer that can code in ALL AREAS of the webapp. - Frontend: React (JavaScript) - Backend: Node.js - Services: Python - Database: MySQL RESPONSIBILITIES: - Integration of new B2B APIs - New payment gateway integration - - Implementation of bug fixes and performance improvements. - Regular software updates and security patches. - Feature additions and enhancements. Skills and Experience: - Proven experience in maintaining e-commerce solutions. - Proficiency in React, Node.js, Python, and MySQL. - Strong problem-solving skills. - Excellent understanding of software best practices and design patterns. - Ability to work independently and meet deadlines. - .NET and are a plus ...

...balalbolka “bconsole” 3 Install raveena voice 4 Ensure you can create .wav file using raveena in Wine with example command: balcon -n raveena -t "The text will be read slowly." -s -5 -v 70 -w "d:Sound" 5 Run wine installation in docker 6 Ensure you can create .wav file using raveena voice with Docker command 7 Send me docker to test locally Thanks for bidding...

I'm seeking a Python expert to develop a solution for a resource allocation problem that involves both the Knapsack Pro...also be required to incorporate LP models in the solution to enhance the resource allocation process. Skills & Experience: - Proficient in Python for algorithmic problem-solving and have a solid understanding of optimization techniques. - Experience in working with LP models and understanding of how to apply them in real-world resource allocation problems. - Previous experience in developing command-line interfaces for solutions - as this project does not require a GUI. The ideal freelancer for this project is someone who has a deep understanding of the Knapsack Problem, LP models, and has the ability to translate this knowledge into an efficient Pyt...

We are seeking an experienced Flutter developer to integrate 's video and call streaming services along with Firebase database into our existing Flutter application. The primary tasks include implementing 's features for seamless video streaming and call functionality, as well as utilizing Firebase database for efficient data storage and retrieval. The ideal candidate should have prior experience with SDK and Firebase integration. Additionally, the developer will be responsible for updating the app to meet the requirements for submission to both Apple Store and Android Store. If you have the necessary skills and expertise in Flutter development, we'd love to hear from you.

We need the following combination of online database and data entry interface from users + a local MS access file. Online Database and web I terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must...

We need an experienced Magento developer to assist with updating third-party extensions when conflicts arise due to newer php/mysql versions. Timeline: Start on the first project on 20th May using remote desktop tools like UltraViewer or AnyDesk for real-time collaboration. Bidders must be highly proficient in Magento 2.4x.

I need a desktop application that can carefully monitor a MySQL database on my Windows system. The app should be able to perform the following functions: - **Monitoring MySQL Database**: The application should constantly monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the ap...

...- Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need access to final git repository Project Completion: 2 weeks This project is an exciting opportunity to work on a cutting-edge software integration and development. If you have the right skill...

...lighting and colors: The selected freelancer must be proficient in enhancing the saturation, brightening the image, and optimizing the white balance to achieve a professional headshot quality. - Change the background: The background of the selfie should be replaced with a solid color. This may require the use of advanced editing tools to ensure a seamless transition between the subject and the new background. Ideal Skills and Experience: - Proficiency in photo editing software: A strong command of editing tools like Photoshop or Lightroom is a must for this project. - Experience with portrait photography: Understanding of professional headshot standards and techniques is highly desirable. - Attention to detail: The ability to make subtle yet significant changes that enhan...

I'm looking for a talented web developer to help improve my existing website. The changes I seek span across editing the design, content, and functionality aspects. (I ju...YOAST SEO - Layout Enhancement: Refine the layout of the website to be more user-friendly and visually appealing - Pages & Features: I have a specific set of pages (6), a video, a contact page featuring a map, and an enquiry as well as email form. The ideal candidate should have: - Proficiency in Wordpress, Astra Pro, and YOAST SEO - Experience in logo design and overall website design - Strong command of adding and curating website content - An eye for detail and aesthetics - Good communication skills If you believe you have the skills and experience to deliver this multi-faceted project, I would lov...

I'm looking for an expert to create a web-based CRM database aimed at efficiently storing and managing information. The data I intend to keep include: - Customer contact details - Sales history - Communication logs - Course details - Course Refresher notifications This project also requires the creation of functionalities to: - Add new contacts - Update existing contact information - Track sales performance Ideal freelancers should have substantial experience in CRM database development, with knowledge of implementing web-based solutions. Familiarity with training or course-based entities would be a bonus. Your expertise ought to allow seamless additions, updates, and performance tracking of stored information. Demonstrable success in similar projects will be advanta...

We are looking to translate a 600-word document from English to Brazilian Portuguese within the next few hours. We require applicants to be native Portuguese speakers with a strong command of English and proven translation experience in this language pair. We offer $6.00 USD, a positive review, and potential future opportunities for similar projects.

I am looking for a proficient full stack developer to help with a personal project. Using NodeJs and NextJs with MYSQL DB, your skills will include: - Expertise in utilizing NodeJs and NextJs - Develop a user-friendly platform - The ability to brainstorm and bring creative digital solutions - Strong problem-solving skills - Understand project requirements and deliver high-quality work - Should be proficient in using Github with AWS and coordinate with infra team member for coordinated push - Understands and knows the importance of proactive communication Expectations: - Your primary responsibility will be to design and develop the application, and to coordinate with the rest of the team working on different layers of the project. - Daily commitment for a minimum of 4 hours f...

I have two websites that need to be merged with a main focus on consolidating information. The current websites are different in design and themes, and I'm looking for a professional who can successfully merge them into a cohesive, user-friendly site. Key requirements: -...link seamlessly Please let me know your experience with similar projects and your approach to this particular task. Your input on the best ways to consolidate the information and prioritize content is highly appreciated. Website language is: - Linux AMI > OS - PHP > web and back-end - NodeJS > ICS - > ICS & Warehouse App - Ionic v1 > Warehouse App - Apache > web server - Database: MySQL Aurora - AWS hosted, leveraging EC2, RDS and S3 - Front-end is custom framework ...

...Project Deliverables: - Full WordPress site development featuring an online store - Customization of the site with a new name and logo - Advanced SEO with keyword research and implementation - Website security reinforcement Key Requirements: - Expertise in WordPress website development, particularly on an e-commerce site - Proven experience in SEO, specifically in advanced keyword research - Strong command of Arabic language and understanding of Arabic market trends - Familiarity with payment gateway integrations, particularly with credit card processing - Prior experience in website security measures - Proactive and solution-oriented approach to problem-solving....

I'm in need of a talented fi...structure, character development, and world-building, as these elements are crucial for a successful fantasy novel. Ideal Candidate: - Proven experience in writing fiction, preferably with a focus on fantasy - A good understanding of the fantasy genre, including common tropes and techniques - Strong storytelling skills, with the ability to create and maintain tension and intrigue - Excellent command of the English language and grammar - Ability to engage and captivate readers throughout a longer work - Reliability and commitment to meeting deadlines If you are passionate about fantasy, have a talent for spinning a good tale, and are looking for a novel-sized project, I'd love to hear from you. Please provide samples of your work in a simila...

Key responsibilities: - We need Malaysia based team manager who can find people to do tiktok live stream selling, include register an account and then do online selling, we need you to be able to seek people and bring them into a group to do this. As a manager, you need to prepare an action plan about how ...Professionalism: As the main point of contact for many clients and customers, you must maintain a professional and helpful attitude at all times. Ideal candidate has: - Proven experience as a virtual assistant or relevant administrative role. - Familiarity with online calendar tools and software (e.g., Google Calendar). - Proficiency with data entry, record keeping, and management. - Excellent command of English, both written and verbal. - Good organizational and time-manageme...

I'm looking for a skilled artist who can create a replica of an existing image in a cartoonish style. The replication should closely resemble the original but with...image will be used for digital purposes, such as on websites and social media. Key Requirements: - Replicate an existing image in a cartoonish style - Maintain a close copy of the original with altered elements - Ensure the final output is suitable for digital use Ideal Skills and Experience: - Proficient in digital art and illustration - Strong understanding of proportions, details, and shapes - Experience in creating cartoonish art - Ability to replicate existing images while adding a unique touch - Understanding of digital use and design principles Please provide examples of your previous cartoonish st...

...several years old. For example Node JS 7.10.0 and MySQL 5.7.0. Everything needs to be updated to highest stable version that offers support and packages. For Node.Js that will likely be version 18 or 20 Moreover, this project offers an excellent opportunity for more development. **QUOTE: UPGRADE** -Please provide a quote for upgrade of website, iOS & Android apps, and admin panel. -The Framework described below. -Specify team size and roles. -Time frame for completion. **PLATFORM FRAMEWORK & DETAILS** Framework: React, Node, Express, React Native Frontend: React (website), Node + Express (APIs on server), React Native (mobile apps on iOS & Android), Bootstrap (making UI web responsive) Backend: Node.js (latest version), Express, MySQL Deployment:...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

i need to get the services of a developer who understands PHP & Java to correct and update some open source software. I have access to raw code and git hub library. Programs work, but needs some adjustments to get them to operate properly. There is not a lot of parts of the the different software that needs correcting and so i would not expect it to take too long, as most of the features work fine, but there are some features that are not working in correct manner. I want to start off with one application fix. Then if work fine, we can work together to add extra features.

We are on the lookout for an exceptional Senior Golang & Blockchain Developer to join our innovative team. The ideal candidate will have a robust background in software development with more than 7 years of experience, a strong command over various programming languages, and excellent communication skills. Responsibilities: Develop, test, and deploy smart contracts and blockchain-based applications. Design and implement scalable and maintainable microservices architecture. Collaborate with cross-functional teams to deliver high-quality software solutions. Optimize backend processes using Golang for enhanced system performance. Ensure the integration of frontend and backend systems for seamless user experiences. Containerize and orchestrate microservices using Docker and Kuberne...

I'm seeking an architectural draftsman proficient in creating a professional drawing of my mixed-use building purchased in 1973. Unfortunately, the DOB and HPD don't have an original layout drawing of my property, which is hindering my process of applying for a Letter of No Objection (LNO) and obtaining a Certificate of Occupancy (CO). The preferred freelancer will have: - A track record in architectural drawing and a deep understanding of building standards prior to 1938. - Proficiency in making comprehensive drawings without original blueprints or plans as a reference. - Broad experience in designing detailed plans that are acceptable for DOB and HPD procedures. - Ability to deliver work within an agreed timeline, as speediness is crucial for this project. This is an...

I urgently need a skilled professional to set up a E-commerce website on AWS. Website is already hosted in AWS instance but due to some error website is stop, We need to start website Tools : php Mysql

...need to be developed. Key Project Details: - Design Style: You'll be working on translating our design style into functional web components. - Number of Components: You'll be responsible for crafting less than 10 web components. - Integration: The components you create will need to be integrated with existing APIs. Skills and Experience: - Proficiency in Sveltekit: You should have a strong command of Sveltekit and experience developing custom web components. - UI/UX Design Understanding: While the design style is set, an eye for good UI/UX practices is appreciated for the development of functional components. - API Integration: Experience with integrating web components with APIs will be crucial for this project. I have attached an AI generated dashboard that meet...

I have a specific PDF file that I need to convert to React-pdf. Key requirements: - Convert a specific PDF file to React-pdf: I have a particular PDF file that needs to be converted to React-pdf format. Ideal skills and experience for the job: - Proficient in React: You should have a strong command of React, particularly with handling PDF files in a web application. - Experience with PDF manipulation: Prior experience in converting PDF files to other formats, particularly in the context of web development, will be beneficial. - Familiarity with image retention in PDF conversions: Experience in preserving images during PDF conversions, especially in the context of React-pdf, will be a significant advantage. When bidding, please send me the works (e.g github) you have done with...

I need a skilled professional who can handle both photography and videography for an upcoming event in Bedford on 22nd June 2024. The event's duration is estimated to be 2-4 hours. Key Responsibilities: - Capture the spirit of the event, focusing on gue... The event's duration is estimated to be 2-4 hours. Key Responsibilities: - Capture the spirit of the event, focusing on guest interactions and the general atmosphere and setting. - Be able to deliver high-quality photos and videos. Ideal Skills: - Proven experience in event photography and videography - Ability to capture candid moments and create a compelling visual narrative - Strong command on lighting and other technical aspects. Your portfolio or samples of previous event coverage are a must to evaluate yo...

I need a skilled writer to paraphrase an article originally generated using AI. The current version of the article is being flagged as 100% AI-generated by various AI detection tools. Your task will be to rewrite the content in a way that ensures it passes AI detection checks, while maintaining the original meaning and quality. Requirements: Strong command of the English language Excellent paraphrasing skills Ability to maintain the original context and intent of the article Experience with AI detection tools is a plus Deliverables: A paraphrased version of the article that can pass AI detection checks The final text will be evaluated using Turnitin to ensure compliance Special Note: Freelancer.com does not allow projects to be posted for less than INR 600. If anyone is willing...

I require an experienced Web Developer to undertake a project we have. The website we need is a comparison website for Coach hire. This will entail a booking system where Coach companies (Operators) will bid/tender for work etc. Below are the features. User Registration and...Users can rate and review operators. • Reviews influence operator rankings. Admin Dashboard: • Admins manage users, operators, bookings, memberships, and more. • Monitor platform activities and resolve disputes. This kind of platform requires a combination of front-end technologies (HTML, CSS, JavaScript), back-end technologies (server frameworks like Node.js/Express or Django, databases like MySQL or MongoDB), and potentially third-party APIs for features like payment processing and Googl...

...an engaging pitch deck and conduct insightful market research. The main objective of this project is to form a captivating pitch that will ultimately appeal to potential partners. In order to accomplish this, you will need: - Extensive experience in market research - Proven track record in creating compelling pitch decks - Strong understanding of business concepts and strategies - Excellent command over storytelling and presentation. The pitch deck should include the following key elements: - An articulation of our company's vision and mission - A clear, compelling value proposition for our product/service. Understanding of our target market and competition will be crucial for presenting a persuasive and unique value proposition. Please submit relevant examples of you...

...experienced developer to create a custom Visual Studio Code extension tailored to my specific requirements. Key Features: - The extension should allow me to define my own set of rules - Specifically, I require the ability to create code formatting rules and code highlighting rules Rule Application: - The code formatting rules must be applicable both automatically upon file save and manually upon command execution. Ideal Skills: - Expertise in creating Visual Studio Code extensions - Proficiency in JavaScript and TypeScript - Prior experience with code formatting and syntax highlighting - Understanding of code linting and analysis - Strong communication skills to understand and implement my unique set of rules. Please provide examples of your previous work in this domain, ...

I'm looking for a dedicated and experienced virtual assistant from Malaysia. This role involves calendar management and data entry tasks, primarily updating databases and processing orders. Key responsibilities: - We need Malaysia based team manager who can find people to do tiktok live stream selling, i...Professionalism: As the main point of contact for many clients and customers, you must maintain a professional and helpful attitude at all times. Ideal candidate has: - Proven experience as a virtual assistant or relevant administrative role. - Familiarity with online calendar tools and software (e.g., Google Calendar). - Proficiency with data entry, record keeping, and management. - Excellent command of English, both written and verbal. - Good organizational and time-man...

I am currently in need of an experienced Django developer to assist me in deploying my Django web application on a VPS hosting provider. To bid on this project, you should: - Have intermediate to advanced level experience with Django and its related technologies. - Be proficient in MySQL, as this is the specific database system that my Django application is built with. - Understand VPS hosting thoroughly. Your role will be to guide me through the deployment process, ensuring that the application runs smoothly and functions as expected on the VPS host. Please show proof of similar projects handled in the past. Your time commitment should be immediate and full-time until completion of deployment. Your proposal should include a plan of action detailing how you intend to car...

...a mobile phone in a few seconds so that everything is finished. The application is in spring boot and angular. The database is mysql. Functionality for Taking Photos Using HTML5 and JavaScript, you can use an input element with the type file and the attribute accept="image/*" to allow users to take pictures of documents directly from the browser on a mobile device. Uploading the Image to the Server When a user takes a picture and clicks the save button, the image is sent to the backend server via an HTTP POST request. The backend server can use a framework Spring Boot (for Java) to process the uploaded images. Image Processing and Data Extraction On the server, you can use OCR (Optical Character Recognition) technology to recognize and extr...

I'm in need of a skilled photo editor to work on a batch of 10 raw images initially. If the initial batch is to my satisfaction, I have more photos that will need editing. The photos are of jewellery (earrings, necklaces, bracelets), so the metal and stone colour should be clear. Requirements: - Expertise in working with RAW format (NEF to be precise) - Ability to edit photos in a natural and subtle style - Proficient in cropping and grading images The edited photos will be used for online publication, so it's important that the quality be top-notch. If this goes well, I will have more work for you in the future.

I'm seeking a proficient Access Database designer to build an advanced and fully functional task management system. Key Features: - Data Entry Forms: These should be user-friendly and designed for efficiency. - Reporting and Analysis Tools: I need to be able to easily track productivity and analyze task-related metrics. - Data Validation Rules: The system needs to ensure the accuracy of inputted data with stringent validation rules. Structure: The database should consist of 5-10 interlinked tables for comprehensive task tracking and management. Ideal skills and experience for this job would include: - Extensive experience with Access database design, specifically around task management systems. - Strong ability to translate user needs into functional system fe...

I'm on the lookout for a senior NodeJS Typescript developer with a high level of skill and a good grasp of English. The role specifically involves backend development. Key requirements include: - Senior level experience in NodeJS and Typescript - API Development experience - Architectural Mindset - Fluent English - Prior work on backend development projects - Strong command of English, as our communication channel will be primarily through instant messaging - Must be European! - AWS Knowledge Plus If you match these requirements and are keen to work on an interesting backend project, I would love to hear from you.

...Leveraging Blox coding to enhance the reports with advanced analytics - Ensuring the integration of invoice data and analysis reports into the reports - Implementing appropriate visualizations and data representations for optimal understanding - Ensuring the reports are user-friendly and easily navigable. The ideal candidate should have: - Proficiency in Sisense Dashboard designing, with a strong command over Blox coding. - Prior experience in creating customized, data-rich reports. - Strong analytics skills to implement and understand advanced analytics. - Experience with integrating data from different sources, especially invoice data and analysis reports. - The ability to understand and translate complex data into easily understandable visualizations for a non-technical audie...

I'm seeking an experienced freelancer with strong attention to detail to perform data entry into my database. The data to be entered is text-based and extracted from various sources which may have distinct formats. Below are specifics about the job: - Handling Text Data: The job will entail entering a variety of text data into the designated database. - Format Diversity: The data comes from diverse sources, so it does not adhere to a specific format. The ideal candidate must be adaptable in handling different data formats. - Correcting Discrepancies: The freelancer will need to spot and correct discrepancies or inconsistencies within the data sources. Accuracy and keenness to details will be crucial. Ideal Skills: - Proficient in data entry - Strong attention to d...

I'm looking for a skilled professional to improve the accuracy of my cloud-based database. To achieve this, the tasks at hand include: - Identifying and removing duplicate entries - Standardizing data formats to ensure consistency - Conducting routine data cleaning checks to maintain accuracy Ideal candidates should have: - Proven experience in data cleaning and management - A deep understanding of cloud-based database systems - Strong communication skills as I prefer to get updates and progress reports through an instant messaging app.

I am in need of an academic writer with a strong understanding in the field of sciences. Key duties: - Research and write original academic articles in the sciences field. - Ensure all articles are insightful, accurate and of high quality. Ideal Candidate: - Excellent command of English language - Proven experience in academic writing, specifically in the field of sciences. - Ability to conduct thorough research and produce plagiarism-free works. Let's create informative and impactful science articles together. Please share your previous academic writing samples while bidding. Thanks!

...our animation team to ensure the story ideas are feasible and align with our creative vision. Incorporate feedback and make revisions to ensure the highest quality of storytelling. Stay updated with trends in the animation industry and incorporate fresh and innovative ideas. Requirements: Proven experience in creative writing, preferably in the animation or entertainment industry. Excellent command of Hindi language, both written and spoken. Strong storytelling skills with the ability to create engaging and original content. Familiarity with 3D animation processes is a plus. Ability to work collaboratively and take feedback constructively. Portfolio of previous work, particularly in story development or scriptwriting, is highly desirable. Experience writing for children’s...

As an experienced UI designer, I need your expertise to redesign the user interfaces of my community web app. - Tasks: Your main responsibilities will involve creating user-friendly interfaces for the app, focusing specifically on redesigning...Elegant and Professional in style. This means a focus on clean, sophisticated design elements that enhance usability and overall user experience. Ideal Skills: - Proven experience in UI design, particularly for web and mobile applications. - Experience with user-centered design principles and practices. - Ability to understand user needs and translate them into appealing design solutions. - Strong command of design tools like Adobe XD, Figma, or Sketch. - A portfolio that demonstrates your capability in delivering elegant and professiona...

I am hiring for a Full Stack Web3 developer for my team. Tech Stack: Blockchain: Blast (EVM) Frontend: Typescript + NextJS + Tailwind + Vercel + WAGMI + Ethers V5 + Typechain Backend: Typescript + Vercel Lambda + tRPC + AWS + Prisma ORM + Ethers V5 + Typechain + Upstash Redis Database: MySQL (Planet Scale) + AWS S3 Storage Randomization: Gelato VRF Static File Hosting: AWS S3, Pinata Smart Contracts: Foundry, Hardhat Monorepo. Here you go: Objective: Design and implement a scalable backend and frontend system for tracking and displaying NFT transactions similar to the "Activity" feature on OpenSea The system should handle varying loads seamlessly, from 500 to 50,000 users. Tasks: System Architecture Design: Task: Design the overall architecture for the activit...