Tuan Doblog.tuando.me·Nov 22, 2024Vietnamese Full-Text Search on PostgreSQLInstall extensions CREATE EXTENSION IF NOT EXISTS unaccent; CREATE EXTENSION vector SCHEMA "public" VERSION 0.7.2; Use a custom text search configuration CREATE TEXT SEARCH CONFIGURATION vietnamese (COPY = simple); ALTER TEXT SEARCH CONFIGURATION vi...PostgreSQL
Alexander Arlund Nørgaardblog.alexnorgaard.dk·Nov 3, 2024Building an Events Application: Querying events and indexing with GINIn my last blog post we explored how to expose a simple API using the Echo Go framework and GORM ORM. We also took a look at how I wanted to represent an event in the database, including using tags and geolocation for search and filtering purposes. G...PostgreSQL
Olalekan Adekolalexyblazy.hashnode.dev·Oct 18, 2024Let's build a Full-Text Search engine (Part 2)“Where is part one?” asked the reader. Part one was written by Artem Krylysov and is a prerequisite to understanding this article. You can find part one here. I’d like to mention that besides introducing a disk-based persistence layer for the projec...68 readsGo Language
Milan Jovanovićmilanjovanovic.hashnode.dev·Sep 21, 2024How I Implemented Full-Text Search On My WebsiteSo, I've got this blog I've been running for a couple of years now. It's a Next.js and TypeScript static site, all optimized for SEO. Sounds pretty standard, right? Well, it was, until I ran into a problem. As my content grew, finding specific articl....NET
Jinjing Zhouforpgvecto.rsblog.pgvecto.rs·Jun 14, 2024pg_bestmatch.rs: Elevate Your PostgreSQL Text Queries with BM25We're excited to announce the release of pg_bestmatch.rs, a PostgreSQL extension that brings the power of Best Matching 25 Score (BM25) text queries to your database, enhancing your ability to perform efficient and accurate text retrieval. This exten...1 like·3.9K readsRAG
Webhortizwebhortiz.hashnode.dev·Apr 21, 2024Explore fulltext search in laravel 10, 11 with RelationsWhile using LIKE operator in laravel can basically get the job done in Laravel when working on simple applications with small datasets Fulltext allows you to perform efficient searches on large text-based data. It is particularly useful when you need...Natural language search Laravel
Melvinmelvinkoh.me·Jan 22, 2024Building a Simple Yet Powerful Search Feature with RedisWhile numerous software options exist for building search features, they can often be overkill for simpler use cases, especially when dealing with less voluminous data. This article presents a solution for constructing a search feature using Redis. W...101 readsRedis
Eray Erdinerayerdin.com·Dec 29, 2023No, I ain't paying for full-text search | Implementing Full-Text Search in FirestoreIt's been a long time since I haven't posted anything here. The life, the work, the hustle, everything's been going hard on me these days. I've switched my mother tongue to Satirish™. This is not my best piece of writing, so viewer discretion is a mu...646 readsFirebase
Kiều Tâm Đỉnhleonardkieu.hashnode.dev·Dec 29, 2023[PostgreSQL Scaling and Optimization] How to search on 10 GB data (1 million rows) within 5 ms?Warning This article will help you to make a full text search API on PostgreSQL - a kind of text and retrieval problem. Nowadays, in large-scale system, people usually decouple write-heavy DB and read-heavy DB, not one for all. Example: using Postg...1 like·299 readsComputer SciencePostgreSQL
Idiomatic Programmersidiomaticprogrammers.hashnode.dev·Dec 14, 2023Adding Full Text Search to Your Django App with django-watsonIn today's blog post, we're going to explore how you can enhance the search functionality of your Django application by integrating Django Watson. Why Use Django Watson? When you use Django Watson, it's like giving your Django app a smart search upgr...43 readsPython