Modernizing Data Layer for Legacy PMS

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

Cloudflare Typescript API Përpunim të dhënash

ID Projekti: #38975726

Rreth projektit