Fog Creek Software
Discussion Board




document URL's

We have document which are stored in a database as BLOBs , is it possible to get a URL reference to a document from within a database? the database is SQLServer, and we want to basically search documents without creating copies on the local file system.

Anon
Monday, April 19, 2004

Check out Full Text Indexing (if you're using SQL 7/2000).  It will search many formats out of the box and has plugins for things like .pdf's.

smallbiz
Monday, April 19, 2004

SharePoint!!! [grin]

Actually, not really - that would require a migration effort. However, check out iFilters for the Windows Indexing Service (and currently most iFilter documentation is under SharePoint, since SPS uses iFilters)

Philo

Philo
Monday, April 19, 2004

> Check out Full Text Indexing (if you're using SQL
> 7/2000).  It will search many formats out of the box and
> has plugins for things like .pdf's

Is there a C/C++ library you know of that will do searches in the many million file formats available?  If it were cross-platform, that would be even better. I am not really talking about indexing though.  Just plain simple searches as if you opened up the native app and did a "find". In the simplest form, it will return true or false based on whether the search expression exists in the file or not.

entell
Monday, April 19, 2004

http://www.dtsearch.com/

-
Monday, April 19, 2004

I'm also interested in some Java or C++ library to searhc the hundreds of document formats out there

Anon
Monday, April 19, 2004

Why do you want a custom solution when the database supports enough to get you more than halfway there.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/yukonftsearch.asp

"Full-text indexes may be built not just on columns that contain text data, but also against formatted binary data, such as Microsoft® Word documents, stored in a BLOB-type column; in these cases, it is not possible to use the LIKE predicate for keyword queries.

..... Full-text search is also highly extensible. The full-text engine can support additional languages for index and query (by adding additional word breakers or stemmers from a third-party vendor), as well as filtering of additional document formats (there are a number of third-party filters to choose from). A set of well-known, published interfaces provide the framework for full-text engine extensibility."

Tapiwa
Monday, April 19, 2004

Philo, you need a last name so we can make you: Philo "Sharepoint" Something. Philo "Sharepoint" just doesn't seem to have the same ring to it.

www.MarkTAW.com
Monday, April 19, 2004

Philo "Sharepoint" Dough

misa
Monday, April 19, 2004

Mr. Philo S Point to you!!

Tapiwa
Monday, April 19, 2004

/

Hey!
Wednesday, April 21, 2004

*  Recent Topics

*  Fog Creek Home