Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
...issues across the stack Contribute to technical documentation and internal best practices What We're Looking For 5+ years of professional experience with C# / .NET, including exposure to legacy .NET Framework applications Solid experience with ASP.NET Core (Web API, MVC, or Razor Pages) Hands-on experience building UI with React (hooks, component architecture, state management) Working knowledge of SQL Server or another relational database Comfort working with REST APIs and understanding of software design patterns Experience with Git and collaborative development workflows Strong problem-solving skills and the ability to work independently across unfamiliar codebases Nice to Have Experience with Azure or AWS Familiarity with CI/CD pipelines Exposure to TypeScript Experience...
I am a Computer Engineering student at LDRP Institute of Technology and Research with a strong foundation in technical problem-solving. While my earlier projects centered on building digital experiences, my true passion lies in uncovering patterns and driving strategic decisions through Data Analytics. Currently, my analytical toolkit includes SQL for data wrangling and complex querying, alongside Excel for in-depth data manipulation. I specialize in bringing these raw numbers to life through interactive dashboards and visualizations using Power BI and Tableau, transforming complex datasets into clear, actionable business intelligence. Along with my analytical journey, I have worked as a Mentor in US IT Bench Sales Recruitment, where I developed the communication and leadership sk...
**Available for Freelance Projects | Full-Stack Developer & UI/UX Designer** Hi everyone! I’m currently available for **freelance projects and remote opportunities**. I’m a **Full-Stack Software Engineer** with experience in: React.js | Angular | JavaScript/TypeScript C# | ASP.NET Core | .NET 8 Web API SQL | PL/SQL | Oracle APEX | Entity Framework Core Figma | UI/UX Design | Responsive Web Design Azure | GitHub Actions | CI/CD Power BI | Data Analysis I’ve worked with international clients on responsive web applications, REST API integrations, Figma-to-code development, performance optimization, and complete frontend development. I can help with: • Building websites and web applications from scratch • React / Angular frontend developmen...
...large datasets * Database indexing * Proper caching where useful * Avoid unnecessary React re-renders * Responsive images Target strong Core Web Vitals and Lighthouse performance. ## Security Implement production-grade security practices: * JWT authentication * Password hashing with bcrypt * Input validation * API validation * CORS configuration * Helmet * Rate limiting * Protection against SQL injection * Protection against XSS * Secure environment variables * Proper error handling * No secrets in source code * Authentication middleware for admin APIs ## API Structure Create clean REST APIs such as: * POST /api/auth/login * POST /api/auth/register if required * GET /api/services * POST /api/services * PUT /api/services/:id * DELETE /api/services/:id * GET /api/projects * ...
...**Playwright / Selenium / Cypress** for web automation * **Appium** or equivalent framework for mobile automation * **Postman / REST Assured / similar tools** for API automation * JavaScript / TypeScript / Python / Java / C# depending on the selected framework * Git / GitHub / GitLab / Bitbucket * CI/CD tools and pipelines * Experience with cloud-based SaaS applications * Experience with PostgreSQL or SQL databases is a plus We are open to your recommendation regarding the **best automation technology/framework** based on our application architecture. We are more interested in a robust, maintainable solution than simply using a particular tool. ## Ideal Freelancer We are looking for someone who: * Has strong hands-on experience in automation testing. * Has previously built au...
Our in-house created document control software has been running smoothly on a C#/.NET stack, MS SQL Server, and AWS for several years, but the developer who built and nurtured it is leaving. I need someone who can step in right away, understand the codebase, and keep the software/application stable and performant. The immediate focus is routine maintenance—diagnosing and fixing any bugs that surface and squeezing better performance out of the code, database, and AWS resources. I don’t have a current list of issues, yet I suspect the usual mix of edge-case errors and slow queries will emerge once you start profiling the system. You’ll get full access to the Git repository, SQL scripts, and our AWS environment (EC2, RDS, S3). A thorough walkthrough with the ...
...Mapping must be preserved so future updates keep everything aligned. • Order side When a customer places an order, the bridge catches it instantly, calls the supplier API to purchase the corresponding digital key, retrieves the key and posts it straight back through the store API so the customer receives it without delay. Technical notes – Both APIs are REST. – A small, fast database (SQL or NoSQL is fine) should sit in the middle for caching, mapping and deduplication. – On any failed call the bridge should automatically retry with exponential back-off; I’ll review other alerting/logging options later, but solid retry logic is essential from day one. – Idempotency is critical so duplicate orders never slip through. – Clean...
I have a set of numeric records that currently live in a proprietary, custom-built database. I need every figure lifted out accurately and keyed into the destination sheets I will provide so I can run consistent reports. You will receive read-only access to the database interface (along ...populate. Accuracy is the top priority—decimal placement, units and column order must match the template exactly. I will run spot checks, so an error rate above 0.2 % is unacceptable. Once complete, submit the filled spreadsheet plus a brief log of any ambiguous values you encountered and how you resolved them. If you have previous experience extracting data from custom databases rather than standard SQL or NoSQL engines, note that in your proposal; it will help me gauge fit and turnaround...
...on-demand and scheduled reports—profit & loss, cash-flow snapshots, trend charts, and any other analytics you recommend that help me spot patterns fast. • Export reports to PDF and Excel. I’m happy to discuss the stack, though a solution that feels native to Windows—think C#/.NET, WPF, WinUI, or similar—will be easiest for me to maintain long-term. A lightweight local database such as SQLite or SQL Server Express is fine, as long as backup and restore are simple. Deliverables 1. Installer or ready-to-run executable for Windows 10/11 2. Source code with brief build instructions 3. Short user guide that shows how to add data and run the analytics Acceptance criteria • Application installs without additional paid dependencies &bul...
...effortlessly toward the information or action they need. In addition to the features outlined below, patients will be encouraged to stay engaged through an integrated blog section that delivers health tips and practice news. Stack and architecture • Back-end logic is planned in PHP for traditional server tasks and Node.js for any real-time components that benefit from non-blocking I/O. • A secure SQL database needs to be designed, populated, and tuned to store patient records, appointment data, doctor profiles, service catalogs, and log data. Normalization, strict role-based access, and encryption at rest are essential. • I expect neat separation of concerns, clean API endpoints, and code that can be containerized for CI/CD. Core functionality • Onli...
...search or tag filter Design Requirements - Keep existing visual design, typography, spacing, and layout language - Responsive on mobile and desktop - Convert static HTML sections into templated/components in your chosen framework - Preserve semantic structure where practical Technical Expectations - Clean, maintainable code - Secure auth and input validation - Protection against common issues (SQL injection, XSS, CSRF as applicable) - Seed/sample data so the site looks complete on first run - Clear project structure and comments where needed Deliverables 1. Full source code schema/migrations 3. Working local setup instructions 4. Single-server deployment guide (VPS or similar) 5. Default admin/demo account credentials for testing 6. Short handoff notes: how to create users, p...
...search or tag filter Design Requirements - Keep existing visual design, typography, spacing, and layout language - Responsive on mobile and desktop - Convert static HTML sections into templated/components in your chosen framework - Preserve semantic structure where practical Technical Expectations - Clean, maintainable code - Secure auth and input validation - Protection against common issues (SQL injection, XSS, CSRF as applicable) - Seed/sample data so the site looks complete on first run - Clear project structure and comments where needed Deliverables 1. Full source code schema/migrations 3. Working local setup instructions 4. Single-server deployment guide (VPS or similar) 5. Default admin/demo account credentials for testing 6. Short handoff notes: how to create users, p...
...document results in clear, shareable reports. Scope: - Selenium (Page Object Model) will drive the browser, exercising price searches across services and regions; focusing on commonly used Azure services and SKUs. - For service-to-service price comparisons, lean Requests-based calls will be used to validate REST API pricing endpoints against UI results. - Data will live in SQLite for now – running SQL rules to catch duplicates, gaps, or sudden changes. Historical deltas and anomaly alerts will surface on a simple dashboard. - Tests will run under PyTest and finish with an HTML report, execution log, and a CSV/Excel summary suitable for finance teams. Deliverables: 1. Full source code (Python 3.x, Selenium, PyTest, Requests, SQLite). 2. Clear Read-me guide with setup and ...
...date/time, raw text, hashtag list, basic engagement numbers, and an anonymised user ID • Simple configuration file where I can add or remove keywords, hashtags or date ranges without touching the core code • Clear documentation plus a short demo notebook or script showing how to load the data and run a sample sentiment check If you have existing routines for natural language processing, Redis/SQL storage, or cloud deployment, feel free to weave them in as long as they keep the workflow portable. Code review and a quick run on my own machine will serve as the final acceptance test....
...be handing the project to an internal team after launch, clean code and clear comments matter as much as the feature set. Stable state management (Provider, Riverpod, or Bloc—whichever you prefer) and a well-structured ASP.NET Core solution are key. Deliverables • Flutter source code with build instructions for iOS & Android • ASP.NET Core Web API project with README and brief Swagger docs • SQL Server (or PostgreSQL) script for initial schema and seed data • Simple driver and rider test accounts so I can demo the flow • Short hand-off session or video walkthrough covering project setup and deployment Acceptance criteria: builds successfully on both mobile platforms, OTP authentication functions end-to-end, rides can be requested and c...
...under load. Pages that once rendered in under a second now spike past five, occasional time-outs appear in the logs, and CPU usage sits uncomfortably high. I’m looking for help focused strictly on bug fixes and ongoing maintenance, with the immediate priority being performance bottlenecks on the server side. You’ll start by profiling the application (IIS, ASP.NET MVC / Web API, Entity Framework, SQL Server) to pinpoint slow spots—inefficient queries, memory leaks, or blocking calls. From there, I need clean, well-commented patches that restore sub-second response times under typical traffic and remain stable in our staging environment for at least 48 hours before deployment. Deliverables • Diagnostic report outlining root causes and performance metrics ...
I’m a senior ASP.NET / C# engineer with more than 9 years of hands-on experience in web application and back-end development, SQL Server & MySQL, RESTful API design, and modern front-end integration. I’m now ready to move into a stable, full-time remote position and I’m offering a straightforward success fee: whatever my first complete month’s salary is, I will transfer that exact amount to the person or company that secures the role for me and delivers an official appointment letter. Here’s what the position must include: • Full-time, fully remote employment issued by an individual employer (not a freelance contract). • Core stack built on ASP.NET / C# with room to apply my skills in Angular or React alongside Entity Framework and .NET...
I need to organise all of my customer information in a structured SQL database and give my team a simple way to add or update those records directly from their phones. The core of the job is two-fold: first, design and deploy a clean relational schema that captures names, contacts, addresses, notes and whatever other standard customer fields you would normally expect; second, build a mobile interface that lets users create, read, update and delete those records through straightforward forms. The mobile side can be cross-platform in Flutter or React Native, or native Android if that is faster for you—what matters most is that it connects securely to the database, validates input, and presents a searchable list of existing customers. No CSV imports or external APIs this time; e...
Build a single Power BI dashboard that pulls data live from my Excel workbooks and our SQL database, then turns that information into clear insights about customer demographics and customer satisfaction. The data model should merge both sources seamlessly, handle refresh schedules, and expose relationships that let me slice results by date, region, product line, and any other key fields you uncover. Inside the report, I want bar charts for quick comparisons, pie charts for proportional breakdowns, and line graphs that reveal trends over time—each fully interactive with tooltips, drill-through, and cross-filtering. Supply the finished .pbix file, document any custom DAX logic, and publish a ready-to-share version to Power BI Service (or show me how in a brief hand-off cal...
I need to turn two raw datasets—sales and customer records—into a clean, insight-packed dashboard. Start by profiling the data in Excel or SQL, removing duplicates, filling or flagging missing values, and standardising every date, currency and categorical field so the tables can join cleanly. With trustworthy data in place, build an end-to-end Power BI model: set relationships, create calculated columns and DAX measures, and surface the KPIs that drive our decisions (revenue trends, customer lifetime value, churn, product mix, regional performance). The visuals should be interactive, with slicers that let managers move from an executive overview down to line-item detail. Quick exploratory charts in Excel are welcome, but the final, shareable report must live in Power BI...
...issues across the stack Contribute to technical documentation and internal best practices What We're Looking For 5+ years of professional experience with C# / .NET, including exposure to legacy .NET Framework applications Solid experience with ASP.NET Core (Web API, MVC, or Razor Pages) Hands-on experience building UI with React (hooks, component architecture, state management) Working knowledge of SQL Server or another relational database Comfort working with REST APIs and understanding of software design patterns Experience with Git and collaborative development workflows Strong problem-solving skills and the ability to work independently across unfamiliar codebases Nice to Have Experience with Azure or AWS Familiarity with CI/CD pipelines Exposure to TypeScript Experience...
...core concepts, tools, and hands-on skills needed to work as a data engineer on AWS. What I'm looking for: 1:1 sessions (video call) covering AWS data engineering fundamentals and hands-on labs Coverage of core services: S3, Glue, Redshift, Athena, Kinesis, Lambda, EMR, Step Functions, RDS/DynamoDB ETL/ELT pipeline design, data lake vs. data warehouse concepts Python/PySpark for data engineering, SQL for analytics Guidance on real-world project work I can add to my portfolio/resume Optional: help prepping for AWS Data Engineer – Associate certification Ideal candidate: Proven hands-on experience as an AWS Data Engineer (production experience preferred, not just certs) Comfortable teaching/explaining concepts to someone new to the field Available for recurring weekly...
...• explore table relationships and data quality, • run summary statistics and frequency counts, • create straightforward visualizations—think bar plots, histograms, heat-maps—that quickly communicate the story behind the numbers, • package everything into a short, well-commented Jupyter Notebook (or SQL script plus slides, if you prefer) so I can reproduce the results at any time. Please keep the focus on descriptive methods; no predictive modelling is necessary. Familiarity with SQL, pandas, and a visualization library such as Matplotlib or Tableau will speed things along. I’m aiming for clarity over complexity, so clean, well-labelled outputs are more important than advanced techniques. When you reply, let me know roughly how ...
I want to extend my Dolibarr installatio...thumbnail generation. • Tags are plain-text keywords entered by the user; they need to be stored in the database and displayed under each image, with the ability to filter/search products by those tags later on. • The solution must respect Dolibarr’s module guidelines so I can install or remove it cleanly through the standard module manager. Deliverables - Complete Dolibarr module (PHP sources, SQL schema changes, language files) - Simple installation guide and a short README showing where to place the files and how to activate the module - Brief test report proving that uploading, tagging, displaying and searching all work on a fresh Dolibarr instance I’m ready to review and merge quickly, so please ai...
Truebodh...experienced Windows Infrastructure & Application Migration Engineer for a 3-month migration project. The project involves migrating business-critical ASP.NET applications, Secured web Portal applications, IIS websites, and SQL Server Reporting Services (SSRS) from Windows Server 2012 to a modern supported platform. The selected freelancer will be responsible for planning, execution, testing, documentation, production cutover, rollback planning, and post-migration support. This is a hands-on technical project requiring expertise across Windows Infrastructure, IIS, .NET Applications, SQL Server, SSRS, Networking, PowerShell Automation, and Technical Documentation. Remote Engagement ₹25,000/month Office-Based (EMEA Shift) - Ghaziabad ₹35,000 - ₹45,000/month Du...
...with U.S. State & Local Indirect Tax Audits. Preferred backgrounds include: * SALT / Indirect Tax Analyst or Senior Analyst * Sales & Use Tax Auditor * State Tax Auditor * Indirect Tax Consultant * Corporate State & Local Tax professional * Big 4 or other tax consulting experience * Experience handling Sales/Use Tax audits for large U.S. companies Experience with tools such as Excel, Alteryx, SQL, Power BI, Vertex, Avalara, or similar tax/data technologies is a plus. Training Format We prefer an intensive one-day live online session, approximately 5–8 hours, with screen sharing and practical examples. Please mention in your proposal: 1. How many years of U.S. SALT/Indirect Tax experience you have. 2. Whether you have personally handled Sales/Use Tax audit...
...around outcome prediction, not trend-spotting or process optimization, so every step—from cleaning the raw customer records to validating the finished model—should directly support that goal. Here is the flow I envision: • Data preparation: handle missing values, engineer features that truly influence buying decisions, and document every transformation in clear, reproducible code (Python, R, or SQL—whichever you prefer). • Model development: test several supervised learning techniques, benchmark them with appropriate metrics (AUC, precision-recall, or another mutually agreed KPI), and converge on the best performer. • Insight & deployment assets: deliver a concise report explaining key drivers of purchase likelihood, the trained model fil...
I run a finance operation that relies on up-to-the-minute market data. What I need now is a streamlined MIS process that turns those feeds into clear, insightful reports and dashboards. You’ll work with market data exclusively, shaping it end-to-end: extracting with SQL, modelling in Excel for quick ad-hoc views, and visualising in Tableau for daily management reporting. Everything must refresh automatically so my team can focus on decisions, not data wrangling. Deliverables • SQL scripts that pull and aggregate the required market data on a schedule • An Excel model with clean, pivot-ready tables and scenario analysis sheets • Interactive Tableau dashboards (published to our server) featuring drill-downs, KPIs, and one-click PDF exports • ...
PHP (Procedural or OOP, clean and secure) MySQL (Database creation script required) Bootstrap 5 (Responsive UI) Key Deliverables: 8 total PHP pages. Complete CRUD (Create, Read, Update, Delete) functionality for personnel. Input validation and SQL injection prevention (Prepared statements). Clean, well-commented code. Database .sql schema dump. Required Skills: Strong proficiency in PHP and MySQL. Experience with Bootstrap 5 frontend layout. Understanding of web security basics.
...sale so you can skip six months of development and start tracking how your website is really performing from day one. The solution is already wired to ingest raw site logs, clean them with Python scripts, model them in SQL, and surface the numbers that matter inside sleek, interactive PowerBI views. Every metric, chart, and drill-through has been built with performance analytics in mind, so you can spot slow pages, high-exit funnels, and untapped revenue opportunities without touching code. You will receive: • Full, well-documented Python source code • Ready-to-import SQL database (schema + seed data) • Three PowerBI dashboards (overview, deep-dive, executive snapshot) Import the database, point the ETL to your own logs, and the visuals light up&mdas...
Project Title: Expert Frappe / ERPNext Developer Needed for Synology NAS Integration (Civil Engi...Vendor Master, and Employee Master. Workflow Automation: Script automated cascading task dependencies based on project type and department (e.g., Highway vs. Structures engineering workflows). HRMS & Payroll Integration: Configure mobile-friendly daily attendance logging and automated monthly payroll calculation rules (Basic, HRA, PF, PT). Backup Pipelines: Assist in configuring nightly MariaDB SQL database dumps and validating the backup pipeline to a secondary Synology unit. Prerequisite: You MUST have prior experience deploying ERPNext on local Synology NAS hardware and writing Python scripts that interact with local OS file systems. Standard cloud deployment experience is n...
...written English, preferably C1 or C2 level Junior to mid-level full-stack development skills HTML, CSS, and JavaScript Experience with React, , Angular, Vue, or similar Experience with Node.js, Python, Java, PHP, C#, or similar Basic knowledge of APIs, databases, Git, and authentication Reliable communication and ability to work remotely TypeScript, cloud, Docker, CI/CD, automated testing, and SQL/NoSQL experience are helpful but not required. Work Arrangement Remote Full-time or part-time availability $10-$80 USD/hour depending on experience and skills How to Apply Please submit your proposal through Freelancer with a short introduction, your technical experience, English level, availability, and preferred hourly rate. Shortlisted candidates may be invited to a brief Englis...
...planning, go-live activities, and transition to production. 2. Server & Configuration Management Configure and maintain application/server configuration files. Set up and manage Dev, QA, and Production environments. Configure and troubleshoot integrations between IBM Rational tools. Investigate configuration issues and support performance optimization. 3. Database Management Work with Oracle, SQL Server, and/or DB2 databases. Identify and remove obsolete or redundant data. Perform controlled database cleanup/truncation after migration where required. Ensure appropriate backup, recovery, and rollback procedures. Maintain data consistency and audit compliance. 4. Application Support & Maintenance Provide L2/L3 production support. Troubleshoot application and integrati...
I have an existing SQL database that needs regular, accurate data entry and ongoing management. The core of the work is keeping every record current, validating each new entry against our existing tables, and running simple queries to confirm that key fields stay consistent over time. You will receive raw data files (mostly CSV) on a scheduled basis. I’ll expect you to import them, reconcile any duplicates, flag inconsistencies, and confirm successful inserts. Familiarity with basic normalization rules, foreign-key constraints, and indexing is important because I want the tables to remain fast and reliable as they grow. Deliverables: • Cleaned, imported data sets fully integrated into the SQL database • A brief log of changes, issues found, and resolutio...
...issues across the stack Contribute to technical documentation and internal best practices What We're Looking For 5+ years of professional experience with C# / .NET, including exposure to legacy .NET Framework applications Solid experience with ASP.NET Core (Web API, MVC, or Razor Pages) Hands-on experience building UI with React (hooks, component architecture, state management) Working knowledge of SQL Server or another relational database Comfort working with REST APIs and understanding of software design patterns Experience with Git and collaborative development workflows Strong problem-solving skills and the ability to work independently across unfamiliar codebases Nice to Have Experience with Azure or AWS Familiarity with CI/CD pipelines Exposure to TypeScript Experience...
...pulls customer counts from two sources—an Excel file and our Databricks environment—and visualises the 12-month trend for each line of business across Brand A, Brand B and Brand C. The core visual should be clean line charts with a rolling monthly view, allowing users to toggle brands or drill down by product line without losing the last-year perspective. You will work with my existing Databricks SQL endpoint (I’ll share the cluster URL and credentials) and a locally stored Excel workbook. I need the model set up so both sources refresh automatically through the Power BI gateway and any new month appended to either source rolls straight into the visuals. Deliverables • A .pbix file containing the data model, relationships, measures and final report pages ...
...issues across the stack Contribute to technical documentation and internal best practices What We're Looking For 5+ years of professional experience with C# / .NET, including exposure to legacy .NET Framework applications Solid experience with ASP.NET Core (Web API, MVC, or Razor Pages) Hands-on experience building UI with React (hooks, component architecture, state management) Working knowledge of SQL Server or another relational database Comfort working with REST APIs and understanding of software design patterns Experience with Git and collaborative development workflows Strong problem-solving skills and the ability to work independently across unfamiliar codebases Nice to Have Experience with Azure or AWS Familiarity with CI/CD pipelines Exposure to TypeScript Experience...
I need a sharp, tech-savvy professional who can speak and write English so naturally that our North-American...handle • Recorded or documented user training sessions (brief but clear) • A weekly summary of maintenance checks performed and any risks spotted The platform itself is well documented, and I’ll provide all manuals plus live access to our staging environment for practice. You should already be comfortable using common remote-support tools and ticketing systems; if you know basic MongoDB / SQL or log parsing, that’s a plus. Availability across US business hours is preferred, though I’m flexible if communication stays quick. Drop your short voice or video intro alongside a concise overview of similar SaaS support work you’ve done, and...
...for Dispatch → Dispatched → Invoice Generated → Payment Pending → Payment Received → Closed. At any point I need to open the tracker and see where each PO sits, along with the raw data that was extracted. Core expectations • Accurate OCR/data-extraction for both clean PDFs and photographed documents • A simple browser interface to upload, view, and filter orders by status • Secure storage (SQL or NoSQL—your call) with an audit trail of status changes • Ability to add or reorder workflow stages later without code overhauls • Clean codebase (Python-Flask, Node, or similar) plus brief setup docs so my team can host it in-house Nice-to-have, but not mandatory: automated email or SMS nudges when a stage changes; dashb...
...in spring boot, key annotations and configurations, REST API and development, Microservice principles and implementation. Strong experience in REST Http services design using Swagger/Open API, unit testing and integration testing. Strong experience in frameworks/ modules like Spring Core, Spring MVC, Spring AOP, Spring Batch and Spring Data experience with SQL Server / PostgreSQL / MySQL or any RDBMS integration using JPA-Hibernate and SQL tasks i.e., writing stored procedures, complex SQLs, performance tuning, handling transactions. Strong experience in Angular 14+ or REACT JS 18 Strong experience in Java script, jQuery, Bootstrap, Html 5, CSS3 Working knowledge of Webpack, CLI and Agile Scrum framework Strong experience in unit testing, mocking frameworks, integration te...
...stack—Node.js, Laravel, or another robust framework—as long as: • Code is clean and documented. • API endpoints are protected (JWT, OAuth, or similar). • Admin panel is responsive (Vue, React, or standard Bootstrap is fine). • RNG or fairness logic can be audited. Deliverables • Production-ready slot game source code. • Fully functional admin panel with the three features listed above. • SQL schema and a brief deployment guide (Docker or plain VPS is fine). • One test account demonstrating the end-to-end flow from registration to payout. Acceptance I will consider the project complete once I can: • Register a player, fund the account, place bets, and cash out. • Track those actions instantly in ...
I have a production oracle instance that has grown beyond 100 GB and it now needs to live on SQL ,Server postgres sql . The task covers everything from preparing the source, mapping the schema, transferring the data, and validating that every object—tables, views, functions, and constraints—behaves exactly the same once it lands in SQL Server. Here is what I expect to walk away with: • A fully migrated SQL Server database, ready for cut-over • A repeatable migration script or SSIS/ADF/DMS pipeline so I can re-run the process for future refreshes • A concise migration report highlighting any datatype conversions, performance tweaks, and objects that required special handling • Verification scripts or queries that prove row...
... • Query optimisation – analysing execution plans, AWR/ASH reports and SQL traces to cut response times and CPU usage. • Index management – auditing existing structures, redesigning or rebuilding where needed, and advising on partitioning or compression if it brings measurable gain. I will grant full access to the non-production environments first, then schedule controlled moves into production once we agree on the changes. Clear before-and-after metrics are essential; please include a concise report that shows what you changed, why, and the improvement achieved. A solid background with both Oracle Database and Oracle E-Business Suite is mandatory, and comfort with tools such as SQL*Plus, OEM/Cloud Control, SQL Tuning Advisor and Data D...
1. High-Potential Skills for "Duo-style" Learning Duolingo's format works best for skills that can be broken into discrete, repeatable units (micro-learning). Category-specific Skill Examples - Technical: Coding syntax (Python, SQL), Excel formulas, Cyber-security basics. - Academic: Mental math, Historical timelines, Biology terminology, Hindi grammar. - Lifestyle: Music theory / Sight-reading, Chess tactics, Cooking techniques, First Aid. - Professional: Project management terms, Sales scripts, Medical coding, Soft skills (IQ/EQ). 2. Essential "Duolingo-Style" Features These are the mechanical parts of the habit-formation engine. - Streak Mechanic: Heart of the app; include "Streak Freezes" to prevent rage-quitting. - Bite-Sized Lessons: Le...
...information so I can quickly answer questions such as: • How often do customers buy and what is the typical basket size? • Which products or categories dominate repeat purchases? • What seasonality or time-of-day patterns emerge? • How does average order value shift across segments (e.g., first-time vs repeat shoppers)? Deliverables 1. A cleaned, well-documented dataset (Python script or SQL query included). 2. An executive-level report (PDF or slide deck) that walks through key findings, charts, and actionable insights. 3. An interactive dashboard (Power BI, Tableau, or a Jupyter Notebook with Plotly) so I can slice the data myself afterward. Acceptance criteria • All calculations are reproducible from the supplied code/notebook. ...
I have a React front-end paired with a Java Spring Boot back-end that is already running locally; now I need it live on Microsoft Azure. The plan is to host the Spring Boot API and the React build on Azure App Service and wire everything up to an Azure SQL Database. What I need you to do • Create or refine the Azure resources (App Service + Azure SQL Database). • Set up the build and deployment workflow so every push to the repository triggers a fresh deployment of both the React static files and the Spring Boot jar. Azure DevOps or GitHub Actions is fine as long as it is reliable. • Configure environment variables, connection strings, and SSL settings so the API talks securely to the database and the front-end talks to the API. • Validate that th...
...LTP and LTQ • cumulative traded volume • total buy quantity and total sell quantity • the best five bid prices with their quantities • the best five ask prices with their quantities • an identifier for the stock universe being tracked I will do all rule-based filtering afterward, so please ensure the raw stream for every stock is preserved exactly as received. Storage needs to be an SQL database; feel free to design the schema that best suits fast inserts and later querying. I would like the code to rely on SQLAlchemy for ORM / connection handling so it stays portable across engines (PostgreSQL is what I use in production). Provide clean, well-commented source in a Git-friendly structure plus a brief README that explains: • how to set up...
...systems or static spreadsheets. The build must support: • Real-time data analysis so new encounters, labs, and vitals are visible in minutes, not days. • Customizable reporting templates our analysts can adjust without developer help. • Data visualization tools that present trends clearly for non-technical decision-makers. I’m open to the platform you recommend—whether that’s Snowflake, SQL Server, BigQuery, Redshift, or a comparable HIPAA-compliant stack—as long as you outline why it fits our scale and security needs. Please plan for typical healthcare data standards (HL7 v2, FHIR, or CCD) and include an ETL/ELT pipeline that cleans, normalizes, and de-identifies data where required for compliance. Deliverables expected: 1. Dimen...
...automatically depending on the signed-in role. CRUD sample For the showcase form, feel free to use a simple table such as Customers or Products. The form should demonstrate DevExpress grid, add/edit/delete dialogs, validation, paging, and search. All operations must persist to PostgreSQL and respect the active user’s rights. Deliverables • Visual Studio solution with commented VB.Net code • SQL scripts (schema + seed data for roles, users, and the sample table) • Brief setup guide so I can compile, run, and extend the project Acceptance criteria The code compiles without errors, connects to PostgreSQL out of the box, logs users in with role-based access, shows the role-sensitive main menu, and performs full CRUD on the sample entity. If anything...
We’re building the next-generation web version of an established product and are looking for an experienced Front-End Developer to help lead the rollout. You’ll work primarily with React, , and TypeScript, building the interfaces our customers use every day. The frontend integrates with an existing C#/.NET REST API backed by SQL Server. You won’t be responsible for modifying the API or database, but you should be comfortable understanding relational data structures and working closely with backend developers when API or data issues arise. What You’ll Do Build and maintain production UI features using React and Work with App Router, SSR, routing, server/client components, and modern data-fetching patterns Integrate frontend functionality with an existing C...
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.