chris's blog

Highly Recommended! Virtual Index and DataGrid scaffold

Submitted by chris on Thu, 2012-04-19 20:58.

In latest DBSight release, there are 2 features that we liked so much that we urge your to try them out!

1) Virtual index. It can aggregate several index search results in one page. And those indexes can be on a separated DBSight installation! So you can literally aggregate lots of search in one single page!

2) Data Grid scaffold. It's a feature-loaded powerful scaffold. It can turn data in your common table or views into a full-text searchable data grid, with facet search, sorting, csv export, fullscreen support, infinite scroll, detail page, etc. It's something you can start from a SQL and turn to a professional-looking search page, presentable to your CEO!

No Global Garbage Collection for DBSight 4.x

Submitted by chris on Tue, 2010-10-05 14:28.

It is hard to see JVM struggles with garbage collection. The CPU fan spins fast and the disk makes a loud noise. OK. JVM, I see you are working hard. But the request hangs and users are waiting.

Why not just kill it and create a new one?

This is what DBSight 4.x did.

DBSight 4.x defaults to a separated searching mode. Each time, a dedicated search process is launched to specifically serve all the search request. If the index is updated, a new search process is created and the previous search process is stopped. Here are some benefits:

+ Stopping a search process is actually much faster for large indexes, than waiting for JVM.

Copying Index Configuration is added!

Submitted by chris on Tue, 2009-12-22 16:25.

One user, Rajendra, asked for a new feature: copy the index configuration.

It is a basic operation that we have missed all along!

DBSight can create, delete, and even upload index configurations. But "copy".... duh! Thanks Rajendra!

We have spent a little time to add it in. Hopefully you will like it. Now you could easily manage all the index configurations, make it easier for you to develop, test, and put DBSight to production.

Please let us know any feature you want. We will add it if it's a good feature.

upgrade to 2.1.3

Submitted by chris on Tue, 2009-05-19 23:26.

If you are upgrading to 2.1.3, you may need to re-create the whole index. This is because the storage format of time is changed, to allow support for time before 1970.

This is a rather big change, so please pay attention to it.

Google Map Scaffold for Lucene Search

Submitted by chris on Mon, 2009-04-06 20:51.

We have just implemented a scaffold of Google Map!

If you have a table with latitude and longitude, you are just minutes away from a working search with Google Map.

Well, it's only in beta, because there are some problems with IE. If you find out what's wrong, please let us know!

Scaffold can do lots more. Just let us know what you want. Or simply send us your templates, and we can convert it into re-usable scaffold.

Suggest-As-You-Type and other partial scaffolding

Submitted by chris on Fri, 2009-02-27 17:57.

We recently added several partial scaffolding, which you can choose to apply to the templates that're generated from scaffolding.

One of the most interesting one should be the fancy Suggest-As-You-Type. Users can start typing and some words or phrases matching what's already typed will show up as hints.

BTW: To see this feature in action, you need to configure which database column to spell check first.

Other partial scaffoldings, for example, multi-selection narrowBy, tag cloud, pagination, are relatively new. You may also want to check them out.

The scaffolding directory structure is also changed, so that you can add your own scaffolding without being overwritten when DBSight upgrades.

Search outside database!

Submitted by chris on Wed, 2008-12-24 20:10.

The strong feature of DBSight is searching databases, but because DBSight is only for database, it has been the shortcoming also.

But thing's changed! Now DBSight can search outside database also!

Basically you just need to implement a simple abstract java class, where you can retrieve content from any data source, like files on disk, XML feeds via HTTP, etc.

The API is simple, yet able to handle incremental indexing and a re-creating index. You just need to select the content and submit it to DBSight. The content is processed in a streaming fashion, without consuming too much memory. DBSight will handle uniqueness checking and content updating in the background.

Integrated Spell Checking

Submitted by chris on Wed, 2008-11-12 14:54.

Spell Checking has been in DBSight from the very beginning. However, it was based on a word file, instead of words taken from the indexes.

Now with DBSight 2.0.5 beta, with just one click from the dashboard, the dictionary can be generated for each index. So now you would have more reasonable spell check recommendations.

And you can specify which field needs spell checking. I think you don't want to spell check on numbers, or URLs, or dates. Just configure them via the new "Spell Check" menu.

Let us know if you have some suggestions or other interesting ideas.

DBSight 2.0 released!

Submitted by chris on Fri, 2008-07-11 16:40.

This thread will talk about some interesting new features. First of all, Batching Subsequent Queries.

We are working on DBSight 2.0, which should improve dbsight on many fronts. One of the improvement is the option to Batching Subsequent Queries.

Previously, you have a subsequent query like:

 select * from comments where article_id = ?

It'll fetch all comments of an article. But this query will run for each article. DBSight needs to send the same query to the database.

Now, you can write the query like:

 select * from comments where article_id in ( ? )

DBSight will recognize this pattern, and expand the query to:

DBSight customer(anonymous by request), on product search, Received 2.6 million Euro!

Submitted by chris on Fri, 2007-12-07 23:59.

Well, I have to say I am jealous. 2.6 million Euro is a lot of money. But congratulation!

DBSight's flexible and highly scalable and memory efficient search is one of the customer's secret weapons!

DBSight gives user flexibility to create and adjust search easily, without thinking much about search details.

The customer used DBSight multi-facet search extensively. A recent algorithm change reduced the customer's memory usage by half!

Anonymous customer, keep it going!

DBSight users, you can do it too!

XML feed