Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google Cloud Datastore: Full text search?

I am developing a database app using Google Cloud Datastore but don't see any built-in way of doing full-text search on fields. Is there a google-cloud-native solution?

The alternative I see is either:

  1. Do full text search application side (read in each row, find matches)

  2. dupe the fields that need to be full-text-indexed into some other product like Google Cloud Sql (mysql) and use it's full-text-search capabilities instead.

like image 687
JasonS Avatar asked Oct 29 '16 18:10

JasonS


People also ask

What is meant by full text search?

Full-text search refers to searching some text inside extensive text data stored electronically and returning results that contain some or all of the words from the query. In contrast, traditional search would return exact matches.

Is Google Datastore deprecated?

Because Cloud Datastore API v1 is released, Cloud Datastore API v1beta3 is now deprecated.

What is indexing in Datastore?

As described above, a Datastore mode database creates an entry in a predefined index for every property of every entity except those you have explicitly declared as excluded from your indexes. The property may also be included in additional, custom indexes declared in your index configuration file ( index. yaml ).


1 Answers

You might want to look into the App Engine search API as an alternative to duplicating fields into Cloud SQL for full text search.

You still need to duplicate the data into documents/indexes but you only pay per queries and storage.

like image 110
danielx Avatar answered Dec 23 '22 11:12

danielx