Xata Database Adapter

[Gold240sx]

I've been trying to get it to work for several weeks. There seems to be an issue in that whenever a xata db is setup for Postgres, individual columns need to be formatted in a particular way.... columns named id, need to be named xata_id for instance. Setting up a xata db from a schema file, into a fresh Payload 3.0 project will get the tables to mount to Xata properly, however after upload, xata will say that it needs to configure the table headers and thats where the problem lies. It would be amazing if it worked. I'd be happy to help in any way I can.

Paul from discord said:

"we'd need to test it, im not sure but this doesnt sound like theyre following a very standard implementation of postgres..."
"you can open an issue with as much detail as you can though the biggest problem that i see is that xata protects the id column which we need"

It would be amazing if it worked. I'd be happy to help in any way I can.

I think that this was the schema file I was building off but any Payload-compatible schema file should do.
schema.xata.template.json