Show HN: Xata, serverless database on top of PostgreSQL and Elasticsearch

Re:Show HN: Xata, serverless database on top of PostgreSQL a... by tudorg on Wednesday November 02, 2022 @04:58AM (#33432964)

> Although I'm a bit bummed out because all sql syntax has been striped out, which makes sense, since we are no longer dealing with just sql here.

Yes, we are hoping to add support for SQL as well, but we need to intermediate the API calls for a bunch of interesting features.

> I got one question though, I see the api calls for migrations, but is there a step by step guide on how we can actually do a migration?

We don't have docs for yet, but it's a UI driven process which resembles GitHub PRs, so it should be pretty straightforward.

[ Parent | on HN ]

Re:Show HN: Xata, serverless database on top of PostgreSQL a... by ranguna on Wednesday November 02, 2022 @12:53PM (#33438961)

> UI driven process

Interesting, although not something I personally like. I'm more used to doing this automatically through pipelines.

Are there any plans to add an automated process, without ui or anything like that?

Fully automated through the cli, like the terraform apply command or sequelize migrations.

[ Parent | on HN ]

Re:Show HN: Xata, serverless database on top of PostgreSQL a... by tudorg on Wednesday November 02, 2022 @03:20PM (#33441502)

Ah yes, that makes sense and we should be able to do that based on the API. The migrations are ultimately JSON documents.

[ Parent | on HN ]

Re:Show HN: Xata, serverless database on top of PostgreSQL a... by ranguna on Thursday November 03, 2022 @04:41AM (#33448468)

Awesome!

Will monitor the docs page for this.

[ Parent | on HN ]