Re: MySQL Searchable Mailing List Archive now up.
This is a very very good search engine for the mailing list!!! Great work Two things: 1- Is it possible to remove our full email adresses? To put like emarcott@... or emarcott at itl dot ca (like the mysqldeveloper archive. 2- Put the Any Date checked by default so we don'T have to always click it:-) (I'm lay) You could add some javascript so that the range is celected when something is entered in the from or to fields my 2 cents #2 is not a big thing, but #1 is pretty important against spam and spam bots. Etienne Robert Alexander wrote: Hi everyone, Just want to make a very brief announcement. I've seen a few mentions in the recent past of the desire for a searchable archive of the MySQL list. I've wanted one, too. So, being ahem 'between contracts' right now, I decided finally to write one. I've actually been keeping an archive of the MySQL list for quite a while in anticipation of doing this some day. Just doin' my bit... The archive is at http://archive.workmate.ca/myarchive It's still in BETA, so this is a test release to see how it holds up. It's fully searchable on Subject or Body, on the From address, and by date range. It's running on a reasonably decent box (a Sun Ultra 1), but on a fairly slow connection (for now). The pages are quite compact, though, so as long as not everybody hits it at once, it should give pretty decent performance. : Written in Perl with MySQL as the backend, of course. : The archive is updated in real-time as the mails arrive, so it should always be up-to-the-minute. Take a minute and let me know what you think -- it's a work in progress, and feedback is appreciated. Thanks, all! /Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
At 20:18 -1000 2001/12/15, Peter Reck wrote: Rob, THANK YOU for putting this together. You're welcome. Glad you like it. : I am a complete newbie to MySQL, and have a VERY BASIC question: In the future, Peter, please direct questions to the MySQL list, and not to me personally. Thanks! - How do I go into the db and clear and/or edit what has been written to it thus far? Maybe you can point me in a useful direction to learn about the basics of MySQL? The MySQL manual, either on-line (http://www.mysql.com/doc/) or in the distribution you got, is *very* good. Take a bit of time to get to know it. For a basic start on logging-in, and inserting and deleting data, take a look at the tutorial in the manual, Chapter 3 Introduction to MySQL: A MySQL Tutorial. I am now looking at a nice summary on developer shed right now, which gives me a basic intro. The stuff on DevShed is generally quite good. It's a good resource. Thanks a lot Rob, Peter Hope this helps, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
At 09:33 -0500 2001/12/17, Etienne Marcotte wrote: This is a very very good search engine for the mailing list!!! Great work Thank you! Two things: 2- Put the Any Date checked by default so we don'T have to always click it:-) (I'm lay) You could add some javascript so that the range is celected when something is entered in the from or to fields Second one first: Any Date is already checked by default. What browser/OS are you using? 1- Is it possible to remove our full email adresses? To put like emarcott@... or emarcott at itl dot ca (like the mysqldeveloper archive. my 2 cents #2 is not a big thing, but #1 is pretty important against spam and spam bots. Etienne A valid concern, Etienne, and one that's very important to me, too. Word's fail me in describing how much I detest spam -- well, at least polite ones do. :-/ I believe our information is safe in this case, though. Let me explain why: To the best of my knowledge, Email harvesting 'bots (spambots) use technology similar to that used by the big web search engines. Those companies, like Google, Yahoo, etc., run two main pieces of software; one (a 'spider') that continually accesses all the sites on the web -- well, they hope it's all of them -- and stores information about, or a complete copy of, each page they find. These pages are stored in their database on their big, fire-breathing computers (it's a staggering amount of data) and that's what the _other_ piece of software, the search engine, looks through when you do a search. The spambots do basically the same thing -- they gather up web pages. They, however, simply extract anything that looks like an email address. These lower-than-pond-scum then add that to their database (350 MILLION TARGETTED EMAIL ADDRSSES FOR ONLY $399.00!) and lie that you 'opted-in' or 'expressed an interest.' Fortunately, search engine page gatherers and spambots can access only 'static' html pages that exist on a server and can be searched. The pages you see when you search the email archive are safe from 'bots because they don't even _exist_ until you ask for them -- they're generated on-the-fly, on demand, and they're sent directly to your computer. The content of the archive is visible only to the person doing the search. So, it's a 99% solution. There's still the chance that an unscrupulous person could go to the effort of doing an archive search in the hopes of getting some email addresses to spam, but that's simply not their style; that's too much like legitimate work. Pirating email addresses is 'profitable' (I guess) if they let a computer do all the work; it's not if a person has to write them down or type them in. There are places that DO put the contents of mailing lists up on the web on static, searchable pages. You should be aware of them so you can make better-informed decisions, and thereby have more control over where your address appears. One site with the MySQL list is http://dbforums.com/f114/. Or try, for example, http://www.mail-archive.com/dbi-users@perl.org/msg06361.html For an interesting exercise, you should try going to www.google.com, or your favourite search engine, and doing a web search on your email address and/or your phone number. The hits you get on that search are the prime places where spambots are getting your email address from. I truly believe we're safe, though I'd love to hear more comments. All the best, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
Netscrap 4.78 oops sorry mispelled that one.. Netscape :) I do loads of html and I hate Netscape with a passion, I think 6.2 renders pages like IE4, but I'm not even sure, and only .2% of websurfer use it. www.technodium.net/kira/kira.htm check this out with IE = perfect.. chek it out with NS, different for every version, even if all the tags are ok As for email spamming, you are right, since it's taken from a database. Unless the archive was called e-may, I think we might not have to protect the emails beyond leaving them outside of static webpages:-) Etienne Robert Alexander wrote: At 09:33 -0500 2001/12/17, Etienne Marcotte wrote: This is a very very good search engine for the mailing list!!! Great work Thank you! Two things: 2- Put the Any Date checked by default so we don'T have to always click it:-) (I'm lay) You could add some javascript so that the range is celected when something is entered in the from or to fields Second one first: Any Date is already checked by default. What browser/OS are you using? 1- Is it possible to remove our full email adresses? To put like emarcott@... or emarcott at itl dot ca (like the mysqldeveloper archive. my 2 cents #2 is not a big thing, but #1 is pretty important against spam and spam bots. Etienne A valid concern, Etienne, and one that's very important to me, too. Word's fail me in describing how much I detest spam -- well, at least polite ones do. :-/ I believe our information is safe in this case, though. Let me explain why: To the best of my knowledge, Email harvesting 'bots (spambots) use technology similar to that used by the big web search engines. Those companies, like Google, Yahoo, etc., run two main pieces of software; one (a 'spider') that continually accesses all the sites on the web -- well, they hope it's all of them -- and stores information about, or a complete copy of, each page they find. These pages are stored in their database on their big, fire-breathing computers (it's a staggering amount of data) and that's what the _other_ piece of software, the search engine, looks through when you do a search. The spambots do basically the same thing -- they gather up web pages. They, however, simply extract anything that looks like an email address. These lower-than-pond-scum then add that to their database (350 MILLION TARGETTED EMAIL ADDRSSES FOR ONLY $399.00!) and lie that you 'opted-in' or 'expressed an interest.' Fortunately, search engine page gatherers and spambots can access only 'static' html pages that exist on a server and can be searched. The pages you see when you search the email archive are safe from 'bots because they don't even _exist_ until you ask for them -- they're generated on-the-fly, on demand, and they're sent directly to your computer. The content of the archive is visible only to the person doing the search. So, it's a 99% solution. There's still the chance that an unscrupulous person could go to the effort of doing an archive search in the hopes of getting some email addresses to spam, but that's simply not their style; that's too much like legitimate work. Pirating email addresses is 'profitable' (I guess) if they let a computer do all the work; it's not if a person has to write them down or type them in. There are places that DO put the contents of mailing lists up on the web on static, searchable pages. You should be aware of them so you can make better-informed decisions, and thereby have more control over where your address appears. One site with the MySQL list is http://dbforums.com/f114/. Or try, for example, http://www.mail-archive.com/dbi-users@perl.org/msg06361.html For an interesting exercise, you should try going to www.google.com, or your favourite search engine, and doing a web search on your email address and/or your phone number. The hits you get on that search are the prime places where spambots are getting your email address from. I truly believe we're safe, though I'd love to hear more comments. All the best, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
At 12:10 -0500 2001/12/17, Etienne Marcotte wrote: Netscrap 4.78 oops sorry mispelled that one.. Netscape :) Hmmm. I see you're using Netscape on NT. [X-Mailer: Mozilla 4.78 [en]C-CCK-MCD (WinNT; U)] Haven't tested with that -- I don't have a BillWare OS here -- but friends have accessed the archive from 95, 98, 2000, and XP that I know of. This is the first report that the 'Any Date' selection has not appeared checked by default. Wonder what could be causing it...? The archive has been tested with Netscape 4.0-4.78 on Solaris, Linux (RedHat 7.0), and MacOS; with Mozilla on Linux; with IE on MacOS; with Lynx and even with the browser in 'StarOffice' on Solaris. : I do loads of html and I hate Netscape with a passion, I think 6.2 renders pages like IE4, but I'm not even sure, and only .2% of websurfer use it. www.technodium.net/kira/kira.htm check this out with IE = perfect.. chek it out with NS, different for every version, even if all the tags are ok As for email spamming, you are right, since it's taken from a database. Unless the archive was called e-may, I think we might not have to protect the emails beyond leaving them outside of static webpages:-) That's my thinking... At 12:16 -0500 2001/12/17, Etienne Marcotte wrote: grr e-may my bad meant e-bay two keys beside.. I think I have the shake sorry! Having a bad spelling day, my friend? G Etienne Regards, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Searchable Mailing List Archive now up.
Hi everyone, Just want to make a very brief announcement. I've seen a few mentions in the recent past of the desire for a searchable archive of the MySQL list. I've wanted one, too. So, being ahem 'between contracts' right now, I decided finally to write one. I've actually been keeping an archive of the MySQL list for quite a while in anticipation of doing this some day. Just doin' my bit... The archive is at http://archive.workmate.ca/myarchive It's still in BETA, so this is a test release to see how it holds up. It's fully searchable on Subject or Body, on the From address, and by date range. It's running on a reasonably decent box (a Sun Ultra 1), but on a fairly slow connection (for now). The pages are quite compact, though, so as long as not everybody hits it at once, it should give pretty decent performance. : Written in Perl with MySQL as the backend, of course. : The archive is updated in real-time as the mails arrive, so it should always be up-to-the-minute. Take a minute and let me know what you think -- it's a work in progress, and feedback is appreciated. Thanks, all! /Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
- Original Message - From: Robert Alexander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 14, 2001 9:19 PM Subject: MySQL Searchable Mailing List Archive now up. So, being ahem 'between contracts' right now, I decided finally to write one. I've actually been keeping an archive of the MySQL list for quite a while in anticipation of doing this some day. Just doin' my bit... The archive is at http://archive.workmate.ca/myarchive Simply fabulous! Thanks! Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
Hi guys, I think i've already pointed this out but im also archiving ALL of the mailing lists from mysql at http://www.mysqldeveloper.com/lists/ Tony Buckley wrote: - Original Message - From: Robert Alexander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 14, 2001 9:19 PM Subject: MySQL Searchable Mailing List Archive now up. So, being ahem 'between contracts' right now, I decided finally to write one. I've actually been keeping an archive of the MySQL list for quite a while in anticipation of doing this some day. Just doin' my bit... The archive is at http://archive.workmate.ca/myarchive Simply fabulous! Thanks! Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php