#52 ✓hold
Mein Klang

limited fulltext search

Reported by Mein Klang | August 6th, 2013 @ 12:56 PM

I am using piggydb-standalone on Lubuntu (german localization).
While trying to retrieve information from fragments I noticed problems with the search mechanism.

There is three things, two that seem local to my machine, as tested against http://piggydb.jp/example/

1) On my local machine words are only found, if they are part of a fragment title. But then they get found inside text fragments as well. Words that only appear in fragment content are not found.

Fragment title:Verallgemeinerte Koordinate
Finds fragment for: Verallgemeinerte, Koordinate
But not for: allgemein, Koordinat
Does not find any of the words in the fragment content/body.

2) Related is the irregular partial matching. Since I am writing in German I have to deal with lots of small word variations due to grammar i.e. Koordinate, Koordinaten; Haus, Häuser. I am quite used to regex or placeholders, but on my local machine piggydb
cannot find partial matches at all. Using Ctrl+F on the browser page is not a happy solution.

3) When I use your example instance I often see no partial matching either. Is this a feature, not a bug?
Search for worth, compare worthy. I was expecting to find both as long as I don't ask for strict matching.
Search for order, compare rder.

BUT search for war and it will find coward.

Downloaded piggydb 6.12
Running piggydb from terminal since I am still working out the problems similar to ticket #51.
Moved actual database inside my home folder and changed file prefix accordingly in application.properties.

java -version
java version "1.7.0_25"
OpenJDK Runtime Environment (IcedTea 2.3.10) (7u25-2.3.10-1ubuntu0.13.04.2)
OpenJDK Client VM (build 23.7-b01, mixed mode, sharing)

I'd be glad for any feedback to help me get this great application to it's full potential on my system.
If you let me know what log files/system info you would you need for further analysis, I'll provide them ASAP.

So long, and thanks for all the ... piggydb

Comments and changes to this ticket

  • marubinotto

    marubinotto August 9th, 2013 @ 02:50 AM

    • State changed from “new” to “hold”

    Hi MK,

    Thank you for your feedback and detailed report.

    Most of the problems you pointed out are the limitation of the current fulltext-search feature. It does not support spelling variants, so words need to be exactly matched to the search word in order to be found.

    Basically it is for gaining performance in searching (piggydb's database could become quite large), but it can be improved, for example, to support spelling variants. I'll keep this ticket for future improvements.

    Does not find any of the words in the fragment content/body.

    Could you post an example exported file that reproduces this problem?

    Running piggydb from terminal since I am still working out the problems similar to ticket #51.

    Okay, I will investigate this problem further and response to the ticket #51.

    Best regards,

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

Piggydb is a Web notebook application that provides you with a platform to build your knowledge personally or collaboratively.

Shared Ticket Bins

People watching this ticket