Topic
  • 3 replies
  • Latest Post - ‏2007-01-12T17:49:40Z by SystemAdmin
SystemAdmin
SystemAdmin
1525 Posts

Pinned topic Is full-text search available for Derby?

‏2007-01-12T17:14:19Z |
Does Derby provide for full-text searching on a given column (or will it ever)?

Thanks
Updated on 2007-01-12T17:49:40Z at 2007-01-12T17:49:40Z by SystemAdmin
  • Stan
    Stan
    267 Posts

    Re: Is full-text search available for Derby?

    ‏2007-01-12T17:32:16Z  
    Outside of substring searches (using functions or the 'like' operator) on string columns, no. As far as 'will it ever?', I recommend posting this question to the Derby development commnunity at Apache. The mail list can be addressed with: derby-dev@db.apache.org. I recall seeing some discussions of implementing other types of indexes that may improve text search capabilities but I have not followed the thread. You can search for this and other message threads related to text search capabilities at the nabble archive site:

    Derby User list: http://www.nabble.com/Apache-Derby-Users-f93.html
    Derby Developer list: http://www.nabble.com/Apache-Derby-Developers-f91.html
  • Jean_Anderson
    Jean_Anderson
    179 Posts

    Re: Is full-text search available for Derby?

    ‏2007-01-12T17:35:39Z  
    • Stan
    • ‏2007-01-12T17:32:16Z
    Outside of substring searches (using functions or the 'like' operator) on string columns, no. As far as 'will it ever?', I recommend posting this question to the Derby development commnunity at Apache. The mail list can be addressed with: derby-dev@db.apache.org. I recall seeing some discussions of implementing other types of indexes that may improve text search capabilities but I have not followed the thread. You can search for this and other message threads related to text search capabilities at the nabble archive site:

    Derby User list: http://www.nabble.com/Apache-Derby-Users-f93.html
    Derby Developer list: http://www.nabble.com/Apache-Derby-Developers-f91.html
    Some discussion about integrating Lucene is on the Derby wiki:

    http://wiki.apache.org/db-derby/LuceneIntegration?highlight=%28lucene%29

    Also a couple Derby issues were opened:
    https://issues.apache.org/jira/browse/DERBY-590
    https://issues.apache.org/jira/browse/DERBY-472

    there's definitely interest!

    -jean
  • SystemAdmin
    SystemAdmin
    1525 Posts

    Re: Is full-text search available for Derby?

    ‏2007-01-12T17:49:40Z  
    Some discussion about integrating Lucene is on the Derby wiki:

    http://wiki.apache.org/db-derby/LuceneIntegration?highlight=%28lucene%29

    Also a couple Derby issues were opened:
    https://issues.apache.org/jira/browse/DERBY-590
    https://issues.apache.org/jira/browse/DERBY-472

    there's definitely interest!

    -jean
    Thanks for the replies.

    But would lucene work with an encrypted database?