Codxplore.com

Latest news:

Sahih al-Bukhari (সহীহ বুখারী) is a free Hadith application for android. This application is advertisement free. Download now https://play.google.com/store/apps/details?id=com.akramhossin.bukharisharif

967
Views
Fuzzy rank based relevant search in PostgreSQL.

Fuzzy rank based relevant search in PostgreSQL.

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
1255
Views
Postgresql find foreign key references and reset primary key serial without truncate table

Postgresql find foreign key references and reset primary key serial without truncate table

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

Subscribe Us


Follow Us