Directly connect to Postgres instance
Hi! I love working with the Xata UI and SDK!
I really miss some features like setting up Triggers and Indices myself. Will this be available with with the the roadmap item "Exposing PostgreSQL: Expose the PostgreSQL wire protocol to directly connect to the Xata PostgreSQL database and your favorite ORMs."?
When can we roughly expect to have this functionality?
3 Replies
We can't provide an exact day, but we're wrapping it up. I'm writing up docs for it now. Barring problems that come up in testing, you can expect it this month. Certain statements like creating indices will require an upgraded plan.
Cool! By upgraded you mean the "Pro" Plan? Triggers can be implemented as well, right?
Both triggers and indices will be supported over wire protocol, such features though may be available with dedicated infrastructure because they have system footprint that requires isolation.