Ask HN: search and relational database integration as a service?

https://news.ycombinator.com/item?id=6512448

by rpedela • 13 years ago

3 7 13 years ago

news.ycombinator.com

Are there any hosted services which integrate a full-text search server (Solr, ElasticSearch, etc) with a relational database (PostgreSQL, MySQL, etc)?

jka2• 13 years ago

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?

rpedela3• 13 years ago

How did you guess? Interested in beta testing? :)

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.

jka2• 13 years ago

Absolutely, drop me a line - my mail is jay at jp hyphen hosting dot net

Glad to provide feedback!

ScottWhigham2• 13 years ago

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.

rpedela3• 13 years ago

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.

ScottWhigham2• 13 years ago

I wish I knew - I'm mostly a SQL Server only guy! Just posting b/c, at some point, I suspect they will entire this market in in a big way.

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

Ask HN: search and relational database integration as a service?

Related Stories