Full-Text Search

Basic FTS

TypeScript

const results = await pulsabase.from(Article)
  .whereFts(['title', 'body'], 'typescript tutorial')
  .find();

Dart

final results = await pulsabase.from('articles')
    .where(r'$fts', {
      'fields': ['title', 'body'],
      'query': 'typescript tutorial',
    })
    .find();

With Language

const results = await pulsabase.from(Article)
  .whereFts(['title', 'body'], 'développement web', { language: 'french' })
  .find();

Supported languages: english, french, german, spanish, portuguese, and all PostgreSQL dictionaries.