Postgresql Projects

opportunity

Backend & admin panel for existing AI chatbot

I have a fully working AI guest assistant chatbot (single HTML/JS file, built and tested). I need a full stack developer to build the backend around it. THE FRONTEND IS DONE — this is purely a backend job. What I need: Secure API proxy — move the Anthropic Claude API call server-side, API key stored in environment variables Database (PostgreSQL or Firebase) — store property records with name, guide text, video links Admin panel (password protected) — add/edit/delete properties, auto-generate unique guest URL per property Dynamic guest page — chatbot loads correct property guide based on URL e.g. mysite.co.uk/guest/naia Hosting & deployment — subdomain on my existing hosting, must handle 20-50 properties I will provide: the working HTML file, Anthropic API key, hosting access. Please only apply if you have built secure backend systems before and can share a relevant example.

Backup website and migrate to Joomla 5

We need someone who will migrate our website from Joomla 4.4.x to 5.x: https://unternehmerzentrum.li/ We're looking for someone who has previous experience with Joomla and feels confident doing this task. Joomla instructions: https://docs.joomla.org/Joomla_4.4.x_to_5.x_Planning_and_Upgrade_Step_by_Step Hosting information needed for upgrade: - PHP 8.1 - MySQL 8.0.13 - MariaDB 10.4.x (testing has shown that J3, J4, and J5, are compatible with MariaDB 10.4.x) - PostgreSQL 12.0 (if you are using PostgreSQL 16 you will need to make a manual change before proceeding.) Acceptance criteria: - Back up of the current website (Joomla 4) has been created and is available to revert to if needed - Hosting environment is prepared correctly - The current website has been migrated to Joomla 5 and runs smoothly with no broken components Let me know if you need any more details.

Full Stack Developer Needed to Fix Admin Panel Bug

We have an existing back office admin panel built on React and Node.js and need a full stack developer to fix a specific issue. Our data table is not filtering correctly on the backend - the REST API returns unfiltered results when query params are passed from the React front end. We need this fixed and tested We are looking for a react developer and full stack developer who can jump into an existing codebase quickly. The front end developer side is React with TypeScript and Tailwind CSS. The backend is Node.js with a PostgreSQL database. The full stack developer we hire should be comfortable reading existing code, identifying the bug, and delivering a clean fix - no full rebuild required This is a small scoped task for an experienced web developer or full stack developer who has worked on SaaS admin tools, back office systems, or internal dashboards before. A react developer who understands how REST API query params flow from a front end developer interface to a Node.js backend will get this done quickly. We are not looking for a wordpress developer or a mobile app developer - we need a pure full stack developer with React and Node.js experience If you are a reliable full stack developer and react developer who can review existing code, fix the bug, and explain what was wrong, we would like to talk. There is more back office development work coming - this is a good entry point for a long-term engagement. Please share your experience as a full stack developer or web developer with React and Node.js admin panel projects

opportunity

Host deploy and test and existing app

This project aims to deploy, on a dedicated VPS server, the complete environment required to run the WHIMO solution developed by the European Forest Institute. WHIMO is an Android application designed to collect, store, and transfer geolocation data to support compliance with the EU’s EUDR regulation. To operate properly, the mobile application relies on a stable, secure, and publicly accessible backend environment. The mission is to deploy, configure, and secure all backend services of WHIMO using the official GitHub repositories, and to ensure that the API is fully operational so the Android application can connect to it. This includes preparing the VPS, installing all dependencies (Docker, PostgreSQL, Redis, Gunicorn, HTTPS reverse proxy), setting up Firebase credentials, configuring the network and security layers, and delivering complete technical documentation. The final objective is to deliver a stable, secure, and operationnal hosted application on the new server environment, ready for use , while respecting best practices in development, security, and operations. Repositories Android Application: https://github.com/EuropeanForestInstitute/whimo-android Backend (Django + REST API): https://github.com/EuropeanForestInstitute/whimo-backend Infrastructure (Optional – IaC): https://github.com/EuropeanForestInstitute/whimo-infra To be provide : VPS credential

Looking for a full stack developer

We’re looking for an experienced Full-Stack Developer who is based in Vietnam to help build and maintain our projects. Tech Stack: - Language: JavaScript / TypeScript / Python - Frontend: React / Next.js / Vue / Angular / Ruby - Backend: Node.js / Express.js / NestJS / Laravel / FastAPI / Django - Database: PostgreSQL / MySQL / MongoDB - Cloud: AWS / Azure (optional) Responsibilities: - Build scalable frontend features - Develop APIs and backend logic - Work with designers/product team - Ensure performance and security Requirements: - 3+ years full-stack experience - Strong Git workflow - Clean, documented code - Good communication Nice to have: - E-commerce / SaaS experience - AI or API integrations

Restaurant & Lounge Platform (Booking System, Admin Dashboard)

Project Description I’m looking for a strong UI/UX designer (and ideally someone who can also build, or work closely with a developer) to help create a modern website and internal system for a restaurant/lounge business. This isn’t just a basic website — the goal is to build something that actually supports the day-to-day running of the business while also giving customers a great experience. On the front end, the site should feel premium and mobile-first. Customers should be able to book tables easily, see what’s going on (for example live sports, events or themed nights), and contact us quickly via WhatsApp or similar. We want it to feel more like a destination (sports lounge / social space), not just a standard restaurant website. Bookings are a key part of this. I’d like the ability to take deposits for certain bookings (e.g. larger groups or busy nights), but also have the flexibility to override this when needed. On the backend, I want a simple but powerful admin system where we can manage bookings, events and customers. Staff should also be able to log in — for example to clock in/out or record expenses during a shift, which can then be reviewed later. Another important part is capturing customer data properly — for example through bookings or WiFi login — so we can use it later for marketing (email, SMS, offers, etc.). We’ll also need to connect in some way with delivery platforms like Uber Eats, Deliveroo and Just Eat — even if it starts simple (links or basic integration). Overall, I’m looking for someone who understands how to design and build systems — not just websites. Key Features (Must Have) Customer-facing website (premium, mobile-first design) Table booking system (with optional deposits) Ability to override booking rules (admin side) Events & live sports display (e.g. football, boxing nights) WhatsApp contact / QR integration Customer data capture (for marketing use later) Admin / Back Office: Admin dashboard Booking management Event management Customer management Staff login (with basic tracking like clock-in/out) Expense logging system (simple but usable) Tech / Stack (Preferred – Open to Suggestions) I’m open to recommendations, but I’d prefer this to be built as a modern custom platform rather than a basic WordPress site. Preferred setup would be: Frontend: Next.js / React, ideally deployed on Vercel Backend: Node.js (Express, NestJS or similar), ideally hosted on Railway Database: PostgreSQL (via Railway or Supabase) The main priority is that it’s scalable, maintainable, and set up properly from the start. If you think there’s a better approach, I’m happy to hear it. What I’m Looking For Clean, premium UI (not template-based) Strong UX thinking (customer + admin + staff journeys) Someone who understands building platforms/systems Ideally experience with dashboards, bookings or hospitality systems Budget / Approach This is a startup project, so I’m mindful of costs and looking for someone reasonable and practical to work with. That said, I’m not looking for the cheapest option — I’d rather work with the right person and build this properly, with potential for ongoing work as the platform grows. Deliverables UI/UX designs (Figma preferred) User flows / wireframes Optional: Frontend or full build Please Include Examples of similar work (especially dashboards or booking systems) How you would approach a project like this Your availability and estimated timeline Final Note I’m not looking for a basic WordPress/Elementor-style site. I’d prefer a modern, scalable solution that can grow into a proper platform over time.

opportunity

Custom Contractor Management System (Replace Tradify)

Project Name: Custom Contractor Management System (Replace Tradify) Project Type: Full custom web + mobile application Overview: We are building a full contractor management system to manage engineers, subcontractors, jobs, timesheets, invoicing, GPS tracking, and reporting. The system must be scalable (currently 9 engineers, future 500+), secure, GDPR-compliant, and integrate with Sage first and Xero later. We need a freelancer (or small team) to develop both backend + frontend, mobile apps, and database according to detailed specifications. ⸻ 1️⃣ Key Features / Requirements A) Web Dashboard (Managers/Admins/Accountants) • Job management (create, assign, track status, attach files/photos) • Subcontractor management (assign jobs, track jobs, generate POs, track invoices) • Client invoice management (create, track, integrate with Sage) • Reports: Timesheets, material usage, profit analysis • Engineer live map / GPS tracking overview • Alerts: overdue invoices, missing photos, incomplete jobs • Role-based access: Admins, Managers, Accountants, Field Supervisors B) Mobile App (Engineers) • Job list (assigned / in progress) • GPS tracking (real-time + periodic, check-in/out) • Job report form: • Time on site (auto/manual) • Travel time • Materials used • Parking / fees • Findings & recommendations • Tick-box checklists • Photos (before/during/after) • Submit reports to web dashboard • Timesheet tracking + weekly summary C) Subcontractor Module • Assign jobs to subcontractors • Track job status • Generate Purchase Orders (POs) • Track subcontractor invoices (manual + CSV/XLSX upload) • Automatic reminders for due / overdue invoices • Exportable / Sage integration D) Invoicing Module • Quote → Job → Invoice workflow • Retainers / deposits • Recurring invoices • PDF export • Sage integration first → Xero later E) File Upload / Import • CSV/XLSX upload for subcontractor invoices • Validate fields, duplicates, missing info • Track manual vs file-uploaded invoices F) Reporting • Job summary, material usage, profit analysis • Timesheets & payroll export • Engineer GPS history / route playback ⸻ 2️⃣ Technical Requirements • Backend: Node.js + NestJS • Web Frontend: React + TypeScript • Mobile App: React Native (iOS + Android) • Database: PostgreSQL • Realtime cache / GPS: Redis • Hosting: AWS + Docker + CI/CD • Accounting integration: Sage first, Xero later • Notifications: Push + Email • GDPR-compliant storage and encryption ⸻ 3️⃣ Deliverables • Fully functional web dashboard • Mobile apps for engineers (iOS + Android) • Subcontractor management module (web + optional mobile) • Invoicing module with Sage integration • Timesheet + GPS tracking module • Database schema & API endpoints • File upload / import functionality • Deployment scripts (AWS / Docker / CI/CD) • Documentation (user manual + API documentation) ⸻ 4️⃣ Project Phases / Milestones Phase 1 – MVP: • Engineer mobile app (GPS + job reports + timesheets) • Web dashboard (job management + reporting) • Subcontractor module (manual + file upload invoices + POs) • Invoicing (Sage integration) Phase 2 – Optional: • Advanced reporting / analytics • Xero integration • Material stock & procurement • Client portal Phase 3 – Optional / Future: • SaaS multi-company version • AI-assisted job report summary • Fleet & asset tracking ⸻ 5️⃣ Requirements from Freelancer • Experience with Node.js, React, React Native, PostgreSQL, AWS • Experience building CRM / ERP / field service apps • Ability to design scalable architecture • Experience with API integration (Sage/Xero) • Ability to handle file uploads, CSV/XLSX imports, and validation • Strong English communication and documentation skills • Deliver code in phases/milestones • Provide full technical documentation + deployment scripts

opportunity

Cloudflare Worker Developer for Internal IP Tracking Tool

We’re looking for a developer to build a small internal tool to capture visitor IP data from our own website for testing and evaluation. The goal is to reliably capture and store raw visit data so we can assess usefulness over the next few months. This is not a full product build. Scope Build a Cloudflare Worker endpoint Capture and store: Visitor IP address Timestamp Page URL / path Referrer UTM parameters (if present) Store data in Supabase (PostgreSQL) Provide a simple JavaScript snippet to embed on the website Compatible with a Duda-hosted website Consent-safe (script should only run after consent – compatible with Usercentrics) Basic security (CORS / origin validation) Clean, readable, documented code Out of scope Dashboards or user interface CRM integrations IP-to-company enrichment This is a lean internal test build, not a product or platform. Deliverables Cloudflare Worker source code + deployment steps Supabase table schema Example embed script Short README explaining setup and data flow Process Before starting, we’ll have a short scoping discussion to confirm approach and assumptions so we’re aligned before work begins. Good fit if you Have hands-on experience with Cloudflare Workers Have worked with Supabase / PostgreSQL Understand how to correctly capture IPs behind proxies/CDNs Are comfortable building small, well-scoped internal tools

Full Stack Developer for creating statistical analysis SaaS

I am looking for a Senior Full Stack Developer to develop a platform for statistical analysis and game history at betting houses, replicating the features of the Tipminer website. Exact reference: https://www.tipminer.com/en What needs to be done: Real-Time Monitoring (Core): Create a system (Scraper/Sniffer) capable of reading game results on our platform via WebSocket or API Reverse Engineering. The data must arrive on the dashboard with zero latency (as soon as the round ends). Anti-blocking system (circumvent Cloudflare/Protections) to ensure stability. Frontend (Dashboard): Responsive layout (Mobile and Desktop) similar to the reference. Candlestick history grid with conditional coloring (Blue, Purple, Pink). Statistical graphs of accuracy, patterns, and paying times. Backend & Database: Store complete round history. Automatic calculation of strategies (e.g., candlestick patterns, sequences, gale). Mandatory Technical Requirements: Backend: Node.js, Python, or Go. Frontend: React, Vue.js, or Next.js. Connection: Advanced experience with WebSockets (WSS) and network sniffing. Database: PostgreSQL or MongoDB. Deliverables: Complete source code (Frontend + Backend). Installation and configuration on the server (VPS). Basic documentation on how to add new “houses” in the future (if applicable). Attention Candidates: Do not send generic proposals. This project requires knowledge of intercepting WebSocket traffic from iGaming sites. If you already have experience with casino APIs or similar projects (Tipminer, Tiphunter), mention this at the top of your proposal. Mandatory questions for the proposal: Do you have experience capturing data via WebSocket (WSS) from protected websites? What stack/technology will you use to ensure minimal delay? Do you have a portfolio of projects related to iGaming or real-time dashboards? What stack/technology will you use to ensure minimal delay? Do you have a portfolio of projects related to iGaming or real-time dashboards?

opportunity

Engineer to audit Existing CRM Codebase (TypeScript/Node/NeonDB)

Job Description I’m looking for an experienced senior full-stack engineer to review an existing CRM system and provide a clear, structured technical assessment of the current codebase. This is not a build-from-scratch role. The goal is to audit the existing system, review architecture and implementation choices, and highlight risks, concerns, and improvement opportunities across backend, frontend, and data layers. Tech Stack Backend: Node.js, Express, TypeScript Frontend: TypeScript, Tailwind CSS Database: NeonDB (PostgreSQL) System Type: Custom CRM platform Auth: Mix of public and authenticated endpoints Scope of Review You will be asked to review the existing codebase and provide written feedback on: 1. Code Structure & Architecture Project structure and separation of concerns API design and route organization Service, controller, and data access patterns Type safety and TypeScript best practices 2. Backend & API Review Public vs authenticated endpoint design Validation, error handling, and middleware usage Security posture of public endpoints Rate limiting, abuse protection, and access controls 3. Frontend Review Component structure and state management Tailwind usage and maintainability Frontend/backend contract consistency 4. Database & Data Layer Schema design and relationships Query patterns and performance considerations Data access safety (SQL injection, unsafe queries) 5. Security & Reliability Authentication/authorization design IDOR, data exposure, and abuse risks Secrets management and configuration hygiene Logging, monitoring, and error visibility Deliverables A written technical review (bullet-pointed and structured) Clear identification of high-risk, medium-risk, and low-risk concerns Practical, actionable recommendations (no theoretical fluff) Notes on what is good and should remain unchanged No code changes are required unless specifically discussed. Ideal Freelancer 5+ years professional full-stack experience Strong TypeScript + Node.js background Experience reviewing or auditing existing codebases Comfortable with PostgreSQL / NeonDB Strong understanding of API security and CRM-style systems Clear written communication (this is a review role)

Full-Stack Web Developer for Long-Term Partnership

We are top rated freelancer agency with more that 5 years of working experiance with international clients around UK, USA, Dubai. We are seeking an experienced full-stack web developer for ongoing projects with a UK-based client. This is a long-term opportunity working remotely on modern web applications, e-commerce platforms, and custom business solutions. Project Scope: Build and maintain responsive web applications Integrate third-party APIs and payment gateways Develop custom admin dashboards and user interfaces Optimize database performance and security Deploy and manage applications on cloud platforms Maintain customer relationship through strong communication Prerequisites (Must Have): 5+ years full-stack development experience Strong proficiency in JavaScript (React/Next.js or Vue.js) Backend expertise (Node.js, PHP, or Python) Database experience (MySQL, PostgreSQL, or MongoDB) Proven e-commerce integration skills (Shopify, WooCommerce, or custom) Experience with Git, deployment pipelines, and cloud hosting (AWS/Vercel/DigitalOcean) UK timezone availability (GMT/BST alignment preferred) Excellent English communication for client updates Nice to Have: Flutter or React Native for future mobile expansions WordPress/OpenCart customization experience API automation with Make.com or Zapier What We Offer: Consistent monthly projects (35+ hours/week) Competitive hourly rates based on experience Long-term partnership with repeat business Clear project briefs and timely payments Please share your relevant portfolio, hourly rate, and availability when applying. Shortlisted candidates will receive detailed project specs.

Remote Backend Developer (Node.js or Python)

We are seeking a proficient and dependable Remote Backend Developer with expertise in either Node.js or Python to bolster our expanding engineering team on a contract basis. Candidates from Latin America or Europe are preferred. The ideal applicant will possess a strong command of English, with a demonstrated ability to construct scalable APIs and backend systems. Familiarity with technologies such as PostgreSQL, MySQL, Docker, and cloud platforms like AWS or GCP is essential. Responsibilities include developing and maintaining backend services, collaborating with frontend teams, and ensuring code quality through reviews. If you are passionate about clean coding and remote work, we invite you to apply.

Full Stack Developer (React + Node.js + AI/ML Experience)

We are hiring a Full Stack Developer with strong hands-on experience in React (Frontend), Node.js (Backend), and AI/ML development. The candidate must have worked on AI APIs, model integration, and machine-learning–based application development. Key Responsibilities: Develop responsive UI using React.js, Redux/Context API Build and maintain Node.js/Express backend services Design and integrate REST APIs Implement and integrate AI/ML models, LLM APIs, NLP workflows Work with databases (MongoDB / MySQL / PostgreSQL) Deploy AI-driven applications on AWS / GCP / Azure Troubleshoot, debug, and optimize performance Collaborate with Product, UI/UX, QA teams Must-Have Skills React.js, JavaScript (ES6+), HTML/CSS Node.js, Express.js AI/ML development (TensorFlow / PyTorch / Scikit-learn) AI API integration (OpenAI, Gemini, Claude, HuggingFace, etc.) REST API architecture & JSON Database knowledge (MongoDB/MySQL/PostgreSQL) Git, Docker (basic) Good to Have Experience with vector databases (Pinecone, Weaviate, FAISS) Knowledge of RAG pipelines / embeddings Cloud deployment (AWS/GCP/Azure) Microservices architecture Project will be discussed with the selected candidate after an Interview. Thank you Ashish

Hiring Full Stack Developers for long-term collaboration

-Requirements Excellent understanding of modern web technologies (React, Next.js, Node.js, Python/Django, Java, PostgreSQL, AWS). Fluent English communication skills (both spoken and written).

Web GIS Developer Needed to Build Property Tax Mapping Tool

I am looking for a highly experienced Web GIS Developer to build an open-source, browser-based Property Tax Mapping Tool for municipal use. The system will integrate an existing PostgreSQL/PostGIS database with a GeoServer map service and a modern web map interface (Leaflet or similar). The tool will allow municipal staff to view buildings and community boundaries, click on features to view property details, and enter or update property tax information stored directly in PostGIS. This is an end-to-end project: system setup, development, testing, deployment, and documentation. Key Features Required 1. Map & Data Integration Connect to existing PostGIS database (building footprints, communities, district boundary). Publish layers using GeoServer (WMS / WFS / GeoJSON). Apply simple, readable map styling (SLD). 2. Web Application (Frontend) Interactive map built with Leaflet/OpenLayers. Click buildings to display attributes in a sidebar. Search for buildings (ID, name, or available fields). Form interface to input/update property tax data (tax year, assessed value, tax rate, payment status, payer name, etc.). 3. Backend API Build a lightweight REST API (Flask, FastAPI, or Node.js/Express). Create/update tax records in PostGIS. Implement secure authentication for municipal staff. 4. Deployment & Documentation Deploy complete application on Linux server or cloud VM. Provide: Technical documentation Brief walkthrough Experience Required Applicants must have strong experience with: Web GIS: Leaflet, OpenLayers, MapLibre Spatial databases: PostgreSQL/PostGIS Map servers: GeoServer (publishing layers, SLD styling) REST API development (Flask/FastAPI or Express) Full stack web development (JavaScript, HTML, CSS) Authentication & basic security Deployment on Linux servers Bonus experience: Building tools for low-resource or Global South environments

opportunity

Shopify app

I’m building a Shopify app focused on decision intelligence for scaling ecommerce stores. This is a well-defined MVP with clear scope, architecture, and requirements. I’m looking for one strong full-stack developer who can execute independently. Tech stack - Backend: Node.js (Express / Nest acceptable) - Frontend: React (Next.js preferred) - Shopify Admin API - PostgreSQL (Prisma) - Simple queue (BullMQ or similar) Scope (MVP) - Shopify OAuth + app install - Billing (Light / Growth / Pro plans) - Backend APIs (analysis, gating, nudges) - Dashboard UI (React) - Weekly background jobs - App Store–ready MVP Requirements - Prior experience building Shopify apps (mandatory) - Comfortable working alone - Able to follow a technical spec closely - Clean, readable code - No over-engineering ** Minimum 5 years experience ** Fixed price ** Timeline: 2–3 weeks Please include: - A Shopify app you’ve built - Your preferred stack - Confirmation you can deliver within scope and budget Payment - 30% upfront - 40% after backend core - 30% after MVP delivery