Support Convex as DB integration

[soranoo]

Convex support real-time out of the box and has a fantastic frontend DX.

I think it can be a way out of the real-time issue discussed in #4191

Proposed Solutions,

1. Generate convex schema based on payload schema
2. Generate convex action based on payload hooks
3. Use convex client hooks to call the payload's convex action

Then the request flow will work like this

sequenceDiagram
    participant User
    participant BeforeHook as Convex Action (Before Hook)
    participant QM as Query/Mutation
    participant AfterHook as Convex Action (After Hook)

    User->>BeforeHook: req(payload)
    BeforeHook->>QM: payload (pre‑hook)
    QM->>AfterHook: result
    AfterHook->>User: response (post‑hook)

Loading

[launchthatbrand]

I am working on a solution, and i think the issue lies in payload.find, which is on server. The before*** hooks run on page reload, disconnecting Convex realtime clientside useQuery.

To make this work on my end I had to replace the default List and Edit views, using the Convex useQuery to fetch and sync data, then formatting how payload likes, and passing it to their native ListView and EditView components.

payload.find and related operations seem to happen on the server, and the actual EditView/ListView components are client components.

In my opinion this requires a custom DB adapter (server side payload.find, ect operations) and overriding things like useListQuery (client side hook that fetches data from payload local api -> server).

When saving a record it would go through payload.create -> db adapter -> add to convex

The ListView would have an overridden useListQuery, which injects the convex useQuery hook, making the listview convex realtime.

Still prototyping and would appreciate any direction.

[soranoo]

Indeed, to fully utilise the power of Convex data sync, tons of components have to be modified.
Btw I found Convex has provided a SSR solution (see https://docs.convex.dev/client/react/nextjs/server-rendering), hope that can help to reduce the need to convert server components into client components.