Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: Postgres extension for BM25 relevance-ranked full-text search

github.com

Post reply on HN
Print view View original

51–60 of 75 posts

Re: Show HN: Postgres extension for BM25 relevance-ranked full-text search

#51

Post by arnitdo »

piskov wrote: post #34

On a tangent note it’s amazing how hard it is to have a good case-insensitive search in Postgres. In SQL Server you just use case-insensitive collation (which is a default) and add an index (it’s the only one non-clustered) and call it a day. In postgres you need to go above and beyond just for that. It’s like postgres guys were “nah dog, everybody just uses lowercase; you don’t need to worry of people writing john d…

> And don’t get me started with storing datetime with timezone (e.g “4/2/2007 7:23:57 PM -07:00“). In sql server you have datetimeoffset; in Postgres you fuck off :-)

`TIMESTAMPTZ` / `TIMESTAMP WITH TIME ZONE` exists?

Re: Show HN: Postgres extension for BM25 relevance-ranked full-text search

#52

Post by legedemon »

piskov wrote: post #34

On a tangent note it’s amazing how hard it is to have a good case-insensitive search in Postgres. In SQL Server you just use case-insensitive collation (which is a default) and add an index (it’s the only one non-clustered) and call it a day. In postgres you need to go above and beyond just for that. It’s like postgres guys were “nah dog, everybody just uses lowercase; you don’t need to worry of people writing john d…

citext doesn't solve your problem of case-insensitive search?

Re: Show HN: Postgres extension for BM25 relevance-ranked full-text search

#56

Post by nopurpose »

arnitdo wrote: post #51
piskov wrote: post #34

On a tangent note it’s amazing how hard it is to have a good case-insensitive search in Postgres. In SQL Server you just use case-insensitive collation (which is a default) and add an index (it’s the only one non-clustered) and call it a day. In postgres you need to go above and beyond just for that. It’s like postgres guys were “nah dog, everybody just uses lowercase; you don’t need to worry of people writing john d…

> And don’t get me started with storing datetime with timezone (e.g “4/2/2007 7:23:57 PM -07:00“). In sql server you have datetimeoffset; in Postgres you fuck off :-) `TIMESTAMPTZ` / `TIMESTAMP WITH TIME ZONE` exists?

They dont store original timezone

Re: Show HN: Postgres extension for BM25 relevance-ranked full-text search

#57

Post by ellefire »

jascha_eng wrote: post #3

FWIW TJ is not your average vibe coder imo: https://www.linkedin.com/in/todd-j-green/ In september he burned through 3000$ in API credits though, but I think that's before we finally bought max plans for everyone that wanted it.

Is this meant to inspire confidence or fear?

Re: Show HN: Postgres extension for BM25 relevance-ranked full-text search

#60

Post by laundermedaddy »

lsaferite wrote: post #10
gplprotects wrote: post #6

> ParadeDB, is guarded behind AGPL What a wonderful ad for ParadeDB, and clear signal that "TigerData" is a pernicious entity.

You: > "TigerData" is a pernicious entity TigerData: > pg_textsearch v1.0 is freely available via open source (Postgres license) They deemed AGPL untenable for their business and decided to create an OSS solution that used a license they were comfortable with and they are somehow "pernicious"? Perhaps take a moment to reflect on your characterization of a group that just contributed an alternative OSS project for a s…

Laundering actual freedom respecting licenses through genai may give the poster more freedom, but that additional freedom is solely to avoid sharing any improvements to the freedom respecting code they are benefiting from with others.
Post reply on HN