[DB/SQL] Search & Filter Query Optimization #4

New issue

Open

opened 2025-11-23 08:30:37 +00:00 by 22360255 · 0 comments

22360255 commented

2025-11-23 08:30:37 +00:00

Member

Priority: High
Assignee: DB Specialist
Context: Rust needs a high-performance query to filter projects without loading everything into memory.
Tasks:

Write a raw SQL query (compatible with Postgres 16) that:

    Accepts a search string parameter $1.

    Performs case-insensitive search (ILIKE) on title AND abstract.

    Filters by is_public = true.

    Orders by created_at DESC.

Bonus: Create a Gin Index on title for speed.
Definition of Done:

Deliver the .sql file to the Backend Lead.

Query execution time is < 50ms on the test dataset.

Priority: High Assignee: DB Specialist Context: Rust needs a high-performance query to filter projects without loading everything into memory. Tasks: Write a raw SQL query (compatible with Postgres 16) that: Accepts a search string parameter $1. Performs case-insensitive search (ILIKE) on title AND abstract. Filters by is_public = true. Orders by created_at DESC. Bonus: Create a Gin Index on title for speed. Definition of Done: Deliver the .sql file to the Backend Lead. Query execution time is < 50ms on the test dataset.