Re: [greenstone-users] SQL request and what is the format ofgreenstone database?

From Michael Dewsnip
DateMon, 06 Dec 2004 09:47:28 +1300
Subject Re: [greenstone-users] SQL request and what is the format ofgreenstone database?
In-Reply-To (20041203124228-896D0173495-postfix3-1-free-fr)
Hi,

I don't know much about SQLite but I've just had a quick look at their
website and I don't think it will do what you want, sorry. SQLite seems
to be an implementation of SQL that happens to use GDBM as the backend
-- not an SQL interface to any GDBM database.

Greenstone 3 uses MySQL, but isn't ready for the prime time yet. There
is some information about it available at
http://www.greenstone.org/greenstone3 if you're interested.

Regards,

Michael

Laurent Giovannoni wrote:

>Hi,
>
>Ok now I see how Greenstone stores the data.
>But are you sure that I can't do SQL requests to the GDBM file?
>With SQLite for example...
>
>Thank u.
>
>Regards,
>
>Laurent Giovannoni.
>
>-----Message d'origine-----
>De : Katherine Don [mailto:kjdon@cs.waikato.ac.nz]
>Envoy□ : vendredi 3 d□cembre 2004 01:55
>□ : Laurent Giovannoni
>Cc : greenstone-users@list.scms.waikato.ac.nz
>Objet : Re: [greenstone-users] SQL request and what is the format of
>greenstone database?
>
>Hi
>
>Greenstone uses GDBM (Gnu Database manager) to store metadata,
>classifier information, and document structure information.
>The database for each collection lives in
>gsdl/collect/<collection>/index/text/<collection>.ldb
>You can look at the database by running
>db2txt gsdl/collect/<collection>/index/text/<collection>.ldb
>
>Greenstone also uses MG (Managing Gigabytes) to create the search
>indexes and store the full text of any textual documents. For more info
>see http://www.mds.rmit.edu.au/mg/
>
>Neither of these uses SQL requests.
>
>Regards,
>Katherine Don
>
>Laurent Giovannoni wrote:
>
>
>>Hello everyone !
>>
>>
>>
>>I will want some information about the greenstone Database:
>>
>>
>>
>>I created a collection of images with their associated XML.
>>
>>
>>
>>Where the Data are stored in the Greenstone database?
>>
>>
>>
>>Which is the format of the database?
>>
>>
>>
>>How I will be able to question this base with SQL requests? It is
>>imperative for me!
>>
>>
>>
>>Thank you for your assistance.
>>
>>
>>
>>Laurent Giovannoni.
>>
>>
>>
>>
>>------------------------------------------------------------------------
>>
>>_______________________________________________
>>greenstone-users mailing list
>>greenstone-users@list.scms.waikato.ac.nz
>>https://list.scms.waikato.ac.nz/mailman/listinfo/greenstone-users
>>
>>
>
>
>
>
>_______________________________________________
>greenstone-users mailing list
>greenstone-users@list.scms.waikato.ac.nz
>https://list.scms.waikato.ac.nz/mailman/listinfo/greenstone-users
>
>
>