Fuzzy rank based relevant search in PostgreSQL.
In this article, I'll share how I've improved a search feature by ranking fuzzy string matches by applying
to_tsvector, phraseto_tsquery, ts_rank, similarity to the searched term.
let's say we need to search list of labs which name contains the character combination of 'medwhite'.
I'm saying contains since there might be names that are not an
Date: August 14, 2023, 9:54 am Author: Akram Hossain
Postgresql find foreign key references and reset primary key serial without truncate table
in this blog post i will try to explain how to find Postgresql foreign key references and reset primary key serial.
now question is why we need to find Postgresql foreign key references and reset primary key serial ?
sometime we have a scenerio where we need to reset the primary key for business need at
Date: July 22, 2022, 8:57 am Author: Akram Hossain