Full-text search and other searches with Data Connect

SQL Connect, formerly Firebase Data Connect, now supports PostgreSQL-powered full-text search alongside string pattern filtering and vector similarity search, offering developers different approaches for querying application data. String filters provide exact, case-sensitive text or regular-expression matches and can be combined with other field constraints, while vector search uses Agent Platform embeddings to find semantically similar content within one column. Full-text search operates across multiple schema fields marked with the `@searchable` directive, supports stemming and four query formats—QUERY, PLAIN, PHRASE, and ADVANCED—and does not require AI services. Although full-text search is effective for large datasets and multi-column lexical queries, vector search is better for conceptual similarity such as matching “car” with “automobile,” while simple filters require the least storage and memory but may perform less well on large documents.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.