top | item 43910441

(no title)

cssanchez | 10 months ago

My experience with PG ended a few years ago. The thing that killed PG for me is the lack of collation for searches. I haven't tested since the last updates that mentioned something along these lines, so this may have improved.

PG for years relied on unaccent which is not a true solution as it requires manually storing two versions of a text (the original and the un-accented one) and handle indexes + searches manually for each field... Not to mention unaccent itself is an extension you have to install. Whereas collation is built-in and it just works by handling it all under the hood in SQL Server. This feature alone is worth switching databases for my use cases.

That and the updates being a royal pain.

discuss

order