[dba-VB] "Smart" fulltext search on large documents(data)base...

Gustav Brock Gustav at cactus.dk
Fri Feb 4 03:32:37 CST 2011

Hi Shamil

How fast is this? Sounds very clever.


>>> shamil at smsconsulting.spb.ru 04-02-2011 03:38 >>>
Hi Doug,

Yes, search google docs docs can be automated  - I have found and I used
That wasn't very quick to make it working but I have got it working after

My sample quick & dirty code, which worked for me was as the following:

    string userName = "myTest at gmail.com";
    string password = "mypassword";

    List<Document> all = new List<Document>();
    GDataCredentials credentials = new GDataCredentials(userName, password);
    DocumentsService service = new

    System.Console.WriteLine("Logging in...");

    RequestSettings settings = new RequestSettings("GoogleDocumentsSample",
    settings.AutoPaging = true;
    settings.PageSize = 100;
    if (settings != null)
        DocumentsRequest request = new DocumentsRequest(settings);
        System.Console.WriteLine("Successfully logged in");

        System.Console.WriteLine("Gettings docs...");

        FeedQuery query = new FeedQuery();
        query.Uri = new Uri( request.BaseUri);
        query.Query = "quick brown fox";

        Feed<Document> feed = request.Get<Document>(query);  
        // this takes care of paging the results in
        System.Console.WriteLine("Collecting docs info...");

        int index = 1;
        foreach (Document entry in feed.Entries)
            System.Console.WriteLine("{0}. {1}", index, entry.Title);

        System.Console.WriteLine("\n *** Docs collected - processing

        index = 1;
        foreach (Document doc in all)
	// just listing collected docs...
            System.Console.WriteLine("{0}. {1}", index, doc.Title);
        System.Console.WriteLine("Login failed.");

Uploading docs to GoogleDocs can be also automated usinhg the same C# lib.

It's funny one can also use GoogleDocs engine as a document formats
convertor e.g. txt -> pdf, or txt -> doc etc. - just upload one format, and
download another one...

Thank you.

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com 
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: 22 ?????? 2011 ?. 20:56
To: 'Discussion concerning Visual Basic and related programming issues.'
Subject: Re: [dba-VB] "Smart" fulltext search on large


Very innovative approach. Good use of the low cost and high power offered by
the "Cloud" services. I'll be interested in how this comes out.


-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com 
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Shamil
Sent: Friday, January 21, 2011 8:34 AM
To: 'Discussion concerning Visual Basic and related programming issues.'
Subject: [dba-VB] "Smart" fulltext search on large documents (data)base...

Hi All --

I have a task to implement a system providing "smart" fulltext search over a
large base of text documents.
My current plan is to use Google Docs.

I plan to get in the future 80 GB ($20.00 USD per year) hosted space on
GoogleDocs, put all the subject docs there, and then use Google API to
search via my documents base.

That seems to be it?

It should be even possible to create a simple (free?) Google Web Site as
front-end to that GoogleDocs documents base?

That GoogleDocs base/site is planned to be used by non-profit organization.

Am I missing something? 
Additional overhead costs to keep that solution's stuff on Google site?

And why I'm writing about that solution here in dba-VBA? - because I plan to
implement a front-end to that application system as an WinForms application
coomunicating with Windows API...

Thank you.


More information about the dba-VB mailing list