Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
zombodb
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
6 ms
·
1.
▲
by
zombodb
7d ago
> Your only duty is to abide by the license. We live in a society. I don’t see any harm in believing we ought to be respectful of the work. That’s all I’m saying. You don’t have to be, but it’s a better world if you are. > If you wan
2.
▲
by
zombodb
7d ago
Over Postgres' FTS, TIN provides at least: - superior performance - superior operational overhead - no second copy of data in tsvector form - BM25 scoring support with optimized top-k output - runtime configurable scoring k
3.
▲
by
zombodb
7d ago
I thought I was clear: > When one develops using open-source software they have an obligation to follow the licenses. Obviously what follows from one of those licenses is what you say. I’m glad we agree!
4.
▲
by
zombodb
7d ago
It’s clear that we’re on opposite ends of open-source ideology. Good luck out there! 2026 is wild times!!
5.
▲
by
zombodb
7d ago
When one develops using open-source software they have an obligation to follow the licenses. They also have a moral obligation to be respectful of the work upon which they’re building. And they have a social obligation to help improve that
6.
▲
by
zombodb
7d ago
Why don’t you like Postgres’ license? It’s as permissive as a license gets.
7.
▲
by
zombodb
7d ago
They also end up with all the infrastructure and processes necessary to keep the external search system in sync, resync/reindex, pkey shipping back to their source of truth in queries, application-side joins and enrichment between both
8.
▲
by
zombodb
7d ago
I’m one of TIN’s developers and if you google my username you’ll see I’ve been in this space for a long time. The answer to your first question is simply: yes As far as your second question, what customization do you need that you believe T
9.
▲
Tin: A Text INdex for Postgres
(planetscale.com)
1 points
by
zombodb
10d ago
|
0 comments
10.
▲
by
zombodb
1y ago
Shout out to grapeseed oil
11.
▲
by
zombodb
2y ago
Yup. Just under a 501c3 to help ensure pgrx outlives us. Huge thanks to TCDI (www.tcdi.com) for continuing to fund development.
12.
▲
by
zombodb
3y ago
Y'all have built something cool. I'm excited to see where it goes from here. If there's anything the pgrx team can do to help, just let us know.
13.
▲
by
zombodb
3y ago
If you build it, they'll come. The only limit is yourself!
14.
▲
by
zombodb
3y ago
Nice deck, Ryan! And thanks for the mentions. ;)
15.
▲
by
zombodb
3y ago
I think maybe what you’re really looking for are the files here: https://github.com/pgcentralfoundation/pgrx/tree/c2eac033856... Those are the internals we currently expose as unsafe “sys” bindings. As we&#x
16.
▲
by
zombodb
3y ago
I don’t think we even expose the TableAM APIs? They are incredibly hard to generate bindings for from the C headers — lots of inline functions and complex #define macros. We have an ambitious goal with pgrx and it’s going to take many year
17.
▲
by
zombodb
3y ago
Thank you. I’ll pass this on to the team.
18.
▲
by
zombodb
3y ago
If you’re aware of bugs that fall within plrust’s domain we’d appreciate any and all reports via GitHub!
19.
▲
by
zombodb
4y ago
Always nice to see pgx being used in the wild! Awesome work.
20.
▲
by
zombodb
5y ago
I don’t pay any attention to what the cloud providers are doing. I have no control over them so….. eh. ZDB is still alive and well but I have a real job now too.
21.
▲
by
zombodb
5y ago
I can definitely reword that if it's confusing.
22.
▲
by
zombodb
5y ago
> Doing so would require ElasticSearch to reach consensus on every read/write ZomboDB only requires that ES have a view of its index that's consistent with the active Postgres transaction snapshot. ZDB handles this by ensuring
23.
▲
by
zombodb
5y ago
I wonder what the ZomboDB developers are up to now? What great text-search-in-postgres things could they be secretly working on?
24.
▲
by
zombodb
6y ago
https://github.com/zombodb/pgx/releases/tag/v0.0.7 !boom!
25.
▲
by
zombodb
6y ago
I'd be inclined to agree. That said, it'd be easy to prototype with pgx, assuming that compression library exists in the Rust ecosystem too?
26.
▲
by
zombodb
6y ago
I've noodled the idea of a pl/pg_rust, but the whole "Cargo.toml" and downloading dependencies from the internet seems bad. I see what you're saying about no_std tho. Could be doable.
27.
▲
by
zombodb
6y ago
That is interesting. pgx does a lot of that too, but for only pg10/11/12. And then it post-processes the bindings and builds a "common.rs" for symbols that are identical across versions. That way you can target all thre
28.
▲
by
zombodb
6y ago
blush
29.
▲
by
zombodb
6y ago
Sure! Top is Postgres, bottom is pgx, after running each 5 times... test=# SELECT count(*) FROM (SELECT generate_series(1, 10000000)) s; count ---------- 10000000 (1 row) Time: 399.630 ms test=# SELECT
30.
▲
by
zombodb
6y ago
Yes there is. It's not documented/example'd yet tho. There's a derive macro called #[derive(PostgresType)]. Combine that with serde's Serialize, Deserialize, and you're gtg. I'm going to be working on mo
More ›