I believe i can create a Solr index for data in RDBMS using dataImportHandler. But I am not sure how to keep the index in sync when the table is updated (new data added,data deleted etc.)
I am using Solr for full-text search for a particular table in my database