I would like to tell you that IBM bought licenses from us!
It's not a big amount, but makes us happy since IBM surely has its own search software.
Integrating DBSight with your application now becomes super easy!
Of course, you can customize the text, stylesheet, etc. The API is improving and please tell us what you want!
The details can be found in the shipped javadoc. We will update the wiki, scaffolding, soon.
Now you can create an index via customized fetcher, and select the SalesForce.com adapter, fill in username/password and the object you want to search on, like "Account".
The rest is exactly the same as ordinary database search configuration.
The good thing is, the incremental indexing will also work. You just schedule the job. And on SalesForce.com side, you need to make the object replicable. This replicable setting doesn't matter if you create index from scratch.
As your data grows, one single box can not hold all of your data. So what to do? Buy a bigger box or add another box?
Getting a bigger box may work for some. Actually it's much simpler and cost less on man-hours. A few thousands of dollars are much cheaper than putting several developers on it.
Of course, Sharded Search can go further by just adding more computer boxes.
DBSight can now support sharded search now! And you don't need to do much. Just adjust the search URL!
Suppose you are 2 indexes on 2 different boxes. The URL format is pretty simple, just say:
This is an interesting feature!
Usually if you have several DBSight servers, you may have to log on to several servers to copy index configurations. And sometimes it is hard to track which one has the latest change.
For Enterprise licenses, to use the Remote Index Replication feature, you also need to setup where the master index is.
Now everything is just one click away!
If you have the remote DBSight server's password, you can browse the local network, copy the remote index configuration and templates with one click!
Brand New feature not seen anywhere else!
Normally when you do a facet search, you get how many hits for that facet. This is a great feature. But there is more!
Now wiht 2.1.6 beta, you can also get Sum and Average for a different field!
It's just like SQL:
select count(*), sum(f2),avg(f2) from t group by f1
DBSight uses Lucene, so it inherits Lucene's fast performance. You may think Lucene's API looks very simple, why not use Lucene directly? But when really used in database-related search, you need to
- Connect to databases (Connection pool?)
- Select the content (What if the content is in several tables?)
- Save as an full-text index (How to analyze the data?)
- And search ...
- And render search results
Very simple? No! Far from enough!
- You need to parse user's query into Lucene's format.
- You need to maintain the search when you are indexing/crawling the data.
- You need to determine what's already indexed and what's not.
Steve Mallett found our site
When we got his email, we thought, gee, spam emails are so intelligently targetted these days! And all of us moved the email to trash. :)
Sorry and thanks a lot, Steve!
I am interested to know if anyone is using DBSight to search their existing bug system.
Usually, bug system is also a good knowledge base. It has solutions, work-arounds, etc. It'll be nice if the bug system is easy to search, without the complicated "Advanced Search", which is done by SQL, slow and no ranking.
DBSight is an ideal solution to search on bug systems. Actually, DBSight's testing environment is a database of a high-volumn constantly changing bug system.
It'll be nice if anyone can send us the SQLs and templates he/she uses on some popular bug system, like Bugzilla, Mantis, etc.
My friend send me a link.
It's a product for searching in database also. It has a nice UI for you to develop. But it has limitations:
- No customization on document ranking, result filtering, multiple language support, etc
- Only for MySQL, Postgres, and Access
- Only for php, coldfustion, or IIS
- No link between multiple tables
If anyone has tried it, let me know the performance with large data volumns.
DBSight has all the features MX Site Search claims
- Search in multiple tables
- Easily to configure search engine