zombodb

7 ms·

31.
by zombodb 6y ago
Fair. With pgx, however, Rust "panic!"s are translated into standard Postgres "ERROR"s, such that instead of crashing, only the current transaction aborts. So while you're pretty much correct in general, pgx handle
32.
by zombodb 6y ago
That's a great question, and one probably best answered over on pgx's GitHub page. But! I plan on adding a command to "cargo-pgx" to package up the extension for you into a directory structure (or tarball, maybe). The i
33.
by zombodb 6y ago
One more follow-up... The top one is pgx, the bottom is Postgres. So there's a little room for improvement here with pgx, but that's okay for a v0.0.3 release. test=# select count(*) from srf.generate_series(1, 10000000);
34.
by zombodb 6y ago
Thank you! If you decide to jump into it, definitely let us know any pain points you have. It takes a bit of time to work out the kinks in a thing like this.
35.
by zombodb 6y ago
As a follow-up. Here's what Postgres' "generate_series" function looks like with pgx: https://github.com/zombodb/pgx/blob/0803bd3aa2f8ef2bd80d2e03... And here's what you'd have
36.
by zombodb 6y ago
re: v0.0.3 -- sure. I just published it last night. We've been working on it since November last year, and have now fully ported ZomboDB to it. It's proving out nicely, but keep in mind that Postgres' internals are infinitel
37.
by zombodb 6y ago
I've looked into them. It seems they're designed to work within a single process, and it's not quite clear to me how sharing the underlying data files across postgres backends (even with proper Postgres locking) would work.
38.
by zombodb 6y ago
Yeah, "rich data types" is a good point. pgx provides a #[derive(PostgresType)] macro that lets you represent any normal Rust struct (that serde_cbor can (de)serialize) as a Postgres type. You write no code. It even generates all
39.
by zombodb 6y ago
`pgx` would let you do that. You could hook Postgres "emit_log_hook" and probably just use serde to xform the provided "ErrorData" pointer right to json and ship it off where ever you want. (edit: typeos)
40.
by zombodb 6y ago
You're not wrong, but barring bugs in `pgx` (of which I'm sure there are plenty right now), at least Rust gives you compile-time guarantees around not crashing. And when running inside your database process, that's a huge win
41.
by zombodb 6y ago
Author of `pgx` here. We developed pgx so that we could rewrite "ZomboDB" ( https://github.com/zombodb/zombodb ) in Rust. ZDB is a custom "Index Access Method" for Postgres. Think btree index, but s
42.
by zombodb 7y ago
Thanks for the positive feedback. I'm sorry your project didn't go in a direction where ZDB would be useful, but I'm thrilled you had a positive experience with ZomboDB.
43.
by zombodb 7y ago
ZomboDB developer here. With ZDB you don't need tsvector at all. With a properly defined mapping, Elasticsearch can do the stemming for dozens of languages, including English. ZDB exposes darn near everything ES supports.
44.
by zombodb 8y ago
Thanks! It’s been fun to develop it and we love when people discover and use it
45.
by zombodb 10y ago
As the developer, I do! Feel free to email the mailing list (zombodb@googlegroups.com). I'd be happy to help answer any questions you might have
46.
by zombodb 11y ago
Let me try to be a little less vague here (I guess to much time has passed to edit?). In general, we developed this for searching structured (but not necessarily relational) full-text content with an enormous amount of associated metadata.
47.
by zombodb 11y ago
I'm just some guy on the Internet that is fortunate enough to be able bring a thing he's spent the past two years working on behind closed doors to the public. I haven't participated in open-source since 1999 (no, really) so
48.
by zombodb 11y ago
It was built as _the_ search platform for a web-based document search and review system, providing real-time search, analytics, and high-volume updates.
49.
by zombodb 11y ago
That's a good question and a point of improvement for the documentation. What I was trying to get across by saying that it's not "crash safe" is that the Elasticsearch index is not WAL logged. As such, if Postgres cr
50.
by zombodb 11y ago
Despite being the developer, I understand where you're coming from. It's always hard to choose an open-source project and decide that you're going to base an important part of your "app" on it. ZomboDB hit github o
51.
by zombodb 11y ago
You can at least execute unstructured queries against your structured data, and stay transactionally safe while doing so. Maybe it's not anything, but it's at least something. ;)
52.
by zombodb 11y ago
You're welcome. It's hard not to when you've spent so much of your career using quality products like Postgres.
53.
by zombodb 11y ago
ZomboDB developer here. I don't frequent HN so please forgive any missteps... Just wanted to say that while the code has proven itself production worthy, I'm still re-writing documentation and the test suite and that stuff is goi