[ckan-discuss] CKA UI Improvements #2 - search results

Friedrich Lindenberg friedrich at pudo.org
Thu Dec 2 16:10:00 GMT 2010

Hi uoc (?),
On Dec 2, 2010, at 5:04 PM, uoc wrote:

> On 02/12/2010 14:54, Friedrich Lindenberg wrote:
>> Hi all,
>> I don't know how many of you have looked at the current state of search using solr, but it supports and already does many of the things outlined in this thread (including, among other things, facets for tags, groups and resource types). It might be worthwhile to update ckan.net to this, actually - unless there is any opposition to doing in-process solr updates for now. As for supporting this in postgres, I think we dropped the idea during the team meeting last monday.
> Worth taking a quick step back and considering that SOLR is for text search (admittedly with fielded text) and doesnt provide the breadth of query capability that an RDBMS would. It wouldnt be unusual to have both systems in place, with the SOLR search capability having some idea of a database record id or some such as linkage.[1,2,3 etc]

That's what we're doing at the moment: keeping the authoritative data in the RDBMS but receiving all functionality related to search to Solr. Seems to work quite well as long as you keep both in sync (if you don't, as I currently do in another app, it is hell)


> [1] 1http://www.lucidimagination.com/Community/Hear-from-the-Experts/Articles/Solr-RDBMS
> [2] http://www.lucidimagination.com/Community/Hear-from-the-Experts/Articles/Solr-Searching-RDBMS
> [3] http://ezinearticles.com/?Using-Solr-Search-With-RDBMS&id=4307003
>> As for the items marked IS THIS POSSIBLE, afais they all are - and pretty trivial.
>> Friedrich
>> On Dec 1, 2010, at 8:47 PM, William Waites wrote:
>>> * [2010-12-01 19:41:13 +0000] Richard Cyganiak<richard at cyganiak.de>  écrit:
>>> ]
>>> ] On 1 Dec 2010, at 16:11, Richard Pope wrote:
>>> ]>Results - Display tags for each package inline to help use choose
>>> ]>which once to click through [IS THIS POSSIBLE?]
>>> ]
>>> ] +1, would be great
>>> ]
>>> ]>Resources icons - Not very useful as a link. Better to display inline
>>> ]>the number of resources available  [IS THIS POSSIBLE?]
>>> ]
>>> ] Or even the list of available formats? I'd find that very useful.
>>> ISTR from looking at performance issues a while back that doing this
>>> involves some rather monstrous joins on the underlying SQL tables that
>>> turned out to be very slow... Maybe this would be better with the Solr
>>> faceted search?
>>> Cheers,
>>> -w
>>> -- 
>>> William Waites
>>> http://eris.okfn.org/ww/foaf#i
>>> 9C7E F636 52F6 1004 E40A  E565 98E3 BBF3 8320 7664
>>> _______________________________________________
>>> ckan-discuss mailing list
>>> ckan-discuss at lists.okfn.org
>>> http://lists.okfn.org/mailman/listinfo/ckan-discuss
>> _______________________________________________
>> ckan-discuss mailing list
>> ckan-discuss at lists.okfn.org
>> http://lists.okfn.org/mailman/listinfo/ckan-discuss

More information about the ckan-discuss mailing list