Postgresql Projects

PART-TIME FREELANCE ROLE Claude Architect — Fleet Tech Platform

Part-time freelance Claude Architect for Fleet Tech Platform: Join a project building a petroleum tanker fleet management system powered by Claude AI. Seeking a technical partner to deploy Claude’s outputs rather than write code from scratch. Requirements: advanced Claude/ChatGPT prompting skills, GitHub proficiency (uploading, browser edits, commits), ability to read server logs and diagnose errors, basic web app knowledge (frontend, backend, database), SQL (queries, ALTER TABLE, INSERT), and clear written English for async communication. Bonus: Node.js/Express, advanced PostgreSQL, maritime domain knowledge, deployment experience on Railway/Heroku.

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

Backend Developer

About the Role We are looking for a skilled Backend Developer to design and build scalable server-side applications. You will be responsible for developing APIs, managing databases, and ensuring high performance and responsiveness of our applications. Key Responsibilities Design, develop, and maintain backend services and APIs Build scalable and secure server-side applications Work with databases to design efficient data models Integrate third-party services and APIs Optimize applications for speed and scalability Collaborate with frontend developers, DevOps engineers, and product teams Write clean, maintainable, and well-documented code Participate in code reviews and continuous improvement processes Requirements 3+ years of experience in backend development Strong knowledge of Node.js, Python, Java, or PHP Experience building RESTful APIs or GraphQL APIs Proficiency with databases such as PostgreSQL, MySQL, or MongoDB Experience with Git and version control workflows Knowledge of authentication, security, and API design Familiarity with cloud platforms (AWS, Azure, or Google Cloud) Nice to Have Experience with microservices architecture Knowledge of Docker and Kubernetes Experience with CI/CD pipelines Familiarity with Redis, Kafka, or message queues Benefits Competitive salary Flexible working hours Remote work options Professional development opportunities Collaborative international team

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

opportunity

2-in-1 Carpooling Platform (Short + Long Distance)

Develop a hybrid 2-in-1 carpooling platform (iOS, Android, Web, Backend) combining long-distance scheduled trips and short-distance on-demand rides with a global toggle. Features: real-time GPS tracking, 3D vehicle animation, driver/passenger KYC, vehicle auto-recognition, wallets with automated 65/35 split, booking flows, cancellation rules, ratings/loyalty, admin CMS, payment gateways, policy pages, scalable microservices, secure auth, and deployment-ready deliverables including API docs, QA, and integrations. Ratings visible on driver profile • Feedback system mandatory ⸻ 9. Driver Profile Display Before booking, passengers must see: • Vehicle details (plate, model) • Available seats • Total trips completed • Ratings & reviews • Past feedback ⸻ 10. Notifications System • Push notifications (Firebase/APNs) • Real-time alerts: • Booking confirmation • Driver arrival • Trip start/end • Payment updates ⸻ 11. Integration Requirements ⸻ 11.1 Website Integration • Sync with existing: • Driver forms • Passenger database • Shared backend APIs ⸻ 11.2 Admin CMS Super Admin must: • Manage users (drivers/passengers) • Monitor transactions • Control payouts • Handle disputes • View analytics ⸻ 11.3 Payment Gateway Integration • Stripe / PayPal / Local gateways • Must work across: • Mobile apps • Website ⸻ 12. Policy & Compliance Pages Integrate: • Privacy Policy • User Policy • Cancellation Policy • Dispute Resolution • Complaint Forms ⸻ 13. Technical Requirements ⸻ Frontend • Flutter / React Native (preferred for cross-platform) • Smooth UI/UX (Uber-like experience) ⸻ Backend • Node.js / Django / Laravel • RESTful APIs • Scalable microservices architecture ⸻ Database • PostgreSQL / MySQL • Real-time DB (Firebase optional) ⸻ Maps & Location • Google Maps API / Mapbox • Real-time GPS tracking ⸻ 14. Security Requirements • KYC verification • Data encryption (SSL) • Secure authentication (JWT / OAuth) • Fraud detection system ⸻ 15. Deliverables Developer must provide: • Fully functional iOS & Android apps • Admin dashboard (CMS) • Backend API documentation • Integrated website system • Testing & QA • Deployment support ⸻ 16. Expected Outcome A fully integrated hybrid ride-sharing ecosystem that: • Works like BlaBlaCar + Uber in one app • Allows mode switching • Provides real-time tracking + structured trip booking • Ensures automated revenue split & wallet system

Senior AI Developer /AI Automation Engineer (LLM, AI Agents,)

Job Overview: We are looking for an experienced AI Developer / AI Automation Engineer to design and build advanced AI applications, intelligent agents, and automation platforms similar to leading AI products for different industries.: • (AI-powered enterprise legal assistant) • (AI agent-based digital workforce platform) • (Generative AI business automation platform) • (AI analytics and marketing intelligence platform) These platforms leverage LLMs, AI agents, data pipelines, automation workflows, and API integrations to automate business operations, data analysis, marketing insights, and enterprise workflows. The ideal candidate should have strong experience in Generative AI, LLM development, AI agent frameworks, and automation systems. Key Responsibilities: 1. AI Application Development • Design and build AI-powered applications using LLMs • Develop AI agents capable of performing automated tasks • Implement retrieval augmented generation (RAG) systems 2. AI Agent & Workflow Automation • Build multi-agent AI systems • Create automated business workflows for: • marketing • analytics • customer support • data processing 3. LLM Integration • Integrate AI models such as: • OpenAI • Claude • Gemini • Llama • Fine-tune models for domain-specific applications. 4. Data & Knowledge Systems • Implement vector databases and semantic search • Build knowledge bases for enterprise AI assistants. 5. API & SaaS Integration Integrate AI with: • CRM systems • Marketing platforms • Google Ads / Meta Ads • analytics dashboards • internal business systems. 6. AI Analytics & Reporting Develop AI-powered analytics dashboards for: • marketing data • campaign optimization • predictive insights. Required Technical Skills AI / Machine Learning • Generative AI • Large Language Models (LLMs) • Prompt Engineering • RAG architecture • AI agents Programming Languages • Python (mandatory) • JavaScript / TypeScript • Node.js AI Frameworks Experience with at least one: • LangChain • LlamaIndex • AutoGPT • CrewAI • Semantic Kernel • HuggingFace AI Infrastructure • Vector Databases (Pinecone, Weaviate, Chroma) • Model deployment • AI APIs Cloud Platforms • AWS • GCP • Azure Databases • PostgreSQL • MongoDB • ElasticSearch DevOps • Docker • Kubernetes • CI/CD Preferred Skills • AI agent development • AI workflow automation • Data pipeline development • Marketing analytics AI • NLP systems • Chatbot / AI assistant development AI Products / Systems You May Work On Develop systems similar to: • AI Legal Assistant Platforms • AI Business Automation Agents • AI Marketing Analytics Platforms • Enterprise AI Knowledge Systems • AI SaaS Automation Tools Candidate Profile: We are looking for someone who: • Has strong experience building AI products • Understands LLM architecture and AI workflows • Can design AI SaaS platforms from scratch • Has experience building scalable AI systems Note: This is going to be a long term Full time position with good salary package. Please only apply if you are not working for any agency and you will be fully dedicated to work only with us since this is not one time project and we want those to be a part who want to be with us for long time. Best Regards Ashish

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?