Ideas on how to use the ADO.NET NNTP Provider

re: Ideas on how to use the ADO.NET NNTP Provider

Ryan Farley — Tue, 25 May 2004 07:01:00 GMT

Hi Dirk, thanks for the link. Really awesome work with the NNTP Data Provider. Such an incredible idea.

I'm currently using it to build a service that will sync newsgroup data with a SQL database to provide full-text searching (for private newsgroups not accessible though google news).

I'll be sure to provide some feedback for any issues I find (any particular areas you want tested?) and will likely post source for the app when I am done.

Thanks again, Dirk!

re: Ideas on how to use the ADO.NET NNTP Provider

Kingsley Tagbo — Thu, 10 Jun 2004 13:39:00 GMT

How can one write a query that restricts filters the posts by date?

E.g. SELECT * FROM dotnetsmart.com where date < june 1, 2004

Each time a connection is made, are all the posts downloaded before the filtering is done? or is the filtering done at the host and then the matching posts downloaded?

Thanks

re: Ideas on how to use the ADO.NET NNTP Provider

Dirk — Thu, 10 Jun 2004 16:42:00 GMT

Currently every header needs to get loaded in order to check for any given criteria. I'm thinking about ways to change that (At least to load just parts of the header and decide based on it's content). Additionally I plan to add a way to say something like "get me postings newer than the posting with the Message-ID xyz". Since the newnews-command is not implemented on many servers I like the idea of checking internally the ID on wich the posting is saved and enumerate until that point...

If you like to contribute: The workspace is open to anybody and we'll happy to welcome you :-)

Regards,
Dirk

re: Ideas on how to use the ADO.NET NNTP Provider

Kingsley Tagbo — Fri, 11 Jun 2004 02:50:00 GMT

Dirk :

Thanks a lot for the invitation. :) I would definitely like to contribute what I know.

Adding a check for "get me postings newer than the posting with the Message-ID xyz" will be fantastic and save a lot of bandwidth time.

It is a fantastic tool and the idea space of the code is like a 'Star Trek'