Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
我正在筹建一套包含 Web 与桌面端的遥感影像处理业务系统,需要一位精通 Java 的全栈开发者将后端与前端整体落地。 项目概况 • 后端:基于 Spring Boot 或 Spring Cloud 微服务架构完成核心业务与 API,结合 MyBatis 持久化。需要合理拆分服务、设计分布式方案,并接入 Redis、RabbitMQ 等中间件。 • 数据库:使用 MySQL 或 PostgreSQL,完成表结构设计、索引优化和 SQL 调优。 • 前端:用 Vue 或 React 实现 SPA 界面,并封装成 Electron 桌面应用,保证与后端接口高效联调。 • 工程化:采用 Maven 多模块管理依赖与构建,使用 Git 做版本控制并解决冲突。 交付内容 1. 可运行的后端微服务代码库(含 README、初始化脚本、配置示例)。 2. 对应的前端项目与 Electron 打包方案。 3. 数据库脚本及性能优化说明。 4. 部署指南与关键技术文档。 验收标准 • 所有功能接口通过 Postman/Swagger 自测; • 前端界面在主流浏览器与桌面端正常运行; • 服务启动后无关键报错,核心接口 QPS 与响应时间符合设计预期; • Git 提交记录清晰,能够复现完整构建流程。 如果你熟练掌握上述技术栈,并有微服务及分布式系统实战经验,欢迎交流你的实施思路与大致工期,我会尽快确认并开始合作。
我有一套实时业务数据,需要用衡石工具制作一份可视化报表。报表必须同时满足以下三项功能: • 数据分析——对现有数据计算关键指标与趋势; • 图表展示——将结果以柱状图、折线图等直观方式呈现; • 定制过滤——用户可按部门、日期等维度快速筛选查看。 数据源已整理,可通过 CSV 或直接连接数据库导入。希望你在衡石中完成模型搭建、仪表盘设计,并提供操作说明与发布步骤。最终交付衡石项目文件及任何使用的 SQL/脚本,确保报表打开即用、过滤交互顺畅。
...成。 图像生成技术:接入自研 AI 图像生成接口,支持关键词输入和图像风格定制,内部部署稳定的生成模型,确保生成图像的质量和效率。 2. 功能模块代码结构 AI生图生成模块:实现用户输入关键词后调用 AI 模型生成相应图像,并返回图像的预览和下载链接。 素材上传模块:允许用户上传不同类型的素材,自动生成哈希值并进行版权存证。所有上传素材在后台审核后才会显示给其他用户。 API接口模块:为其他平台提供图像生成服务的接口,通过 API Key 进行权限控制和调用次数限制。 用户权限模块:管理不同用户的权限,提供会员升级功能,控制素材下载、AI生图次数等。 3. 代码优化与安全性 优化:使用异步加载、缓存机制和数据库优化,提高系统响应速度和用户体验。 安全性:通过 HTTPS 加密、权限验证、输入校验等手段确保系统的安全性,避免潜在的 SQL 注入和跨站攻击。 总结: 《五合一小众图库素材站》是一个集素材管理、AI图像生成、创作者生态及版权保护于一体的多功能平台。它通过独特的技术创新和商业化路径,不仅为小众行业用户提供了高效的创作工具,还为内容创作者提供了一个盈利与版权保障的优质平台,具备了强大的市场竞争力和不可复制的技术壁垒。
最近在建一个外卖送餐的网站,需要接入Xunhupay的(微信和支付宝)支付模块。 网站使用的是foodomaa的整站代码: 需要的技能有: Software Version: PHP 7.x Software Framework: Laravel File Types Included: JavaScript JSJavaScript JSON HTML CSS PHP SQL Layered PNG 如果您感兴趣,可以写信给我,价格好商量。 另外网站还有其它的一些改版工作要做,我们可以具体讨论一下能不能一并做。 等您回复哦……
程序是: 首先 第一步: 随机抽取5个phome_ecms_news里面的id和classid 第二步: 读取phome_ecms_news的id和classid,作为函数使用 第3步: 插入phome_enewspl_1新的内容到数据库 例子:$sql = "insert into phome_enewspl_1(plid, pubid, username, sayip, saytime,id,checked,classid,zcnum, fdnum, userid,isgood,saytext,eipport) values (NULL, '1000310000019701', '', '', unix_timestamp(), '$id', '0', '$classid', '50', '1', '0', '0', '评论内容', '48010')"; 第四步: 更新phome_ecms_news的字段plnum+1并且对应第一步读取的id值 例子:UPDATE phome_ecms_news SET plnum =plnum+1 WHERE id = 20488;
To develop OTD KPI reports on JobBOSS: Calculate OTD archive rate by daily, weekly, monthly, there are two conditions need to be fulfilled, one is quantity delivery fulfillment, the delivered qty should equal to requested qty, another condition is delivered date, the delivered date should equal or be earlier than promised day. Scope: all closed SO which closed on curren...qty, another condition is delivered date, the delivered date should equal or be earlier than promised day. Scope: all closed SO which closed on current day, current week and current month. Set the OTD target If SO was delivered earlier on last month , then the OTD need to be included in last Month’s OTD KPI. by SO + Project number Use Chart display the OTD by day,week and month. Data source: ERP SQL DB Tool: ...
该项目需要开发人员,主要技术为: ASP.net/CS/MVC/WCF框架, DIV+CSS,JS(easyui/jquery/native JS/Ajax/Json). 熟悉Oracle数据库, 精通SQL及PL/SQL. 该项目周期大概两个月,之后会有不定期项目需要开发人员 人员需驻场,地点深圳或者天津。
1、精通VB.net,使用以上语言独立开发或深度参与过项目; 2、掌握SQL数据库的使用,能实现复杂查询语句,具备编写存储过程、触发器和函数的编写能力; 3、熟悉ERP、BOM或者MRP。 联系人:陈经理 联系方式:[REMOVED BY FREELANCER.COM ADMIN]
需要开发一套库存及订单管理系统,要求基于数据库(mysql或sql server均可)开发。 库存管理部分,要求对商品的入库出库有良好的输入及确认界面; 订单管理系统,因为是从客户的服务器上下载txt文件(内容为订单),需要将订单纳入数据库,然后根据库存情况判断能否发货,并在最终确定发货日期及发货数量后生成txt文件并上传回客户的服务器。下载及上传txt文件,有客户提供的软件,只要以命令行方式调用即可。 需要按照客户指定格式打印交货单。
android app & SQL/PHP web DB freelance job 詳情請email 查詢
我们目前有一个基于Windos Access 的一个内部应用软件, 我们希望能将其用WINDEV 来重新开发 以便于我们之后的应用。指定使用WINDEV 开发软件。在我们公司坐班工作,直到项目完成。
SQL注入/代码审计/数据库权限/渗透测试技术 接渗透单子高手,联系电子邮箱:aqcp#(#改成@)语言要求:中文 熟练掌握各种内网渗透测试工具与相关知识,精通常见安全攻防技术:sql注入、xss、文件上传、文件包含、命令执行等漏洞 熟悉linux、unix、Windows、oracle、J2EE等各种环境下WEB的安全配置与安全检查及WEB漏洞防范; 熟悉各种脚本语言(asp,php,jsp,java,net、perl、python等)具备独立挖掘web安全漏洞与入侵手段 具备一定的网络安全知识,对网络安全结构、系统漏洞、入侵检测、病毒防护等有深入理论基础和实践经验; 熟悉渗透测试黑客攻防的步骤、方法、流程、熟练掌握各种渗透测试攻防工具有实际渗透经验者优先; 求大虾接单,脱裤,要求,电话,手机,姓名,邮箱,其他的一概不要。每笔单1000美金起步,根据站的难度而定价格,具体可以详谈,寻找长期合作. 态度认真、中介勿扰,请技术实力说话。
安全测试、漏洞发掘、漏洞渗透测试、安全审核、安全风险、服务器安全漏洞渗透测试评估与分析及加固; 联系QQ:840555737 2、对产品代码进行审视,找出安全漏洞并提出修改建议; 3、研究各种安全技术,编写和维护用于安全测试的攻击工具、防御工具和分析工具; 4、负责公司Web产品涉及到的安全性研究; 5、负责响应公司的安全事件; 6、为公司员工提供信息安全教育及培训。 岗位要求: 1、熟悉渗透测试的各类技术及方法,熟练掌握各种渗透测试工具;熟练操作各类操作系统、应用平台; 2、精通或熟练掌握php/perl/python/javascript/shell等多种脚本语言; 3、熟悉asp,php、jsp等主流的Web安全技术,包括SQL注入、XSS、CSRF等常见的安全漏洞利用; 4、熟悉国内外主流安全产品、工具,如:AppScan扫描器、wvs等; 5、对Web安全测试有自己的理解; 6、熟悉常见攻击和防御办法,熟悉web安全和渗透技术,能自行进行web渗透测试,恶意代码监测和分析; 7、熟悉ddos攻击类型和原理有一定的ddos攻防经验,能有效防御黑客挂马和恶意流量攻击,会熟练搭建负载均衡系统。
网站用途:园区展示官网 开发语言:php 参考网站: 具体要求: 需要设计的页面数量和网站功能参考附件。 代码要求: 无SQL INJECTION, XSS等漏洞;前端通过HTML和CSS有效验证,class和id等命名符合语义化规范;代码逻辑清晰有注释,方便后期修改升级。 网站维护: 服务商需要提供后期维护支持 其他要求: 服务商最好是成都公司,要有对公账号,可开发票。 请报价格、工期、设计师的portfolio以及在什么开源程序的基础上开发。 熟悉prestashop的优先。
网站建设要求是 网站程序语言是PHP 数据库为SQL Server 不需要做到也下几点: 1、网站界面大气大方 2、网站语言必须为 中午--英文 两种语言 根据访问者的IP来主动换语言 3、一般的交友网站的功能都要做到 4、网站主要功能有一下几点 1、在线聊天 2、在线动态 3、介绍好友 4、相册密码功能 5、在线音乐 6、签到 7、等级功能 8、举报-敏感词 5、这里有几个网站可以拿来参考 这是我的QQ号 929471701
...Strong experience with Laravel (Blade, Admin Panel, PHP). • Proficiency converting Figma → responsive Laravel pages. • Understanding of component-based frontend and responsive layout techniques. • Familiar with Git/SSH deployment workflows. • Ability to deliver fast, pixel-perfect output. Deliverables 1. Source Code – Full repository (GitHub/GitLab/Bitbucket) or zipped clean copy. 2. Database – SQL dump (schema + sample data) for setup or migration. 3. Config Template – . or list of required environment variables (DB, API keys, storage, etc.). 4. Deployment Guide – Server requirements, installation steps, migration notes, and cron setup. 5. Cron Jobs – List of exact commands, schedule, and purpose for each task. 6. API Docs ...
...testing. What you give when applying is the maximum price I will pay you! Let's not run unnecessary circles. Copy robot: A Master account that can work from telegram messages and in manual mode. You can choose which mode it works in. Slave account (initially 9) that copies the master account. But can also work from telegram messages independently of the master account. Each account is saved in a sql table (as a user) for statistics. The amount of bets for each account can be set individually. Each account can be turned on and off to copy the master or work from telegram messages. Each account automatically accepts the trader's changes in bets and odds. It displays this if there is a difference from the master account or telegram bets. It monitors and prevents duplica...
I need an experienced SQL specialist who can step straight into our pharmaceutical data environment and tighten every performance screw. My priority is query performance tuning and a thoughtful indexing strategy, followed by deep execution plan refinement so that reports inside Dataiku render quickly and reliably. Current challenges • Queries touch multi-million-row clinical and sales tables and now run in minutes instead of seconds. • Indexes have grown organically and no longer align with business-critical workloads. • Dynamic reporting in Dataiku is sluggish, putting analysts on hold and raising compliance concerns about data integrity. What I expect from you 1. Review existing SQL code and indexes, then deliver a clear, actionable tuning plan. 2...
...the final, tested release. Key features to build - Stock tracking with add, remove and adjustment logs. - Barcode scanning support for common USB scanners, plus optional barcode printing. - Report generation in PDF / Excel for current stock, low-stock alerts, and movement history. Technical expectations • Clean, well-commented source code and a lightweight relational database (SQLite or SQL Server LocalDB recommended). • Installer that works on Windows 10 and above without extra licensing hassles. • Straightforward user interface—no steep learning curve. Deliverables 1. Executable installer (.exe or .msi). 2. Full source code and database schema. 3. Brief user guide covering setup, daily use, and backup. 4. The initial mock-ups and any ...
...exposure. • Build a stress-testing model that simulates extreme volatility, sudden TVL outflows, and large redemptions using on-chain data, DEX aggregator APIs, and standard VaR / scenario-analysis techniques. • Propose dynamic liquidity buffers and circuit-breaker thresholds, complete with implementation steps for smart-contract or policy changes. • Draft a live monitoring dashboard (Python, SQL, Web3, or comparable stack) that flags breaches in real time and auto-generates weekly risk reports for stakeholders. Acceptance criteria 1. A documented liquidity-risk policy aligned with industry compliance guidelines. 2. Stress-test model delivered in an auditable Jupyter notebook (or similar) with reproducible results. 3. Real-time dashboard deployed to st...
I’m looking for a Python-savvy analyst to turn the numerical records stored in my databases into clear, actionable insights. The job centres on data analysis (not web development or automation scripting), so I need someone comfortable pulling figures directly from relational tables, cleaning them with pandas, and explorin...at least one statistical test or model relevant to the dataset. • Summarise findings in a concise report or notebook section with easy-to-read charts (matplotlib or seaborn is fine). • Deliver all code, a short “how to run” README, and any requirements.txt. I already have database credentials and can provide table schemas on kickoff. If you have a solid background in Python data analysis and SQL, I’d love to see a quick samp...
I have an existing PHP website—around 30 public-facing pages plus a small admin panel—and I now need it rebuilt in Net beans and SQL as backend. The goal is a one-to-one conversion that preserves every current feature and keeps the exact same design and layout. No new functionality is required and the site has no third-party integrations, so the task is purely a straight port. What I’m looking for: • A NetBeans for the front end. • A clean SQL backend (tables can follow the current MySQL schema). • Basic setup instructions so I can deploy the project locally and on my server. Please focus on producing working pages that match the existing look and behavior; deep refactoring, performance tuning, or UX redesigns are not in scope right now...
Busco incorporar a una persona con entre cuatro y cinco años de experiencia real en Oracle APEX para liderar la migración de varias aplicaciones críticas a esta plataforma. El puesto es estable, de larga duración y se desarrolla en Madrid bajo un modelo híbrido (al menos dos días por semana en oficina). Qué necesito de ti • Dominio sólido de APEX, PL/SQL y Oracle Database. • Capacidad para revisar el código legado, plantear la estrategia de migración y ejecutar cada fase con buenas prácticas. • Habilidad para moverte en entornos colaborativos donde la comunicación fluya a través de las herramientas que usemos (Teams, Jira, Confluence) y donde la gestión de tiempos y ...
...such as PyTorch, TensorFlow, or Scikit-learn. Hands-on experience with OCR tools (Tesseract, EasyOCR, or PaddleOCR). Working knowledge of Computer Vision techniques (image segmentation, detection, feature extraction). Experience with LLM APIs or frameworks (OpenAI, Hugging Face, LangChain, Ollama, etc.). Good understanding of REST API development and microservice integration. Experience with SQL/NoSQL databases and Git-based version control. Familiarity with Linux environments and cloud platforms (AWS/GCP/Azure)....
I’m looking for a Python-savvy analyst to turn the numerical records stored in my databases into clear, actionable insights. The job centres on data analysis (not web development or automation scripting), so I need someone comfortable pulling figures directly from relational tables, cleaning them with pandas, and explorin...at least one statistical test or model relevant to the dataset. • Summarise findings in a concise report or notebook section with easy-to-read charts (matplotlib or seaborn is fine). • Deliver all code, a short “how to run” README, and any requirements.txt. I already have database credentials and can provide table schemas on kickoff. If you have a solid background in Python data analysis and SQL, I’d love to see a quick samp...
... Internal employees pursuing skill upgrades • External candidates undergoing recruitment evaluations The questions will have 3 difficulty levels – Easy, Medium, Hard Along with the question creation, we also require SMEs for evaluating the candidate answers manually on the assessment questions on below skillsets. Let me know if this is feasible Skill Name Python SQL ML PySpark Scala Java (Spark) ML Flow Kubernetes Docker SpringBoot (Java) React Native JavaScript Angular React JS GIT Kafka Node JS Rust Linux Terraform Ansible Server CEPH Storage Microservices MYSQL (In-memory DB setup + Database Setup) CI/CD + Jenkin + Kafka Prometheus Grafana Network Network Security Hyperledger Fabric Chain code Golang ...
I need a lightweight Windows desktop application that lets me manage records stored in a SQL database. The goal is to keep things simple—just the core CRUD features. Core needs • Display records in a clean, sortable grid. • Add, edit, delete, and search entries through a user-friendly form. • Basic validation (required fields, correct data types). • Export the current view to CSV. Deliverables • Compiled installer or portable EXE that runs on Windows 10/11. • Full, well-commented source code so I can maintain it later. • A brief read-me explaining setup, connection string placement, and any third-party libraries used. I’m comfortable with C#/.NET, WinForms, WPF, or a similar native stack—as long as it’s stable a...
I’m expanding my U.S.-based remote engineering team and want to add one or more full-stack developers who live anywhere in Canada. Day-to-day you’ll build, ship, and maintain features across web products that serve thousands of active users. What I’m looking for • Primary stack: Python and JavaScript on the back- and front-end (React / Node.js). • Solid grasp of SQL databases, Git workflows, and modern CI/CD pipelines. • 3–5 years of professional development experience delivering production code. • Strong English communication: you’ll present ideas, handle code reviews, and collaborate in daily stand-ups. Nice-to-have Experience with PHP, C#, or other languages in our broader ecosystem is welcome, as is familiarity with agile...
I need a clear design blueprint for an AI-driven solution that automatically maps all internal and external dependencies within complex web applications. My core objective is to find the application services. And break the monolith sql database in to microservices. Here’s what I expect to walk away with: • An end-to-end architecture diagram that shows how data will be gathered (static code analysis, runtime tracing, log aggregation, etc.), processed with machine-learning models, and surfaced through visual graphs or dashboards. • Clear acceptance criteria: the design must present to work in the all web application. please highlight the outcomes you achieved. I’m ready to move quickly once the design meets these requirements.
I need a quick, working proof-of-concept ETL pipeline built by someone who has real-world experience moving data end-to-end. The job is intentionally lean: • Connect to at least one common source (a simple SQL table, NoSQL collection, or a lightweight API—whatever you can access easily for demonstration). • Extract a small sample dataset, transform it with a couple of clear, documented steps, and load it into a destination of the same family or a flat file. • Package your work in a git-friendly structure with a short README explaining prerequisites, how to run the flow locally, and how to swap in other sources later. Tool choice is open. If you prefer Apache NiFi, Talend, or Apache Airflow, go for it; if another open-source option will get the job done...
...code. Note: We will manage contact form integration. Typography: Google Fonts only — must be self-hosted for performance and GDPR compliance. Performnce: Clean code, lightweight assets, optimised images, and minimal dependencies. Target Lighthouse scores above 90 for desktop and mobile. Deliverables & Handover 1. Full Local Copy Complete export of the working WordPress site including: Database (.sql file) Theme folder (with all source files) Any custom or MU plugins Uploads, media, and configuration files (e.g. .env, ) 2. Source Files Include all uncompiled source files (SCSS, ES6, etc.) Include compiled/minified CSS and JS versions for production 3. Build Instructions Provide a README with: Local environment setup Build process and dependencies Commands to compile or...
I’m mapping out a new internal tool that will pull data from our SQL Server instance and expose it through an API so it can be shown as plain HTML tables on a web page. I need an experienced developer’s guidance to make sure the foundations are solid and that we end up with a clean, maintainable solution. Scope of work • Refine the overall architecture—best practices for a .NET-based REST API that taps SQL Server directly. • Draft endpoint structure and security approach (authentication, role-based access, parameter sanitisation). • Produce a functional prototype: one or two sample endpoints that query the database and return JSON ready to be rendered as tables. • Advise on IIS setup—site bindings, application pool settings...
...8+ years Role Overview: We are looking for a highly skilled Java Banner Specialist to provide development and support for enterprise Banner applications. The role involves working across multiple technologies including Java, PL/SQL, APIs, and Tomcat servers to ensure seamless integration, performance, and reliability of Banner systems. The specialist will also handle troubleshooting, scripting, and deployment activities in coordination with functional and technical teams. Key Responsibilities: Develop, enhance, and support Banner applications using Java and PL/SQL. Manage and configure Tomcat servers for application deployment and maintenance. Design and integrate REST and SOAP APIs to connect Banner with external systems. Develop and maintain shell scripts for auto...
...have a dynamic website backed by a Cloud SQL database that is ready for production, and I need an experienced Google Cloud engineer to get it live, stable, and secure. The codebase is complete; what’s missing is a well-architected deployment that handles traffic smoothly and keeps data safe. You will take charge of provisioning a Google Cloud stack—choosing the most suitable runtime service (Compute Engine, Cloud Run, or App Engine) and wiring it up to Cloud SQL. Along the way, I expect HTTPS to be in place, firewall rules tightened, environment variables stored securely, and basic monitoring enabled so I can track performance once we launch. Deliverables I’d like to see: • Production-ready infrastructure deployed in my GCP project • Cloud...
...creazione di un'interfaccia utente pulita, veloce e responsive. Integrazione Pagamenti: Requisito fondamentale e non negoziabile: profonda esperienza dimostrabile con l'API di Stripe, in particolare con i flussi di pre-autorizzazione (Payment Intents / Setup Intents). I candidati senza esperienza specifica su Stripe non saranno considerati. Database: Capacità di progettare e gestire database (SQL o NoSQL). Lingua: Buona comunicazione in italiano o inglese. Cosa Includere nella Tua Candidatura: Per essere presi in considerazione, i candidati devono fornire: Una breve presentazione delle proprie competenze. La conferma esplicita di poter rispettare la scadenza di 30 giorni. Un link a un portfolio di lavori passati, indicando specificamente progetti simili o...
...analytics events, A/B test plan (if beneficial), and monitoring. - Provide documentation, test queries, and a 60–90 minute handover session. Environment & tech stack (tell us what you support) - Backend: Node.js/Express, Ruby on Rails, PHP/Laravel, or other — specify which you will work with. - Frontend: React (InstantSearch/React InstantSearch), Vue, Angular, or plain JS — specify. - Data source: SQL/NoSQL/CSV/Elasticsearch/CMS — describe how you’ll index and keep data in sync. Deliverables - Proposed index schema and mapping for each index. - Complete Algolia configuration: searchableAttributes, attributesForFaceting, customRanking, ranking rules, replicas. - Synonym lists, query rules (with examples), typo- and proximity-settings. - Facet/Fi...
On site in Calgary Alberta. I maintain several reporting workspaces and now need an expert who can take our dashboards to the next level. The existing environment already pulls data from SQL databases and Excel files, and I have recently added Databricks tables to the mix. Here is what I need next: • Build and refine complex DAX measures that drive KPI-rich, drill-through dashboards. • Write and optimise SQL queries so the source tables deliver only what Power BI truly needs, keeping refresh times low. • Review the current data model—some areas are in good shape, others still rely on ad-hoc joins—and suggest pragmatic improvements without starting from scratch. • Configure relationships, calculated columns, and hierarchies so end-use...
...necessary configuration data). We need an experienced WordPress/MySQL DBA to safely execute a final, high-impact optimization step. Key Requirement and Goal: The primary goal is to execute a full table rebuild to eliminate fragmentation and optimize the storage format, thereby significantly reducing the table size. The successful freelancer must be able to perform and verify the following command: SQL ALTER TABLE lhp_postmeta ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Scope of Work: Full Backup: Take a complete backup of the entire database before making any changes. Verification: Verify the current lhp_postmeta table size and its ENGINE (must be InnoDB) and ROW_FORMAT. Execution: Safely execute the ALTER TABLE command (which will lock the table for a period of time, estimated to b...
I’m finalising a new mobile app and now need a small-scale SQL backend that simply works. The job is focused on database management—no elaborate micro-services, just a clean, dependable foundation. What I’m after: • A concise relational schema (roughly five or six core tables for users, sessions and content). • Basic CRUD functions or lightweight API endpoints so the app can read and write data. • Secure connection settings, sensible indexing and a couple of sample queries to prove everything is wired correctly. • A short README showing how to spin the database up locally and deploy it to a modest cloud instance such as AWS RDS, Azure SQL or another platform you recommend. If you’re comfortable with MySQL, PostgreSQL or SQL...
...compliance, and performance under complex user scenarios. My Expertise Includes: Manual Testing: Writing detailed test cases, exploratory and regression testing. Automation: Selenium, Cucumber, JUnit, and TestNG for UI and functional test automation. API Testing: Postman and Rest Assured for functional and contract validation. Performance Testing: JMeter for load and stress tests. Database: SQL and MongoDB for data validation and backend integrity. CI/CD: GitLab & Jenkins pipeline integration for automated execution and reporting. Defect Tracking: Jira for bug management, traceability, and sprint QA reporting. Approach: Review the current build and define a critical test case matrix. Identify automation candidates and build a maintainable Selenium-Cucumber framewor...
I need an experienced Power BI specialist to stand up our reporting environment, model the data, and deliver interactive dashboards. The main focus is clear, executive-ready financial reporting, but I also want to keep a close eye on daily operation...Query and DAX best practices – Design at least three drill-through dashboards (Finance, Operations, Forecast) with intuitive slicers and conditional formatting – Optimise performance and ensure refresh schedules run reliably – Hand over a concise user guide and a walk-through session so my team can maintain and extend the solution I can supply data in whatever format you prefer—Excel/CSV, SQL Server, or cloud sheets—and will provide access quickly. Please share examples of similar projects and outli...
...captured right now is each investor’s investment history and their current or past shareholdings; contact details and other extras can come later, but they are not my first priority. Microsoft Power Automate is the preferred platform, so the job centres on creating flows that: • search and collect filings, press releases, portfolio pages and other open-web references • populate a structured table (SQL, SharePoint, or another store we agree on) • trigger AI-powered prompts to clean, tag and summarise the records into actionable insights—think frequency of deals, average cheque size, or common co-investors What I expect from you in the end: 1. The working Power Automate flows and connectors 2. The clean, exportable database with investment histo...
I’m building a single-city real-estate portal in Ital...properties. • Media management for photos, virtual tours, and floor plans. • Stats on views and leads. Everything should live inside Supabase (Postgres, Auth, Storage) with row-level security for approved vs. pending data. Deliverables 1. Source code in a Git repo ( 14+, Supabase SDK). 2. Styled UI components with a ready-to-skin design system (Tailwind or similar). 3. Supabase SQL/schema files and seed data. 4. Deployment scripts or instructions so I can launch on Vercel or another Node-friendly host. 5. Brief hand-over session and documentation covering the approval workflow and filter logic. I’m ready to move quickly once I see a clear plan for the database schema, filter implementatio...
I’m seeking a SAS programmer with hands-on mastery in both Base and Advanced SAS. The work centres on clinical-trial data, so familiarity with SDTM and ADaM standards is essential. Key responsibilities • Build and validate SDTM and ADaM datasets from raw clinical data. • Write clean, efficient code using PROC SQL, PROC REPORT and PROC MEANS. • Develop or refine reusable macros while keeping everything CDISC-compliant. What I expect to receive • Fully documented SAS programs ready for immediate use. • A concise technical note explaining key logic, assumptions and validation checks. • Any macro library you create or adapt during the assignment. Infosys-level certification (Base and Advanced SAS) or equivalent credentials will give...
...criteria. Key Deliverables: Database Design Document (LO1) Requirements analysis and design specification Entity Relationship Diagram (ERD) Normalization (up to 3NF) Data dictionary and relationship mapping Database Implementation (LO2) SQL scripts for database creation and table design Sample data population Queries, reports, and views Testing and Evaluation (LO3 & LO4) Test plan and results Evaluation of database effectiveness Recommendations and improvements Final Submission File Full written report in academic format (Word) SQL script file or screenshots of implementation Harvard referencing Deliverables Deadline: Within 5-10 days (flexible for quality work)...
...storage into a seamless, highly scalable pipeline for our project. Here’s what I need from you: • A clear, vendor-agnostic architecture diagram that shows every Azure service you recommend—whether that’s Event Hubs, Service Bus, Data Factory, Functions, AKS, or native PaaS options. • A storage strategy that explains where structured, semi-structured, and unstructured data will live (e.g., Azure SQL Database, Cosmos DB, Blob Storage, Data Lake), how data will be partitioned, encrypted, and lifecycle-managed, and what patterns you’ll employ for high availability and disaster recovery. • Written rationale for each decision, covering performance targets, cost optimisation, and operational monitoring with Azure Monitor or other tooling. ...
...Laravel application—backend, front-end assets, and MySQL database—and re-install it on my own hosting so it behaves exactly as it does today. The current site includes: • Custom user authentication, unique data processing, and several API integrations • Third-party connections for payment gateways, analytics tools, and social media APIs Scope of work 1. Extract every file, environment setting, and SQL table from the live server. 2. Re-configure .env, routes, and any scheduler/queue services so paths, keys, and cron jobs point to my domain. 3. Install the clone on my cPanel/VPS (Laravel + MySQL stack already available) and confirm all pages, forms, and dynamic data load without errors. 4. Test critical flows—login/registration, data processing...
I need Apache Superset installed, configured, and secured so that it can serve multiple tenants from a single server. All of our data lives in PostgreSQL and every tenant already has its own separate database on that server. When a user signs in, they must see only their database in Superset, be able to explore data, write SQL, and build dashboards with full read-and-write rights—but never touch anyone else’s data. You will take the project from a clean install through to production-ready status. That means handling the Superset installation itself, setting up the PostgreSQL connections, mapping each user to the correct database, and putting simple role-based rules or row-level security in place so our compliance team is satisfied that there is no cross-tenant leakage....
I need a straightforward relational database that lets a local shop track its small-electronics inventory. Here’s what I’m after: • A single SQL script that creates three tables—Products, Suppliers, and Orders—with exactly these columns: – Products(ProductID, ProductName, Category, Price, StockQuantity) – Suppliers(SupplierID, SupplierName, ContactPerson, PhoneNo) – Orders(OrderID, ProductID, SupplierID, OrderDate, QuantityOrdered, Cost) • Primary keys for each table and the necessary foreign-key links (Products ↔ Orders, Suppliers ↔ Orders) so ProductID remains unique—the detail I care about most. • Two sample queries that demonstrate typical use: 1. List every product whose StockQuantity ...
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.