tudorg

10 ms·

91.
by tudorg 3y ago
This is fair, and it's a bit embarrassing but I copied the C version from an older tutorial without looking at it critical enough. Still, the Zig version gets the arguments as normal function parameters and doesn't need to call `P
92.
by tudorg 3y ago
I understood that reference, zombo :)
93.
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, b
94.
by tudorg 3y ago
It's for sure the question that a lot of people have. Initially we had more details about that in the blog post, but we didn't want it to become a "Zig vs Rust" blog post, so we kept it to a minimum. I will expand just a
95.
by tudorg 3y ago
It would be amazing if we could could use Zig for TLEs, and we'll look into it, but I worry it might not be possible because Zig can't guarantee memory safety in the same way that Rust can.
96.
by tudorg 3y ago
Ah, makes sense, thanks! And they do own the trademark, it seems.
97.
by tudorg 3y ago
I'm curious about something: I suppose Salvatore still owns the copyright for most of the code? The old license does include his copyright, up to 2020: https://github.com/redis/redis/blob/7.2/COPYING
98.
by tudorg 3y ago
Just to set a bit more context, there are two types of clusters in Xata, shared and dedicated. For shared, we indeed bundle the CPU/memory cost into storage. This is because, typically, a small database also won't consume too much
99.
by tudorg 3y ago
This is really cool, I love the idea of combining partitioning with foreign data wrappers to get sharded Postgres. I have tried it before and hit the same issue from the article: > However, on closer inspection, we can see that we didn’t
100.
by tudorg 3y ago
Hi, we were planning to announce this next week, because we're having a launch week, but it's nice to see pgzx already slowly gathering votes here :). We'll have a blog post where we talk more about the motivation behind it,
101.
by tudorg 3y ago
Nice work! I like that it's both a library and a server right from the start. Will it be able to generate INSERT/UPDATE statements to apply the differences?
102.
by tudorg 3y ago
> We introduce ExaLogLog (ELL), which is based on a recently proposed generalization of earlier data structures such as HLL, EHLL, and PCSA [17]. However, the geometric distribution of the update values is replaced by a distribution for
103.
by tudorg 3y ago
Hey, SQL over HTTP is possible now in Xata, and direct Postgres access will be possible _real soon_.
104.
by tudorg 3y ago
A good way to think about it is that any operation for which Postgres needs to inspect the existing data can block for a long time if there's a lot of data. For example, adding a unique constraint has to block. There is, however, a wor
105.
by tudorg 3y ago
Nice overview of pg-osc. I'd like to also mention pgroll, which has some similarities, but does this at column level rather than table level and takes things further: it can expose the old and new schema simultaneously (using views), w
106.
by tudorg 3y ago
> Update: I think I see what happened. Xata is a serverless DB service, and this is a tool they wrote that can be used independently of their service (I assume). The subscription options presented to the user look like they are related t
107.
by tudorg 3y ago
> Anyone know how well this works with very large datasets? The backfill sounds like it would take a while to do. It can take a long time, yes. It's somehow similar in that regard with, for example, gh-ost for Mysql that also does b
108.
by tudorg 3y ago
Sorry about it, small glitch with our blog as we tried to fix something in the title and accidentally broke the metadata for it :)
109.
by tudorg 3y ago
Ah yes, good catch! Fixing..
110.
by tudorg 3y ago
Yes, that's exactly it. I generally agree with "always move forward" but if rolling back is as easy as dropping the "new" view, that makes it a lot less scary.
111.
by tudorg 3y ago
Great question! Reshape was definitely a source of inspiration, and in fact, our first PoC version was based on it. We decided to start a new project for a couple of reasons. First, we preferred it to have it in Go, so we can integrated it
112.
by tudorg 3y ago
hey HN, repo is here: https://github.com/xataio/pgroll Would love to hear your thoughts!
113.
by tudorg 3y ago
This is a fantastic article! It shows that even simple migrations (like adding or removing a column) can be quite tricky to deploy in concert with the application deployement. We (at Xata) have tried for a while to come up with a generic sc
114.
by tudorg 3y ago
If you are using Postgres, I think you can create a view for each table and put all the views in a schema, then you switch the app all at once by using `SET search_path TO`.
115.
Running Python in the browser to create a playground(xata.io)
1 points by tudorg 3y ago|0 comments
116.
by tudorg 3y ago
hey HN, and thank you todsacerdoti for posting it! This is a feature that we wanted for a long time, but we also wanted to get it right. It's somehow the equivalent of storing files and images in an S3 bucket and then putting URLs to t
117.
by tudorg 3y ago
I think Azure offers sharding via Citus: https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql... Then, there's the Postgres compatible offerings like CockroachDB and Yugabyte that do sharding tra
118.
by tudorg 3y ago
That sounds interesting, are you using `ts_rank` or otherwise sorting by relevancy?
119.
by tudorg 3y ago
[author] Part 1 was on HN last week here: https://news.ycombinator.com/item?id=36699016 Happy to answer any questions. As with any DB comparison, it's tricky and I might have errors or I might have missed obvious thing
120.
by tudorg 3y ago
I posted the follow-up here: https://xata.io/blog/postgres-full-text-search-postgres-vs-e...

More ›