#642 beagle integration broken since migration to sqlite

Misc (88)
Johannes Rohr

Since liferea started using sqlite for storing the feed information, the beagle search engine is no longer capable of indexing them. There is a bug report about this in the gnome bugzilla, see http://bugzilla.gnome.org/show_bug.cgi?id=472934

The first comment to this report says:

"This will be hard to do ... its very hard, mostly impossible, to track changes in sqlite without app support."

Would it be possible to add such support to liferea?


  • Lars Windolf
    Lars Windolf

    Logged In: YES
    Originator: NO

    While I do not think it is impossible I also cannot say how to do it exactly because I don't know about the Beagle indexing (and personally I do not use it). Also I want to note that the cache files are internal interfaces not to be relied on (disclaimer...).

    Something that might help indexing the DB file content: All items are added to the items table with ever-growing item id, so it is pretty easy extracting all new items when saving the max item id from the last crawl. I have to say that it is more problematic to find out what old items were dropped. There is no easy way to determine it from a DB snapshot.

    I don't know about cooperative Beagle usage. If there is an easy way to interface with Beagle and to tell it about new/deleted items/feeds (maybe loosely couple like DBUS) it might be worth adding such functionality to Liferea. But please note that I do not drive any activities in this direction.

  • Lars Windolf
    Lars Windolf

    • priority: 5 --> 3
    • status: open --> open-invalid