[OGo-Developer] GDLContentStore

Helge Hess developer@opengroupware.org
Mon, 24 Sep 2007 15:25:39 +0200


On 24.09.2007, at 15:10, Adam Tauno Williams wrote:
> Don't even know what it was for.

:-) Just for completeness ...

GDLContentStore (GCS) is a library for storing (small) BLOBs into  
PostgreSQL while maintaining an index on the contents of that BLOB.

It was/is written for SOGo which stores vCard and iCalendar resources  
("files") as-is. When you store a resource into GCS it will parse the  
entity (eg iCal VEVENT) and extract 'index information'. This  
information is then stored in separate "index tables" and can be  
SELECTed using SQL.
This index is necessary for the SOGo web interface, eg when it wants  
to display a week of events. W/o the index it would need to parse all  
events on each query.

Well and it also does all that table-on-the-server balancing stuff to  
distribute the files in a cluster. etc etc ;-)

Greets,
   Helge
-- 
Helge Hess
http://www.helgehess.eu/