`SupabaseGroongaDocumentStore` and `SupabaseGroongaRetriever`

[davidsbatista]

Implement SupabaseGroongaDocumentStore and SupabaseGroongaRetriever for full-text search powered by PGroonga, a PostgreSQL extension for fast, multilingual full-text search exposed by Supabase.

Detailed design

This retriever works without embeddings, complementing dense retrieval in hybrid search pipelines.

from haystack_integrations.document_stores.supabase import SupabaseGroongaDocumentStore
from haystack_integrations.components.retrievers.supabase import SupabaseGroongaRetriever

document_store = SupabaseGroongaDocumentStore(
    supabase_url="https://<project>.supabase.co",
    supabase_key=Secret.from_env_var("SUPABASE_SERVICE_KEY"),
    table_name="haystack_fts_documents",
)

retriever = SupabaseGroongaRetriever(document_store=document_store, top_k=10)

Implementation notes

• Primary dependency: supabase-py
• Auth via supabase_url and supabase_key (using Secret for secure handling)
• PGroonga must be enabled on the Supabase project — document this as a prerequisite
• Supports multilingual tokenization, relevant for non-English use cases
• Can be used alongside SupabasePgvectorEmbeddingRetriever in hybrid pipelines
• Integration lives in integrations/supabase/

Checklist

• The code is documented with docstrings and was merged into a feature branch

[ShubhamGond105]

Hi @davidsbatista @julian-risch

I'd like to work on this issue and implement SupabaseGroongaDocumentStore and SupabaseGroongaRetriever.

I had originally expressed interest in #3082 but @srini047 is already working on that one, so I'm moving here to avoid duplicating effort.

I've studied the recently merged PR #3164 (SupabasePgvectorDocumentStore) and plan to follow the same structure as a blueprint.

Before I start:

• Is PGroonga available and stable enough on Supabase to build against?
• Are there any design decisions or constraints I should be aware of upfront?

Happy to get started once I get your go-ahead. Thanks!

[ShubhamGond105]

Hi @davidsbatista — I've opened PR #3266
implementing SupabaseGroongaDocumentStore and SupabaseGroongaRetriever.
Happy to incorporate any feedback!