Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
Preciso de um dashboard em Power BI focado exclusivamente em dados de vendas. Quero que a principal métrica em destaque seja a receita gerada e que, sempre que fizer sentido, essa informação apareça em gráficos de pizza. Escopo básico: • Conectar-se à minha base de dados de vendas (posso fornecer arquivo Excel, CSV ou link SQL). • Modelar as tabelas para garantir atualização automática. • Criar páginas limpas e responsivas, usando principalmente gráficos de pizza para distribuir a receita por produto, região e período. Outros tipos de visualização podem ser incluídos se ajudarem a contar a história, mas o gráfico de pizza deve p...
...Automation Locating and interacting with elements Wait strategies and basic UI test implementation Screenshots Popup dialogs and dynamic content Multiple tabs/windows Parallel execution and shadow DOM handling 5. Test Runners & BDD Frameworks NUnit / xUnit / MSTest Parameterized tests Parallel test execution 6. General Technical Skills Code reviews and static code analysis CI/CD tools Git SQL (SELECT, JOIN, DML/DDL) Design patterns Test strategies and test planning SDLC methodologies What I’m looking for in a mentor: Hands-on experience in .NET test automation Ability to explain why things are done, not just how Focus on real interview expectations and questions Ideally, mock interviews and code review sessions Timeframe: short and intensive (i...
SITUACIÓN ACTUAL: Sistema RelojControl en producción (GitHub: ) - Backend: Node.js 16 + Express + Sequelize + SQL Server - Frontend: Vue.js 2 + Vuetify + Vuex - Funciones: Órdenes trabajo (OTs), timers realtime, reportes Excel, upload Excel - 2 READMEs + estructura backend/front + models (64KB) SE REQUIERE MÓDULO 2 : ASIGNACIÓN OPERADORES A OTs con filtrado por usuario ESPECÍFICAMENTE: BACKEND: - Tabla user_ot_assignments (userId, orderId, assignedBy, date) - POST /api/assign-ot {userId, orderId[], assignedBy} - GET /api/user-orders/:userId (solo OTs asignadas al usuario) - Asignación masiva array orders FRONTEND: - Admin: (tabla OTs + checkboxes usuarios) - Operador: filtrada → solo mis OTs asignadas - Upload
...(for email) and Twilio (for SMS) without breaching rate limits. • Admin dashboard where I can edit interpretation text, adjust default settings, and monitor delivery logs. Deliverables 1. Responsive front-end (React or Vue preferred) with sign-up, profile, and dashboard pages. 2. Back-end API (Node, Python or PHP—your choice) that performs astronomical calculations, stores preferences in a SQL or NoSQL database, and triggers the alert cron jobs. 3. Integrated email and SMS pipelines, tested end-to-end with sample users. 4. Deployment scripts (Docker or similar) so I can move the stack to AWS Lightsail without drama. 5. Brief hand-over video or document walking me through the codebase and the alert rule builder. Acceptance criteria • Transit and das...
...format file. There might be a need to scrape data as well. Both the full address string and the explicit lat/long coordinates have to be preserved so I can map or geocode later. The ODB occasionally stores lookup tables in separate relations; bring those values across so the sheet is human-readable— no foreign-key IDs left unresolved. If you use any transformation scripts (Python, LibreOffice Base, SQL, Power Query, etc.) please hand those over as well; I may need to re-run the process when updated releases appear. If I decide to add extra columns later, I’ll let you know, so keep your workflow flexible enough to accommodate a quick re-extract. Deliverables for acceptance: • Clean, filter-ready .xlsx file with every building in Canada • Any code or que...
Hi, - CPU: AMD EPYC 7571 (8 core(s)) - Version: Plesk Obsidian v18.0.75_build1800260102.11 os_RedHat el8 - O...SERankingBacklinksBot but that was fixed, the domain was also configured wrongly in our server but then it was fixed - This is the current screen from sucuri - The bandwidth usage of the domain is very high in plesk and the website has few unique visitors per day I personally don't believe the issue is the plugin, as we have also installed SQL monitoring tools and we didn't find any issue. We are looking for someone with experience to examine and resolve the issue, if you don't have the experience please don't contact us. We believe that the issue is either wrong settings applied on the server or the site is being attacked.
...withdrawal requests; • mark withdrawals as paid and store a PayPal transaction ID. I am happy with any modern backend stack (Firebase, Node, Laravel, Django, etc.) as long as: • data is secured and scalable; • API endpoints are documented; • I get full ownership of the source code. Deliverables – Cross-platform mobile app source code – Admin panel source code and live deployment – SQL or NoSQL database schema and seed data for testing – AdMob integration set to test mode – PayPal (or Stripe Payouts) cash-out flow in sandbox and ready for production keys – Step-by-step publishing assistance up to successful store approval Acceptance criteria 1. A new user can register with email, verify the addres...
I have several disparate sources holding our inventory information and I want it all pulled together into one clean, well-structured Microsoft SQL Server database file. The job is straightforward in principle: extract every piece of inventory data you can reach, reconcile duplicate SKUs or mismatched item descriptions, then load the final result into a single .sql or .bak file that I can restore through SQL Server Management Studio. Please preserve every existing field that carries operational value—quantities on hand, reorder thresholds, location codes, cost figures, and any audit timestamps—and normalise the schema where it clearly improves reporting speed or data integrity. If a field appears under different names in different systems, map it consistent...
...desde una base de datos SQL; el objetivo es una migración limpia, controlada y auditable hacia el nuevo esquema. Qué espero de ti • Diseñar y desarrollar mappings, sesiones y workflows en PowerCenter que cubran todo el flujo de extracción, transformación y carga. • Incluir manejo de errores, validaciones de calidad y registro detallado de eventos. • Documentar cada mapping en el repositorio y entregar un pequeño manual de despliegue/rollback. Aceptaremos el trabajo cuando: - Todos los procesos se ejecuten sin fallas en la ventana nocturna definida. - Los conteos y checksums entre origen y destino coincidan al 100 %. - El paquete completo esté versionado y listo para promoción a QA/Producci&oacu...
...nos encontramos en búsqueda activa de una pequeña agencia en Sudamérica para colaborar de forma recurrente (y también por bolsas de horas mensuales) en proyectos de: SEO avanzado (onpage/offpage, auditorías, canibalizaciones, interlinking, backlinks, métricas, tendencias y enfoque adaptado a LLMs) - Desarrollo y diseño web WordPress (obligatorio) - Programación a medida (Bootstrap, PHP, CSS, SQL, Ajax, JavaScript, HTML…) - Prestashop (opcional, muy valorado) - Shopify (opcional, muy valorado) - Diseño gráfico (logos, piezas de publicidad, mockups en Figma, cartelería) >>> Contexto: ya trabajamos desde hace años con una agencia de Venezuela. Queremos sumar un segundo partner ...
...two Please build in a simple scheduler or CLI flag so I can trigger each scrape automatically via cron. Bet365 is heavily scripted, so headless-browser handling (Selenium, Playwright, or Puppeteer) plus proxy/anti-bot measures may be required; use whichever stack you’re comfortable with, provided it is well documented. Deliverables 1. Clean, runnable source code with setup instructions. 2. SQL schema and migration script. 3. README showing sample queries that compare initial vs. pre-game lines. 4. Brief note on how to extend the scraper to additional stat fields in future. I’ll test by running the scraper on a live slate and verifying the database shows the two snapshots and correct movement calculations. Objective 2 I then want a web app that alerts me of...
My PHP (mysqli) site is suddenly refusing to save changes to the database. Reads still work, but any record update—whether triggered from the WordPress admin area or through our custom JavaScript front-end—returns no change and sometimes throws a silent SQL error. The job is to trace and eliminate this update failure. I can grant access to the codebase,and phpMyAdmin. The stack is: • PHP 8.x using mysqli • MySQL 5.7 • WordPress (themes and a small helper plugin interact with the same tables) • Vanilla JavaScript on the client side
...Back-End Requirements All anime content will be stored in our own databases. We are looking to design and implement a scalable backend architecture. Required experience includes Go (Golang) for backend services, Node.js and JavaScript for supporting services or APIs, working knowledge of SQL and NoSQL databases, and experience with API design and system architecture. Required Skills and Experience We are looking for a full-stack developer with strong experience in ReactJS and Go, solid understanding of SQL and NoSQL databases, and familiarity with modern web architectures. Basic knowledge of anime streaming platforms such as HiAnime, KaiAnime, or similar websites is preferred. Deep anime knowledge is not required, but understanding how streaming platforms function wil...
I need a complete, cloud-hosted database solution that I can reach from any browser. The core of the project is a secure web application that lets my team create, read, update, and delete two key data sets—our inventory and our customer records. A relational structure in a managed cloud service (AWS RDS, Azure SQL, Google Cloud SQL, or a comparable platform) is the target back-end; I’m open to whichever stack you feel delivers speed, reliability, and straightforward maintenance. Here’s what I expect: • A clean data model covering all inventory details and customer profiles, with the appropriate relationships, constraints, and indexing. • Web UI with intuitive forms, tabular views, and quick search / filter so staff can locate or edit a record i...
I need an experienced .NET full-stack developer to move several in-house web projects forward. Most of the work circles around ASP.NET Core (MVC and Web API) backed by SQL Server, with the user interface rendered in Bootstrap. Scope of work • Build new modules and, where necessary, refactor legacy .NET code into a clean, layered architecture. • Design and optimise SQL Server tables, views, stored procedures and indexes to keep the app fast under load. • Implement an admin area focused on Analytics graphs; charting libraries that work smoothly inside Bootstrap are welcome. • Secure the application with claims- and cookie-based authentication, plus role-based authorisation throughout. • Integrate third-party REST APIs, handle error cases gr...
I maintain a live Angu...and leave the codebase cleaner and easier to extend. Key deliverables • Stable, fully functioning Dotnet Core backend with no data synchronization lapses • API endpoints returning expected payloads without timeout or serialization errors • Brief hand-over notes or a pull-request summary so I can follow the changes You should already be comfortable with Visual Studio, Entity Framework Core, SQL Server, Git, and basic Angular debugging so we can trace requests end-to-end while you’re here. If you can drop by our Koramangala office (or any mutually convenient spot) this week, we can kick-off immediately. Let me know your availability and a couple of recent projects where you handled similar Dotnet Core integration fixes, and we&r...
...legacy UI logic causes freezes or display problems under newer Windows builds. • Leave the code cleaner than you found it—comment your changes and maintain our existing naming conventions. • Provide a brief change log at the close of each task so we can track what moved and why. The environment is pure VFP 9 (no .NET wrappers), talking to DBFs on a local network share; some routines also hit a SQL Server instance over ODBC, so familiarity with both sides will help. I’ll open access through AnyDesk or VPN to a staging machine that mirrors production. First priority is stabilising today’s pain points; once that’s under control we can discuss broader upgrades or partial migration strategies. If you know VFP inside out and enjoy coaxing extra ...
...permitiendo agregar fácilmente nuevos módulos del ERP, soluciones y desarrollos personalizados conforme la plataforma evolucione. Objetivos del Proyecto Posicionar a VLIM Solutions como una empresa seria de desarrollo de software empresarial Presentar el ERP modular en modalidad SaaS / hosting de forma clara y comercial Promocionar los servicios de desarrollo de software en Oracle (APEX, PL/SQL, integraciones) Ofrecer servicios de soporte y consultoría Oracle facturados por hora Facilitar la generación de leads mediante llamadas a la acción claras (Solicitar demo, Contactar ventas, Agendar llamada) Diseño y Enfoque Desarrollo completo en Squarespace Diseño moderno, limpio y orientado a empresas de tecnología / SaaS ...
...two Please build in a simple scheduler or CLI flag so I can trigger each scrape automatically via cron. Bet365 is heavily scripted, so headless-browser handling (Selenium, Playwright, or Puppeteer) plus proxy/anti-bot measures may be required; use whichever stack you’re comfortable with, provided it is well documented. Deliverables 1. Clean, runnable source code with setup instructions. 2. SQL schema and migration script. 3. README showing sample queries that compare initial vs. pre-game lines. 4. Brief note on how to extend the scraper to additional stat fields in future. I’ll test by running the scraper on a live slate and verifying the database shows the two snapshots and correct movement calculations. Objective 2 I then want a web app that alerts me of...
...js + Laravel codebase * Build new features end-to-end (UI, APIs, database changes) * Fix bugs, optimize performance, and improve reliability * Write clear, maintainable code with solid testing practices * Collaborate on technical decisions and suggest practical solutions Requirements * Strong hands-on experience with and Laravel * Experience building and consuming REST APIs * Solid SQL/database skills (MySQL or PostgreSQL) * Comfortable working in Git-based workflows and code reviews * Strong communication and ability to work independently Nice to have * Experience with authentication (e.g., Laravel Sanctum, NextAuth) * CI/CD and deployment experience (VPS or containerized environments) * Familiarity with performance tuning and security best practices If you’re a pragma...
I have a PHP-based website fully packaged with installation notes, environment variables, and an SQL dump. All files are sitting in a ZIP, ready to be uploaded to my existing shared hosting account (cPanel). What I need now is simple but time-sensitive: • Upload every file to the correct directory, keeping the documented structure intact. • Create and configure a brand-new MySQL database as described in the docs, import the SQL, and update the connection details in the config file. • Run a quick post-deployment check to confirm pages load correctly, forms submit, and no PHP errors appear. You will receive: FTP credentials, cPanel access, and the full documentation folder. Once the site is live and error-free I’ll sign off right away. If yo...
...maintenance, upgrades, and deployment fixes Required Technical Skills • Strong experience with .NET ecosystem, C#, ASP.NET Core • Proficiency in Ruby environments (Rails or similar frameworks) • Advanced React and frontend development knowledge • Solid understanding of REST APIs, authentication, and data flow • Experience debugging production environments and live systems • Knowledge of SQL/NoSQL databases and performance optimization • Familiarity with Git workflows, CI/CD pipelines, and cloud deployment • Ability to analyze legacy systems and refactor safely Preferred Qualifications • Experience handling large-scale or enterprise web applications • Exposure to DevOps practices, containerization, or cloud platforms • Un...
My existing ASP.NET-based site (C#, SQL Server) is ready for live payments; the missing piece is a clean, fully-tested connection to the ICICI Bank payment gateway. The integration has to handle three flows—one-time charges, recurring billing cycles, and full or partial refunds—without persisting any card data on our servers. Key deliverables • Seamless server-side code that calls ICICI’s API for payments, subscription creation, and refunds, then returns clear success/error responses to the UI. • Web-configurable credentials and callback URLs so I can switch between sandbox and production by editing settings, not code. • Token-based implementation that keeps us out of PCI scope (no storage of card details). • Brief deployment guide an...
I'm seeking a skilled full stack developer to create a web application designed to streamline job application processes...and tailored specifically for tech job seekers. Key Features: - User Authentication: Secure login/signup. - Job Listings: Aggregated from various platforms. - Application Tracker: Monitor application status. - Profile Builder: Create and customize resumes. Ideal Skills: - Proficiency in frontend (React, Angular) and backend (Node.js, Django) technologies. - Experience with database management (SQL, NoSQL). - Strong UI/UX design principles. - Previous experience in building job-related web applications is a plus. Looking for a developer who can take this from concept to completion, ensuring a smooth and engaging user experience. Please share any relevant ...
...content-visibility suppression on major social platforms. You will design and execute an evidence-based study: gather relevant data points (public APIs, scraped feeds, or previously archived datasets), apply statistical or machine-learning techniques to spot anomalous reach patterns, and document any rules, thresholds, or signals that appear to mute posts. I am open to your preferred toolkit—Python, R, SQL, or specialty OSINT platforms—as long as the workflow is reproducible. What matters most is a clear, defensible methodology, transparent code, and a concise explanation of the findings that a non-technical stakeholder can understand. If you uncover heuristics behind the suppression, flag them; if the analysis proves inconclusive, explain why and suggest next s...
Two to three seasoned full-stack engineers are needed to push a complex, production-grade banking platform forward. The application’s backbone is .NET Core, the UI is written in Angular, and critical jobs run as Azure Functions, all talking to a SQL Server datastore. Your day-to-day work will revolve around: • Designing and coding new features end-to-end in .NET Core and Angular • Writing and refactoring serverless logic inside Azure Functions • Optimising queries and data models in SQL Server • Raising pull requests, performing code reviews, and managing branches in GitHub • Updating stories and tasks in Jira while collaborating in two-week sprints The environment is fast-moving and highly regulated, so I value developers who already...
I’m looking for a data scientist based anywhere in Latin America to help me create reliable predictive models for a finance-focused project. You’ll start with large historical datasets stored in SQL and deliver models that accurately forecast key financial indicators. I work mainly with Python, so you’ll find Pandas, NumPy, Scikit-learn and, when deep learning is justified, TensorFlow already in place. If you prefer R for certain tasks, that’s perfectly fine as long as the final workflow remains reproducible. The end-user needs to consume insights through Power BI, so once the model is validated I’ll ask you to craft intuitive dashboards that highlight drivers, confidence ranges and any red-flag anomalies the model detects. Solid statistical grounding ...
I need a developer to design a SQL database and a small ERP-style system for my logistics company. This system will create goods dispatch notes based on specific parameters. Core Functionalities: - Calculate quantities to be delivered per item per day. - Calculate total of each item to be delivered per month per customer. - File upload capability. - Output goods dispatch notes in Excel format. - Accessible as a web app for different users - Dashboard to track progress of deliveries per month - Interface to modify the data and based on delivery needs - Capable of calculating and creating all the dispatch notes per week and per month Ideal Skills and Experience: - Proficiency in SQL and ERP system development. - Strong experience in database design. - Familiarity with Excel ...
...create various agents for our private equity business. The only billed time will be the time spent on the video call with our team, unless specifically approved otherwise. we want to be able to create a screen scrape tool to average certain cost items of specific real estate proejcts 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. Tech freedom I haven’t settled on Claude, OpenAI, or any other foundation model yet. I’m op...
...Automation Engineer with strong skills in IVR testing and Hammer to connect with one person and connect with him daily helping work Requirements min 5+ years of experience in IVR / Contact Center testing Strong hands-on experience with Hammer (must-have) Experience with Genesys Cloud or similar platforms Manual and Automation Testing experience API Testing (Postman / Rest Assured) SQL for database validation Experience with Azure DevOps / Jira Knowledge of Agile/Scrum methodology Must be willing to coordinate and work closely with another team member for daily support and knowledge sharing Responsibilities Develop and maintain Hammer automation scripts Perform end-to-end IVR testing Execute manual and regression testing Validate call flows and backend data Report...
looking for an experienced OT / Industrial IIoT freelancer to develop a small on-premise technical demo (PoC) related to an automotive Paint Shop (Pre-Treatment & E-Coat). The goal is to demonstrate a realistic Industry 4.0 data flow, fully on-premise, without modifying PLC control logic, and aligned with industrial cybersecurity best practices.
...QR code processing • M-Pesa Daraja API: B2C payments, OAuth 2.0, webhook callbacks • Safaricom API integration for mobile money disbursements • JSON/XML data formatting and parsing • Webhook development and callback management • API rate limiting and queue management 4. Technical Skills • Deluge scripting (Zoho's scripting language) - Advanced level • JavaScript for client-side customizations • SQL for data queries and reporting • Database design and data modeling • Data migration strategies and execution • System integration architecture (Hub-and-Spoke) • Mobile app configuration (iOS/Android) • Barcode/QR code integration for inventory 5. Industry & Domain Knowledge • Telecommunications/Field Service...
Restructure execution flow to isolate SQL Server and MS Access ODBC drivers, eliminating driver-level deadlocks and restoring scheduler stability.
...Architects/Analysts - Degree or Master’s in Computer Security, Data Science, or Computer Science - Expertise in implementing Digital Public Infrastructure (DPI) approaches 4. Cybersecurity and Data Security Expert - Degree or Master’s in Cybersecurity or IT Governance - 10 years of experience with CSIRT/SOC, PKI, IAM 5. Data Management Expert - 5+ years of experience with large databases (Oracle, MS SQL, PostgreSQL) and data visualization platforms 6. Artificial Intelligence Expert - Master’s degree in Computer Science with specialization in AI - 5 years of experience designing and deploying AI solutions 7. Data Hosting and Cloud Expert - 10 years of experience designing data hosting and cloud solutions 8. IT Legal Expert - Master’s degree in ICT law ...
...WordPress site—database dump, wp-content, core files, everything—zipped and ready to go. The new host uses cPanel, and I’d like the site fully restored there so it looks and functions exactly as it did on the previous server. What I need you to handle: • Upload the full backup through cPanel (File Manager or SFTP). • Create a new MySQL database, user, and correct privileges, then import the SQL file. • Update with the new database credentials. • Point or update DNS if necessary so the domain resolves to the restored site. • Run a quick check for broken links, missing media, or plugin issues after migration. Everything should end with the site loading fast and error-free on the new hosting account. If you’ve completed...
...solution (web + mobile + hybrid) that runs across AWS and Azure, orchestrated with Kubernetes and backed by SQL Server. What you’ll work on • Blazor applications (must have) using MudBlazor • .NET MAUI clients consuming the same backend APIs • Clean, testable C# domain logic • REST APIs with strong test coverage (TDD expected) • SQL Server schema design, queries, and performance tuning • Containerised services (Docker) • CI/CD pipelines (Azure DevOps) • Deployments to AWS (EKS, Lambda) and Azure (AKS, Functions) Must-have experience • Strong C# / .NET • Blazor (WASM or Server) – mandatory • Real full-stack experience (UI + API) • Test-Driven Development • SQL Server (T-SQL...
I run several mission-critical applications on AWS and I’m looking for a seasoned C#/.NET engineer who can extend our backend, shape new APIs, and keep deployments rock-solid. Day-to-day you’ll work with AWS Lambda for serverless jobs and EC2 for long-running services, containerise everything in Docker, then roll it out to our Kubernetes clusters. All data lives in SQL Server, so you’ll need to be comfortable with T-SQL, indexing, and performance tuning. Development happens on Linux, version-controlled with Git, and we sync up during US-CST hours—daily status notes are required so nothing slips through the cracks. Compensation is in the USD 500-1,000 monthly range and can scale with proven results. WPF, Redis, Grafana, or SIP/VoIP expertise would...
...All Reports) All new reports must include: One-click Excel export Clean headers Numeric values (not strings) No formatting issues while uploading to GST software Technical Requirements Framework: Laravel (existing system) Follow existing coding standards No core file overwrites unless required SaaS / multi-tenant compatibility must be preserved Use existing export utilities if present Optimized SQL queries (large data safe) Deliverables Fully working GST Sales Report Fully working GST Purchase Report Transaction Mode Report Poduct Expiry field integrated Excel export for all reports Tested on sample data No existing feature regressions Acceptance Criteria Report totals must match actual invoice data GST breakup must be mathematically accurate Excel files must open correctl...
...current schema dump (or direct access if you prefer), sample data, and a brief outline of the application’s data flow so you can map dependencies accurately. What I expect back: • A MySQL-ready schema that mirrors the original structure, optimised where obvious gains are available (indexes, data types, constraints). • Reliable migration scripts or a repeatable procedure (PHP, Python, or plain SQL—your choice) that I can rerun in staging and production. • A sanity-check report showing row counts and key relationships before and after the move to confirm data integrity. • Quick guidance on any minor config tweaks my PHP framework might need to point to the new MySQL instance. Tools are up to you—phpMyAdmin, MySQL Workbench, CLI, or be...
I need a data analytics expert to analyze key datasets. Key requirements include: - Analyze sales, customer, and operational data. - Identify trends, make predictions, and improve efficiency. - Deliver insights for reports, business decisions, and strategy development. Ideal skills and experience: - Proficiency in data analytics tools (e.g., Python, R, SQL). - Strong analytical and statistical skills. - Experience in generating actionable insights from complex datasets. - Ability to communicate findings clearly. If you have a proven track record in data analytics and can work within my budget, I would love to hear from you.
...reports or CSV exports without ever leaving the interface. A clean, intuitive UI is important because I expect non-technical staff to use it daily. Under the hood, I’m open to the stack you feel is most stable—C#/.NET (WinForms or WPF) or a lightweight Electron build are both fine as long as startup time is fast and the installer is straightforward. Local storage can sit in SQLite or a small embedded SQL Server database; just make sure the data file is easy for me to back up. I’ll provide the exact field list and sample data once we start, but anticipate roughly 15–20 columns, a few dropdowns, and one attachment field per record. All code must be well-commented, and I’d like a brief hand-off call or screen-share at the end so I know how to build an...
...Google Play Store. Sixth: Security & Data: : Full compliance with the Personal Data Protection Law (PDPL) in Saudi Arabia and National Cybersecurity Authority (NCA) standards. : Encryption of all sensitive data (customer info, addresses, payments) using advanced protocols (e.g., AES-256) and securing connections via SSL/TLS. Security: Securing endpoints against attacks (SQL Injection, XSS) and using Two-Factor Authentication (JWT). Residency: Commitment to local data storage within Saudi Arabia as per regulatory requirements. Testing: Delivery of a report proving the system is free of security vulnerabilities, with Audit Logs for all sensitive operations. Support: Commitment to technical support and bug fixes for a period to be agreed
...e 50 páginas que descreva arquitetura, metodologia, testes e resultados. • Prazo total aproximado de 6 meses, com entregas parciais combinadas. Requisitos-chave • A solução deve priorizar a experiência do usuário, reduzindo pontos de atrito no processo de coleta. • Quero ver propostas detalhadas de projetos: cronograma, tecnologias sugeridas (por exemplo, Python, Java, Node.js, bancos NoSQL ou SQL), divisão de tarefas e métricas de sucesso. • Documentação clara (diagramas UML, fluxos de dados, manuais de instalação e uso) para compor o relatório. Critérios de seleção Envia-me exclusivamente propostas detalhadas de projetos – quanto mais estruturadas,...
I need a MySQL database dump sql hosted on AWS for backup and restore purposes. Key Requirements: - Expertise in AWS and MySQL - Set up MySQL without automated backups
I need a reusable ETL framework built inside Databricks notebooks, version-controlled in Bitbucket and promoted automatically through a Bitbucket Pipeline. All sour...any cluster. Acceptance criteria • Parameter-driven notebooks organised by layer. • Reusable GraphQL connector packaged as a .whl. • Bitbucket Pipelines yaml that runs unit tests, uses the Databricks CLI to deploy notebooks, and executes an integration test on commit. • Clear README detailing how to add a new API endpoint and where to place cleaning logic. Leverage native tools—PySpark, SQL, Delta Lake, dbutils—while keeping external libraries to a minimum and fully documented. Please share a brief outline of your approach and any relevant Databricks + Bitbucket CI experience s...
Ya tengo el diseño inicial de la interfaz construido con V0 de Vercel en Next .js. Ahora necesito que lo conviertas en una aplicación funcional que: • Reciba y almacene datos de usuario junto con los documentos que ellos mismos suban. El usuario deberá aceptar "términos y condiciones" ya que está subiendo información confidencial • Guarde todo en una base SQL; me da igual MySQL o PostgreSQL mientras quede bien estructurado y con migraciones incluidas. • Exponga un API REST para altas, bajas, cambios y consultas, de forma que mi equipo pueda consumirla sin fricción. • Ofrezca un pequeño panel interno (puede ser dentro del mismo Next .js) para visualizar y filtrar la información almace...
I have several months of raw sales data sitting in mixed Excel/CSV files and a small SQL dump. I need that information cleaned, organised, and explored so we can finally see what the numbers are really telling us. After the data is trustworthy, I want to zero-in on three priorities: revenue trends over time, customer acquisition and retention behaviour, and sales performance broken down by region. Power BI is my preferred canvas for the visuals. Please build an interactive dashboard that lets managers slice by date, product line, and region while keeping the layout simple enough for non-technical teammates. If you also know Tableau or advanced Excel, great, but the .pbix file is the deliverable that matters most. Once the dashboard is live, I’ll need a short narrative (one-t...
...API: - Chat / reasoning - Speech-to-Text - Text-to-Speech - AI behaviour must follow client-defined instructions - Admin AI analyst must query stored conversations and uploads VOICE: - Vonage Voice API - Outbound calls to UK mobile numbers - Used mainly for low-balance reminder calls - Internet-based voice support (WebRTC acceptable) DATABASE & STORAGE: - Separate database per client (Cloud SQL or Firestore) - Encrypted at rest - Cloud Storage for file uploads - Maximum upload size: 100MB - AI-searchable data (vector search or equivalent approach) FRONTEND: - Mobile-first responsive web application - React / / Vue (open to suggestion) - Voice chat interface - Text chat interface - Live transcript displayed during voice calls - File upload interface - Admin dashboard...
I'm seeking a consultant based in Johannesburg South Africa, with strong experience in Pow...Automate, and knowledge of Syspro for a 6-month engagement. The goal is to build tables and dashboards and automate some of our internal workflows. Key Responsibilities: - Building tables and dashboards in Power BI - Automating internal workflows using Power Automate - Connecting to SQL databases and Excel spreadsheets as data sources - Ensuring that both management and operational teams can effectively use the outputs Ideal Skills and Experience: - Strong expertise in Power BI and Power Automate - Proficiency in SQL and Excel - Familiarity with Syspro - Experience in creating user-friendly dashboards for management and operational teams Please provide examples of similar proj...
...Automation Engineer with strong skills in IVR testing and Hammer to connect with one person and connect with him daily helping work Requirements min 5+ years of experience in IVR / Contact Center testing Strong hands-on experience with Hammer (must-have) Experience with Genesys Cloud or similar platforms Manual and Automation Testing experience API Testing (Postman / Rest Assured) SQL for database validation Experience with Azure DevOps / Jira Knowledge of Agile/Scrum methodology Must be willing to coordinate and work closely with another team member for daily support and knowledge sharing Responsibilities Develop and maintain Hammer automation scripts Perform end-to-end IVR testing Execute manual and regression testing Validate call flows and backend data Report...
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.