Postgresql Projects

The Spring Framework Software

We seek an experienced Java developer to help expand the capabilities of our Spring Framework based software. The core application is a modular REST API platform built using Spring Boot, JPA, and PostgreSQL. Additional functionality is required to enhance user authentication, implement fine-grained authorization controls, and integrate with third party identity providers.

Infrastructure Setup & Backend Foundation

SKILLS : C#, DevOps, AWS, Databases, .Net, Infrastructure, Authentication This role requires setting up foundational infrastructure for a new application and developing its initial backend systems. Responsibilities include configuring a shared database like PostgreSQL to facilitate collaborative development. Additionally, an appropriate hosting environment such as AWS must be established alongside deployment guidelines. The backend implementation will create an API project preferably in C# along with authentication and API endpoints. An ORM will enable database interactions. Upon completion, clients will receive a functional app featuring login, APIs, and comprehensive documentation on the database and deployment processes. A strong technical background in infrastructure configuration, backend development expertise in languages like C#, and experience deploying applications through pipelines are necessities for this role.

Full stack developer for regular work

Proficiency in JavaScript/TypeScript. Hands-on experience with front-end frameworks such as React. Experience with backend technologies like Node.js, Express, NestJS, or similar frameworks. Familiarity with SQL databases such as PostgreSQL or MySQL. Strong problem-solving skills and the ability to understand client issues. Experience with RESTful APIs and third-party integrations. Knowledge of version control systems like Git. Strong debugging and troubleshooting skills. Ability to work both independently and in a team environment.

Need Full Stack Software Engineer(U.S. Based Only)

We’re looking for a skilled Full Stack Software Engineer to join our remote team. This role is open only to engineers based in the United States. You’ll help build and improve web applications used by real businesses every day. What You’ll Do: Build and maintain web apps using modern tools (React, Node.js, etc.) Work on both frontend and backend features Write clean, tested code Collaborate with other developers and designers Help plan and improve the system architecture Requirements: Must be based in the United States (we will not consider international applicants) 3+ years of experience in full stack development Strong skills in JavaScript, React, and Node.js Experience with databases (PostgreSQL, MongoDB, etc.) Familiar with Git and cloud deployment (AWS, etc.) Good communication and self-motivation Nice to Have: TypeScript experience Supabase or Firebase Worked in a startup or small team Mobile or PWA experience

Secure server-side functions for login and webhook handling

We are seeking an experienced Next.js Developer to complete a membership-based web application. The project is mid-build and requires an immediate, capable developer who can finish and extend the platform to meet business-grade requirements. Key Responsibilities: Integrate Memberstack for membership management, user authentication, and subscription billing. Integrate SAML Single Sign-On (SSO) for enterprise clients using WorkOS (or a similar provider) and connect it to the Memberstack user system. Develop and secure server-side functions for login and webhook handling (subscriptions, SSO events). Ensure clean, scalable, and secure code practices. Coordinate with our internal team to bring the project to production-ready completion. Technical Requirements: Proven expertise in Next.js and React.js. Experience integrating Memberstack or similar membership platforms (e.g., Auth0, Clerk.dev). Strong knowledge of server-side functions in Next.js (e.g., getServerSideProps, API routes). Ability to implement IP-based access restrictions using server-side logic. Experience with SAML SSO flows and WorkOS, Auth0, or equivalent. Familiarity with Stripe for subscription billing is a plus. Strong understanding of authentication, authorization, and security principles. Comfortable with PostgreSQL or MongoDB for user and access management. Other Requirements: Available for immediate start. Able to deliver high-quality, production-ready code within agreed deadlines. Excellent communication and reliability.

I need to develop Push Notification for website and mobile app

TowDispatch is a full-featured platform designed to streamline operations for car towing agencies. The system supports both web and mobile environments and enables seamless coordination between dispatch administrators and field drivers. Tech Stack Web Frontend: React.js + Tailwind CSS Backend & Realtime DB: Supabase (PostgreSQL, Auth, Edge Functions) Mobile Application: Capacitor (for native app packaging), integrated via Android Studio for Android and planned iOS deployment Core Functionality Admin Dashboard Job Management: Create, assign, update, and delete tow jobs Driver Management: Add, edit, and monitor driver status and activities Reporting Module: Generate operational and performance reports Notification System: Real-time job status feedback via toast messages (web) and push notifications (mobile) Driver App Job Inbox: View assigned jobs with real-time updates Job Workflow: Update job progress (e.g., en route, job complete) Profile: Manage driver-specific settings and preferences Current Challenge: Push Notification Implementation With the mobile app version now fully operational through Capacitor and Android Studio, the primary challenge lies in implementing a reliable and scalable push notification system to replicate and extend the existing toast-based web notification model. Existing Web Notification Flow Notifications are triggered via toast messages, displayed in-app for real-time user feedback All notification events (e.g., job assignment, completion) are stored in Supabase for traceability

opportunity

I need to implement Push Notification in Website and Application

TowDispatch is a full-featured platform designed to streamline operations for car towing agencies. The system supports both web and mobile environments and enables seamless coordination between dispatch administrators and field drivers. Tech Stack Web Frontend: React.js + Tailwind CSS Backend & Realtime DB: Supabase (PostgreSQL, Auth, Edge Functions) Mobile Application: Capacitor (for native app packaging), integrated via Android Studio for Android and planned iOS deployment Core Functionality Admin Dashboard Job Management: Create, assign, update, and delete tow jobs Driver Management: Add, edit, and monitor driver status and activities Reporting Module: Generate operational and performance reports Notification System: Real-time job status feedback via toast messages (web) and push notifications (mobile) Driver App Job Inbox: View assigned jobs with real-time updates Job Workflow: Update job progress (e.g., en route, job complete) Profile: Manage driver-specific settings and preferences Current Challenge: Push Notification Implementation With the mobile app version now fully operational through Capacitor and Android Studio, the primary challenge lies in implementing a reliable and scalable push notification system to replicate and extend the existing toast-based web notification model. Existing Web Notification Flow Notifications are triggered via toast messages, displayed in-app for real-time user feedback All notification events (e.g., job assignment, completion) are stored in Supabase for traceability

Next.js Dev: Memberstack, IP and SAML Integration

Description: We are seeking an experienced Next.js Developer to complete a membership-based web application. The project is mid-build and requires an immediate, capable developer who can finish and extend the platform to meet business-grade requirements. Key Responsibilities: Integrate Memberstack for membership management, user authentication, and subscription billing. Implement server-side IP-based access control within the Next.js framework. Integrate SAML Single Sign-On (SSO) for enterprise clients using WorkOS (or a similar provider) and connect it to the Memberstack user system. Develop and secure server-side functions for login, IP verification, and webhook handling (subscriptions, SSO events). Ensure clean, scalable, and secure code practices. Coordinate with our internal team to bring the project to production-ready completion. Technical Requirements: Proven expertise in Next.js and React.js. Experience integrating Memberstack or similar membership platforms (e.g., Auth0, Clerk.dev). Strong knowledge of server-side functions in Next.js (e.g., getServerSideProps, API routes). Ability to implement IP-based access restrictions using server-side logic. Experience with SAML SSO flows and WorkOS, Auth0, or equivalent. Familiarity with Stripe for subscription billing is a plus. Strong understanding of authentication, authorization, and security principles. Comfortable with PostgreSQL or MongoDB for user and access management. Other Requirements: Available for immediate start. Able to deliver high-quality, production-ready code within agreed deadlines. Excellent communication and reliability. Contract Type: Freelance (with potential for ongoing project work). Location: Remote (UK hours preferred but flexible). How to Apply: Please provide: Your portfolio or examples of similar projects. A brief overview of your approach to handling IP access control and SAML in a Next.js environment. Your hourly or project-based rate and availability.

opportunity

I need a team who can create a software and debug current

Please send examples of previous SaaS, proptech, construction tech, or real estate software projects you have built. I am seeking an experienced full-stack developer or small team to help build the MVP (Minimum Viable Product) for a real estate developer management platform. The goal of this platform is to streamline project management, budgeting, permit tracking, CRM, and 3D visualization for real estate developers, land developers, and builders. The platform must have a strong and clean UI, built first for web (desktop priority, responsive mobile-friendly second). Key Features for MVP: User registration and login (developer-focused dashboard) Project creation and management (basic inputs: project name, description, timeline, budget, etc.) Task management and progress tracking Permit and documentation management (upload, status tracking) CRM basics: track leads, investors, and sales/leasing contacts AI-assisted 3D project visualization (early stage: basic model uploads or AI generation for pitches) Admin backend to manage users and projects Bonus (if possible): Google Earth compatibility for 3D models Future scalability toward mobile app development Tech Stack Preference (flexible): Frontend: React, Next.js, or similar Backend: Node.js, Django, or similar Database: PostgreSQL or similar Hosting: AWS, Vercel, or similar AI integration (open to suggestions for best path) Ideal Candidate(s): Experience building scalable SaaS platforms or proptech/construction tech products Comfortable with AI/ML integrations (or willing to collaborate with AI specialists) Strong UI/UX skills for a clean, professional developer dashboard Bonus: Experience with 3D modeling or Google Earth data formats Timeline: Looking to build a functional MVP over the next 2–3 months. (Initial sprint: Core platform setup within 4–6 weeks.) Budget: Bootstrapped project — open to negotiation based on skill, efficiency, and milestones. (Equity possibilities down the line for the right long-term partner.)

Referee and Umpire Management App Development

We are developing a fully featured, cross-platform referee app system that will be very similar to REFSIX, but enhanced with biometric sync, role-specific workflows, and live coordination across all match officials. The system will support five separate apps—one per sport: • Football (Soccer) • Futsal • Rugby Union • Rugby League • Tennis Each app will have its own branding and rules, but share a unified codebase, architecture, and core functionality. ⸻ Scope of Work – Phase 1 1. Design • Branding: • Unique logos and color themes for each sport. • UI/UX Design: • Refined match control UI (like REFSIX) for mobile and smartwatch. • Web/tablet dashboards for assessors and managers. • Sync status indicators, touch-based timers, and live match data visibility. ⸻ 2. Build Tech Stack: • Frontend: React Native + Expo SDK, Tamagui UI, native watch modules. • Backend: NestJS (REST API), PostgreSQL, Firebase Auth, AWS S3, Redis Streams. • Local Storage: MMKV (mobile), CoreData (iOS), IndexedDB (web). Devices Supported: • iOS + Android phones • WearOS + watchOS • Tablet / Web (Next.js) Sync Architecture: • BLE device pairing for watch-to-phone sync • Firebase + Redis Streams for live sync across officials, assessors, and managers • Role-based visibility and real-time updates between: • Referees • 4th Officials • Assessors • Managers • Admins ⸻ 3. Sport-Specific Functionality Football / Futsal: • Cards, goals, stoppage time, misconduct, substitutions. Rugby Union / League: • Blood timer, HIA, sin-bin, scrum resets, substitutions. Tennis: • Points, sets, medical timeouts, challenges. Each app will reflect sport-specific timing, flow, and terminology. ⸻ 4. Testing • BLE sync validation between watch + phone • Cross-device sync between referee roles and assessor views • Offline behavior + recovery • Multi-device match simulation with 3+ connected roles ⸻ 5. Admin & Assessor Web Portal • Real-time synced view of ongoing matches • Event tagging, clip marking • Match history exports (PDF) • Consent/safeguarding reports • Role-based access and edit permissions ⸻ 6. Additional Phase 1 Features • Pre-match sync check (BLE + Firebase) • Manual foul/collision logger • Emergency SOS button • Offline video tagging • PDF reports • Minor consent flags • BLE + Wi-Fi fallback sync • Sync status icons (green/yellow/red) • Language selector: English, Spanish, French, German • Manual “Push to Cloud” option • Real-time coordination across all match roles

Web Scraping Specialist: Amazon Price Monitoring

Advanced Web Scraping Specialist for Amazon Price Monitoring and Notification System Duration: 3 - 6 Months (Possibly Longer) Start Date: ASAP Overview: We are seeking an experienced and highly skilled freelancer to create a complex web scraping system that will monitor product prices on Amazon in real-time. This system must be able to efficiently scrape Amazon's product listings, detect price changes, and notify users of these changes with high accuracy and speed. This project requires a strong understanding of web scraping, API integration, and advanced data handling techniques. You should be comfortable with large-scale data extraction, working with multiple product categories, and managing frequent updates. Key Responsibilities: Web Scraping: Build a scalable web scraper to extract product data (price, title, product description, reviews, etc.) from multiple Amazon product pages. This includes handling pages with dynamic content and CAPTCHAs. - Price Change Detection: Implement a robust system to track price changes for thousands of products on Amazon in real-time. Ensure that the system can identify price fluctuations, including minor adjustments. Notification System: Develop a user-friendly notification system that alerts users when a product price changes. Notifications should be sent via email or push notifications (based on user preference). - Data Storage: Build an efficient data storage solution for the scraped data, ensuring historical price tracking is available. You must optimize storage and retrieval of large volumes of data. Scaling: Ensure that the scraper can scale effectively, with the ability to handle high volumes of products and frequent price updates. - Accuracy & Reliability: The scraper should minimize errors (false positives/negatives) in price change detection and be able to handle rate-limiting and anti-scraping mechanisms implemented by Amazon. - User Interface (Optional): If feasible, create a simple front-end interface where users can track their selected products, receive notifications, and customize their preferences. Follow best practices to avoid being blocked or banned by Amazon. - Required Skills & Experience: Advanced Web Scraping: Proven experience with advanced scraping techniques using tools like BeautifulSoup, Scrapy, Selenium, or Puppeteer. - API Integration: Strong experience with integrating third-party APIs, especially for notification systems (e.g., SendGrid, Twilio). - Real-Time Data Processing: Expertise in setting up real-time data pipelines and event-driven architectures. - Cloud Infrastructure: Knowledge of cloud platforms (AWS, GCP, Azure) to deploy the system and manage resources efficiently. - Data Storage & Databases: Proficient in designing and maintaining databases, with experience in relational and NoSQL databases (PostgreSQL, MongoDB, etc.). - Programming: Strong knowledge of Python, JavaScript, or other relevant languages. Experience with multithreading, async programming, and handling large-scale data. - Anti-Scraping Measures: Deep understanding of IP rotation, proxy servers, CAPTCHAs, and other countermeasures to avoid being blocked by Amazon’s anti-scraping mechanisms. - Attention to Detail: Ability to deliver accurate and well-tested solutions with minimal oversight. Nice-to-Haves: - Experience with Headless Browsers: Familiarity with using headless browsers (e.g., Puppeteer, Playwright) to interact with dynamic Amazon pages. - Machine Learning: Experience with machine learning for detecting patterns in price changes or predicting future price trends (optional but a plus). - Prior Amazon Scraping Projects: Any prior experience scraping Amazon and handling its anti-scraping protocols will be an advantage. Start your Proposal with "My Prior Experience in this" Deliverables: - A fully functional Amazon price monitoring system that tracks price changes and notifies users. - A detailed report of the system architecture, installation guides, and any relevant documentation. - Source code and technical documentation for future updates or changes. Why Work With Us: - Challenging Project: You’ll be tackling a high-complexity project that will require innovation and technical expertise. - Collaborative Team: You’ll work closely with a team of developers and product managers to bring this project to life. - Long-Term Opportunity: A successful completion could lead to more projects in the future as we expand our platform. If you are an experienced, detail-oriented developer who enjoys tackling complex challenges and building scalable systems, we want to hear from you! How to Apply: Please provide: 1. A brief description of similar projects you’ve worked on. 2. A portfolio of relevant work or Resume + Linkedin/GitHub repositories. 3. Your approach to handling large-scale web scraping and price monitoring systems. 4. Estimated timeline for completing the project. 5. Hourly rate or project rate. Looking forward to working with you!

opportunity

Referee and umpire separate app build

Looking to create a master referee and umpire app. This app will have the same core across all sports, but then each app will be downloaded separately with that sport's logic built in. We are looking at creating an app for football and futsal, rugby union and league, and tennis. I have attached a number of attachments, showing the overview of what we expect across all watches, then dive into each sport and what each app needs to have. We are looking to build an amazing app that covers these sports, which will have the same core but then each has its own sport logic. We need to do a deep review of all the laws of that sport to understand the role of a referee or umpire, what they record, and what logic and safeguards could we build in to help them. Amazing opportunity to build the world’s best referee platform. Goal Mobile App (Cross-Platform) • React Native 0.74+ (bare workflow) • Expo EAS (for OTA updates, builds, CI) • SQLite or WatermelonDB (offline-first storage) • react-native-ble-plx (for BLE communication) • react-native-biometrics (for Face ID / Touch ID / Android Biometrics) • On-device Whisper (PyTorch Mobile or TFLite) • SecureStore / Keychain / Android Keystore for sensitive data • Fastlane (App Store + Play Store deploy automation) ⸻ Apple Watch App • Native Swift + SwiftUI + WatchKit • WKExtendedRuntimeSession (for long-running match sessions) • CoreBluetooth (client-only BLE, sync with paired iPhone) • Local CoreData or file-based event logging • Background sync via paired iPhone ⸻ Wear OS (Android Watch) App • Native Kotlin + Jetpack Compose • ForegroundService (for match runtime) • BLE Peripheral + Central roles enabled • FusedLocationProviderClient for GPS • SQLite for offline event buffering • Android SpeechRecognizer (optional Whisper if hardware supports) ⸻ Other Smartwatches • No consistent BLE or dev support beyond Apple + Wear OS • Recommendation: Do not support Fitbit, Garmin, or proprietary platforms unless using their SDKs just for fitness/HR integration ⸻ Web Platform • Next.js 14 + React 18 • Tailwind CSS (utility-first responsive design) • Strapi or Directus (headless CMS for rule management, teams, config) • Firebase Auth or Clerk.dev (SSO, OAuth, email login) • Custom match review dashboard (React + Timeline for event/video sync) ⸻ Backend & Infrastructure • Node.js 20+ with NestJS (modular and scalable API framework) • PostgreSQL 16 (relational + geospatial queries) • Redis (caching, pub/sub, rate-limiting) • BullMQ or Temporal.io (match workflows, sync jobs) • WebSockets or Server-Sent Events (real-time updates) • Cloud provider: AWS or GCP • Infrastructure as Code: Terraform ⸻ AI & ML • OpenAI Whisper (on-device transcription, multilingual) • TensorFlow Lite or PyTorch Mobile (for gesture/foul detection) • MediaPipe or YOLOv7 (on-device or edge pose detection) • Firebase Remote Config or custom CDN for model delivery/versioning ⸻ BLE & Sync Logic • Buffered event logging (sync every 30–60 seconds) • BLE RSSI-aware retries and backoff • Apple Watch: BLE via iPhone bridge • Android Watch: direct BLE to phone or peer watch (if needed) ⸻ DevOps • GitHub Actions (CI/CD for web + backend) • Expo EAS Build + OTA • Docker for backend services • Firebase App Distribution for early testing • Sentry + OpenTelemetry (error tracking and performance) • Grafana + Prometheus (metrics and observability) ⸻ Cybersecurity & Compliance • Appdome (app shielding, anti-reverse engineering) • Firebase App Check + rate limiting via Redis • AES-256 encryption at rest, TLS 1.3 in transit • Keychain (iOS) / Keystore (Android) for biometrics + secrets • GDPR/CCPA-compliant privacy tools (OneTrust or Transcend) • Secrets management: Doppler or AWS Secrets Manager • Annual pen testing + SAST (Static Analysis) in CI ⸻ Optional / Enterprise Features • Match integrity scoring (GPS, BLE, behavior) • AI coach for referees (post-match performance feedback) • Video annotation + synced voice log review • Referee network platform (availability, scheduling, credentialing) • White-label capabilities for leagues or federations Apps creation Football referee app Futsal refeeee app Rugby union referee app Rugby league referee app Tennis umpire app. Full created, best platform and stack possible, fully tested, fully uploaded and a full website to go along with this for full marketing and dashboard for referee/umpires and all admin access to control and review issue