Feature Requests

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)

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.

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.

Provide enum data type, or constraints on the multiple type. Use case: define a specific set of values an array column can have.

Store geolocation data (lat/lon coordinates) in a dedicated column type. Support geo bounding queries based on shapes (such us box) on geolocation columns.

Add password field as a column type. Allow choosing password hash algorithm. Add password checking to SDK.

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.

Provide self-service backup and restore features