On Tue, Dec 21, 2010 at 1:46 PM, Greg Weber
mongoDB does not have LIKE. But it has regular expressions, so LIKE is easy to implement. I doubt Redis has anything here. A true key-value store like Redis already doesn't make much sense with the filtering 'Where' queries. I think of Persistent not as a key-value friendly store, but as a noSQL friendly interface (no joins) that something like MongoDB fits in well. The other think to think about is creating better capabilities for allowing users to use arbitrary SQL (or mongo queries) with Persistent.
For the SQL backends, I think the problem is that it is not well documented and could probably have a nice wrapper put around it. However, running arbitrary queries is definitely supported, and I've done it in the past to implement full-text search. For those interested, you'll want the withStmt and execute functions from Database.Persist.GenericSql.Raw[1]. This is yet another thing I should write a blog post/section in the Yesod book about. Michael [1] http://hackage.haskell.org/packages/archive/persistent/0.3.1.3/doc/html/Data...