notNull constraint without default
Provide a strict "Not null" column constraint to require a column value or otherwise reject the record.
I want to serve clients all over the world without having to compromise on latency. Something like read-replicas in multiple regions. The goal would be to call one single endpoint and let Xata take care of redirecting the query to the nearest database.
Ability to duplicate table with data copied over
Would asking for a "table duplication feature" be too much? You select your table of interest and copy it to a new table with a new name, including data. From Twitter: https://twitter.com/GayriSafi3/status/1704349305862000751
Total result count in paginated queries
Include the total number of results in the response of paginated queries. Similar to https://feedback.xata.io/feature-requests/p/include-total-hits-in-search-response From Discord: https://discord.com/channels/996791218879086662/996791219348852836/1152677810842914887
Local version of Xata
From Discord: I'm currently testing Xata for my project, and I noticed that to use the cloud version of Xata, I need to integrate my local application with Xata library, SDK, or API. I'm wondering if there's a local version of Xata available in case of network disruptions. It would be ideal if the local Xata can automatically sync with the cloud version in both directions.
JSON column array operations
API and SDK support for pushing and popping items to / from arrays in JSON columns, without reading the content prior to the update.
Webhooks and Triggers
Provide support for hooks to act on events before and after a CRUD operation against a record. Use cases: custom validation rules, orchestration of internal or external events upon record updates.