3 ms·
We're referring more to the "data platform" part. What we mean by a "Postgres data platform" (and arguably it's not an widely accepted term, so take it with a g
by tudorg 3y ago
We're referring more to the "data platform" part. What we mean by a "Postgres data platform" (and arguably it's not an widely accepted term, so take it with a grain of salt) is that you get not only Postgres, but secondary data stores around it, more tightly integrated than in a typical cloud provider:
- Elasticsearch, to which we replicate data automatically via CDC
- Blob storage for file attachments, we use S3 to store the files and Cloudflare to cache them on CDN
- (in the future) Caching
- (in the future) Time-series databases, again with automatic replication from Postgres
That said, you can use just the Postgres part, and we are very happy if you do.
- nop_slide 3y agoEdited my comment above, but this looks really rad. I made an account and going to try porting a side project DB to it later! Particularly we need to improve our search and I've been lazy about tweaking our ts_vector setup.
- nextaccountic 3y ago> Elasticsearch Do you use zombodb? https://github.com/zombodb/zombodb https://github.com/zombodb/zombodb
- bear9628 3y agoYou can get an overview of the platform in this Post: https://xata.io/blog/serverless-postgres-platform#the-platform https://xata.io/blog/serverless-postgres-platform#the-platfo... Zombodb is a really cool project, but no, we don't use it. We use logical replication and triggers to also capture schema changes with your records into an event stream. The event stream is used to send your data to Elasticsearch (and create/update the index). See: https://xata.io/blog/serverless-postgres-platform#logical-replication-events https://xata.io/blog/serverless-postgres-platform#logical-re... Stay tuned, we are planning to open source this component as well.