i have a setup right this instant where the dataimporthandler is being used to pull data for an index from a postgresql server.
i'd like to switch over to push, and am looking for some validation of my approach. i have perl installed as an untrusted language on my postgresql server and am planning to set up triggers on the tables where insert/update/delete operations should cause an update of the relevant solr indexes. the trigger functions will build xml in the format for UpdateXmlMessages and notify Solr via http requests. is this sensible, or am i missing something easier? also, does anyone have any thoughts about coordinating initial indexing/full reindexing via dataimporthandler with the trigger based push operations? thanks, richard
