Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
...creation, renewals, billing & payments, plus on-demand report generation. • Customer Portal – a responsive web and mobile experience that lets policyholders track claims, download documents, pay invoices, and update account details. All front-end work will be written in React for the web and React Native for iOS and Android. The back-end will run on Node.js with Express, relying on a relational SQL schema that you will design for compliance with North-American insurance data standards. Clean REST APIs, unit tests, and clear documentation are expected so that future actuarial and underwriting services can plug in without friction. Acceptance criteria 1. Each module functions end-to-end in a staging environment, passing user flows and edge-case tests. 2. Sour...
**Project Title:** Data Processing & Clea...* Handle inconsistent or incorrect data entries * Perform basic transformations and feature engineering * Generate summary statistics and insights * Output clean dataset in CSV / Excel format **Technical Skills Required:** * Python * Pandas, NumPy * Data Cleaning & Preprocessing * Basic Data Analysis **Optional (Preferred):** * Data visualization using Matplotlib / Seaborn * Experience with SQL or database integration **Deliverables:** * Well-structured Python script * Cleaned and processed dataset * Brief documentation explaining the workflow **Project Goal:** To convert raw, unstructured data into a clean and usable format for analysis and decision-making. **Budget & Timeline:** (Open for discussion based on experienc...
...access policies, service accounts, and role-based access control (RBAC) for enhanced cloud security. * Designed and configured Google Cloud VPCs, subnets, firewall rules, private networking, Cloud NAT, Cloud Router, and Private Service Networking. * Configured Google Cloud DNS, SSL certificates, HTTPS load balancing, and Kubernetes Ingress for secure internet-facing applications. * Managed Cloud SQL PostgreSQL databases, including provisioning, connectivity, authentication, backups, and performance optimization. * Implemented Redis caching using Google Memorystore to improve application performance and reduce database load. * Integrated Google OAuth 2.0 authentication into the application with secure client configuration and redirect URI management. * Configured NGINX as a ...
Customer Data Analysis using SQL: Recently completed a hands-on Customer Data Analysis Project using SQL, where I explored and analyzed 81,446+ customer transaction records to uncover valuable business insights. Key Analysis Performed: Identified total transactions based on gender, product category, and payment method. Analyzed which gender purchased the highest number of products. Calculated total revenue generated by each gender. Compared category-wise transactions, units sold, and revenue. Evaluated purchase patterns across categories and genders. Examined payment method-wise revenue and transaction performance. Segmented customers into different age groups to analyze buying behavior. Found the age group with the highest product purchases. Identified the most fr...
I need a full-stack ASP.NET web application—C# on the back end, SQL Server for data—delivered in both English and Arabic with complete RTL rendering on every screen. The build is split into two clear areas: External Applicant Portal • Public registration form that captures entity details and uploads supporting documents. • Submission triggers a reference number so applicants can log in later and track real-time status updates. • All outward-facing pages must switch seamlessly between English (LTR) and Arabic (RTL) without layout shifts. Administrative Portal • Review queue showing every incoming application and its attachments. • Configurable, multi-level approve / reject workflow. Each step records the acting user, decision, and time...
I have an active MySQL database that has gathered duplicates, incomplete fields, and a few broken relationships over time. I need focused help cleaning this existing data set so every table is consistent and reliable again. Your task is limited to data cleaning; I will handle any future insertion work or query tuning myself. Deliverables • A cleaned SQL dump or set of migration scripts ready for direct import • A short report outlining the issues you found, the steps you took to fix them, and any preventive measures you suggest Acceptance Criteria • Duplicate rows and orphaned records are removed • Mandatory fields contain valid, properly formatted values • All foreign-key relationships pass integrity checks without errors Feel free to work wi...
...sheets, model the data cleanly, and design compelling visuals that let me slice and drill down without having to touch the underlying files. You are free to suggest the most meaningful charts and KPIs once you see the data, but the refresh must remain one-click simple: whenever I replace the source Excel files, the dashboard should update automatically. If you think an additional source—such as a SQL database or an online service—would improve insights later on, please note it in your proposal; for now everything needs to function with Excel alone. Deliverables: • A fully-functional .pbix file linked to my Excel data • Any DAX measures and data-cleaning steps documented within the file • A brief PDF or video walkthrough showing how to refresh and...
...schema, and produces a simple prioritized "review this first" output plus a few summary metrics. There's also a light AI/ML component — for example, using an LLM to pull structured fields out of the free-text notes, or a simple model to score/rank claims for review. Nothing exotic; we care more about it being done sensibly and reliably than about model complexity. What we're looking for: - Strong SQL and hands-on ETL / data engineering experience - Real data-quality and validation instincts (this is the core of the job) - Comfort with Python and basic AI/LLM or ML usage * Bonus: experience with insurance, fintech, or other regulated-industry data Scope is roughly a few days of work. The dataset is synthetic — no real personal data — and wil...
...Database * PostgreSQL * Redis * MongoDB (optional for analytics) ### Authentication * JWT Authentication * OAuth (Google, GitHub) * Two-Factor Authentication (2FA) ### Cloud & Deployment * Docker * Nginx * AWS / Azure / DigitalOcean * CI/CD Pipeline using GitHub Actions --- # Security Requirements * HTTPS encryption * Role-based access control * Secure authentication * Password hashing * SQL injection protection * XSS protection * CSRF protection * API rate limiting * Automated backups * Activity logging --- # Performance Requirements * Fast page loading * Server-side rendering (SSR) * Image optimization * CDN support * Database indexing * Caching with Redis * Lazy loading * API optimization --- # Future Enhancements * AI-powered content recommendations * AI wri...
...Database * PostgreSQL * Redis * MongoDB (optional for analytics) ### Authentication * JWT Authentication * OAuth (Google, GitHub) * Two-Factor Authentication (2FA) ### Cloud & Deployment * Docker * Nginx * AWS / Azure / DigitalOcean * CI/CD Pipeline using GitHub Actions --- # Security Requirements * HTTPS encryption * Role-based access control * Secure authentication * Password hashing * SQL injection protection * XSS protection * CSRF protection * API rate limiting * Automated backups * Activity logging --- # Performance Requirements * Fast page loading * Server-side rendering (SSR) * Image optimization * CDN support * Database indexing * Caching with Redis * Lazy loading * API optimization --- # Future Enhancements * AI-powered content recommendations * AI wri...
...slow. I need a small Windows-friendly executable that I can install locally (no separate runtimes or server components) and use to: • Browse for any .xlsx file, read every row without dropping or corrupting data, and load the full set straight into a fresh SQLite database that the tool creates beside the original file. • Present a lightweight GUI: one multiline textbox where I can type any valid SQL statement and a results pane/grid that shows the returned rows. No extra frills such as syntax highlighting or autocomplete are necessary; simplicity and speed are the priority. • Ensure reliability—types, encodings, and special characters from the spreadsheet must survive the import exactly as they appear in Excel. Duplicate column names or mixed data types ...
...Analytics concepts right through to intermediate-level AI insights. The audience is a batch of students who already use data in their daily roles, so the sessions must balance theory with immediately applicable, tool-driven practice—think exploratory data analysis, statistical modelling, predictive analytics and an introduction to generative AI techniques using mainstream platforms such as Excel, SQL and Power BI. I need offline trainer: • A complete training roadmap broken into daily objectives, and assessment checkpoints • Slide decks, datasets and code notebooks that I can keep for future cohorts • Brief post-training reports on participant progress and next-step recommendations Deployment details • Venue: Vijayawada campus (fully equipped la...
...take real time on its own. What I need help with: Download, safely unzip, and inspect the contents of the backup — ideally in an isolated/local environment, not uploaded directly to a live server, since the original site was compromised Determine what's actually in the archive — specifically whether it includes only site files (theme, plugins, wp-content/uploads) or also a database export (a .sql file), since my articles/post text live in the database, not in the file structure, unless a database dump was included If a database file is present: extract and recover my articles/blog posts from it If no database file is present: help recover as much article content as possible through alternative means (e.g., reconstructing from cached files, checking for Word...
I’m updating an existing database and need a reliable hand specifically for data entry work focused on database updating. The core of the assignment is data cleaning and val... then correct or flag them. • Validate key fields using simple logic checks or cross-referencing with reference lists I’ll provide. • Upload the cleaned data back into the database (MySQL via phpMyAdmin) and confirm row counts match. Deliverables will be weekly cleaned-data files plus a brief change log that notes what was fixed, removed, or added. Familiarity with Excel functions, basic SQL commands, and an eye for detail is essential. If you’ve handled similar data entry and maintenance tasks before and can commit a few hours each week, I’d be happy to hear how you c...
...requires a thorough penetration test across every component, from the public-facing pages to the admin dashboard and database layer. The primary focus is a realistic simulation of real-world attacks so I can clearly see where the platform, plugins, themes, and server stack are vulnerable. Key test scenarios I must see covered: • Brute force attack simulation on the login and registration endpoints • SQL injection testing, particularly against authentication and data-handling functions Please conduct any additional checks you consider essential for a complete assessment, but keep the site online and functional throughout. Industry-standard tooling such as WPScan, Burp Suite, OWASP ZAP, or equivalent is expected; include every command, request, or script you run so ...
...already use on the web version • A payment gateway to handle one-time and recurring purchases All endpoints must return JSON, follow REST conventions, and include basic rate limiting and error handling. I’ll share the current app flow, screen states, and sample payloads the moment we start, so you can stub everything quickly and then move to production-ready code. Deliverables • MySQL schema (SQL dump + ERD) • Deployed MySQL instance (cloud of your choice) • API source code with clear instructions to reproduce locally and on the chosen host • Postman or cURL collection for testing every route • Integration inside FlutterFlow with working data queries and mutations Acceptance criteria 1. CRUD operations complete in under 300...
...Job Title * Company Name * Category * Subcategory * Location * State * City * Salary * Experience * Qualification * Job Type * Skills * Number of Openings * Job Description * Company Logo * Apply Method * WhatsApp Number * Email Address * Expiry Date ## Search & Filters * Keyword * Category * City * State * Salary * Experience * Job Type ## Security * Secure authentication * CSRF protection * SQL injection protection * XSS protection * Input validation ## Performance * Fast page speed * Optimized database queries * Caching * Mobile-first design ## Deliverables * Complete source code * Database * Admin panel * Installation on my server * Bug fixing * Documentation * 30 days of support after delivery ## Developer Requirements * Proven experience building classified or...
Brief Client wants to track a fixed list of about 15–20 mutual funds or sto...trends in an Excel dashboard without touching code. Requirements • Python: Daily/weekly data fetcher (API or scrape) with incremental append logic — skips already-fetched dates and handles non-trading days • SQL: SQLite or MySQL backend storing fund_id, date, and nav, with computed daily/weekly returns as a view or materialized table • Excel: Power Query connection pulling directly from the SQL database, with a dependent dropdown (select fund → auto-filter dates) and a "Growth of ■100" style index chart Deliverables • Python fetcher script with scheduler note (Task Scheduler / cron) • SQL database file with schema documentation • Excel ...
...exports from different regional offices. They need a system to consolidate, clean, and reconcile this data against a master SQL database, then auto-generate a formatted Excel report. Requirements • SQL: Design a normalized schema (sales_master, regions, products tables); write queries to detect duplicate or missing entries across monthly uploads • Python: Script to read multiple Excel files using pandas, validate against the SQL schema, push clean data via SQLAlchemy, and flag mismatches in a log file • Excel: Auto-generated pivot-style summary report (openpyxl or xlsxwriter) with monthly totals, region-wise breakdown, and a variance column vs. the previous month Deliverables • SQL schema and seed script • Python ETL script (CLI-runna...
...Maintenance Contract) management SLA monitoring and escalation Spare parts and inventory tracking Dashboard with real-time ticket status and analytics Email/WhatsApp notifications Role-based user access (Admin, Manager, Coordinator, Technician) Mobile-friendly interface for field technicians Report generation and export (PDF/Excel) Preferred Technology: Modern web-based application REST API architecture SQL database Cloud or on-premises deployment Experience integrating with third-party systems is an advantage...
...Develop and maintain modern web applications. Build responsive, user-friendly frontends. Design and implement scalable backend APIs. Integrate third-party services and APIs. Improve application performance and reliability. Collaborate on new features and technical decisions. Preferred Skills JavaScript / TypeScript React, , Vue, or Angular Node.js (Express or NestJS) REST APIs and/or GraphQL SQL or NoSQL databases Git and modern development workflows Cloud platforms (AWS, Azure, or GCP) are a plus We're Looking For Someone Who Is currently based in the United States. Has strong communication skills. Writes clean, maintainable code. Can work independently and meet deadlines. Is reliable and interested in a long-term collaboration. Nice to Have Experience with AI integrations ...
...AI or rule-based automations—for example, predicting bottlenecks or surfacing overdue tasks—so managers see issues before they escalate. • Provide an architecture that leaves room to add classic workflow features such as task management, automated notifications, or progress tracking when we scale. Preferred stack I’m most comfortable with common analytics tools—Python (Pandas, scikit-learn), SQL, Power BI or Tableau for visualization, and a cloud database (PostgreSQL, BigQuery, or similar). If you have an alternative stack that hits the same goals, feel free to suggest it. Deliverables 1. A functioning web-based (or easily hosted) workflow optimization dashboard tied to my three data streams. 2. Annotated source code plus an ETL script or pi...
...The platform must be architected for high scalability and security, offer a responsive SPA-style interface, and feel instantly familiar to corporate users. Scope of work • Back-end: Design and implement a modular service layer (REST or GraphQL) that handles employees, clients, projects, jobs, attendance, gate passes, documents, KPIs, and reporting. A relational store such as PostgreSQL or MS SQL is preferred, with ORM migrations and role-based access control baked in from day one. • Front-end: Build a clean, lightning-fast UI in React, Angular, or Vue with TypeScript, real-time validation, and adaptive layouts that work equally well on desktop dashboards and tablets used on-site. • DevOps: Containerise the stack (Docker, Kubernetes or similar), wire up CI/CD...
...model and workflows. • Outline an extensibility plan (plugin or micro-services) so future features can be added without major refactoring. • Recommend a CI/CD pipeline for automated builds, unit tests and signed installers for Windows. Deliverables (acceptance criteria) 1. Architecture document (PDF/Docx) clearly describing design decisions, diagrams and technology choices. 2. ERD and SQL scripts ready to run on the suggested database engine. 3. Clickable wireframe or prototype demonstrating the main data-entry, search and reporting screens. 4. Source-controlled skeleton project that compiles on Windows 10/11, implements the agreed layering, and includes sample unit tests. 5. Read-me file that details build prerequisites and deployment steps. I can pro...
...overdue accounts and show real-time revenue dashboards. • Reporting – export attendance logs, membership statistics and financial summaries to CSV/PDF at the click of a button. I’ll need both the compiled installer and full source code, plus concise setup instructions so staff can deploy the app on multiple front-desk PCs. A modern, clean UI, easy navigation and solid local database (SQLite, SQL Server or your recommended option) are essential. Acceptance criteria: 1. Fingerprint scan records appear instantly in the member’s profile. 2. New member form captures all required fields and edits save without error. 3. Invoice PDF matches our sample template and marks as “paid” once a receipt is entered. 4. All reports export correctly a...
I’m updating an existing database and need a reliable hand specifically for data entry work focused on database updating. The core of the assignment is data cleaning and val... then correct or flag them. • Validate key fields using simple logic checks or cross-referencing with reference lists I’ll provide. • Upload the cleaned data back into the database (MySQL via phpMyAdmin) and confirm row counts match. Deliverables will be weekly cleaned-data files plus a brief change log that notes what was fixed, removed, or added. Familiarity with Excel functions, basic SQL commands, and an eye for detail is essential. If you’ve handled similar data entry and maintenance tasks before and can commit a few hours each week, I’d be happy to hear how you c...
I have a small (under 5 GB) Azure SQL Database that must be brought in-house and run on SQL Server Express 2022. Every object—tables with their data, stored procedures, functions, views and indexes—needs to make the trip intact so the system behaves exactly as it does today. Once the database is sitting in SQL Server Express, the legacy VB6 application that currently points to Azure has to reconnect seamlessly. That means updating the connection logic, testing all critical screens and reports, and confirming read/write operations work without timeout or syntax issues. Preferred workflow • Export or script out the Azure database, then restore or import into SQL Server Express 2022 using SSMS, Azure Data Studio, or the Data Migration Assistant...
...need an SSRS specialist to design and/or refine several tabular reports that sit on top of an existing SQL Server data source. The goal is to achieve clean, parameter-driven output that users can export instantly to Excel or PDF without additional formatting. Here is what I will provide: • Access to the database (SQL Server 2019) with sample data and the current schema • Business rules that determine which fields, filters, and aggregations must appear • Branding guidelines (logos, colours, fonts) What I expect from you: • Well-structured .rdl files that follow SSRS best practices (shared datasets, expressions kept in code where possible, consistent naming) • Optimised T-SQL queries or stored procedures where report performanc...
...applications from idea to deployment. Key Requirements (Must-Have): ✅ Language: FULLY BILINGUAL in English and Spanish (professional fluency – C1 or above). You will be interviewed and tested in BOTH languages. ✅ Frontend: Strong experience with React.js, , or Vue.js. ✅ Backend: Strong experience with Node.js () or Python (Django/Flask). ✅ Databases: Experience with SQL (PostgreSQL/MySQL) or NoSQL (MongoDB). ✅ Tools: Git, GitHub, and comfortable with remote collaboration tools (Slack, Zoom, etc.). Nice-to-Have: Experience with Docker, Kubernetes, or cloud platforms (AWS/GCP/Azure). Previous experience working in fully remote teams. What We Offer: Fully remote work (flexible hours). Starting rate: $30/hour (negotiable based on experience). Long-term opportunit...
...library/database. • A dedicated About Me/Team section drawn from the existing page content and formatting. You are free to reinstall Divi (if you hold a license) or replicate the design with an alternative theme or builder—Elementor, Gutenberg blocks, or custom PHP/CSS are all acceptable as long as the final result matches the original styling and responsiveness. I’ll provide: • Full site files and SQL backup • cPanel / hosting credentials for a staging sub-domain • Screenshots of the former design for reference Completion is confirmed when the rebuilt site: 1. Displays all portfolio items in a responsive grid on desktop, tablet, and mobile. 2. Shows the About Me/Team section styled consistently with the rest of the site. 3. Pass...
Need a website for our boutique brand. Need a modern, visually "stunning" website with smooth animations an...Media connectivity and access, Instagram recent posts and other necessary sections. Out of scope: User Accounts, online shopping. Should be functioning on all screen sizes. We will provide: logos, brand colour palette, videos and photos. Bonus: if website content should be configurable. Technical Requirements: To be designed in React.js with Redux Following strict component based design pattern A SQL/MySQL database holding Product and configuration. Behavioural Tests to be delivered for all workflows and critical component in Selenium/Playwright. Inspirations: Winning project will be between => 14,000 - 18000 INR
I n...edits. Core Functionality • Contact Us page must include a form that validates input and saves each submission to a MySQL table. • A lightweight success message (or modal) should confirm to users that their message was received. Deliverables • Fully responsive Home, About Us and Contact Us pages. • PHP scripts that handle form processing, input sanitisation and database insert. • SQL file (or clear setup notes) to create the required table. • Brief deployment/read-me so I can drop the project onto my server and go. Timing & Collaboration I’m aiming to sign off within 10 days, so clear checkpoints and a sensible milestone split will help us both stay on track. Links to similar work or quick wireframes are a plus&mda...
...expertise in Java, Spring Boot, REST APIs, and either React or Angular. The ideal candidate must have successfully completed Karat certification/assessment and should have prior experience delivering corporate training to professionals. Required Skills: Core Java & Advanced Java Spring Boot, Spring MVC, Hibernate/JPA RESTful API Development React.js or Angular HTML, CSS, JavaScript, TypeScript SQL (MySQL/PostgreSQL) Git, Maven/Gradle Microservices (preferred) Good understanding of software development best practices Mandatory Requirements: Karat Certified (or successfully completed the Karat assessment) Proven experience as a corporate trainer or technical mentor Strong communication and presentation skills Ability to conduct interactive virtual training sessions Experien...
I need a seasoned SSRS developer to turn a SQL Server data set into a polished compliance-audit report. My top priority is the visual structure—nested tablixes, precise grouping, conditional colour cues, warning/approval symbols, image placeholders, and reliable page breaks all have to work together so the PDF reads like a board-ready document. You will receive the database objects, sample data, and a style guide. From there, build the RDL yourself (no AI-generated one-click templates), and keep notes on why each region, expression, and parameter exists; I’ll ask you to walk me through that reasoning once the draft is ready. Deliverables • Production-ready .rdl file matching the style guide • A short design brief (1–2 pages) explaining layout choice...
...anything that falls outside the accepted formats, and leave me with a reliable, production-ready dataset. The work is entirely validation-driven: you will compare stored values against the reference rules I supply, normalise units, fix capitalisation, catch misplaced decimals, and make sure linked fields stay in sync. A portion of it will be manual review, but you’re welcome to speed things up with SQL queries, Excel filters, or any data-wrangling tool you prefer, as long as the final result is accurate. Deliverables • A cleaned and validated database file (same structure, corrected content) • A concise log or report of the changes made, so I can audit what was touched Acceptance criteria • No duplicate primary keys or records • All required fie...
...- Conduct a complete security audit of our application. - Identify vulnerabilities in the web application, APIs, database, and server. - Perform penetration testing and vulnerability assessment. - Review the application against the OWASP Top 10. - Analyze authentication, authorisation, session management, and input validation. - Review API security and identify potential attack vectors. - Assess SQL injection, XSS, CSRF, SSRF, IDOR, file upload, and other common vulnerabilities. -Review Linux server configuration and security hardening. - Assess cloud security configuration (if applicable). - Review source code for secure coding practices. - Investigate any suspicious activity or security incidents if discovered. - Provide a detailed report of findings, risk levels, proof of conc...
We are a financial service company looking for an experienced Full-Stack Developer or a small team to deploy our pre-built React-based Loan Management System, migrate its data layer from Firebase/Mock to a robust SQL Database (MySQL or PostgreSQL) with a secure Node.js backend, and build 2 companion Android apps that sync with this centralized database. The web portal's user interface, screens, states, and business logic are 100% complete and built in React (TypeScript) + Tailwind CSS + Vite. You only need to build the SQL backend, wire the API endpoints, build the Android applications, and go live on our custom domain.
Project Overview We are looking for an experienced backend developer or small agency to build a natural-language reporting chatbot for our live web platform. The system will allow internal staff to query a MariaDB database using plain English, automatically converting their questions into secure, read-only SQL queries via the Anthropic Claude API. The chatbot will display formatted data results directly in an existing web admin area and provide an option to download the output as a Word document. Core Technical StackBackend Framework: Symfony (PHP) Database: MariaDB AI Integration: Anthropic Claude API (specifically Claude Haiku 4.5 and Sonnet 4.6) Frontend: Existing Bootstrap 4 and Vanilla JavaScript (No heavy modern frontend frameworks required) Document Export: P...
...maintainable, and well-tested code. Participate in code reviews. Troubleshoot and resolve software issues. Optimize application performance and security. Collaborate with cross-functional teams using Agile methodologies. Required Skills 4+ years of professional software development experience. Strong knowledge of JavaScript and TypeScript. Experience with React. Experience with Node.js and Express. SQL or PostgreSQL database experience. Git and GitHub. REST API development. Docker fundamentals. Excellent problem-solving skills. Strong written English communication. Nice to Have AWS or Azure experience. CI/CD pipelines. Kubernetes. GraphQL. Automated testing with Jest or Cypress. Employment Details Remote position. Full-time. Flexible working hours. Long-term collaboration. Compen...
My production SQL Server is running on an Azure VM that was originally provisioned with a 500 GB managed disk. The database itself sits comfortably below 120 GB, so I’m paying for far more storage than I need. I want to shrink the provisioned space to 120 GB and cut the monthly bill, but I cannot afford even the slightest data loss in the process. Here’s what the job entails. You will: • Analyse the current 500 GB environment, confirm the live data footprint and identify everything that must move. • Safely shrink and migrate the database to a new 120 GB disk (or resize in place if that proves cleaner) while retaining all indexes, stored procedures and user accounts exactly as they exist today. • Optimise the VM and SQL configuration so perform...
...* Subscription Plans: Monthly/yearly premium memberships for businesses, car dealerships, or real estate agencies. 4. Technical Quality & Performance Standards * Real-Time Data Sync: Bids and countdown timers must update instantly across all platforms using technologies like WebSockets. * Security: Robust data encryption, secure password hashing, and protection against common vulnerabilities (SQL Injection, XSS). * Localization: Complete and accurate RTL (Right-to-Left) support for Arabic, alongside LTR for English. 5. Required Deliverables from the Developer/Agency * Full Clean Source Code: Fully documented and structured code repository. * Deployment & Launch: Successful publishing of the apps on Google Play and Apple App Store, and deployment of the website/admin ...
I'm looking for an experienced developer to integrate an SQL system into an existing app, which is not my own. Key requirements: - The SQL system will be primarily used for a nutrition database. - I need someone who can assess the app's current structure and determine if any APIs or endpoints are available for integration. Ideal skills and experience: - Proficiency in SQL systems (MySQL, PostgreSQL, or SQLite) - Experience with app integration and database management - Ability to analyze existing systems and provide solutions Please provide examples of similar work done.
...Laravel, Symfony, MySQL, PostgreSQL, Redis, RESTful API, Software Architecture. Project Overview We are seeking an expert Senior PHP / Backend Developer to spearhead the re-engineering and performance optimization of our core e-commerce server infrastructure. The primary objective is to systematically decouple critical domain modules from a tightly-coupled legacy monolith, optimize slow-running SQL queries, eliminate database deadlocks under peak transactional loads, and deliver a high-throughput, secure API layer for frontend integration. This is an intensive, 6-week contract requiring complete technical autonomy and immediate delivery. 2. Scope of Work The selected engineer will take full ownership of the following technical execution streams: Monolith Decomposition & R...
Full Stack developer having 10+ .NET Core/Angular exp Design, develop, and maintain robust and scalable web applications using .NET Core for the backend and Angular 19 for the frontend. Implement server-side logic, APIs, and database interactions using C#, .NET Core, Entity Framework, and SQL Server (or other relevant databases). Develop responsive and interactive user interfaces using Angular, HTML, CSS, JavaScript/TypeScript, and related libraries (e.g., Angular Material, RxJS). Integrate frontend and backend components, ensuring seamless data flow and communication via RESTful APIs. Write clean, efficient, and testable code, adhering to coding standards and best practices. Participate in all phases of the Software Development Life Cycle (SDLC), including requirements gathering, ...
I need an e-commerce website built with the CodeIgniter PHP framewor...plug in additional gateways without a full rewrite. Key deliverables: • Responsive storefront and service-detail pages • Password-protected customer accounts with email verification and password reset • PayPal checkout flow, order confirmation, and IPN handling • Admin dashboard to create, edit, and deactivate services, view orders, and issue refunds • Complete CodeIgniter project files, SQL schema, and a brief setup guide Acceptance criteria: All core pages load error-free, user actions (register, log in, buy, view orders) work end-to-end, and a real PayPal transaction completes successfully during hand-over. Let’s keep the interface clean, the code well-commented, and th...
...the back-end and database layers. The project covers three SQL-related areas: designing and structuring the database from scratch, migrating legacy data into the new schema, and then fine-tuning queries so performance stays sharp under load. On the application side I’m using Web Forms for the user interface, backed by a set of API services that expose selected functionality to other systems. Robust authentication and authorization must be baked in from the start so we can meet internal security policies. You’ll work mainly with Microsoft SQL Server, C#, and VB.NET (some legacy modules are in VB). Familiarity with Windows Server administration is a plus as it speeds up troubleshooting on the IIS host. Deliverables • Normalized SQL Server databas...
...pipeline—from ingestion through transformation to storage—so that the front-end team always has clean, query-ready information. You’ll also dive into exploratory and diagnostic analysis, helping us uncover trends that inform product decisions and power the visual stories we show users. The stack is flexible, but you should be comfortable with modern data-engineering tools (think Python or Scala for ETL, SQL-based warehouses, stream processing frameworks, containerised deployments, and cloud services such as AWS or GCP). On the web side we are leaning toward a REST-or GraphQL-driven API that feeds a JavaScript visualisation layer. If you have a preferred alternative that achieves the same performance and scalability goals, I’m open to it. By the end o...
...indicative timeline is four to six weeks: * Requirements and API review – 1 week. * Data mapping and business rules – 1 week. * Design and prototype – 1 week. * API integration and development – 1 weeks. * Testing and User Acceptance Testing – 1 week. * Deployment and training – 1 week. 9. Future Expansion Options * Scheduled automatic API synchronisation. * Automated weekly email distribution. * SQL and Power BI integration. * Driver risk scoring. * Geofence reporting. * Predictive risk analysis. * Additional reports, clients, and KPIs. * Mobile reporting and management alerts. 10. Summary The Automated IVMS Reporting Platform will combine weekly exception reporting, kilometre reporting, and staff risk management into one central solution...
...management, defect resolution, and RCA • Functional and technical documentation • Change management and CAB participation • ServiceNow ticket management • Support Finance Close and critical business periods • Coordinate with global teams across regions Mandatory Skills Oracle EBS R12.2.3 Finance Modules: AP, AR, GL, FA, EBTax, Vertex, OneSource, Cash Management • Strong hands-on experience in: o PL/SQL o Oracle Forms o Oracle Reports o BI Publisher o ADF/OAF o Workflow Builder • Experience supporting customizations, extensions, and integrations • ServiceNow or similar ITSM platform experience • Experience with Vertex and external tax engine integrations • Experience in multinational deployments (English, Chinese, Japanese) • ...
Oracle EBS ASCP (Advanced Supply Chain Planning) Functional Consultant (7+ Years) Role Summary Seeking an experienced Oracle EB...Experience • Oracle ASCP • Inventory • Purchasing • Order Management (OM) • Shipping Execution • Collections & Planning Server Setup • Distributed Planning Environment Experience • ATP (Available-to-Promise) • Safety Stock & Supply Planning Concepts • Sourcing Rules • Strong SQL Skills Oracle Workflow • Concurrent Programs Good to Have • Global Order Promising (GOP) • Oracle Value Chain Planning • Demantra • APCC • Oracle Production Scheduling • Retail Supply Chain Experience • Oracle Certification Nice-to-Have Technical Skills • PL/SQL &bull...
Step by step guide for using MySQL database engine from Node.js
Want to expand the freelance services you're offering? Learn a new skill and take an exam that will certify your expertise.