Modernizing Data Layer for Legacy PMS
$2-8 AUD / saat
The task is to build a modern data layer to enhance our legacy Property Management System (Beds24).
We need a reliable system to sync and normalize data from Beds24's property management system.
Current challenges include:
- Inconsistent webhook formats
- Unreliable API behavior
- Complex data relationships
- Token management needs
What We're Building:
┌─────────────┐ ┌──────────────┐ ┌────────────┐
│ Beds24 │────►│ Business │────►│ Data │
│ │ │ Logic │ │ Layer │
└─────────────┘ └──────────────┘ └────────────┘
Building a robust data layer and business logic system using serverless functions (Cloudflare Workers/Supabase Functions) and SQL database (D1/PostgreSQL).
1. Modern Data Layer
- Complete booking management
- Change history tracking
- Price and availability tracking
- Full audit capability
2. Sync System
- Reliable data synchronization
- Error handling and recovery
- Bidirectional updates
- Performance optimization
Technical Stack:
- Serverless Functions (Cloudflare Workers or Supabase Functions)
- Database (Cloudflare D1 or Supbase PostgreSQL)
- Modern TypeScript
- Proper error handling
What Makes This Interesting:
- Build something that matters
- Solve real-world challenges
- Create a reliable foundation
- Enable future innovations
- Work with modern tech stack
Deliverables:
1. Database Schema & Migrations
2. Setup and Working Serverless Functions
Implementation Requirements
Core Functions
- Webhook Handler
- Token Manager
- Full Sync
- Error Handler
- Data Transformer
6.2 Database Tables
beds24_tokens
beds24_webhook_logs
beds24_bookings
beds24_booking_groups
beds24_info_items
beds24_invoice_items
beds24_messages
beds24_guests
beds24_guest_emails
beds24_guest_phones
beds24_bookings_guests
Key Features
Automatic token refresh
Data normalization
Relationship maintenance
Proje NO: #38975726
Proje hakkında
Bu iş için 6 freelancer ortalamada $16/saat teklif veriyor
Hello Jacob R., We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on Data Processing, Typescript, API, Cloudflar Daha Fazla
Hello, there. We can help you with building a modern data layer and business logic system for Bed24's property management system. We have years of experience in website design, graphic design and logo design (p Daha Fazla
✋!!STOP HERE!!✋ Dear client, Thanks for your job posting and hope you are doing well. I am writing to express my interest in the open Modernizing Data Layer for Legacy PMS. With over seven years of specialized experie Daha Fazla