Ticket #31 (assigned idea)

Opened 4 years ago

Last modified 2 years ago

Remove dependency on sql

Reported by: ggozadinos@… Owned by: ug
Priority: minor Milestone:
Component: search_engine Version: 0.6
Keywords: sql Cc:

Description

It would be really great if there was an API for setting up different sgf repositories. I would love to integrate kombilo into egoban.org, which is a Plone site implemented on Zope. As you may know zope has its own OO database where all objects are stored. With the current implementation of kombilo I would have to duplicate all sgf once for zodb and once for sqlite... If you would like help on the matter you know how to find me, although my C++ skills haven't been brushed up for quite a looooong time;)

Change History

Changed 4 years ago by ug

  • status changed from new to assigned

Hi George,

thanks for your input. Since there are really no complicated searches at all, it would be relatively easy to move to any other database, which has a C++ interface. I do not know whether this is the case for the Zope DB.

On the other hand, the overhead of using sqlite (or another sql database) really is not that big. Most of the space of the database which libkombilo builds is taken up by information which is needed (only) by the pattern search, so this is stuff which you would not necessarily want to have in the Zope DB anyway.

Actually, if one wants to use the hashing algorithms, the database can become quite large (several hundreds of megabytes), and it might actually be desirable to separate it from the Zope DB in order to keep the performance of Zope up - I don't know.

Changed 4 years ago by ug

George replied by email:

Hey again,
I tried to file this under trac on ticket
http://trac.u-go.net/kombilo/ticket/31 but got a denial from your spam
system;)
This is what I replied anyway,
gg

Sorry for taking such a long time, I thought I would be automatically
notified of replies... Can I actually do that? If yes, please send me an
email...

ZODB for a start has no c++ interface that I know of... But...
What I was thinking of, was providing through a (python?) interface sgf
files to kombilo with some id that I have assigned (or is assigned already
to me). Kombilo would parse the file in its own db (independently hosted)
and would return the ids I have assigned as search results...
Do you see what I mean? That would be very convenient for others as well who
have the sgf files already stored in some (other) db and do not care about
kombilo storing the sgfs...

First, I am very sorry for the problems with the "spam filter". The plugin I used is in fact broken, as far as I can see. I was not able to fix it, and the only viable solution seems to be to require registration from users who want to contribute content. This is how it will work from now on (please do not hesitate to set up an account; it should be very easy). An additional benefit is that I now enabled email notification (which was disabled before because of the spam problem).

Now about your suggestion: The most important change would be to allow the user to prescribe the id a game should have - this will be trivial to implement.

Note: See TracTickets for help on using tickets.