Xata
p/xata
Serverless database platform powered by PostgreSQL
Alex Francoeur
Serverless PostgreSQL Platform by Xata — Postgres, powered up
Featured
20
Xata: PostgreSQL's data platform. Connect with any PostgreSQL client. Enjoy instant database creation, branches, zero cold starts or pausing, full-text and vector search, file attachments, and more. Xata's free tier is among the most generous for PostgreSQL.
Replies
Alex Francoeur
Hey PH community! Alex here, head of product at Xata 👋 We're really excited about todays launch as it marks the next major step in the evolution of Xata. Since the beginning our mission has been to radically simplify the way developers work with data. I'm proud to say that we've stayed true to that mission and up until now, have been able to accomplish it by abstracting away the underlying databases. With todays announcement, we are unleashing the elephant with our brand new serverless PostgreSQL service. This means you can connect to your Xata database using any PostgreSQL client, while still keeping everything that you love about Xata. A collaborative interface, instant database creation, git-like branching, zero cold starts or pausing because of inactivity, a full-text and vector search engine, file attachments, and much more. We aim to provide your entire data layer as a service and are building our platform with PostgreSQL at its core. This was a pretty interesting technical challenge and if you're interested in learning more, you can check out our launch blog for more details. Product Hunt fam 🐱, I think you'll really enjoy this. We actually did record a "meet the makers" video if you'd like to learn more about our investment in PostgreSQL from our CEO and meet the developers behind our brand new service. It's a fun informal chat with the amazing people that made this release possible. Starting today, you can use PostgreSQL enabled databases as part of our public beta. With our shared cluster architecture, we're able to provide one of the best PostgreSQL free tiers in the industry and we'd love for you to take it for a spin with your next project. Our team is really excited about this release and if you're able to dive in, we'd love to know what you think and are open to any and all feedback. Happy building 🦋
Alex Francoeur
@antonikozelski Thank you so much for the support and feedback! Can't wait to hear what you think :-)
Jesse Ouellette
@alexf_19 unbelievable platform you’ve built. I’m a happy customer and it’s excellent quality and great support!
Timi Lab
Congratulations on the launch. I've been a very big Xata fan since this year. Was using MongoDB as my database before, but when I heard about Xata, I knew I had to jump in on this, and I can say that you all are doing an amazing job.
Alex Francoeur
Thank you for the support @timi_lab! 🫶
c
I've been using Xata with Next.js/Remix for a few months now. The support via discord is quite fast. While it seems that their main effort is to position themselves as a Postgres platform, and their recent OSS contributions (pgzx, pgroll) are proof of that, Xata is also a very unknown alternative to Algolia -like Meilisearch and Typesense- via their out of the box Postgres-Elasticsearch for full-text search replication, which imo they should promote a bit more!
Alex Francoeur
@camiaei Thank you for the support and being such an avid user! Our integrated search and file storage capabilities are certainly part of the benefits of our platform. Noted, we'll promote that more ✅ 😃 🦋
Congrats on the launch @alexf_19 and Team Xata 🚀 As a big fan of Postgresql I really love your latest product direction. I have a few questions: - Can Xata be used for "infinitely scalable" data storage? Example use case: powering social media feeds of millions of followers who follow famous people - What is the latency like to communicate with a Xatabase from an AWS or GCP hosted web app?
Alexis Rico
Hey @jgani! Thanks 🚀 During our launch week we also announced a new upcoming feature, currently in private beta, that covers that scenario: Postgres Dedicated Clusters. Thanks to the compute power of AWS we are able to spin up a dedicated database cell with all the scale benefits of Amazon Aurora for you. You can either configure a size for your instance or even use the auto-scaling feature. You can read more in https://xata.io/blog/postgres-de.... Regarding latency, talking to a hosted app in AWS in the same region will be very low since you will likely be in the same datacenter. For GCP or Azure, server to server latencies within the same region are also quite good when connecting to AWS.
Alex Francoeur
@jgani Thanks for the questions! It looks like @sferadev beat me to the answers. If you'd ever like to chat in more detail, you can find me in our Discord (https://xata.io/discord) or I'd be happy to hop on a quick Zoom and hash out any details. Have a great rest of your week 🙂
@sferadev @alexf_19 Thanks Alex. I'm not on that scale yet at the moment. I'm keeping my architecture old school and simple. I asked the questions to help educate people about Xata :)
Matt Carroll
very cool! Love seeing more options in this space as psql is the database i want to use for the rest of my life :) One thing that excite me here are built in file uploads. I always punt as long as I can to integrate a durable storage layer like s3, so it's cool to roll that right into the db layer itself! How should i think about this relative to something like SQLAlchemy? it seems like your SDK would replace SQLAlchemy? Could i use xata as my database layer but still keep my SQLAlchemy ORM in place? they both seem built on psycopg2 so maybe? thanks for sharing and shipping! also your free tier seems super reasonable, so thank you! One thing i saw when perusing the docs: # Pull down schema changes a generate Typings xata pull --> maybe should be `changes and generate Typings`? all the best!
Alex Francoeur
@catt_marroll first and foremost, thanks for the docs suggestions, great catch! I can't seem to find that specific text for some reason, but if you scroll up to the top of the page there should be an "edit in GitHub" option. Could you share that link? Or if you'd like, you could create an issue or PR. Either way, if you send it along we can get that fixed quickly. If you're most interested in file attachments, our TypeScript, Python and Go SDKs provide the best out of the box experience. We also offer SQL helper functions directly in those SDKs too if you'd prefer to use SQL directly. That being said, assuming you can just drop a PostgreSQL connection string into SQLAlchemy (which looks to be the case) you could use SQLAlchemy directly as well. Here are some docs on connecting with psycopg2: https://xata.io/docs/python-psyc... Thank you for the support, feedback in questions 🙏 If you'd like to chat in more detail, we can continue here, carry it over to our discord (https://xata.io/discord) or hop on a quick zoom sometime.
Matt Carroll
@alexf_19 if you go to https://xata.io/docs and scroll down to "Install the CLI" on that page, you'll see it in the code block right below. I took a look at the repo for the docs and i dont see that "landing page" in there (i see the edit button you are talking about on other pages but not that one). lmk if that isnt clear and i can drop you can email! wrt using the product, thanks for the info :) I am currently using RDS for an app im developing, but ill try plugging and playing with xata and when I get a bit of time. again thanks for the generous free tier which makes it really compelling. Ill reach out if i get blocked on anything!
Alex Francoeur
@catt_marroll Perfect, I see it now. Thank you! If you end up trying us out, I'd love to learn more about what you're building. Have a great rest of the week!
Parker Dinkins
I started using Xata after trying a few other solutions on the market. It is amazing!!!! I was able to get my database set up and and API to access it from my application in one day. It has allowed me to spend less time on infrastructure and more time building my application. I ran into a problem one day and was able to get help almost immediately in their discord. My application would not be where it is today without Xata's customer service, easy to use product, and amazing documentation.
Alex Francoeur
@parker_dinkins you're amazing, thank you for the support! 🫶