May 13th, 2013· Avoids exceptions during JSON embedded search when column names have uppercase characters.
January 8th, 2013· A major focus on improving robustness for managing the separated search process, including ensuring index replication works even when the index is updated, avoiding index replication notification noises from other dbsight systems, and each index takes a fixed 2 ports instead of sharing the ports.
· An error in iPhone search result scaffolding has been fixed.
November 26th, 2012· This version adds an option to default to a specific sortBy column.
· It has a fix to clean up HTTP connections cleanly.
November 13th, 2012· This version adds compression for more efficient index replication and adds protection for index data file correctness.
October 15th, 2012· This version will always merge an index when the merge threshhold is set to 0.
· It avoids an NPE during search suggestion.
August 21st, 2012· This version optimizes parameter types to increase incremental SQL execution performance.
July 3rd, 2012· This version adds index freshness and scheduling information to the front page.
May 15th, 2012· This version adds File Fetcher to search files on the local disk and passes the timeout from the search API to the connection to the searchers.
May 8th, 2012· This version adds efficient real-time statistics for top popular queries.
· It fixes exceptions in the log when running with Tomcat.
April 17th, 2012· This version adds an email-style list-detail layout option to the datagrid scaffold.
· It adds a jQuery UI theme to the narrow by(facet) section scaffold.
March 20th, 2012· This version adds Data Grid scaffolding including: themes, grid data representation, slide-in detail page, collapsible facet search, search suggestion, full-screen mode, and CSV export.
· There are many bells and whistles.
· An NPE with pre-defined data sources has been resolved.
· There are other minor textual adjusts.
December 19th, 2011· This version fixes a highlighting issue when time-based ranking is enabled, and adds basic authentication to the search API.
July 25th, 2011· Search result scaffolding added Excel output format.
July 19th, 2011· This version supports multiple patterns for remote access security checking.
· Directory listing has been disabled due to security concerns.
July 11th, 2011· Robustness was increased with automatic recovery from disconnected search servers.
· Range search precision was increased for large integers.
June 20th, 2011· A note to the dashboard for skipped tasks to avoid multiple index creation scheduled at the same time has been added.
June 6th, 2011· This version focuses on index job scheduling and timing for load balancers to switch between servers when servers are busy indexing.
· It avoids backlogging indexing jobs running on the same index.
· It avoids indexing starting at the same moment.
· It adds status notification via ping before and after each indexing job.
· It corrects the index swapping sequence for zero search gap.
· It updates the quartz library.
May 23rd, 2011· Added an embeddable continuous scroll widget.
· Added customizable port range for searching processes to use.
· Enabled a single character word as part of a phrase.
· Added Google Map API Key to Google Map Scaffolding.
April 5th, 2011· Indexing was made much faster for large indexes.
February 8th, 2011· This version adds an embeddable Javascript library to add search UI to any page via JSONP.
· Dynamic sorting now supports simpler syntax for each column.
· A facet search display order bug has been fixed.
· Facet search for integers has been fixed.
· A facet result sorting order bug has been fixed.
· This release has much more efficient pagination for single-shard search.
January 24th, 2011· This version adds an option to disable narrowBy(facet) search.
· It automatically supports JSONP callback by setting the content type and encoding to JSON data.
January 10th, 2011· Support for decimal range facet search was added.
· Support for float type for sum or average columns was added.
· Search timeout was fixed to 60 seconds in distributed mode.
· The precision of the sum() and average() functions for facet search was increased.
December 20th, 2010· This version adds support for database fields with Unix time in seconds.
· It adds the parameter facetLimit to control the number of facet counts for improving performance when the number of facet counts is large.
December 13th, 2010· An API for a customized fetcher to submit files directly has been added.
December 6th, 2010· The date storage format was changed to support a wider range of dates.
· An option was added to set dynamic selectable columns to transmit only required columns for more performance.
· Language support was added for Danish, Finnish, Hindi, Hungarian, Indonesian, Italian, Norwegian, Romanian, Swedish, Spanish, and Turkish.
November 29th, 2010· This version adds a FreeMarker syntax online editor to modify the search result template.
· It adds automatic detection and adjusts the default heap size for 32 and 64 bit JVMs.
November 22nd, 2010· This version fixes a minor display issue on the dashboard page.
· The XML configuration format has been transparently upgraded to prepare for future new features.
October 25th, 2010· Collect and display status for each remote searcher instance.
· Improved throughput performance by optimizing and reusing HTTP connections.
· Displaying values with the same column names has been fixed.
· A score is added to each result during sorting.
October 18th, 2010· This version properly releases a used port number after each index update to ensure resource reuse.
· Range query under distributed search mode was fixed.
October 11th, 2010· This release separates out the searching as a different operating system process.
· This eliminates Java stop-the-world Global Garbage Collection, improves performance by avoiding memory fragmentation, and ensures greater scalability for a single node.
· Other major features includes automatically re-ranking facet searches according to usage, and role-based access control for role-specific contents.
October 5th, 2010· Multi Index Search mode automatically searches all indexes with non-negative display order.
· A facet search caching error for some specific searches was fixed.
September 27th, 2010· This release will automatically take a thread dump for hanging indexing processes.
· It fixes a IBM JDK threading issue for indexing.
· It fixes a search exception after updating content directly via Submit API.
September 20th, 2010· For the Chinese, Japanese, and Korean languages, full-width form Latin words are automatically converted to half-width form to match words in the index.
September 13th, 2010· This release adds gzip and deflate compression for sharded search and the Java search API.
· It improves the Average function for each facet search.
· It avoids a connection timeout issue via round robin connection reuse.
· It will properly release the spell checker reader to avoid a file deletion error.
August 23rd, 2010· Memory efficiency was improved by more than 75% for a single valued facet search.
· A facets counting error caused by zero-valued boosting was fixed.
August 16th, 2010· Added iPhone scaffolding.
· An option was added to skip a facet search that has only one entry.
· A parameter to control the Lucene query boolean operator was added.
· Facet cache performance was improved.
· Wildcard search was fixed.
· A negative-only query was fixed.
August 2nd, 2010· This version improves memory efficiency by reducing memory usage for sparse valued facet search.
· It adds index name and remote host name for multi index search and shard search to render results differently.
· It fixes possible NULL valued primary key cases during the indexing process.
· dbsight's jar file locations are displayed in the system report page to avoid possible duplicated jar files in the classpath.
July 19th, 2010· This version adds an adapter to crawl and synchronize data on SalesForce.com and create full text searches on the data.
· It adds an option to optimize the index after indexing.
· API changes: an API for a customizable fetcher to delete old records has been added.
July 12th, 2010· Sharded Search is added so that users can automatically combine results from distributed search nodes, with correct weight and ranking calculated.
· Facet search and pagination still works during sharded search mode.
March 8th, 2010· The number of search results explained via debug option is now adjustable.
· Option to switch between default Lucene parser and ComplexPhraseQueryParser is added.
· Improve performance and Removing 255 length limit for CommaSemicolonExtendedAnalyzer.
· Fix displaying error when show content via primary key column.
March 8th, 2010· Fix exception when using Synonyms and Reserved Words to analyze content.
· CommaSemicolonExtendedAnalyzer can work well during searching.
March 8th, 2010· Configurable Query Timeout is added to handle query timeout to avoid non-responding database connections.
March 8th, 2010· Lucene 3.0 compatible.
· Freemarker template is added to Facet Search definition xml file.
· Facet Types Editing Window is added.
· Synonyms and Stop Words are configured individually.
· Avoid overwriting reserved, spell_check, stopwords, synonyms file.
· Configurable Reserved Words is added.
· Update POI library to process Word Doc, Excel, and PowerPoint files.
March 8th, 2010· IKAnalyzer is added for better support for international language, especially Chinese, and customizable dictionary.
· Added DBSight version to index configuration file.
· Incremental Indexing Sql improves performance by not requiring order by modified date.
· Sum and Avg for any field is added in facet search results.
October 12th, 2009· An old history data reading error is ignored.
September 29th, 2009· Paginated SQL retrieval for PostgreSQL result sets has been added.
· Single Valued Facet warm up has been added when updating new indexes.
· Configuration loading exception has been fixed.
May 11th, 2009· Added support for time before 1970. Need to re-create index when upgrading.
· Shutdown hanging with tomcat is fixed.
· Fix Scaffolding error.
· Removed hard coded indexing log level.
March 23rd, 2009· JSONP scaffolding was added.
· Result-Per-Page partial scaffolding was added.
· The Spell Checking suggestion is avoided if a field query is included.
· The User Input value was added to the SearchResult.
· A configurable number of NarrowBy (Facet Search) choices was added.
· The SqlServer Driver name was fixed.
· The page for empty results was fixed.
· NarrayBy in boolean operartor OR mode was fixed.
· Boosting a document by a value was fixed.
· PatternSyntaxException of Advanced Incremental SQL was fixed.
March 2nd, 2009· Multiple-Choice Partial Scaffolding was added.
· Suggest-as-you-type now works for 1 character also.
· Column-specific partial scaffolding was added so that it can be applied several times.
· Scaffolding now can be applied to subdirectories.
· Performance for spell checking dictionary generation was greatly improved for large indexes.
· Performance for deletion detection was greatly improved and efficient.
· Different versions of the same jdbc drivers can be used.
· Multiple-Choice Query was added.
· Scaffolding for RSS syndication was fixed.
· A problem in which jQuery.js was included twice was fixed.
February 9th, 2009· Support for negative-only queries has been added.
· There is an additional directory to store customized scaffolding. Hierarchical date search has been added.
· More memory-efficient duplication checking.
· Direct Lucene querying in the search API has been added.
· Hierachical facet search link has been improved to handle child filtered columns.
· The delete action also deletes buffer index entries.
· Performance has been improved by skipping empty buffer indexes.
· The Jgroups dependency has been removed to simplify license checking.
January 12th, 2009· Numeric range search with inclusive/exclusive on both ends is added.
· Deletion SQL choice with incremental indexing is made clearer.
· Multiple schedules can be added/changed/deleted.
· The Lucene library is updated to latest release.
· Buffer Index can selectively update a specific index field.
· Buffer index cache flushing is resolved.
· Configurable email notification for indexing processes is added.
· AJAX Search Suggestions partial scaffolding is added.
· HA Cluster mode support subscribing incremental index changes and a spell-check index.
· Tag cloud generation via partial scaffold is streamlined.
December 29th, 2008· This release adds an option to schedule deletion detection for incremental indexing.
· It adds a customizable fetcher for data sources other than databases.
· It adds job scheduling for the spell check dictionary.
· It fixes a possible format error for the period table.
· It fixes problems handling negative queries like "night -title:sky".
December 8th, 2008· This release adds multiple scheduling for the same index.
· It includes counting integer zeros for facet searching.
· It improves numeric facet search by adding open-ended ranges.
· A bug related to reading float numbers into integers has been fixed.
· Caching has been added for multi-row queries.
· Batching has been added for multi-row queries.
November 17th, 2008· This release adds index-specific spell checking.
· It fixes highlighter highlighting without summarizing.
· It adds optional classpath for indexing to resolve a Tomcat jsdk classpath issue.
· It simplifies narrowBy rendering logic.
· It improves search performance by optimizing on Facet Search.
November 10th, 2008· This release improves search performance by avoiding repeatedly loading configuration files.
· It defaults to getting an auto-commit database connection to avoid extra setAutoCommit operations.
· It fixes incorrect error reporting for BufferIndex submit.do.
October 27th, 2008· This release improves search performance by avoiding repeatedly loading configuration files.
· It defaults to getting an auto-commit database connection to avoid extra setAutoCommit operations.
· It fixes incorrect error reporting for BufferIndex submit.do.
October 6th, 2008· A new Scaffolding Engine for more flexible result page rendering has been added.
· Developers can create customized re-usable scaffolding.
· A Tag cloud scaffold has been added.
· It is easier to add JDBC libraries.
· The performance of SQL retrieval has been greatly enhanced by batching SQL.
September 15th, 2008· This release fixes Lucene memory leaking when refreshing the index in memory-only mode.
· It adds configurable max field length.
· It can process an empty query by matching all documents in multi-index search mode.
· It handles SqlServer special empty or all zero date time format.
Find us on Google+
