Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««1234

Cool Projects Expand / Collapse
Posted Thursday, August 29, 2013 7:19 AM



Group: General Forum Members
Last Login: 2 days ago @ 5:51 AM
Points: 1,918, Visits: 3,519
The latest "cool" project I worked on was an "integration" between SQL Server and ElasticSearch.
The full text engine in SQL Server is just not good enough, so we wanted to use something else, but without losing the real-time update of the full text index when changing data in the tables. We ended up with ElasticSearch because it is very easy to work with (REST and JSON based), and very easy to manage and expand.

The "integration" is based on Service Broker, triggers on the tables that is responsible for sending messages, and a Windows service (written in .NET) that listens for new messages and writing updates to ElasticSearch.
Post #1489709
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse