Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
我已经准备好整站代码与域名,现在需要将它完整部署到一台全新的云服务器上。服务器目前只有干净的操作系统环境,请你负责: • 安装并配置最新稳定版 MySQL • 初始化数据库、导入我提供的 .sql 文件,并确保站点可以正常读写 • 部署网站代码,配置 Nginx/Apache 与 HTTPS(若你更熟悉其中一种可自行选择) • 基本安全加固与防火墙端口设置,让站点上线即可访问 我希望整个流程保持可重复性,因此请在结束时留下简单的部署文档或脚本。需要你熟练掌握 Linux 服务器运维、MySQL 调优及常见 Web 服务器配置。完成后,网站能够通过域名正常访问,后台数据也可在 MySQL 中查看。 代码是JAVA写的
我已经准备好整站代码与域名,现在需要将它完整部署到一台全新的云服务器上。服务器目前只有干净的操作系统环境,请你负责: • 安装并配置最新稳定版 MySQL • 初始化数据库、导入我提供的 .sql 文件,并确保站点可以正常读写 • 部署网站代码,配置 Nginx/Apache 与 HTTPS(若你更熟悉其中一种可自行选择) • 基本安全加固与防火墙端口设置,让站点上线即可访问 我希望整个流程保持可重复性,因此请在结束时留下简单的部署文档或脚本。需要你熟练掌握 Linux 服务器运维、MySQL 调优及常见 Web 服务器配置。完成后,网站能够通过域名正常访问,后台数据也可在 MySQL 中查看。 代码是JAVA写的
...数据库已在使用中。眼下首要任务是把整站平滑迁移到云服务器——我倾向于 AWS 或 Google Cloud,但愿意听取你对实例类型、区域、网络与安全组配置的专业建议。迁移完成后,我希望与你建立一种“随叫随到”的长期合作关系:一旦服务器或网站出现故障,你能远程排查、快速恢复,并给出防止再次发生的改进方案。 交付标准 • 一次性迁移:完整代码、数据库与静态资源在新云环境中可正常访问,域名解析、SSL 证书与备份策略全部就位。 • 文档与脚本:迁移流程、关键配置、常用运维命令须整理成 Markdown 或 Shell 脚本,方便我日后参考。 • 后续支持:根据实际情况按小时计费或按次约定,我需要的不只是救火,更包括定期检查和优化建议。 如你擅长 Linux、Nginx/Apache、Docker、CI/CD、数据库调优,并熟悉 AWS 或 GCP 的 IAM、VPC、Cloud SQL 等服务,我们的合作会很顺畅。欢迎分享你做过的类似迁移或故障修复案例,并说明你通常的响应时间。
...竞赛,但目前还只是初学者。为了确保学习方向正确、进度连贯,我想通过一对一辅导系统掌握 Web 安全、逆向工程以及密码学这三大常见赛题方向。 课程安排与期望 我希望你能先了解我的基础,然后为我定制一套循序渐进的学习计划: • 制定每周目标与所需资源 • 精选并讲解难度递增的练习题(最好来自常见平台或往届赛事) • 在线实时演示解题思路与工具使用,例如 Burp Suite、Ghidra、IDA Free、pwntools、CyberChef 等 • 布置课后挑战并在下一次辅导时点评 write-up,帮助我改进思考方式 授课形式 一周 1-2 次远程直播(Zoom、Google Meet 或其他你熟悉的平台均可),每次 1–2 小时;课间答疑可通过聊天或邮件进行。学习资料、脚本示例及参考链接请统一整理到可共享的云端文件夹,方便我反复查看。 交付与验收 • 至少覆盖 20 个以上典型题型:SQL/SSRF/XSS、栈溢出/格式化字符串、经典对称/非对称加解密等 • 提供完整的教案、录屏或课件(PPT/Markdown 均可) • 课程结束时,我能够独立解出新手赛常见基础题并写出结构化的 write-up 只要你对 CTF 有实战经验,能清晰表达思路并乐于分享,请与我联系并说明可安排的时间与大致教学框架。
我正在筹建一套包含 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
Our Magento 2 store suddenly refuses to complete the Product Price reindex and shows the familiar “no linked stock” message. Nothing was updated, no extensions were added, and I haven’t tried any quick-fix SQL scripts or CLI commands yet, so you’ll be starting with a clean slate. I’m looking for someone who has already wrestled with this specific indexing glitch and can get the catalog back to a fully reindexed state without disrupting live traffic. Acceptance criteria / deliverables: • Identify the root cause of the “product price index – no linked stock” error and document it briefly. • Apply the corrective fix (database clean-up, configuration adjustment, or code patch) on our staging site, demonstrate a successful bin...
...installation guide, and change log should be shared. Redis - VPS = 12vCores - 48GB RAM - 300 GB SSD NVMe - The server has Cyberpanel 2.4, Redis, Memcached, and Watchdog installed. - PHP 8.1 memory_limit = 4096M, max_execution_time = 600, max_input_time = 120, post_max_size = 512M, max_input_vars = 40000, max_multipart_body_parts = 4500, = 1, opcache.memory_consumption = 512 - SQL max_connections = 2000, innodb_buffer_pool_size = 24G, innodb_log_file_size = 2G - OpenCart 3.0.4.1 and Journal Theme 3.2.8 are installed - Redis Status: Redis and the PHP-Redis plugin are installed and active on the server (redis-cli ping -> PONG) - To prevent delays, when installing the module, can you ensure that database queries are cached via Redis (Object Cache)? - In my OpenCart...
...drawn from the cleaned data. The core of the job is data analysis, with a focus on market analysis. Once the information is re-entered and verified, I’d like you to identify key market trends hidden in the numbers—patterns in customer behaviour, shifts in demand, emerging opportunities, and any risks you notice. Feel free to use Excel, Google Sheets, or your preferred tools (Python + Pandas or SQL are fine too) as long as the final files remain easy for me to open and follow. Deliverables • A fully re-typed and proof-checked spreadsheet, aligned with my existing column structure • A concise market analysis report (slides or doc) that explains the trends you found, the methods you used, and your recommendations I’m available for quick check...
...workflow Once I sign in through Entra ID, the dashboard should open with an MS SQL MCP back end already connected. From there I must be able to: • watch every tunnel live (status, latency, throughput) • edit the connection parameters in an on-screen code panel and push the change instantly • shift the FileServer stack to one of the preset regions (Swiss 1/2/3/4, Norway South/North, Ireland, UK, US Pacific, US Midwest, Singapore) simply by selecting it Operational data—geo-IP, DNS, subnet mask, gateway, plus distance to the regional DNS gateway—has to be logged in real time and displayed alongside each session. Extra milestone After the main build is accepted, I want the same dashboard to link the SQL store to external databases (I...
...Well-commented scripts or workflows that automate duplicate removal, spell-checking and format standardisation • A repeatable pipeline that loads the cleansed data into Google Cloud and can be triggered on demand • At least one concise insight report or dashboard with visualisations and written commentary • Clear documentation so I can rerun or extend the process without guesswork Python, SQL and native Google Cloud tools such as Dataflow, BigQuery, or Looker Studio are perfectly acceptable here, but if you have a strong case for another tool inside the Google suite, I’m happy to hear it. Accuracy, transparency, and clean code will serve as the acceptance criteria. Please include a brief timeline with milestones for cleaning, cloud setup, and insigh...
I need an experienced developer who feels at home in both TypeScript and Python and has already played with the popular open-source “AI agent” stacks. My immediate goal is to stand up a proof-of-concept chatbot that can reason over structured data stored in a SQL database, surface answers in natural language, and be easy for me to extend later. Here is what I’m after: • Pick and wire up an open-source autonomous-agent framework (LangChain, AgentGPT, SuperAGI or a comparable option you trust). • Expose a clean TypeScript interface so the rest of my app can call the agent with a prompt and receive a streamed response. • In Python, configure the agent’s toolset to pull data from my existing Postgres tables, run simple analytic queries, and r...
I’m a beginner looking for a 1-on-1 Databricks instructor for a very hands-on, fast-paced 2-week program. Requirements: - Strong real-world Databricks experience - Hands-on Apache Spark (PySpark), SQL, Delta Lake - Real use case / mini project (end-to-end pipeline) - Live screen sharing, coding together - Beginner-friendly but practical (no theory-only) Goal: By the end of 2 weeks, I want to confidently build and understand a real Databricks data pipeline. Availability: 5–6 sessions per week, 1–1.5 hours per session Please share: - Your Databricks experience - How you would structure these 2 weeks - Your hourly rate Thanks!
...returns multiple routes: 1 - The natural route (Google/Waze-like): - Fastest / shortest path - Acts as the reference route 2 - Alternative and diverse routes, based on: - Penalty-based rerouting - Via-point routing - Isochrone / driving-distance frontier sampling - Fixing geometry stitching & direction reversal issues - Building correct route geometry in JavaScript (not SQL) Expected API response - Return at least 5 different routes, or - Ensure that route overlap does not exceed 70%, according to the specifications above Requirements - Proven experience with GIS / Geospatial Systems - Strong understanding of graph-based routing - Experience working with directed networks Preferred background - Navigation engines - Logistics / routing systems - ...
...size and assets already optimized Deterministic puzzle generation in place UI foundation and navigation patterns established Existing SQL database with live request data Existing SSO/authentication flow connected to our website Existing database schema for user activity logging What We Need Done (7-Day Scope) Performance & UX Polish Improve touch responsiveness and gesture handling (no lag or floatiness) Smooth animations and transitions Remove remaining performance bottlenecks Refine post-completion interaction logic so it feels intuitive and polished Tune haptic feedback to highlight key moments only Request Integration Connect to existing SQL endpoints to display open requests Present requests in a clean, browsable list Allow authenticated users to cl...
...can tap into practical resources, swap experiences, and grow their businesses together. The concept is clear; what I need now is a developer who can turn that vision into a reliable, easy-to-navigate web application built with Java Spring. Here’s where we are and what I’m counting on you for: • Back-end: Set up a solid Java Spring (Spring Boot) foundation, integrate security, and wire it to a SQL database that scales. • Front-end: Craft a responsive interface that feels intuitive on desktop and mobile alike. I have wireframes for core pages and welcome your UI/UX insight to refine them. • Core features: User registration/authentication, a searchable content area for our curated resources, and a simple discussion space to get the community started...
...pops up and the page stops there. I can capture and share a screenshot of the exact message, but I don’t have the text copied out. Nothing else needs to be clicked for the issue to appear; it happens instantly after authentication. I’m looking for someone willing to troubleshoot this one-off problem pro bono. You’ll have temporary access to the project files or a zipped copy (C#, .NET Framework, SQL Server back-end) so you can replicate and patch the fault. Once you identify the cause and supply the fix—whether it’s a tweak, an authentication middleware adjustment, or a code-behind patch—I’ll implement it on the live server and confirm the site moves past the login screen without throwing the error. If you enjoy helping out and wou...
Our production platform is already live on CodeIgniter (MVC) with a Bootstrap front end, Ajax-heavy JavaScript, a MySQL/SQL back immediate need is to improve code maintenance so the application can scale cleanly while we continue to ship new functionality. What needs to happen: • Track down and resolve outstanding bugs that affect both the customer dashboard and admin area. • Build out several new features now on the roadmap, using the current CodeIgniter architecture but written cleanly enough to migrate later to Laravel or a Node.js micro-service. • Refactor brittle controllers, models, and SQL queries for faster response times and lower complexity.
...several related Excel sheets straight into my PostgreSQL database. No transformations are required—just a clean import exactly as the data sits now. During the session we will • create or confirm the target tables and column types, • choose the quickest import method (COPY commands, pgAdmin’s import wizard, or any tool you prefer), • load every sheet accurately, and • finish by writing a few SQL queries to verify row counts, join related tables, and pull sample SKU-level results. Deliverables for me at the end of the call will be: • a working, repeatable import script or step-by-step notes; • the example SELECT queries we ran together; and • confirmation that every row of product data landed in Postgres without errors...
Quiero reducir al mínimo los gastos de mi suscripción en Azure sin comprometer rendimiento ni seguridad. Necesito que revises conmigo, paso a paso y en tiempo real, toda la configuración de: • Máquinas virtuales • SQL Database/Managed Instance • Servicios relacionados (storage, networking, backups, etc.) Trabajaremos mediante sesiones interactivas en TeamViewer, AnyDesk y Microsoft Teams con audio. No se permite el uso de chats de IA para elaborar respuestas; la comunicación debe ser directa y durante la sesión. Flujo esperado: 1. Auditoría inicial: identificas consumos elevados, licenciamiento inapropiado y recursos infrautilizados. 2. Propuesta inmediata de cambios (tamaño, auto-shutdown, reservas, e...
I’m looking for a reliable way to mirror my on-premise SQL database to AWS RDS in real time. The web service you build will capture every change that hits the local tables—customer information, inventory data, and transaction records—then push those changes up to the cloud with minimal latency. My priorities are: • Zero data loss and consistent state between the two stores, even when connectivity drops temporarily. • Latency low enough to feel immediate to downstream apps that rely on the cloud copy. • A straightforward deployment path: I should be able to install the service on a Windows or Linux host beside the local database, point it at the RDS instance, and watch it run. Deliverables 1. Source code for the sync service (language and f...
I’m working on a college assignment that requires a fully-functional Hospital Management ...electronic medical records storage with role-appropriate access • Admin dashboard to oversee users, departments, inventory, and finance summaries • Dynamic reporting (daily collections, patient census, doctor workload, etc.) with export to PDF/Excel • Separate Doctor and Patient portals for updating notes, viewing prescriptions, and checking visit history Please include a short README and a SQL dump for easy setup, and comment your code so I can explain it during my viva. If you propose an alternate tech stack, outline exactly how it will still meet every point above and remain simple enough for me to demonstrate in class. Looking forward to seeing how you’l...
I need a solid backend that lets several independent restaurants run from the same cloud platform while keeping a local MySQL database at each venue. The stack is already set: Node.js on the server side, Angular for the web console, and standard SQL. Core features I must see working: order management that mirrors every ticket and status update in real time, a secure user-authentication layer (roles for cashiers, kitchen, managers, etc.), and inventory tracking that updates stock counts the moment an item is sold or a delivery is recorded. Each restaurant keeps operating even if its connection blips, so a lightweight web service will sit on the local machine, watch the MySQL tables, and push changes to the cloud API the instant they happen; the cloud then replies with any new d...
...data from our internal finance databases and live web sources, then produces clear, timely analytics for management. Reporting and analytics are the sole focus—no transaction execution—so the system must excel at pulling, cleaning, and interpreting numbers rather than booking them. We also want to compare legal documents vs term sheets and excel spreadsheets Data sources • Company databases (SQL, flat files, Excel exports) - Dropbox all our files are in drop box • Extensive web scraping for competitor benchmarks and investment-market signals If you have ideas for safely adding external financial APIs later, let me know, but the two feeds above are mandatory. - There will Tech freedom I haven’t settled on Claude, OpenAI, or any other foun...
...employee ranks) • Admin suite that, at minimum, supports real-time Admin Chat Commands and integrates smoothly with in-game logs • Robust anti-cheat covering speed, teleport, weapon, and money hacks • Event/mission hooks so I can plug in future features without rewriting core modules Technical expectations – Pure Pawn, neatly sectioned includes, and a single well-named main gamemode file – SQL queries parameterized and abstracted, no inline string concatenation vulnerabilities – Server-side performance profiling to ensure mobile players stay under 50 ms ping spikes during peak hours – Consistent naming conventions, clear separation of data, logic, and presentation, and no dead code Delivery & handoff I’ll test on ...
...repository and staging server. • Document and prioritise fixes or improvements we agree on, then tackle them in small, testable milestones. • Push clean, well-commented code to Git, verify on staging, and help me roll changes to production once everything checks out. Core stack in use is modern HTML/CSS/JS with a popular front-end framework (React). The back end runs on Node, RESTful APIs, and a SQL database. Familiarity with performance tuning, accessibility best practices, and basic SEO is highly valued. Deliverable for each milestone 1. Updated source code committed to the repo 2. Short change-log outlining what was done, why, and any follow-up items 3. Confirmation that the feature or fix works on staging If you have recent examples of websites you have m...
The task is to turn my early-stage concept into a working hybrid MVP that will launch first on the web. Everything else in the pro...Vue on the front end, Node/Express, Django or a similar REST backend, paired with JWT or OAuth for token handling. What matters is that the codebase remains portable so I can wrap it later with Capacitor, Ionic or another bridge for iOS and Android. Deliverables • Deployable web build (staging & production) • Documented source in Git, including setup/readme • Database schema / migrations (SQL or NoSQL) • Basic test coverage for the auth routes • One brief walkthrough call on hand-off Once the auth workflow is solid we’ll iterate on dashboards, data models and mobile packaging, but this listing is just fo...
...the code clean and well-documented. Country handling should rely on a dedicated table so I can add or deactivate markets without touching code. A single-page Vue or Alpine-powered admin dashboard is preferred, but Blade is acceptable if you keep the UI responsive. I will test on PHP 8.2, MySQL 8, and the latest Laravel version, so stick to those versions. Acceptance criteria 1. Fresh repo and SQL dump install in under five minutes 2. All three feature sets above function across at least two demo countries 3. Permissions: admin can edit anything; owner can only edit their own listing 4. Code passes phpstan level 5 and php-cs-fixer default rules Please include a short readme covering setup, environment variables, and any third-party packages used....
...the code clean and well-documented. Country handling should rely on a dedicated table so I can add or deactivate markets without touching code. A single-page Vue or Alpine-powered admin dashboard is preferred, but Blade is acceptable if you keep the UI responsive. I will test on PHP 8.2, MySQL 8, and the latest Laravel version, so stick to those versions. Acceptance criteria 1. Fresh repo and SQL dump install in under five minutes 2. All three feature sets above function across at least two demo countries 3. Permissions: admin can edit anything; owner can only edit their own listing 4. Code passes phpstan level 5 and php-cs-fixer default rules Please include a short readme covering setup, environment variables, and any third-party packages used....
...a table view and modal forms for adding or editing records. Please keep the code readable and tutorial-friendly. Inline comments that explain the reasoning behind key sections—especially JDBC connections, prepared statements, and event handling—are essential. Include a concise README that tells me how to import the project, run the SQL script to create the tables, and launch the application. Deliverables • Complete Java source code organised in packages • SQL file to create and populate the sample MySQL schema • Well-commented Swing UI classes showing form design, validation and table refresh logic • README / brief documentation (setup steps, class overview, screenshots if possible) I’ll test by compiling, running and verifyin...
...Key Deliverables Interactive Power BI dashboards with slicers and filters Cleaned and structured datasets ready for reporting Business insights and observations derived from the dashboards Identification of operational bottlenecks and revenue leakage points Tools & Skills Used Power BI – Dashboard creation, DAX measures, data modeling Excel – Data cleaning, validation, and preprocessing SQL (where applicable) – Data extraction and aggregation Data Analysis & Data Management Business Insights & Reporting Outcome This project demonstrates the ability to: Handle real-world food-tech and delivery platform data Convert raw operational data into meaningful insights Build decision-ready dashboards for stakeholders Support business teams in i...
I need an experienced SQL professional who can take customer data sitting on a remote SQL Server and refresh the corresponding tables on our in-house server every day. The transfer must be reliable, consistent, and handled through SQL Server Management Studio (SSMS), as that is already part of our workflow and permissions model. Your job will be to analyse the source schema, map it cleanly to our destination tables, set up the daily pull / push routine, and keep concise logs so I can trace each run at a glance. Data consistency checks, graceful error handling, and verification reports are essential because the customer records drive several downstream apps on our side. The engagement is straightforward: configure the process, prove a few consecutive successful ru...
...an experienced .NET Trainer / Senior Developer to conduct an intensive classroom-based training program for final-year engineering students. Location Gudivada, Andhra Pradesh (Onsite) Batch Size 30–40 students Duration 15–16 days Daily Schedule 9:00 AM – 1:00 PM 1:30 PM – 4:30 PM Responsibilities Deliver hands-on training covering: C# fundamentals ASP.NET Core Web API Entity Framework Core SQL Server Authentication and Authorization Industry-standard architecture and best practices Guide students through a real-world industry project Share professional development and interview preparation insights Assign daily exercises and conduct code reviews Requirements Minimum 5 years of experience with .NET / ASP.NET Core Prior corporate training or teaching ...
...x with Laravel framework (or CodeIgniter if you prefer) - MySQL/MariaDB database - Compatible with Apache or Nginx server - Ubuntu/Linux VPS compatible - Clean, organized code with comments - Easy to maintain and update Performance & Security: - Fast loading speed (optimized images, lazy loading, caching) - SEO-friendly URLs (example: ) - Security features: - SQL injection protection - XSS protection - CSRF protection - Secure password hashing - Admin panel IP whitelist option - reCAPTCHA on registration/login - CDN compatible (Cloudflare integration) SEO Optimization: - Proper meta tags (title, description, keywords) for all pages - Open Graph tags for social media sharing - markup for movies/TV shows - XML sitemap auto-generation -
I need a concise technical blueprint that shows exactly how to print in Cityworks environment at through SQL Server Management Studio. The goal is to make sure a field on the form "DUP. BAD CHECK “ L-If a Bad Check fee (L-BADCHECK) is attached to a case, it's owed. Status, type, etc. do not matter. Same for L-DUPLCTE. L-DUPBC - this is either or both a bad check fee and a duplicate fee from historic records (Pre-migration) 30 - BC 20 - Dupe 50 - Both (Rare, if it exists) the Cityworks front-end application, then landing it in the back-end SQL database on a batch schedule. You’ll be working with: • Cityworks PLL (latest build) • Microsoft SQL Server 2019 + SSMS What I expect from you: • A clear, step-by-step docum...
I need a lightweight .NET MAUI mobile application that targets Android and contains only three sc...configuration, must live in a MySQL database accessed through a secure REST API that you will craft and integrate. Please separate API, data-access and front-end layers cleanly and keep the code in MVVM pattern. C#, .NET 8, Entity Framework (or Dapper), Visual Studio and standard platform libraries for biometrics and NFC are preferred. Deliverables • Complete MAUI solution and REST API source code • SQL script that creates the MySQL schema and seeds sample data • Release-ready APK/AAB • Concise setup guide covering environment requirements, build steps and how to change the WebView URL Begin your proposal with the exact phrase “MAUI-READ” to con...
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.