Array column type
Support array column type of string, integer, decimal, object, link type. Provide standard array management operations such as pop and push. Provide aggregation capabilities on the array content such as: aggregations (sum, avg, min, max, count, unique count) filters (gt,lt, eq) sorting (asc,desc)
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.
Add support for real-time/subscriptions
Support BaaS-like real-time subscriptions. This depends on having security rules and the ability to call Xata from the browser, so https://feedback.xata.io/feature-requests/p/row-level-security is related.
Geopoint column type and query support
Store geolocation data (lat/lon coordinates) in a dedicated column type. Support geo bounding queries based on shapes (such us box) on geolocation columns.
UI import schema from json
Similar to the CLI's capability (xata init --schema filename.json, xata schema edit --source, xata schema upload schema.json) for creating or updating a database from an existing schema file, provide the option in the web UI to import schema from json in order to initiate or update a database/branch.
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.
Add password field as a column type. Allow choosing password hash algorithm. Add password checking to SDK.