Grails app: own query language for data stored in DB and files + full text search (Hibernate Search, Compass etc)

I have an application which stored short descriptive data in DB and lots of related textual data in text files.

I would like to add "advanced search" for DB. I was thinking about adding own query language like JIRA does (Jira Query Language). Then I thought about having full text search across those textual files (less priority).

Wondering which tool will better suite me to implement that faster and simpler.

I most of all I want to provide users with ability to write their own queries instead of using elements to specify search filters.


UPD. I save dates in DB and most of varchar fields contain one word strings.

UPD2. Apache Derby is used right now.


Take a look at the Searchable plugin for Grails.

Need Your Help

Computed function issue with KnockOut

javascript jquery knockout.js

Working with KnockOut - I'm trying to build the basics of a master detail/items app before adding to MVC .Net code.

AsyncTask questions

android android-activity android-asynctask

I was reading things about AsyncTask. It was understandable to me, but immediately two concerns came up to my mind:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.