"Tired of querying in antiquated SQL?
Well, you don't have to! LINQPad lets you interactively query databases in a modern query language: LINQ. Kiss goodbye to SQL Management Studio!
LINQPad supports everything in C# 3.0 and Framework 3.5, and more:
* LINQ to Objects
* LINQ to SQL and Entity Framework
* LINQ to XML
* WCF Data Services & SQL Azure
* LINQ to SQLite and MySQL Enterprise Server
* Mindscape LightSpeed ORM
* (Even old-fashioned SQL!)"
Fast Query is an exciting Crestone feature that is usually off the marketing radar. It is a subset of Sitecore Query that executes with SQL speed, meaning fast.
VisualSearch.js enhances ordinary search boxes with the ability to autocomplete faceted search queries. Specify the facets for completion, along with the completable values for any facet. You can retrieve the search query as a structured object, so you don't have to parse the query string yourself.
A special thing about the queries is that they can be handled either directly in the database on the data provider level or by the data manager tier. When the query is being resolved, the data manager tries to use its data providers first and resorts to a higher level (and slower) API in case of failure.
If you are building an ASP.NET web application that's going to get thousands of hits per hour, the execution overhead of Linq queries is going to consume too much CPU and make your site slow. There's a runtime cost associated with each and every Linq Query you write.
OpenJS Grid is the easiest jQuery Grid ever. With very little work you can have a data grid that can do everything from sorting and searching to complex database queries. Best of all, its open source. So you can learn how it's all done.
The IndexViewer is a Sitecore integrated Lucene index browser. It allows you to open an index defined in the web.config. You can see information about the index (last updated, number of documents etc.), browse the documents in the index and see the content and last but not least it allows you to search the index using different Lucene Queries.
Apache CouchDB is a document-oriented database that can be queried and indexed in a MapReduce fashion using JavaScript. CouchDB also offers incremental replication with bi-directional conflict detection and resolution.
A preview release of a component that extends the standard Sitecore Searching mechanisms, specifically, the relatively "new" Sitecore.Search namespace introduced in 6.0 and provides easy search querying APIs