Am I forced to use Xata_id?
I'd want to use a numeric primary key if possible, secondly, I'd probably want to remove xata_id all together
2 Replies
Certainly, you can set up your own primary key via the postgres wire protocol (with e.g. psql), there isn't any restriction for it. The xata_id is only required for the UI and other added features (Search, File attachments etc) to function so if you remove it these components won't work. You can create tables and manage schema with DDL statements, in which case the UI will prompt you to "Adapt" your table which adds the xata internal columns. You can use Xata as a "vanilla" Postgres without adapting tables.
We're also working on making the UI work without the xata_id, as long as there is a primary key set. This enhancement should be available by next month.
Gotcha, thanks for the help!