I have written a first pass of an SQLUpdateHandler based on this discussion. It is working well for simple cases and has not tried anything complex yet.
For now, it extends SolrRequestHandler (not UpdateHandler) because the request plugin framework seems more stable. What is the best way to post unfinished code and ask for review? Should i make a JIRA issue and post a patch with a "not ready for prime time" note? Should I post the code on a personal website? Does this belong in the main package o.a.s.update? or a 'contrib' package/project/source folder? If it is in the main tree: the unit tests require mysql-connector.jar and assume you have a database at: jdbc:mysql://localhost/solrtestsql with user=solr and password=solr. Any suggestions on how this should be handled or structured. While we are discussing package layout and external dependencies, consider the not-too-distant case where I will need to do this with an excel spreadsheet and depend on jakarta poi. Perhaps it would be good to stub folders and examples for 'contrib' RequestHandlers and UpdateHandlers. Thanks! I'm asking so many questions because i want to make sure i can give back whatever useful stuff I'm doing now.
