[google-appengine] Re: "like" operator in GQL

2017-06-07 Thread 'George (Cloud Platform Support)' via Google App Engine
Indeed, the general imperative for scalability in App Engine is at odds with possible queries that would result in table scans. You may read more on the topic from the accepted reply to the *"Google App Engine: Is it possible to do a Gql LIKE query?"* question

[google-appengine] Re: "like" operator in GQL

2017-06-06 Thread Kunal Pariani
This kind of query worked but i imagine this breaks the whole "Cloud Datastore reads scale because the only queries supported are those whose performance scales with the size of the result set (as opposed to the data set)" concept. So doesn't that decrease the value of using Datastore at the fir

Re: [google-appengine] Re: "like" operator in GQL

2011-09-28 Thread Niklas Rosencrantz
If I had to implement something like GQL "like" I think I would try to build many queries or a method like GQL IN without the limitations GQL IN has. I think non-rel db:s handles one problem much better: Everything from a HTTP request is a string like a parameter representing a boolean value must h

[google-appengine] Re: "like" operator in GQL

2011-09-28 Thread roberto.cr
there are many differences between traditional relational databases (like mysql) versus non-relational databases, aka nosql (like gae's datastore) but yes, "Full-text search over Datastore" is coming really soon App Engine Product Roadmap http://code.google.com/intl/en/appengine/docs/roadmap.html

Re: [google-appengine] Re: "like" operator in GQL

2011-09-28 Thread Niklas Rosencrantz
These are among the drawbacks, minuses and reasons why app engine should be cheaper than traditional hosting: - no join, no like, no full text search while sql-based system have these - extremely difficult to migrate from M/S to HRD while sql-based system usually can migrate even large blobs - site

[google-appengine] Re: "like" operator in GQL

2011-09-28 Thread bbaychev
Have you tried SQLite syntax? On Sep 26, 11:55 pm, someone1 wrote: > Not available in GQL but I've had success utilizing IndexTank for full- > text search capabilities with AppEngine > > On Sep 25, 2:55 pm, Bruce Aloe wrote:> Hello, > > > SQL supports "like" operator. I am wondering whether GQL

[google-appengine] Re: "like" operator in GQL

2011-09-26 Thread someone1
Not available in GQL but I've had success utilizing IndexTank for full- text search capabilities with AppEngine On Sep 25, 2:55 pm, Bruce Aloe wrote: > Hello, > > SQL supports "like" operator. I am wondering whether GQL supports the > "like" operator or not. > > I have been looking at the GQL >

[google-appengine] Re: "like" operator in GQL

2011-09-25 Thread Niklas Rosencrantz
Depending on your use case you might want to stick with google search i.e. adding the google search box via adsense while waiting for google to offer the full-text search functionality we require. Regards, Nick Rosencrantz -- You received this message because you are subscribed to the Google G

[google-appengine] Re: "like" operator in GQL

2011-09-25 Thread David
It's not exactly like the LIKE statement, but this should work in a similar fashion and return similar results for a LIKE 'abc%' select * from MyEntity where myField >= 'abc' and myField < 'abd' On Sep 25, 11:55 am, Bruce Aloe wrote: > Hello, > > SQL supports "like" operator. I am wondering whet