Are there any hosted services which integrate a full-text search server (Solr, ElasticSearch, etc) with a relational database (PostgreSQL, MySQL, etc)?
Not that I'm aware of, but I have considered that there could be a market for them before too :)
What kind of approach are you thinking of? Using the database as the primary store, and reflecting any row changes in the corresponding search indices?
Yes to the database as the primary store and syncing to the search server then adding a "search clause" to SELECT essentially for seamless integration.
Microsoft has their SQL Azure service but, as of right now, they do not support FT (although SQL Server has robust support for FT). My assumption is that this will be supported in the coming few years though - FT is becoming a must for many BI situations and BI has been driving the MSFT SQL Server team for almost a decade.
How does SQL Server's full-text search support compare to Solr or ElasticSearch? I have used full-text search in MySQL and PostgreSQL and have not been impressed.
7 comments
[ 3.3 ms ] story [ 24.3 ms ] threadWhat kind of approach are you thinking of? Using the database as the primary store, and reflecting any row changes in the corresponding search indices?
Yes to the database as the primary store and syncing to the search server then adding a "search clause" to SELECT essentially for seamless integration.
Glad to provide feedback!
Also, since a lot of companies host SQL Server (Amazon, Rackspace, etc), it's possible that they support SQL Server's FT service.
http://aws.amazon.com/rds/sqlserver/#features