Postgresql jobs
...(Spring Boot/Node.js/Socket.io) Configure server dependencies (Java, PostgreSQL/Redis, Maven) • Infrastructure: Are you planning to deploy on a our server • Version: need the latest official Signal Server (Java-based) • Customization : rebrand the app or simply run a private instance Configuration & Customization: Set up config .yml for production Optional branding or private instance configuration ________________________________________ Core System Requirements The official Signal Server is Java application requiring several dependencies: • Java Runtime: Spring Boot (The latest versions typically require Java 24) or Erlang/Elixir (Temurin distribution), though older guides (v1.88) used Java 11. • Databases: PostgreSQL & Founda...
...production-grade Google Cloud environment. Everything will be green-field, so you can design the layout cleanly without wrestling with legacy resources. Only the production tier is required. WHAT I NEED YOU TO BUILD • A GitHub-triggered Cloud Build pipeline that containerises the app, pushes to Artifact Registry, and rolls out to Cloud Run with zero-downtime updates. • Private Cloud SQL for PostgreSQL (Private IP via Private Service Access) reachable from Cloud Run through a Serverless VPC Access connector. • Secrets (DB creds, JWT keys, etc.) stored in Secret Manager and injected at runtime. • External HTTPS Load Balancer fronting Cloud Run, with Cloud DNS records for and a managed SSL certificate. I already own the domain; you’ll handle certi...
...authentication, auditing, and system scalability. You’ll work closely with Product, Security, and Operations teams to deliver secure-by-default services with great developer ergonomics. Tech stack (current & relevant) • Python (Django / Django REST Framework) • Go (services, high-performance workloads) • C++ / C# (agents, performance-critical components, integrations) • REST APIs, OpenAPI/Swagger • PostgreSQL / Redis (typical), message queues/eventing (nice-to-have) • Docker, Kubernetes (nice-to-have) What we’re looking for • Strong backend experience in Python and/or Go (bonus for C++ or C#) • Strong experience building REST APIs (preferably with Django REST Framework) • Solid understanding of backend archi...
Build Full Stack API with FastAPI, PostgreSQL & Streamlit UI You said: Uploaded image Give me matter for this ChatGPT said: Good. This is important. If you write a weak description, you’ll attract low-quality freelancers. If you write clearly, you get serious professionals. I’ll give you a strong, clear project description you can directly paste. Option 1: FastAPI + PostgreSQL + Streamlit Project Project Title Idea: Build Full Stack API with FastAPI, PostgreSQL & Streamlit UI I need a developer to build a full-stack application using FastAPI, PostgreSQL, and Streamlit. Project Requirements: • Build REST APIs using FastAPI • Connect to PostgreSQL database • Implement full CRUD operations (Create, Read, Updat...
Please Sign Up or Login to see details.
The goal is to design a future-proof relational backbone for a multi-channel retail platform, built natively on PostgreSQL. I already run an operational system, and its live transactional records will have to be migrated into the new structure without downtime. Everything else—users, inventory, orders—will start fresh. Core design expectations The operational schema should be fully normalised to 3NF and optimised from day one for high concurrency. Think table partitioning (range and list), well-chosen GIN and B-Tree indexes, plus JSONB columns where semi-structured flexibility makes sense. Triggers, constraints and stored procedures must enforce business logic consistently, so the application tier can stay lightweight. Analytics layer Alongside the OLTP schema I ne...
...between users. Users will be able to register, see their balance, send/receive funds, and request withdrawals. There will be an admin side to review users, approve/reject transactions, and manage settings. Current status Basic bot is already started using Node.js, Telegraf and PostgreSQL. Some database tables and commands are implemented, but the project is not production-ready yet. Code needs review, cleanup, and completion of missing features. Main tasks Review the existing Node.js / Telegraf code and PostgreSQL schema. Fix bugs, optimize structure and make the code easy to maintain. Complete core flows: user registration and referral (if needed), deposit / balance update logic, send / receive / internal transfer flow, withdrawal request and admin approval,...
...product. The core idea is simple: users open the app and immediately see fresh, well-structured content that I publish through an admin dashboard. Clean navigation, quick load times, and an intuitive layout are critical. Here is what I have in mind: • Cross-platform build using Flutter or React Native so we keep a single codebase. • A lightweight backend (Firebase, Supabase, or a Node + PostgreSQL stack) that lets me log in, create articles, tag them, and push updates instantly. • Push notifications the moment new content goes live. • Basic user analytics so I can track reads, session length, and popular topics. • Solid offline caching so articles remain viewable without a signal. • Store-ready assets: app icons, splash screens, and scre...
...view for owners to monitor multiple branches. ● Exporting: One-click exports for accounting (CSV, Excel, PDF). 3. Technical Requirements ● ● ● ● Architecture: Offline-first using a local database (e.g., SQLite, Realm, or PouchDB). Front-End: Modern, responsive framework (e.g., React/Electron, Flutter, or .NET MAUI). Back-End (Cloud): Secure API (Node.js, Python, or Go) with a robust database (PostgreSQL/MongoDB). Hardware Compatibility: Standard Windows/Android drivers for retail peripherals. 4. Deliverables ● ● ● ● Fully Functional Application: Compiled installer for the target OS (Windows/ Android/macOS). Admin Web Portal: For remote management and analytics. Source Code: Well-documented code hosted on a private repository (GitHub/ GitLab). User Manual: Brief documentation for ...
SCOPE AND ARCHITECTURE ADHERENCE The published technical requirements and stack (Python, PostgreSQL as source of truth, Redis for locking, Binance integration, Docker deployment) are the priority baseline for this project. If you propose architectural changes (e.g., different database, alternative execution model, third-party services, or different infrastructure), you must provide clear technical justification explaining: • Why the change improves robustness or reliability • How it preserves deterministic state and idempotency • What trade-offs are introduced • Why it is superior to the baseline stack "Unjustified stack substitutions or generic alternatives will not be considered" OPTION A – Hybrid (Binance + 3Commas) Senior Python Enginee...
...reconcile it continuously. • Track every offer, update the user’s balance in real time and flag failed or stale trades for manual review in an admin panel. Admin / Back-office A lightweight dashboard is needed for live game monitoring, user bans, bot status and manual item adjustments. Tech & Delivery I’m comfortable with common stacks such as Node.js, TypeScript, React, MongoDB or PostgreSQL, but I’m open to alternatives if they keep latency low and the interface snappy. Please outline your chosen stack, timeline and any hosting requirements when you reply. Acceptance criteria 1. Site replicates Bloxybet’s UX/UI closely (no original copywriting required). 2. Unlimited simultaneous coin-flip rooms run without lag. 3. Jackpot a...
...growth I’m restructuring the entire infrastructure and codebase for true horizontal scale, bullet-proof uptime, and lightning performance. Here is the current landscape you’ll step into: • Native iOS & Android codebases that need profiling, refactoring where necessary, and tighter CI/CD. • A Laravel monolith that must be modularised, cached with Redis, and tuned for very high concurrency. • PostgreSQL instances approaching their limits; we’re ready for partitioning, read replicas, and autoscaling. • Alibaba Cloud services (ECS, RDS, OSS, SLB) underpin everything, though I’m open to architectural suggestions, even hybrid or multi-cloud, if they offer measurable benefit. • Real-time websockets for live video, chat, not...
...already in place, but the UI needs a visual and usability upgrade before we move forward. Beginning tomorrow, I’d like you to step in, take ownership of the codebase, and carry the project all the way to production. On the backend I’m leaning toward Node.js, yet I’m flexible on the stack if you can justify clear benefits. Our database is still open for discussion—feel free to propose SQL (MySQL, PostgreSQL) or NoSQL (MongoDB, etc.) solutions that best fit a live-service game. Whichever route we pick, clean schema design, migration strategy, and security best practices are essential. Core scope • Fix and polish the existing frontend, focusing specifically on user-interface design so it looks and feels like a modern game portal. • Architect and...
...optimized for macOS (vfs_fruit, extended attributes) • macOS Time Machine backup share • Avahi/Bonjour — server appears in Finder automatically • NFS for Linux clients • SFTP with key auth • SMART monitoring, ZFS scrub schedule, nightly backups • Organized shares: /data/documents, /data/media, /data/backups, /data/projects, /data/ai-models 3. NEXTCLOUD (Dockerized) • Docker Compose with MariaDB/PostgreSQL + Redis • SSL via Let's Encrypt, file versioning, sharing links • Sync client tested on my MacBook • API access enabled for future AI integration 4. DOCKER INFRASTRUCTURE • Docker Engine + Compose + Portainer • Clean project structure, isolated networks per service • Watchtower, health checks, log rota...
1. Project Overview We are seeking a developer to enhance an existing production web application built with the following technology stack: • Frontend: Vue.js • Backend: Laravel (API) • Database: PostgreSQL • Storage: AWS S3 • Deployment: GitHub Actions + AWS EC2 The system is already live and operational. This engagement focuses on foundational improvements and feature extensions — not a full redesign. 2. Scope of Work (Initial Phase) This phase focuses on improving the document upload workflow and implementing basic cloud import functionality. 2.1 Document Upload Improvements Requirements • Implement drag-and-drop upload support. • Support the following file types: • PDF • DOC / DOCX • CSV • XLSX ...
1. Project Overview We are seeking a developer to enhance an existing production web application built with the following technology stack: • Frontend: Vue.js • Backend: Laravel (API) • Database: PostgreSQL • Storage: AWS S3 • Deployment: GitHub Actions + AWS EC2 The system is already live and operational. This engagement focuses on foundational improvements and feature extensions — not a full redesign. 2. Scope of Work (Initial Phase) This phase focuses on improving the document upload workflow and implementing basic cloud import functionality. 2.1 Document Upload Improvements Requirements • Implement drag-and-drop upload support. • Support the following file types: • PDF • DOC / DOCX • CSV • XLSX ...
...school-specific data Answer contextual questions Automate admin tasks Generate reports Provide predictive analytics Work role-wise (Admin / Teacher / Parent / Student) 4. Scope of Work for AI Developer Phase 1 – AI Architecture Design Developer must: Design AI system architecture Create data ingestion pipeline Build RAG (Retrieval Augmented Generation) system Connect to school database (Supabase / PostgreSQL) Ensure multi-school isolation (SaaS model) Implement role-based AI responses Phase 2 – Core AI Features 1️⃣ Admin AI “Show attendance report of Class 10A this month” “Which teachers have pending syllabus?” “Generate monthly performance report” Predict drop in performance Identify fee defaulters 2️⃣ Teacher AI Auto lesson plan g...
...access Location (GPS) + maps integration Clean UI/UX 4) Deliverables Android app (APK + source code) Admin + Lab Panel (web) OR Lab partner app Backend + DB + APIs Deployment support (server setup) Basic documentation + handover 1–2 months bug support (mention in proposal) 5) Preferred Stack (Developer suggest) Flutter / React Native (mobile) Node.js / Django / Laravel (backend) MySQL/PostgreSQL Firebase/FCM push notifications AWS/S3/Cloud storage for reports 6) Please include in your proposal Similar apps experience (Health / booking apps) Timeline + cost breakup (Phase wise) Team size & communication plan Post-launch maintenance cost (optional) Budget: (Developer propose) Start: Immediately Country: India...
Job Title: Senior Cloud Database Engineer – PostgreSQL Migration Architect Location: Remote Work Timing: UK Business Hours (GMT/BST) Engagement Type: Freelance (Long-Term Possible) Platform: Freelancer.com Project Overview We are seeking a highly skilled and experienced Senior Cloud Database Engineer with deep specialization in PostgreSQL migrations and distributed database infrastructure. This role is for a demanding enterprise client, so we require a proven track record of successful large-scale cloud database migrations with verifiable experience. You must be comfortable working during UK business hours and collaborating with cross-functional cloud and infrastructure teams. Role Summary Senior Cloud Database Engineer – PostgreSQL Migration Architec...
...you suggest—surfaced within one tap from the dashboard. Speed and reliability matter more than bells and whistles: every interaction should load in under a second, and every piece of patient data must be encrypted at rest and in transit. Tech-stack choices are open, though I’m leaning toward a React front-end, Node/Express or Django back-end, JWT-based auth, and a cloud database (MongoDB, PostgreSQL, or similar). If you prefer another combination that still gives me a clean, responsive UI, I’m flexible. Deliverables • Fully responsive UI with appointment scheduling as the focal point • Direct-contact hospital directory integrated into the same workflow • Secure user management (registration, login, role-based access) • REST or G...
...(Express) • Python (Flask) • PostgreSQL (Cloud SQL) • BigQuery • GCP (Cloud Run, Pub/Sub, GCS, Cloud Build, Cloud KMS) • Terraform • Event-driven architecture • HIPAA-compliant infrastructure • AI-assisted development (Claude Code) Responsibilities • Own and extend our ingestion backend (Node.js) • Maintain and evolve our mapping/transformation service (Python) • Design and implement secure healthcare data pipelines • Ensure PHI separation and HIPAA compliance • Debug production pipeline failures (Pub/Sub, DLQs, idempotency) • Improve observability (structured logging, monitoring, alerts) • Collaborate in an AI-first development workflow Required Experience • 5+ years professional backend developm...
...workflow, and our current e-commerce flow. The assignment covers more than a straight port: once the core experience is re-implemented, I also want richer analytics and reporting, stronger security hardening, and seamless hooks into selected third-party services so the new platform launches with clear business insight, tighter protection, and future-ready integrations. You will work against a PostgreSQL back end; no other database is required. All existing WordPress data—users, posts, media, products, orders, and settings—must transfer intact, with zero visible downtime to customers. I will supply an export of the current site along with a prioritised feature map to guide development. Deliverables • Complete Visual Studio / .NET solution with clean, commented s...
...filing deadlines. Reminder System: Email/SMS notifications for upcoming deadlines (e.g., 30-day stamping deadlines for Letters of Offer). Conflict Check: A search tool to ensure no conflict of interest before opening new files. Technical Preferences Frontend: React, Vue.js, or Angular for a responsive, modern UI. Backend: Node.js (Express), Python (Django/FastAPI), or PHP (Laravel). Database: PostgreSQL or MongoDB (must be secure and scalable). Document Processing: Integration with libraries like Docxtemplater, , or specialized APIs for document manipulation. Security: High-level encryption (AES-256), SOC 2 compliance standards, and multi-factor authentication (MFA). Freelancer Requirements Proven portfolio in SaaS or Enterprise Resource Planning (ERP) software. Experien...
...done. • Provide a working client package—or clear instructions for obtaining and patching one—that logs straight into the server. • Leave me with a brief text file covering commands to start/stop the server, locations of configs, and any future update steps. I intend on implementing my own custom map, npcs etc once I have the server set up. If you have experience with Canary, TFS, MySQL/PostgreSQL setups, and client linking quirks, this should be straightforward. I would prefer to work alongside you using screenshare. Looking forward to finally seeing the server online and playable! If you are not used to this work - You are welcome to purchase a ubuntu 22.04 vps to attempt to get this set up for yourself, before teaching me how to do so. I will happ...
... 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 skills Ability to confidently ...
...& Caching Work with PostgreSQL for schema design and queries Use Drizzle ORM (or similar ORM) for database operations Implement caching strategies using Redis Optimize queries and data access patterns Collaboration & Delivery Work closely with distributed Agile teams Participate in sprint planning / review sessions (as needed) Deliver features within agreed timelines Provide clean, maintainable, well-documented code Support bug fixes and performance improvements Required Skills & Experience Proven experience as a Full Stack Developer (Freelance / Contract / Full-time) Strong proficiency in Angular (v18+), TypeScript, HTML, CSS Solid experience with Node.js Experience with / Strong understanding of REST APIs & Microservices Experience with PostgreSQL Fam...
...Management - Vendor Registration - Performance Tracking - Payment Management 8. Admin Panel - User Management - Role & Permission Management - Master Data Management 9. Reports & Analytics - Production Reports - Inventory Reports - Quality Reports - Sales Reports Technical Requirements: - Modern scalable stack (React, Flutter, Node.js, Laravel, .NET) - PostgreSQL/MySQL database - Cloud deployment (AWS/Azure) - Secure API-based architecture - Role-Based Access Control - Workflow Automation - Approval Systems - Document Management - Dashboard & Reports - WhatsApp/Email/text message Integration - Future SAP Integration Ready Features: - Web Admin Panel - Android & iOS Mobile App - Real-time Notifications - Automated Workf...
...experience, education, skills and anything else you can legally obtain). I will confirm the final field list before you begin. Key objectives • Build or configure a scraper / API wrapper that logs in, navigates to each target profile and captures the agreed-upon fields • Write clean code with clear comments so I 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 exa...
...ratings, booking calendars, and other extras can wait, so please build the architecture with clean separation of concerns to make those future add-ons painless. You are free to choose a modern stack—React, Vue, or vanilla JS for the front; Node, Django, Laravel, or a similar framework for the back—so long as the code is well-documented, componentised, and backed by a reliable database such as PostgreSQL or MySQL. The finished site must run smoothly on desktop and mobile, load fast on a 4 G connection, and deploy to my VPS or a cloud host that we agree on. Deliverables for this milestone • Responsive UI with intuitive navigation and modern aesthetic • Secure sign-up, login, and profile management • Tool listing creation/edit screens with image up...
The developer should build a cross-platform AI-powered IT Help Desk agent and management system that supports Windows, Linux, and macOS. The system must include a backend API (preferably in Python FastAPI or Node.js) to handle ticket management, device registration, and command distribution, along with a secure database (PostgreSQL) and an optional vector database for AI knowledge retrieval. The agent itself should be written in a compiled language like Go for cross-platform deployment, capable of registering devices, reporting system info and heartbeat, detecting missing patches, restarting services, and executing safe commands remotely. The AI component should analyze incoming IT tickets, automatically suggest fixes, and optionally execute auto-remediation commands when safe. All ...
...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-assisted development workflows Hi...
...translate that depth into clear, structured technical training sessions. Your core mission is to design and deliver training that sharpens our developers’ practical skills. Expect to break down real project scenarios, walk through architectural decisions, explain code quality best practices, and answer ad-hoc questions as they come up. We work mostly with JavaScript/TypeScript, React, Node.js, and PostgreSQL, so fluency in these (or closely related stacks) will help you connect quickly with the team. Deliverables • A short training plan outlining topics, session length, and learning objectives • Live or recorded sessions (remote is fine) with interactive Q&A • Lightweight reference material or code snippets that reinforce the lessons Success mean...
We would like to create a platform where our technicians can query an AI chat about status of different areas of our network. We have several different data repositories, (PostgreSQL, clear-text log files, InfluxDB, etc..) We had used chatgpt to help build this initial system, and it was rather easy and worked quite well. Everything fell apart though as we attempted to expand the system for full production use).
I’m setting up a central repository where each of my subscribed clients—schools, companies, public bodies and si...files. • Upload/Download handling large PDFs and images without corrupting filenames or timestamps. • An admin panel for me to create new client accounts, assign storage quotas and pull usage logs. I will provide working examples of similar portals and a detailed field list once we begin; you’re free to suggest the tech stack, but PHP/Laravel, Node/Express or Python/Django with a MySQL or PostgreSQL backend are all acceptable. Security, straightforward navigation and a responsive design outweigh flashy graphics. Deliverable is a fully functioning portal installed on my server, source code included, plus brief hand-over documentation so ...
...Manage users Basic analytics dashboard Monetization Paid listing option Seller subscription plans Featured listings option TECHNOLOGY REQUIREMENTS (PREFERRED STACK) The platform should be built using a scalable architecture similar to modern marketplace platforms. Preferred stack: Frontend Nuxt 3 (Vue) with SSR for SEO Backend Laravel API (PHP) Database PostgreSQL or MySQL Search Engine Elasticsearch or OpenSearch for filtering and search Caching / Sessions Redis Background Processing Queue system for imports, image processing, and notifications Storage S3-compatible object storage for images Infrastructure CDN integration (Cloudflare or similar) Docker-based deployment preferred Admin / CMS Custom a...
...Workers: Build the fault-tolerant "Watcher" (indexing) and "Sweeper" (fund movement) services. Database: Design and migrate the PostgreSQL schema for high-integrity financial records (idempotency, audit logs). 3. Frontend Development (React/) Admin Console: Build a secure, internal dashboard to view payment flows, manual sweep overrides, and system health (e.g., "Low Gas" alerts). 4. QA & Handoff Testing: Write an E2E test suite using Hardhat/Anvil (forking Mainnet) to simulate reorgs and edge cases. Documentation: Deliver API docs (Swagger/OpenAPI) and a "Runbook" for operations. Tech Stack Requirements Backend: TypeScript, Node.js (NestJS preferred), PostgreSQL, Redis. Web3: v6 / Viem, Hardhat (for testing). Frontend...
...(frontend tile + backend workflow + HeyGen integration). Provide ongoing platform maintenance (bugfixing, hardening, small improvements). Pricing model: Fixed package for multi-tenancy/entitlements. Flat rate per new use case (continuous stream, varies by customer). Hourly rate for anything beyond these two fixed scopes. Tech stack: TypeScript, (API/backend), React 18 + Vite (frontend), PostgreSQL + Prisma, Docker Compose, Nginx, MinIO (S3), GitLab CI/CD, hosted on Hetzner (EU/Germany). Key responsibilities: backend auth/authorization patterns (RBAC/ABAC), tenant isolation in DB queries/services, schema + API extensions, frontend entitlement enforcement, HeyGen workflow integration, deployment/CI improvements. Ideal freelancer: proven multi-tenant SaaS experience, strong TS...
...tax computation, and persistence. 2.2 User Classes and Characteristics • User: Individual taxpayers filing their own returns • Admin: System administrators responsible for monitoring and support • Super Admin: Users with elevated privileges for configuration and system management 2.3 Operating Environment • Modern web browsers on desktop and mobile devices • Serverless backend services with a PostgreSQL database 2.4 Design and Implementation Constraints • Compliance with Indian tax laws and filing procedures • Compliance with the Digital Personal Data Protection Act (DPDP), 2023 • Use of Supabase for authentication and backend services 3. Functional Requirements 3.1 User Management • The system shall allow users to register using an em...
...staging servers in Quebec Harden Ubuntu (firewall, Fail2ban, SSH, auto security updates) Deploy Odoo 18 Enterprise with Nginx, SSL/TLS, secure headers Configure PostgreSQL (encryption, tuning) Migrate database, filestore, and ~13 modules from Ensure full functionality across Accounting, CRM, HR, Sales, Inventory, Website, Manufacturing, etc. Implement encrypted daily backups (30-day retention) Provide DR and technical documentation Support testing and final production cutover Experience working in environments aligned with: Law 25 PIPEDA PCI DSS Skills Required Strong Odoo Enterprise deployment experience Python + PostgreSQL Linux / DevOps Nginx & SSL Proven migration experience Please share your previous portfolio of similar work....
...IO, Go with gRPC, or an equivalent solution that plays nicely with iOS and Android clients. End-to-end encryption, push-notification hooks (FCM / APNs), and a RESTful or GraphQL API for ancillary data are highly desirable. Deliverables • Production-ready server code with clear setup instructions • Secure user authentication and encrypted message transport • Message persistence (MongoDB, PostgreSQL, or similar) with indexing for quick retrieval • Simple admin endpoint or dashboard for basic monitoring • Post-deployment support to ensure smooth integration into the mobile app I’ll provide app side endpoints and UI; your focus stays on the backend and real-time layer. If this sounds up your alley, tell me briefly how you’d architect it ...
...Reliable data storage and retrieval using a relational engine—MySQL or PostgreSQL, whichever you are most comfortable optimising. RESTful APIs should be documented with Swagger/OpenAPI, secured with JWT or a similarly strong token strategy, and thoroughly unit- and 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 s...
...defect extraction Structured data normalization Repair cost estimation logic Long-running job orchestration Background workers / queues Multi-user concurrency Production deployment architecture NOTE: Required Technical Stack (Non-Negotiable) You must have experience with: Node.js or Python backend (FastAPI / Express / NestJS) Background job queues (BullMQ / Celery / Redis / RabbitMQ) PostgreSQL Object storage (S3 or equivalent) Production deployment (AWS / DigitalOcean / similar) API architecture design Handling long-running async workflows Bonus: Experience with AI APIs (OpenAI / Anthropic) Experience with document parsing Cost optimisation for AI workloads NOTE: The Core Challenge We process building inspection PDFs (50–70+ defects per document). E...
We are looking for an experienced full-stack developer or development team to build a complete Society / Apartment Management Software for residential housing societies. The solution should include a Web Admin Panel and Mobile Applications...Complaint summary - Admin dashboard with analytics Technical Requirements: - Web-based Admin Panel - Android & iOS App - Role-based access (Admin, Committee, Resident, Security, Accountant) - Cloud hosting - Secure login with OTP - Data encryption - Backup system Preferred Tech Stack (Open to Suggestions): - Frontend: React / Flutter - Backend: Node.js / Laravel / Django - Database: MySQL / PostgreSQL - Cloud: AWS / GCP Deliverables: - Complete source code - Deployment support - API documentation - 3 months post-launch support - Basic tr...
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...
I'm seeking an experienced backend developer to build the backend for a cab booking application using Node.js. Essential Features: - User authentication - Payment processing - Driver tracking Ideal Skills & Experience: - Proficiency in Node.js - Experience with user authentication and payment processing - Knowledge in tracking algorithms and databases (MongoDB, MySQL, or PostgreSQL) Please provide relevant work experience.
...100 users. Ideally we will be able to update code in github and the apps will update on the devices, but i understand if this is not possible. App will need permissions for GPS, using the camera, saving photos to the local library and push notifications. Frontend: React 18 + TypeScript, built with Vite, styled with Tailwind CSS and shadcn/ui (Radix UI components) Backend: Supabase (hosted PostgreSQL database, authentication, file storage, and Edge Functions written in Deno/TypeScript) Routing: React Router v6 (single-page app) State Management: React Query (TanStack Query) for server state, React Context for auth and GPS tracking What's Already Done for Native Deployment Capacitor is pre-configured (): App ID: App Name: drive-smart-log
We are looking for a skilled retainer developer to monitor, maintain, and fix bugs on our website built with React, Supabase, TypeScript, WebSockets, and PostgreSQL. In addition to maintenance, we need the developer to help create and enhance trading features on our loot box style platform which is based around football. Key Responsibilities: - Monitor and maintain the website - Quickly identify and fix bugs - Improve stability and speed of the site - Develop and enhance trading features - Implement new features based on user feedback Required Skills: - React - Supabase - TypeScript - WebSockets - PostgreSQL - Node.js - JavaScript This is an ongoing retainer role (1-3 months initially) with potential for long-term engagement. We need someone with very good availability, e...
...pricing rules, view analytics and handle user permissions. For the customer side in particular, these functions are non-negotiable at launch: • Product search & intelligent filters • Real-time order tracking • Secure prescription upload (PDF/JPEG), with pharmacist dashboard for review Architecture and stack are up to you, but I expect modern, well-documented code (Laravel/Node, React/Vue, PostgreSQL/MySQL, AWS/GCP—whatever you’re strongest in) and an API-first approach so the future mobile apps can plug straight in. Multi-tenant support, role-based access control, payment gateway integration, and HIPAA-compliant handling of medical data are essential. Send me a brief outline of your proposed tech stack, timeline to MVP, and a link to a comp...
...feels at home in FastAPI. The day-to-day work centres on designing clean, scalable REST endpoints, wiring them to a PostgreSQL database, and keeping the Dockerised environment tidy for smooth deployments. Most of the upcoming tasks involve integrating external providers: think payment gateways for transaction flow and AI/ML services that power in-app intelligence. Beyond those, you’ll help craft automation scripts, refine existing business logic, and keep an eye on performance as traffic grows. Here is what a typical assignment looks like: • create or extend a FastAPI micro-service • expose secure endpoints, including user auth where required • connect to PostgreSQL and structure migrations • plug in a third-party SDK (often payments o...
...payout statements 8. PAYMENT COLLECTION • Company UPI QR Code • Partner uploads payment proof • Admin verification workflow • Status tracking 9. SECURITY & COMPLIANCE • Secure login (OTP + Password) • Role-based access control • Encrypted data storage • Audit logs • Secure document uploads 10. TECH STACK Frontend: React / WordPress Custom Dashboards Backend: Laravel / Node.js Database: MySQL / PostgreSQL Storage: Cloud Storage PDF & QR: Automated generation 11. DEVELOPMENT PHASES Phase 1: Core system, dashboards, partners, taxation Phase 2: HR, payouts, government loans Phase 3: Analytics, automation, mobile app 12. SCALABILITY RULES • Unlimited partners, staff, admins • Single Super Admin only • Modular system f...
Top postgresql Community Articles
Using PHP PDO to manage data in MySQL
Details about how to use the PHP PDO library for data manipulation