Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Friday, December 2, 2016 7:39 AM
Points: 1,957, Visits: 3,574
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