Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
...Django REST APIs, GraphQL, or gRPC Microservices architecture Machine Learning and AI TensorFlow, PyTorch, Scikit-Learn, or similar frameworks Experience working with LLMs and modern AI frameworks Prompt engineering, RAG, or vector databases is a plus Cloud and DevOps AWS, Azure, or Google Cloud Platform Docker and Kubernetes CI/CD pipelines and deployment practices Data and Systems SQL or NoSQL databases (PostgreSQL, MySQL, MongoDB, Redis) Data processing and scalable system design experience Security and Best Practices OAuth, JWT, RBAC authentication systems Secure API development and production standards Optional (Nice to Have) Blockchain or emerging technology experience Expectations Strong real-world development experience Good English communication skil...
I’m ready to bring in a security specialist to run a thorough, manual penetration test on my live e-commerce application. Automated scanners aren’t enough for this engagement—I need human-driven testing that uncovers real-world attack paths. Here’s what I’m looking for: • A full manual assessment covering all SQL Injection, Cross-site Scripting (XSS) and Cross-site Request Forgery (CSRF),Web Application Penetration Testing , Network Penetration Testing Services External or Internal, Web Services Testing, API Testing • Exploitation-level proof of concept for every confirmed issue, with clear, reproducible steps. • A concise risk-ranked report that separates critical, high, medium and low findings, followed by practical remediation advi...
I have a Hadoop cluster holding several large data sets, and I need a seasoned PySpark developer who also writes rock-solid SQL. The immediate aim is to connect to the cluster (YARN/HDFS with Hive metastore), develop or refine PySpark jobs, optimise the accompanying SQL, and make sure everything runs smoothly end-to-end. You’ll receive access to a staging namespace plus a sample of the data. Once the logic checks out we’ll promote the code to the full environment. Deliverables • A clean, well-commented PySpark notebook or .py job that executes successfully on the cluster • The corresponding SQL script or view definitions ready for Hive or spark-sql • A concise README detailing execution steps, parameters, and expected outputs ...
...can maintain it later • Save each record directly into a relational table (MySQL or PostgreSQL—let me know which you prefer) using prepared statements to prevent SQL injection • Provide a simple configuration file where I can switch credentials, database connection strings and add new profile URLs without touching the core logic Acceptance criteria • I point the tool at 10 test profiles; all mapped fields appear in the database exactly once with no missing characters • A command-line log or dashboard shows progress and any errors in real time • You hand over the source code, a README with setup steps, and a sample SQL schema Experience with Python (Selenium, Playwright or similar), LinkedIn APIs, and database integration will be...
...JCL, DB2, CICS, and IMS is required. Key Responsibilities Provide 2 hours/day technical support and guidance. Develop and enhance applications using COBOL, JCL, DB2, and CICS. Perform impact analysis, debugging, and production support. Support batch and online processing systems. Collaborate with stakeholders and mentor junior team members. Required Skills COBOL, JCL, DB2, CICS, IMS DB, SQL Endevor, Topaz, Control-M ISPF, SORT, IDCAMS Strong troubleshooting and SDLC knowledge...
...CSV so staff can pull quick counts. • Low-stock thresholds with email alerts (SMTP already configured in the system). • Clear install/merge instructions and brief user documentation. Acceptance The module must install without breaking existing ERP functions, display accurate stock counts after sample transactions, and meet simple code-review standards (PSR-12, parameterised queries, no raw SQL injections). I will provide a code snapshot, database schema and access to a staging server. If this initial stock-tracking phase goes smoothly, we can discuss adding supplier or order processing down the line....
...solutions fast Non-Negotiables * Design quality is paramount: clean, polished, modern UX/UI execution * Bug-free delivery is paramount: high attention to detail and strong QA habits * Mastery of AI workflows is paramount and will be evaluated in the hiring process Requirements * Strong hands-on experience with and Laravel * Proven experience building and consuming REST APIs * Strong SQL/database skills (MySQL or PostgreSQL) * Comfortable with Git-based workflows and high-quality PR reviews * Clear communication and ability to work independently Nice to Have * Experience with auth flows (Laravel Sanctum, NextAuth, etc.) * CI/CD and deployment experience (VPS, Docker, containerized infra) * Performance and security hardening experience * Experience integrating LLM tools and AI-...
...(should allow for multiple or "all"). ● <api_key> – Handled via __secrets.AIRTABLE_API_KEY or custom named key. Reference: Use the existing platform templates as a reference for coding standards and placeholder syntax. 2. Validation Scenarios You must demonstrate a successful flow execution for each of the following architectures: ● Scenario A: The Native Bridge (Airtable → SQL) ○ Flow: DLT-Code Node (Source) → SQL Database Node (Destination). ○ Test: Connect the Airtable template to your local Postgres or MySQL instance. ● Scenario B: Local Analytics (Airtable → DuckDB) ○ Flow: DLT-Code Node (Source) → DuckDB Node (Destination). ○ Test: Materialize Airtable data into a local .duckdb file. ● Scenario C: Universal Connector (Airta...
I currently manage a website built for display management. It runs on a Linux server with an SQL database. Over time, the system has slowed down and is struggling to handle the increasing volume of data efficiently. The goal is to redesign the website using modern technologies and update the overall architecture to improve performance and scalability. All page designs have already been completed in Figma. The platform synchronizes its main database with local databases on connected desktop workstations, and the new version must remain fully compatible with the existing desktop software to ensure seamless synchronization. There are three user roles: Super Admin, Admin, and User, each with specific permissions to manage or view different levels of content. In addition, the UI need...
I’m building an internal business tool and need an experienced .NET Core developer who can work during the India night shift (roughly 9 PM–5 AM IST). The project centers on a browser-based web application, so you’ll spend most of your time inside ASP.NET Core, Entity Framework, and SQL Server, wiring up clean MVC or Razor Pages, setting up dependency injection, and testing endpoints with Postman or Swagger. You’ll collaborate directly with me over Teams for quick stand-ups and code reviews, pushing updates to a Git repository each night. I already have wireframes, a partial domain model, and an Azure DevOps board with user stories ready for you; your first tasks will involve refining the data layer, implementing responsive views, and tightening up API endpoi...
...dashboards and retraining scripts Acceptance criteria A working API must return real-time predictions within agreed latency limits, integrate seamlessly with the current SMTP/ESP workflow, and include logging for compliance review. Final delivery is considered complete when the system runs in production and all documentation passes peer review. Tools & stack Python, scikit-learn or TensorFlow, SQL/NoSQL for data storage, and standard MLOps utilities (Docker, CI/CD) are anticipated, yet alternative libraries are welcome if they meet the same reliability and security standards. Timeline and milestones will be outlined together at project start, with code reviews scheduled at each major checkpoint....
...multiple mats and rounds, with clear matside displays. • Scores are entered live; individual results immediately roll into cumulative team standings. • At any point, I can print clean, ready-to-post brackets or final summaries. Everything must run in a browser so I can open it from any laptop in the gym. I’m flexible on the tech stack—React or Vue paired with Node.js, Django, or Laravel and a SQL database makes sense as long as the code is clean, documented, and easy to deploy. An exportable data format and concise installation guide are part of the final hand-off. I’ll share detailed rules, UI sketches, and workflow diagrams once we connect. We can break the build into milestones for architecture, core engine, interface, testing, and deployment,...
...polished Power BI report that pulls live data from my SQL Server instance, applies a handful of straightforward calculations (simple sums, averages, percentages—nothing too exotic), and then presents the results in an interactive set of bar charts, line graphs, and pie charts. You will start by configuring the data gateway or direct-query connection so the report can refresh without manual intervention. Once connected, build a clean data model with clear relationships, sensible field naming, and the calculated columns or measures we agree on. With that foundation in place, design the visuals so users can slice, filter, and drill down smoothly on the key metrics we track each week. Deliverables • A fully-functional .pbix file connected to my SQL Server da...
...clients—schools, companies, public bodies and similar organisations—can log in over the internet to view, upload and download their own estate-related and compliance documents such as surveys, inspection reports and certificates. Editing in the browser isn’t required; the goal is a “read, upload, download” portal that keeps every file in its original form. Here’s what I need built: • A relational database (SQL or comparable) that stores the file-metadata and user accounts. • A clean web interface that works on desktop and mobile, served from my own on-prem server. • Username-and-password authentication with session timeout and password-reset functions. • Role separation so each client only ever sees their own folder ...
I need a Python-based tool that can scan video files, detect Trees, Road, Infrastructure—and leave room for many more object classes as the project grows—then save ev...confirm accuracy. OpenCV for frame extraction and display is acceptable; YOLO, TensorFlow, or another modern model is fine so long as the code is clean, well-commented, and easy for me to retrain with additional classes. To keep the hand-off smooth, please include: • A self-contained Python 3 script (or module set) that performs detection, inserts frames into MySQL, and plays them back. • The SQL schema and sample data script. • A brief README explaining environment setup, model weights location, and how to add new classes. Show me past work on similar computer-vision or database-driv...
...knowledge of .NET Framework 4.8 or higher, with experience developing, maintaining, and improving applications in production environments - Experience with Entity Framework (Code First and/or Database First), including relationship handling, migrations, and query optimization - Strong command of LINQ for efficient querying, data transformation, and business logic - Database - Proven experience with SQL Server, including: - Development and maintenance of Stored Procedures - Creation and usage of Functions, Triggers, and Views - Query optimization and performance analysis - Data schema management in production environments - Integrations & Services - Experience consuming and integrating REST APIs / services, both internal and third-party - Knowledge of cloud services, preferabl...
...2. I can log in to the admin panel, create a coupon and see it apply correctly at checkout. 3. Orders, stock and coupons are stored and editable in the database. 4. Code is organised, commented and delivered with a short README on setup. Please keep the setup straightforward so I can host it on a standard LAMP stack. Source code should be delivered via Git (GitHub or Bitbucket) along with a SQL dump for initial data....
...solution including: ? Ignition Perspective Application Modern, responsive screens Recipe CRUD interface Color picker with Hex capture Matrix editor (437 rows) Recipe library and selection Product assignment dashboard Status indicators and interlocks ? Database (MySQL) Parent–child recipe structure Optimized foreign key design Active status tracking table Indexed queries for fast access Full SQL export provided ?Deliverables You will receive online demonstration of : Ignition Project Complete Perspective screens Named Queries & scripts MySQL schema PLC tag/DB mapping list As discussed the project is divided into phases, in this phase complete project will be demonstrated through video and online live support. Final files will be handed over in next phase. Loo...
...integration-tested. I’ll provide the mobile team’s contract-first API specs; you’ll wire them up, create the database schema, and deliver clear migration scripts. Acceptance criteria 1. Endpoints for sign-up, MFA login, password reset, profile update and session management return the exact request/response shapes supplied. 2. Onboarding flow persists all user milestones and is replayable for audit. 3. SQL scripts run cleanly on both MySQL 8 and PostgreSQL 15. 4. Postman or similar collection demonstrates every endpoint, including negative cases. 5. Code passes all tests via Maven and spins up with Docker-Compose in one command. If you’re experienced with Spring Security, JPA/Hibernate and containerised deployment, this should feel straightfor...
...who can move comfortably between Python scripting, SQL optimisation, PySpark transformations and Airflow orchestration. The immediate focus is end-to-end pipeline build-out: designing clean ingestion logic, transforming data in Spark, writing efficient queries and scheduling everything through well-structured Airflow DAGs. If you can demonstrate hands-on experience across all four technologies - Python, SQL, PySpark and Airflow—and enjoy owning a pipeline from raw source to curated output, I’d like to work together. Deliverables I’m expecting: • A working set of PySpark jobs that handle ingestion, transformation and output staging • Airflow DAGs that schedule, monitor and alert on each job’s success or failure • Parameteri...
Employment Type & Work Location: - Full-time position - Onsite work required - Candidates must be willing to work onsite in Thailand and/or Indonesia (depending on project assignment) Required Skills: - Strong proficiency in Python - Solid knowledge of SQL - Experience with Git version control system - Good English reading and writing skills Preferred Skills: - Experience with ERP systems and/or eCommerce platforms - Business knowledge such as Accounting or Supply Chain - Experience with Docker Additional Advantages: - Hands-on experience with ERP systems (development and/or functional usage) - Knowledge of JavaScript, HTML, CSS - Demonstrable work on GitHub repositories - Public GitHub repository with proven experience will be a strong advantage
I’m building a high-end real-estate lead engine that can capture, qualify, and route 150–200 fresh inquiries every week with a hard 99.5 % uptime target. Instead of a generic chatbot, the core of this MVP is a lightning-fast Custom Qualification UI written in React, backed by a Node.js API and a PostgreSQL (or comparable SQL) data store. What I need from you is end-to-end ownership of the stack: solution architecture, clean code, robust testing, and cloud deployment. The product must open the door for future add-ons such as a real-time analytics dashboard, but for this first milestone the focus is on: • Lead scoring system that assigns quality grades the moment data arrives • Automated lead routing that pushes hot prospects to the correct broker or CRM qu...
...marketing, UX, and technical teams to optimize website performance - Develop predictive models or advanced analytics to anticipate user behavior - Ensure data accuracy, consistency, and reliability Required Profile : - Bachelor’s degree (or equivalent) in Statistics, Mathematics, Computer Science, Data Science, or related field - 2–5 years of experience in data analysis - Strong proficiency in SQL, Advanced Excel, Google Analytics, Power BI or Tableau - Knowledge of Python or R for advanced analysis is a plus - Strong analytical mindset and ability to translate data into clear recommendations - Ability to work independently while collaborating with a multidisciplinary team - Interest in digital products, web platforms, and ideally the iGaming industry Project Detail...
I need my operational data—currently stored across several Excel workbooks—turned into interactive Power BI reports that make trend-spotting and drill-downs effortles...detailed project proposal outlining the steps you would take to: • connect and clean multiple Excel sources • model the data for accurate relationships and DAX measures • design intuitive visuals that highlight KPIs, variances, and historical trends • deliver a ready-to-share .pbix file plus a short hand-off guide Everything will be built on Excel inputs for now, though I may extend to SQL or cloud sources later, so keep future flexibility in mind. Proposals that anticipate potential pain points (e.g., refresh errors, file path changes) and suggest best-practice Power Query ...
Mores What functionality do you want the Telegram bot to have? bot que gestione una base de datos de usuarios y realice peticiones HTTP, Automaticas, API-based integration with external game servers (Unity/JSON). No standard SQL ¿Qué tipo de base de datos te gustaría usar? SQL ¿Qué tipo de peticiones HTTP debe realizar el bot automáticamente? The bot requires standard REST API methods (GET, POST, PUT) to interact, interact with JSON-based endpoints and handle authentication headers.
...APEX) Deliverables: • Requirements Document (SRS) • Data Model (ERD) • Flow Diagrams • Project Schedule Phase 2 – Database & Backend Design (Week 2) Duration: 5 days Tasks: • Design Oracle tables: o Students o Parents o Teachers o Classes o Attendance o security o Student Delivery Logs o Users & Roles • Create sequences & constraints • PL/SQL APIs & packages • REST APIs for mobile app • Security & authentication design Deliverables: • Database schema • PL/SQL packages • API documentation Phase 3 – Oracle APEX Backend Development (Weeks 3–4) Duration: 10 days Modules in APEX: Admin Module • Student management • Parent management • Teacher management • ...
I want a clean, responsive dashboard built in that pulls live sales data directly from my existing SQL database (MySQL or PostgreSQL—you can choose whichever you prefer for local development). The focus is purely on sales-related metrics: totals, revenue by product and region, daily trends, plus a couple of quick-glance KPIs such as average order value and conversion rate. The database schema is already in place; what I’m missing is a front-end that fetches, aggregates, and presents that information in an intuitive way. Think simple routing with pages or app router, server-side fetching where it makes sense, and lightweight visualisations with or a similar React-friendly library. Styling can be Tailwind, Chakra, or plain CSS modules—whatever lets you keep the b...
Responsive Web application + Mobile App Technology: .NET core, SQL, Angular Feature 1. Vehicle Master Management Add and manage vehicle details including registration, insurance, permits, fitness, PUC, and ownership information. 2. Driver Management Maintain driver profiles, license details, expiry tracking, and vehicle assignment. 3. Trip Tracking Log trip start and end with odometer capture and maintain route/date-wise trip history. 4. Fuel Management Record fuel entries with bill upload, auto-calculate mileage, and monitor fuel efficiency. 5. Maintenance Management Schedule preventive maintenance, record service history, and track maintenance costs. 6. Compliance & Expiry Alerts Automated alerts for insurance, permit, PUC, fitness, and license expiry. 7. Gate Ent...
...figures that must be transferred accurately into working spreadsheets and then reflected in our existing SQL database. The spreadsheets will be the primary source, so precision in every cell—dates, currency formats, formulas, and cross-sheet references—is essential before the data is pushed to the database. You will receive scanned source documents, the current Excel template, and credentials to a staging schema in our SQL environment. Once each spreadsheet is complete and vetted for errors, the corresponding tables in SQL need to be updated so that our reporting dashboards stay in sync. Deliverables • Completed Excel workbook with all financial data correctly entered and formatted • SQL script (or direct upload) that mirrors the s...
...an experienced developer to support and enhance an existing enterprise application built using Visual Basic (VB / VB.NET) with a SQL database backend. The application is currently in active use, and we require a developer who can quickly understand the existing codebase, implement enhancements, optimize database performance, and resolve issues as they arise. This is not a greenfield project — the focus will be on improvement, stabilization, and incremental feature development. Scope of Work Includes: Understanding and working with an existing VB / VB.NET codebase Enhancing modules and implementing new business requirements Writing and optimizing complex SQL queries, stored procedures, views, and functions Debugging and resolving application and database-related...
I need an API layer that lets HikCentral Pro push employee attendance records directly into my SQL database. HikCentral will be the data source; the SQL instance will act as the system of record. At the moment I’m not completely sure of the payload format—HikCentral’s documentation mentions something that looks like “POSTSQL”, so I’ll need guidance on the exact structure (it could end up as JSON once we see the sample webhook). Core requirements • Accept incoming attendance records from HikCentral over HTTPS. • Route those records into a chosen table within my SQL environment (SQL Server is currently installed, but I can adjust if you suggest a better flavour). • Support three actions through separate, se...
I need a compact application that can independently generate both e-Invoices and e-Way Bills without depending on any existing ERP. The focus is on a clean, self-contained workflow: I enter the transaction data, the system validates it against government schema, submits it to the portal, and returns the ...bulk invoices or consignments can be uploaded quickly. • A searchable history page that keeps every IRN, acknowledgement number, and PDF for easy download. • Basic analytics—daily or monthly counts broken down by GSTIN—to spot anomalies at a glance. * Invoice Booking with Multiple Line of Same Code with Batch Selection. Tech is flexible, a secure backend (vb .NET) and a lightweight database SQL server Deliverables 1. Fully working source code wi...
...- Section for additional notes and comments. 2. Reporting Module Updates Reports are currently generated via SQL queries into HTML tables. - Adding new filters (Date, Status, Manager). - Adding new columns to two existing reports. - Performance optimization (fixing slow query execution). 3. Refactoring the Discount Mechanism The current "Discount Rules" module needs a logic overhaul: - Support for multiple discount types (Fixed amount, Percentage, and Combined). - Dynamic conditions (based on Client Type, Total Amount, Date range, and Service Category). - Bug fixing and edge-case handling. Requirements - Extensive experience with procedural PHP and vanilla codebases. - Strong SQL skills (optimization and complex joins). - Ability to maintain and patch legacy c...
...have an existing analytics initiative that now needs a dedicated Redshift-based warehouse. The core objective is to design and implement a robust schema in Amazon Redshift, then ingest data coming from three different sources—our operational SQL databases, a set of RESTful APIs, and periodic flat-file drops in CSV or JSON. Here is what I’m aiming for: • A well-structured Redshift warehouse (star or snowflake schema, whichever is most appropriate) built to scale and documented clearly. • Reliable, automated ingestion pipelines for each source type. For SQL we currently use PostgreSQL and MySQL; for APIs the payloads are mostly JSON; the flat files live in S3. • Transformations that standardise data types, handle slowly changing dimensions, ...
...instantly generate a finished PDF. The workflow is straightforward: • Users authenticate through a standard login screen (ASP.NET Identity is fine). • After login they see a dashboard listing the available templates. Payment Gateway required. • When a template is selected, questionairre is uploaded, the user completes the questionaire, the system pulls the relevant data automatically— from a SQL-based data source and from a simple form the user completes—and merges it into the template. • The completed document is rendered as a PDF, reviewed to the admin team, once approved, then offered for download and optionally emailed to the user. Type of users. Admin, Distributor and End User. Distributor may introduce end users. End User who is associ...
I’m standing up a new analytics environmen...stays locked to the right teams. Policy-driven best-practice is a must. • CI/CD – Set up a clean, automated release flow (Azure DevOps or GitHub Actions—your choice) that moves code, ARM/Bicep templates, and data-factory JSON from dev through to prod with approvals and rollbacks. I’m storing the curated data in Data Lake, but the design should remain flexible enough to surface results into Azure SQL or Dataverse later if we decide to expand into Power Platform. By the end of the project I expect working pipelines, documented RBAC assignments, and a push-button deployment process I can demo to the team. If you’ve delivered similar Azure data lake solutions and can move quickly, let’s talk. Not...
...outputs suitable for reuse downstream Deliver clean, well-structured CSV outputs with no duplication All work happens before CRM, sales, or marketing systems. Required Core Competency (Non-Negotiable) You must be very comfortable with SQL and relational data concepts, including: GROUP BY and aggregation logic Join types and their implications Primary keys vs display fields Entity-level vs transaction-level data Deterministic merges (rules-based, not heuristic) You may execute work in SQL, Excel, or Google Sheets — but you must think in SQL terms. Working Style Expectations You follow SOPs exactly You do not invent logic or “clean things up” subjectively When rules are unclear or data conflicts exist, you stop and flag You prefer ...
...codificación asistida por IA, dentro de un contexto ágil. Nuestro equipo, compuesto por 6 desarrolladores, trabaja con .Net (C#, SQL Server) en entornos Windows y Azure. Buscamos mejorar nuestras competencias en: 1. **Automatización de procesos con IA**: Usar herramientas como n8n para integrar sistemas y optimizar flujos operativos. 2. **Codificación asistida por IA**: Aplicar tecnologías para hacer el desarrollo más ágil, automatizado y eficiente. **Requisitos**: - La capacitación debe ser impartida completamente en español. - Sesiones en vivo (máximo 2 horas diarias), estilo taller, enfocado en teoría + práctica. - Adaptación a nuestro stack actual (.Net, SQL Server, Azure). - ...
...reviewed the code, so plan to step through each user flow, patch breakages, and make sure the app genuinely meets Minimum Viable Product standards. User sign-in must switch to Google Authentication (OAuth 2.0) for a single, consistent login on web and Android. After that, the app needs a persistent data layer. I haven’t selected a database yet, so I’m open to your recommendation—Firestore, Cloud SQL, or another Google-friendly option—provided the app can read and write user data reliably. When those pieces are solid, the web build should be connected to my domain, served over HTTPS, and deployed live on Google Cloud. If a simple CI/CD pipeline (Cloud Build or GitHub Actions) speeds future updates, feel free to include it. Finally, convert or wrap the pr...
...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...
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...
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.