Building a Real-Time POS & Operations ERP Suite with WebSockets & Prisma

Point of Sale (POS) and Enterprise Resource Planning (ERP) platforms in high-volume hospitality environments require sub-second state synchronization across cashier terminals, mobile waiter handhelds, and kitchen display printers.

1. Core Architecture Challenges

• Concurrent Order Conflicts: Preventing duplicate seat reservations or conflicting order modifications when multiple waiters tap buttons simultaneously.
• Low-Latency Kitchen Sync: Dispatching kitchen order tickets (KOT) to thermal printers instantly upon cashier checkout.
• Inventory Deductions: Automatically decreasing inventory ingredient counts per order item.

2. Real-Time WebSocket Event Pipeline

Using Socket.io alongside Prisma ORM & MySQL transactions, order state changes radiate instantly across connected client channels:

typescriptExample
// Server-Side WebSocket Order Handler
import { Server, Socket } from 'socket.io';
import { prisma } from '@/lib/prisma';

export function registerPOSHandlers(io: Server, socket: Socket) {
    socket.on('order:create', async (payload) => {
        const order = await prisma.$transaction(async (tx) => {
            const newOrder = await tx.order.create({
                data: {
                    tableId: payload.tableId,
                    items: { create: payload.items },
                    total: payload.total
                }
            });
            await tx.table.update({
                where: { id: payload.tableId },
                data: { status: 'OCCUPIED' }
            });
            return newOrder;
        });

        // Broadcast to Kitchen Display Terminals & Cashier Screens
        io.emit('kitchen:new_order', order);
        io.emit('table:status_change', { tableId: payload.tableId, status: 'OCCUPIED' });
    });
}

3. Production Learnings

1. Transactional Safety: Wrapping order generation and table status toggles inside Prisma transaction blocks guarantees DB integrity even during server restarts.
2. Optimistic UI Updates: Cashier terminals update table status visually before server confirmation, eliminating UI latency lag.