Wednesday, January 18, 2006

Visual Basic Team Releases January LINQ CTP

Microsoft released the January CTP of the Language Integrated Query (LINQ) project's Visual Basic preview for Visual Studio 2005 on January 17, 2006. The big news is that the January CTP finally adds DLinq support to Visual Basic 9.0. You can download the January bits here. The new CTP replaces the September (PDC 2005) Visual Basic CTP that, unlike the C# version, didn't support DLinq for relational data sources. [Updated 2/7/2006]. The January CTP requires the release version of Visual Studio 2005 or Visual Basic Express, and works with SQL Server 2005 or SQL Server Express. (It probably also works with SQL Server 2000 or MSDE 2000, but I haven't tested that capability.) Microsoft hasn't tested the CTP with languages other than English. Although not stated in the Readme page, it's a good idea to use Control Panel's Add/Remove Programs tool to remove the September CTP version before executing Linq VB Preview (Jan 2006).msi. Running the CTP's installer adds a VB LINQ Preview item to your Programs menu with Readme, Visual Basic 9.0 Overview, Visual Basic 9.0 Samples, Visual Basic LINQ Project Overview, and XLINQ Overview choices.

SQLMetal.exe Updated for Visual Basic 9.0

The January CTP's version of the SQLMetal.exe utility creates the DatabaseName.vb class file that's necessary for mapping an SQL Server resultset to a LINQ object. (The September CTP's SqlMetal.exe didn't work with the /language:vb switch.) Later VB 9.0 versions will add a designer to simplify generating the mapping class file.

To create a Northwind.vb class file with nwind as its namespace by attaching the Northwind.mdf file in the C:\Program Files\VB LINQ Preview\Samples\Sample Queries\SampleQueries folder to your default SQL Server 2005 instance, execute the following from the "\Program Files\VB LINQ Preview\Samples\Sample Queries\SampleQueries folder:

"\program files\vb linq preview\bin\sqlmetal" /namespace:nwind /language:vb /code:Northwind.vb northwind.mdf

If you've already added a Northwind database to your default SQL Server instance, you receive a "Failed to attach an auto-named database for file northwind.mdf. A database with the same name exists ..." or "A connection was successfully established with the server, but then an error occurred during the loginprocess. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)" exception.

In this case, execute the following to create the class file from the server and database you specify in the following example, which assumes SQL Server Windows authentication:

"\program files\vb linq preview\bin\sqlmetal" /server:localhost /database:Northwind /namespace:nwind /language:vb /code:Northwind.vb

New January CTP Features

According to the January CTP's Readme page, the CTP adds the following new features to the September release:

LINQ Intellisense: Query statements now have statement completion, Intellisense, and Pretty Printing to improve overall discovery and readability of VB queries. DLinq Support: Previous tech previews of the LINQ CTP did not fully support leveraging the DLinq technology which is for querying against relational data stores, such as SQL Server. DLinq support in this release is limited in that only the working query syntax over objects will extend to DLinq. Editing support for XML Literals: The Visual Basic background compiler provides immediate feedback, with this release this support has extended to integrated XML. Specifically, XML literals are now automatically indented and XML literals plug into auto-correction. The XML literals are now completely colorized with customizability through the VS 2005 Options, Fonts and colors.
The following new features apply to XML late-binding:
Importing XML Namespaces: XML namespaces can be imported to the VB program using similar mechanism to importing CLR namespace. Accessing Elements with Namespaces: Once an XML namespace is imported, you can use qualified identifiers to access elements with namespaces. Indexer for IEnumerable(Of T): An indexer was added to IEnumerable of any type. This enables easy access to any element from a generic IEnumerable, specifically for accessing the first XElement from the XElements collection that is returned from XML late binding expressions.

Paul Vick Summarizes New January CTP Features

Paul's February 6, 2006 post on the availability of the January CTP was a bit late, but his informal summary of the new DLinq and XLinq features is quite useful:

  • We now support some Intellisense for Select expressions. This is a step forward in our investigation of the Select/From vs. From/Select question, so we’re definitely interested in feedback here.
  • We now support a lot more LINQ, specifically DLinq and variable capture (so you can now access local variables in queries). A huge chunk of my November/December went towards implementing lambda expressions and expression trees in Visual Basic and that, combined with some excellent work by another team member on variable capture, means a lot of stuff works now that didn’t before.
  • The editing/display experience for XML literals has been greatly enhanced — just having colorization makes a huge difference.
  • A bunch of extensions were made to the XLinq support to make working with namespaces and elements easier.
Here's a screen capture that demonstrates colorization of part of the code for generating XLinq XML literals with element values obtained with DLinq from the Northwind sample database: Online Demo and Newsgroup Paul Vick and Amanda Silver deliver "Visual Basic Futures: Latest Developments in the LINQ Project", a 10-minute video overview of the objectives of the LINQ project, plus a brief description of January CTP's new and improved DLinq and XLinq features. Amanda continues the presentation with a 20-minute demonstration of DLinq and XLinq in Visual Studio 2005 console applications that demonstrate basic DLinq and XLinq syntax in simple console applications, the LINQ VB Project Sample Query Explorer Windows form project, and a new (but apparently unfinished) visualizer that displays expression trees for LINQ queries, as shown here:

Unfortunately, the expression tree visualizer isn't included with the January CTP bits. Click here to read a trasncript of the overview and demo. You can post questions about the new VB 9.0 features and (hopefully) receive answers on the LINQ (General) newsgroup. The newsgroup's MVPs are mostly—or, more likely, entirely—C# coders. Sample Applications

The Programs, VB LINQ Preview, Visual Basic 9.0 Samples menu choice opens the [C:]\Program Files\VB LINQ Preview\Samples folder, which contains Hands On Labs, Sample Queries, Visual Basic 9.0 Survey, and XML DOM Survey subfolders. Following is a screen capture of the LINQ VB Project Sample Query Explorer form that opens when you double-click the [C:]\Program Files\VB LINQ Preview\Samples\Sample Queries\SampleQueries.sln solution file and run the 101 DLinq Samples JOIN SelectMany - 1 To Many - 1 sample (DLinq27()).

Note: The default connection string is: connString = "AttachDBFileName='C:\Program Files\VB LINQ Preview\Samples\Sample Queries\SampleQueries\Northwind.mdf'; Server='.\SQLEXPRESS';Integrated Security=SSPI;enlist=false". If you don't have SQL Server Express installed or you already have added the Northwind sample database, you must change the connection string in the DLinqSamples class's Declarations section to a value that suits your installation.

This project lets you execute the sample LINQ, DLinq, and XLinq queries and, for DLinq, display the T-SQL statement and, where applicable, the query resultset for the sample.

The other two sample projects are console applications that are similar to their corresponding September CTP counterparts.

Links to Earlier LINQ Articles and OakLeaf Blog Posts

"Comparing LINQ and Its Contemporaries" by Ted Neward from the .NET Framework Developer Center (December 2005)

"Late Binding in Visual Basic" by Paul Vick and Erik Meijer (December 1, 2005, 00:22:45 MSDN TV video)

"Streamline Mapping With Orcas and LINQ" article from the December 2005 issue of Visual Studio Magazine.

"Cure Data Type 'Impedance Mismatch' With LINQ," from Fawcette Technical Publishing's .NETInsight newsletters for PDC 2005 (September, 2005)

"The Language Integrated Query (LINQ) Project" (first LINQ post), September 14, 2005

"Erik Meijer on LINQ as a 6GL Language Feature," September 14, 2005

"LINQ Interview with Anders Hejlsberg and Paul Vick," September 19, 2005

"Jon Udell: Microsoft driving toward .Net unity," September 21, 2005

"XLinq Presentation at the XML 2005 Conference," September 23, 2005

"Comparing C# 3.0 and VB 9.0 LINQ Syntax," September 26, 2005

"More on Object-XML and Object-Relational Impedance Mismatch," September 29, 2005

"Jon Udell: LINQ 101," September 29, 2005

"Compose XML Content with XLinq Expressions and VB 9.0 XML Literals," October 1, 2005

"More on Visual Basic 9.0 and LINQ versus SQL," October 10, 2005

--rj Technorati:

Monday, January 16, 2006

InfoWorld Gives Thumbs Up to SQL Server 2005

InfoWorld magazine's "Special Report" for January 16, 2006, "SQL Server's extreme makeover," begins with this summary:

"Microsoft's flagship database pumps up to enterprise class with high availability, slick disaster recovery, rebuilt integration services, stronger analytics, and other heavy-duty enhancements."

Contributing Editor Sean McCown, who wrote "SQL Server bulks up," the five-page review of SQL Server 2005 and its management tools, says:
"More than five years in the re-making, SQL Server 2005 not only addresses shortcomings in high-availability and disaster recovery, but brings sweeping mprovements in almost every area. Management tasks have been streamlined, and monitoring and diagnostics have been beefed up. A default locked-down configuration, data encryption, and other new features strengthen security. Analysis Services, Reporting Services, and data Mining are now fully integrated and mature. DTS (Data Transformation Services) has been rewritten from the ground up, emerging as the more powerful and flexible SQL SSIS (Server Integration Services.)"

He gives SQL Server a score of 9.1 (Excellent) with 9 out of 10 points for managability, performance, availability and scalability, plus 10 points for value. I would have awarded 10 points for managability, which has been SQL Server's forte since version 7.0 introduced the "Starfighter" management tools. Starfighter was the code-name for the first version of SQL Server Enterprise Manager implemented as a Microsoft Management Console (MMC) application.

McCown reviews new SQL Server Integeration Services (SSIS), which replace Data Transformation Services (DTS) and feature .NET Framework 2.0 integration. He points out some annoyances with SQL Server Management Studio (SSMS), but gave the new Data Management Views (DMVs) high marks for providing DBAs with management assistance, server statistics, and reports. Increased security with DDL triggers to prevent undesired schema changes, better password management, control over schema changes, and column/cell-level encryption also received a nod. (See my "Encrypt and Decrypt Data in Yukon" article from Visual Studio Magazine for a developer's eye view of SQL Server 2005's encryption/decryption processing.)

High-availability (HA) features and disaster recovery capabilities get high marks for mirroring, online restores, and page-level restores. Although McCown noted that mirroring was unsupported in the November 2005 release version of SQL Server 2005, Microsoft promises a supported version in 2006. Online indexing also contributes to HA.

A "Development Snapshot" graphic's Pros section outlines new SQL Server 2005 features for developers, such as CLR integration, new T-SQL constructs, and native XML data storage. The Cons include lack of IntelliSense for T-SQL queries, which Microsoft promised and then reneged, problems with an "unresponsive interface" for SSMS (which I haven't encountered), and more complex queries for DVMs than their "deprecated counterparts." A "Cool Tools for SQL Server Coders" graphic lists the most important T-SQL enhancements. See "Take Advantage of New T-SQL Features" and "Exploit Yukon's XML Data Type" for more details and downloadable Visual Basic 2005 source code examples for these new features. The article doesn't review new SQL Server Service Broker (SSSB) features or native XML Web services capabilities. (See my "What’s New With VS and Data" interview, forthcoming Visual Studio Magazine article on SSSB and August 2005's "Create Interoperable Native Web Services.")

McCown gives SQL Server 2005’s business intelligence (BI) tools—SQL Server Analysis Services (SSAS), SQL Server Data Mining (SSDM), and SQL Server Reporting Services (SSRS)—a test drive and finds them "finally designed to work together to answer your intelligence needs." SSRS's Report Builder gets praise for its Report Model, which lets administrators define the data available to user-defined reports.

The review concludes with a rehash of what's missing in SQL Server 2005—Intellisense for T-SQL queries, a centralized code repository, and lack of a separate extract, transform, and load (ETL) server—and advice about if and when to upgrade to SQL Server 2005. McCown's closing remarks, however, say it all:

SQL Server 2005 is an excellent release that will gain Microsoft some real respect in the high-end database market. SQL Server’s tools now lead Oracle and DB2 in pretty much every area—management, monitoring, and especially development—and of the three vendors, Microsoft seems to be the most concerned about improving them.

About the Reviewer:

Sean McCown is a Contributing Editor for InfoWorld magazine and a frequent contributor to SQLServerCentral.com as well as the SQL Server Worldwide Users Group. He also writes the occasional product review for Computerworld and article for SQL Server Standard. His April 2004 "Databases flex their XML" review for InfoWorld drew this detailed response from Michael Rys, Microsoft's point man for SQL Server 2005's XML data type.

You can read Sean's book reviews on database programming, database and Windows security, and general database topics at his ITBookworm site, and read his advice for DBAs and DBA "war stories" on his DBA Rants blog. Sean is the Senior DBA for SourceCorp of Dallas, Tx, where he lives with his wife and two kids. He's practiced and taught Kenpo for the past 20 years. [Kenpo competency is very useful for DBAs, especially Senior (supervisory) DBAs.]

Sidebar: Taking the Database Beyond SQL

Tom Yeager, InfoWorld's Test Center chief technologist and new-technology blogger begins his analysis with this paean to integration of the .NET Framework 2.0 with SQL Server 2005:

Through integration with .Net, SQL Server 2005 takes its rightful place as an active peer, not a detached agent, in large-scale distributed applications. ... SQL Server 2005’s .Net integration creates a dream scenario in which SQL developers can incorporate the advanced functionality of .Net in their stored procedures, while C#, Visual Basic, and even JavaScript developers can work with databases as though they were language extensions.

But .NET integration isn't limited to creating stored procedures with native code; you can also write user-defined functions (including table-valued functions), user-defined aggregates, triggers, and—if you have the courage—user-defined data types with Visual Basic 2005 and C# 3.0. (JavaScript isn't a supported language for creating SQL Server objects.)

.NET might be the best thing since sliced bread (or Java integrated with competitors' RDBMSs), but native code running in the SQL Server 2005 process has the potential to be the most misused feature in this release. (See the "When to Use SQLCLR" sidebar to my November 2005 "Manage Data With VS 2005" Visual Studio Magazine article.

Ahead of the Curve: SQL Server could make 'better together' ring true

Tom Yeager says, "Windows [2003] Server [R2], Visual Studio [2005], and SQL Server [2005] may impress even hardened skeptics," and goes on to explain why "reality-based" is a better marketing slogan than "better together" for Microsoft's newly upgraded server systems and developer tools. Yeager contends that testing by Microsoft's IT department and tens or hundreds of thousands of independent beta testers creates a truly "reality-based" server suite.

Database Underground: An Answer to Open Source

Sean McCown's December 11, 2005 blog post argues that SQL Server and Oracle "freeware" (Express Edition) versions of their proprietary relational database management systems (RDBMSs) are more suited to mission-critical applications than "open-source" databases like MySQL and PostgresSQL. (See "Oracle Releases Free 10g Express Edition Beta," October 2005). McCown sees advantages to Express Editions' maturity, performance monitoring, and well-travelled upgrade path.

McCown didn't make an important argument in favor of Express Editions: There is little or no relief from vendor lock-in with "open-source" databases. Migrating databases from MySQL to PostgreSQL or—heaven forbid—HSQLDB is likely to be far more difficult than moving to and from Oracle, SQL Server, DB2, or Sybase. The commercial RDBMS vendors provide tools to accomplish the transation; with an "open-source" database, you're mostly on your own.

McCown wants Microsoft and Oracle to remove the 4-GB size limits from their Express Editions in the hope that doing this will induce Web site owners to migrate from "open-source" to "proprietary" databases. It seems to me that Microsoft and Oracle are delivering much a more useful and stable product than MySQL or PostfresSQL—the two major players in the open-source database market—and neither vendor charges for support. Microsoft provides an Express version of SSMS to handle simple database chores in a Windows UI. Bear in mind that the size limit is per database, not per server, and you can run many named instances of SQL Server Express on a single computer running Windows XP or 2003 Server. (See my May 2005 "Migrate to SQL Server 2005 Express Edition" Visual Studio Magazine article.)

Editor's Letter: SQL Server 2005 leaves open source databases in the dust InfoWorld editor Steve Fox supplies a pointer to Sean McCown's December 28, 2005 review of MySQL 5.0, "Long-awaited MySQL 5.0 makes its debut," and quotes McCown as referring to DBAs that use "open source" databases as “'tree huggers' who don’t want to pay for commercial software." The woods are full of folks who subscribe to the "software should (or must) be free" theory, so it's unlikely that this opinion piece will change many "open-source" proponents' minds. However, McCown's An Answer to Open Source might convince rational DBSs to at least consider an Express Editions of a commercial RDBMS. Note: eWeek's Lisa Vass wrote a similar column titled "MySQL vs. the Lite Databases: A Fair Comparison?" that appeared December 29, 2005. She published a related column, "Readers Respond to MySQL, Lite Databases Comparison," the following week. This second column described how readers took her to task for omitting PostgreSQL and Firebird from the initial comparisons. Technorati: P.S. In honor of Martin Luther King, Jr.'s birthday, celebrated Monday, January 16, 2006, I've finished a major update to my Squidoo lens (Web page) about The Black Scholar: Journal of Black Studies and Research, its history, editors and contributors.

Thursday, December 29, 2005

A First Look at Amazon Connect Author "Blogs"

This post is a bit off-topic, but writing books about databases consumes a substantial part of my time and contributes a significant part of my income. So I decided to create an author "blog" on Amazon's newly-announced Amazon Connect service that I discovered via Memeorandum today. I added the quotes around blog because Amazon includes the term plog in some of its Connect URLs and blog in other URLs and pages. According to TDavid, plog is an acronym for "product log," not "Web log." Plogs don't have much in common with today's blogs, in my opinion, so I plan to stick with plog in future references to Amazon Connect's message collections. Click here to display the Amazon page for Special Edition Using Microsoft Office Access 2003. Scroll past Product Details to the Amazon Connect section, which displays my plog in its natural habitat. Click the Roger Jennings' Author Profile Page link to read an extended bio, bibliography (of currently-verified titles), and five Favorite Books, Albums, Movies, and Periodicals. I discovered many posting problems with Amazon Connect that don't occur with standalone blogging tools, such as Blogger. My conclusion is that authors should consider the current Amazon Connect incarnation to be a beta-grade application. One of the characteristics of free (usually ad-supported) online utilities and tools is their perpetual beta state, which permits mini (weekly) or micro (daily or hourly) feature updates and bug fixes. Following are some of the issues I encountered when adding and editing a few messages to my Amazon Connect plog: 1. Creating an author plog involves a Byzantine process of vetting your credentials as the author of each of your books sold by Amazon you want to add to your bibliography. You must provide the e-mail address and telephone number of an agent, editor, or publisher of the book who will verify that you are its author. Fortunately, my current QUE acquisitions editor for Special Edition Using Microsoft Office Access [12] was at work today to verify my current QUE and SAMS titles. Titles from other publishers were verified after January 2, 2006. 2. As several other bloggers have noted, Amazon Connect doesn't publish an RSS 2.0 or Atom 1.0 file for syndicating author plogs. This omission appears to me to be intended to create a walled garden that's intended primarily for visits by Amazon customers. By itself, lack of an RSS or Atom file is sufficient to disqualify the Amazon Connect message collection as a blog. Lack of RSS/Atom syndication will discourage authors from spending significant amounts of time updating their plogs. 3. The WYSIWYG HTML editor lets you insert links to and images of books and other products from the Amazon site, as well as links to external pages. However, the editor doesn't offer a direct HTML editing choice. Thus, you can't add arbitrary images or format your "messages" other than with the editor's toolbar buttons. 4. You can't test external links in message preview mode. You must preview the message before you can post it; posting is required to test links, which open from an amazon.com redirect. It's very easy to forget to post (and thus lose) a new "message." 5. There's no indication of how to save a new or edited message. The only button on the editing page is "Preview your message," which you must click to open a page with a "Post your message" button. 6. All edits to existing messages I posted on December 30, 2005 returned a "An error occurred trying to post your message" warning. However, the edits persisted. The error message appears to be spurious. 7. Adding Favorite Books, Music and Movies to your Author Profile is limited to a list of books, albums, and DVDs or tapes you recently browsed on the Amazon site or that you've marked as owned. Fortunately, Amazon offers most of my favorite books, Brasilian music CDs, and film tapes/DVDs. 8. The Books, Music, and Movies You Own panes in the Build Your List of Favorite ... dialog is broken if you haven't marked any items as owned. For example, a "You don't have any items in ${hash-get canonName} you ownBooks You Own" message appears in the pane if you haven't marked a book you own.

9. Book thumbnail images inserted into message text need top, right, and bottom margins increased.

10. You can't format your author bio ("About Me") with HTML tags, nor can you add working HTML anchors. This omission is additional evidence of Amazon Connect's walled-garden policy. My bio, in particular, needs external links to avoid the need to add unnecessary trivia that's available elsewhere. I'd also like to be able to emphasize words with italic or bold fonts. The About Me textarea should be replaced with an upgraded WYSIWYG HTML editor.

11. The HTML editor needs a spell-checker similar to or, hopefully, better than that provided by Blogger. Spelling gaffes are especially embarrassing for authors.

12. Pasting content from other HTML sources can cause a substantial increase in font size. The HTML editor displays text in a fixed-size serif font so you don't see the font size change until you preview the content in a sans-serif font. The HTML editor doesn't enable font-size selection or correction. Workarounds for this problem are cumbersome, to be generous. Here's a screen capture that shows the increased font size starting at "Magazine Express, Inc."

13. It appears that you can't change the recipient list for a message nor can you delete a message. (If you can, I haven't found how to do it by experimentation or from the FAQ.) The inability to change the recipient list results in the need to duplicate posts that apply to bibliography items added after the post (post post?) or instruct readers to click the See All of AuthorName's Posts link. This is a very serious problem for me.

The preceding are issues (probably bugs) that I've encountered so far. I'll update this post as problems are corrected or new problems appear.

On the positive side:

1. If you log on with your Amazon account, which is difficult to avoid, you can edit your Author Profile and messages anywhere that you can read them. You might need to re-enter your password now and then to enable editing.

2. Amazon's automated e-mail system for verification of your bibliography appears to be quick and informative. You receive immediate e-mail confirmation of verification attempts and verifications that succeed. Amazon help-desk personnel intervene promptly when a verification issue occurs.

3. The ability to associate specific messages with a particular book (or group of books) is a great idea, but the ability to edit the book (recipient) list for a message is crucial.

--rj Technorati: SQL Server Express

Tuesday, December 27, 2005

Squidoo Beta Problems - December 2005

I've been testing Squidoo lenses as a supplement to the OakLeaf blog since the Web application entered the public beta stage in early December 2005. In the process, I created and/or edited three moderately large lenses with the Squidoo beta version(s) that were in effect from December 20 to December 27, 2005. Hopefully, other lens authors will find this account of my recent experiences useful. On December 28, I added some recommendations to increase Squidoo's usefulness. The suggestions appear at the end of this post. I added additional problems and suggestions in January 2006 after creating a very large lens.

Note: Web applications allow their developers to "go live" with updated beta versions at will. Thus, new features get added, some bugs get excised, and other regression bugs appear without notice. This means that the problems reported here might have been fixed by the time you read this or new bugs might have shown up. For the Squidoo team's view of their products status, check the SquidooStatus blog. Unless otherwise noted, the problems appear when editing or viewing with IE 6.0 or Firefox 1.5.

Squidoo Problems

Following are the more important issues that are currently affecting my three lenses, all of which have been reported to the Squidoo development team: 1. One of my off-topic lenses, No More U.S. Custom Surfboards?, lost about 75% of its content in the 12-hour+ period from 6:00 p.m. December 20, 2005 to 6:30 a.m. December 21, 2005. Two Linked List modules and a Text module disappeared from the lens, which was confirmed as successfully published. My recommendation is to keep local backups of your lenses as IE Web Archive - Single File (*.mht) files or Firefox Web Page Complete (*.htm) files. This problem was reported to be fixed by a code update on December 22, 2005. I haven't encountered a reoccurence of the problem, but I still recommend keeping up-to-date backups. 2. After December 20, 2005, I was unable to add this small *.jpg image file to a Text module of the custom surfboards page with IE 6 SP1 and the latest patches. There was no prior problem uploading and inserting the same image. Browsing for, inserting the file name in the text box, and clicking Upload Photo bypasses the Save operation and doesn't add the uploaded image to the module. Other sites also exhibit similar problems with images that previously appeared in text modules. The problem does not occur with Firefox 1.5. For software development purposes, I have IE 6 set as my default browser; other viewers and/or LensMasters might not have Firefox 1.5 installed. This problem appears to have been fixed as of 1/20/2006. (Updated 1/20/2006.)

3. The WYSIWYG HTML editor for the text of the Introduction module became inoperative on December 26, 2005. The HTML editor is frozen. For now, you must edit Introduction text with the pop-up HTML editing dialog. This problem appeared to be fixed as of about 13:00 on December 27, 2005. 4. Adding Technorati tag anchors—such as <a href="http://technorati.com/tag/surfboards" rel="tag">surfboards</a>—to the Introduction text doesn't work because Squidoo strips the rel="tag" attribute/value pair from the anchors. The reason for doing this is unknown. This problem appeared to be fixed as of about February 5, 2006.

5. Adding similar tag anchors to module or link Description text doesn't work, because Squidoo prepends http://www.squidoo.com/surfboards/%22 to the URL and strips the rel="tag" attribute to create the following unusable hybrid: http://www.squidoo.com/surfboards/%22http://technorati.com/tag/surfboards%22. The presence of the rel="tag" attribute appears to cause the erroneous URL problem. This problem appeared to be fixed as of about February 5, 2006.

6. Attempting to claim a Squidoo lens for a Technorati account results in this Quick Claim message: "Good news! We've detected that your blog platform, WordPress, supports Quick Claim, which is the easiest way to claim your blog." Obviously, a Squidoo lens isn't a WordPress blog. (Updated 2/5/2006.)

However, there's now a method for adding a lens to a Technorati account because both Squidoo and Technorati have fixed claim problems. Following is the workaround:

A. Start the Technorati blog claim process, proceed as if you were claiming a conventional Blogger or WordPress blog. The claim will fail.

B. Click Configure Blog, then click the Skip This Step link to bypass the WordPress Username and Password page, and click it again to bypass the Tehnorati Embed page.

C. On the Technorati Link page copy the link from the Step 3 text box to the Clipboard. The link will appear similar to <a href="http://technorati.com/claim/75fm94x63">Technorati" Profile</a>.

D. Open your lens and its Introduction module for editing, and click the HTML button to open the HTML editing window. Move to the bottom of the window, and paste the link into the text.

E. Click Update to close the window, Save the module, and click the Technorati Profile link to verify that it points to your Profile. Then click Publish.

F. Click Claim Blog Now to open the Configure Blog Claim page and complete the entries as you would for a conventional blog.

G. Clear the Show Technorati Embed on my Site check box, and then click Save changes.

Note: The preceding process failed for the OakLeaf databases lens, which was the first lens built in the Squidoo beta, but succeeded for all other lenses, as shown here:

7. I was unable to use I.E. 6.0 to add a Subtitle or Description element to a Linked List module after adding a link to the module and saving it. However, there was no problem doing this with Firefox 1.5. Firefox displays Add a Subtitle and Add a Description links if the Subtitle and Description element are empty; IE 6.0 doesn't. This problem appeared to be fixed at about 13:00 on December 27, 2005.

8. The Search Results page doesn't return consistent results for lens titles or tag names. For example, a search on oakleaf or database (but not databases) returns the OakLeaf Databases Lens and on microsoft or access returns the Microsoft Access Lens. Searching on hsqldb (a tag name) returns both lenses. The reason for the failure of databases is unknown. [This problem returned on 1/24/2006 and was fixed as of 1/26/2006] However, searching on custom or surfboard[s] doesn't return my more recent custom surfboards lens, nor does a search on any of the lens's assigned tags, such as blanks, epoxy, grubby clark, etc.. This failure indicates that a problem occurred with Squidoo's search system prior to publishing the surfboard lens. The result is that Squidoo users can't find my surfboards lens by ordinary search methods. As of 1/18/2006, searching on custom or surfboard[s] and most other tags now returns my custom surfboards lens, However, using custom as the search term places my lens (now rated #111) on the second results page, following several unclaimed lenses. It appears that tag-based searches still require some work. (Updated 1/19/2006.)

Note: On 1/12/2006, the Squidoo Status blog reported problems with corruption of the Squidoo search database. The itermittent nature of the search problem might be due to repeated corruption of the search database.

9. RSS modules don't update automatically to reflect changes to the specified blog. For example, I added an "First Look at Amazon Connect Author 'Blogs'" post. My update frequency for the Recent OakLeaf Blog Atom Links RSS module of the OakLeaf Databases Lens was set at once/day. Several days after adding the post, it didn't appear in the list. I had to manually edit and refresh the list to add the new post. The same problem applies to the RSS module of my Microsoft Access Lens. (Added January 11, 2006, reverified 1/19/2006.)

10. Star ratings (1-Poor through 5-Exceptional) appear to be arbitrary and there's no indication how users can assign ratings to a lens. Squidoo FAQ #15 states: "Your lens may be #406 overall, but still be the top ranked lens and the best rated lens (based on the user-rating star system) in your category." My No More U.S. Custom Surfboards? lens ranked #176 on 1/11/2006) but originally had a user rating of 1-Poor. C. S. Lewis - his life and writings ranked #217 but has a user rating of 4.5 stars. How did ordinary viewers assign these ratings and what prevents a "LensMaster" from logging out (to act as an ordinary viewer) and assigning five stars to his or her lenses? (Updated 1/11/2006.)

Note: Part of the answer to the the above appears to be that only users with Squidoo accounts can assign star ratings to lenses. I was able to assign 5-star ratings to all my lenses by logging on with another account that has no lenses, and clicking the 5-Excellent star repeatedly. (Unlike most polls, you can "vote" as often as you want in a single session.) You don't see the star rating until you log out and view the lens as an ordinary user. Check out my The Black Scholar lens as an example. (Updated 1/11/2006.) 11. Another recent problem is the disappearance of new added items to Link List modules. The empty added items text boxes appear momentarily in IE 6.0, and then disappear, as shown below in IE 6 SP1 with the latest patches:

You must save the Link List with the empty item and then edit the list to complete the entry. This problem began in IE 6 about 1/1/2006 but, like the problem with images in Text modules, does not occur when using Firefox 1.5. Squidoo is running LAMP, which usually implies Firefox as the default browser. However, there are many folks who have only IE 5+ installed. (Updated 1/11/2006.)

This problem appears to have been fixed as of 1/17/2005.

12. Squidoo's ranking method for lenses (LensRank) is unfathomable to be charitable. For example, my expansive The Black Scholar Lens ranked #297 on 1/19/2006, #317 on 1/17/2006 and #767 on 1/16/2006, which was a considerable improvement over #1,996 on 1/14/2006. The lens has been updated almost daily since January 1 and has more than 200 outbound links as of 1/16/2006. According to Squidoo FAQ #16:

"LensRank does a full sweep of all lenses in the Squidoo system and ranks them according to things like frequency of update, traffic, inbound and outbound links and more. We recalculate the rankings every day or so. So, if you just built a lens and are disheartened to see that it's at the bottom of the LensRank pile, or behind several unclaimed UFG lenses, don't worry. Give it a day or two and we bet you'll see the LensRank improve (ie: get smaller...remember, LensRank #1 is best). LensRank is built to reward human-made, updated, curated lenses.

Right now, as we are figuring out the proper LensRank and search ratings and fine-tuning the algorithms, you may find that our search function is not returning the lenses you would expect. In a perfect world, your handmade lens will have a higher LensRank--and therefore be a higher search result--than any unclaimed UFG lens. We are working to make this so. But you can do it too by making a great lens, including a lot of links, and updating often."

The original problem might have resulted from a hiatus in operation of the "ranking engine" during early January 2006. Minor daily changes to the lens, however, haven't resulted in substantial reductions to LensRank, which ranges randomly from about 280 to 320. Unlike my Surfboards lens, it appears impossible to affect the rating of The Black Scholar lens by making additions to or updating it. (Updated 2/5/2006.)

13. Module relocation in the Your Lens Layout frame doesn't work. Moving a module any distance in the main editing page is a PITA. This problem was fixed as of 2/5/2006; relocation now works like a champ.

I'll continue to update this post from time to time with additional problems I encounter or fixes/workarounds I find for the preceding issues. Suggestions for Squidoo Improvements

Following are suggestions that I believe would make Squidoo more useful to me and to readers of my lenses:

1. Permit lensmasters and, perhaps, ordinary Squidoo users to mark lenses as having no significant content, containing deliberately misleading information, or being spam (splenses). Presently, the Report This Lens link applies only to lenses that contain adult content and aren't flagged as adults-only lenses.

2. Add the capability to insert limited-size images into the Description element of Linked List items (similar to that for Text modules). Doing this could improve the page flavor of sites with a large number of links or links with longer descriptions (see the No More U.S. Custom Surfboards? lens's Linked List modules as examples.)

3. Add category sub-elements with domain-based tags to the RSS 2.0 <channel> element, such as <category domain="http://del.icio.us/tag" >surfboards</category> and <category domain="http://www.technorati.com/tag" >surfboards</category>, to support future tag-aware readers. Tag values could be extracted from the Squidoo Related Tags list, but it would be helpful to include an RSS editing feature similar to that for Squidoo tags. This suggestion is in addition to fixing the problems with Technorati tags in preceding problem items 4 and 5.

4. Consider adding RSS 2.0 <item> elements for all modules, preferably with domain-based <category> tags. Doing this might cause RSS readers to attempt to display individual modules instead of the entire Squidoo page.

5. Fix the alignment of the image added to the Introduction text for IE and Firefox browsers in View mode. (Alignment is OK in Edit mode with Firefox 1.5, but not IE 6.0 SP1). Text should be raised about 5px and the image dropped about 10px to correct the problem shown below in IE 6:

6. Fix the user-ranking (star) system and the LensRank algorithm, and explain (in some detail) the theory of ranking lenses. The current explanation appears not to be applicable to this Squidoo implementation. (Updated 1/14/2006.)

7. Correct problems with existing modules and current features before adding new modules, such as Indeed.

8. Increase the maximum number of characters of Text modules from 2,500 to at least 20K. The text limit is inappropriate for this module type and requires splitting text (includings lists) into multiple Text modules. This problem was fixed for lists as of 2/5/2006 by the addition of the Text List Module. (See The Black Scholar Issue List as an example that replaces three Text modules).

9. If possible, fix Firefox 1.5's SmartNavigation failure. When readers return from an outbound link, Firefox moves to the top of the lens page; IE 6.0 returns to the location from which the user clicked the link. This is a serious problem for readers of a large lens, such as The Black Scholar.

Let me know what you think about these suggestions and add your own as comments.

Technorati:

Thursday, December 15, 2005

Squidoo and Google Base: A Tale of Two Aggregators

Other than the obvious relationship between 23-skidoo—a roaring-twenties slang term for "I'm outta here," which might have originated in the Barney Google comic strip—and the Squidoo moniker, similarities between Squidoo and Google Base aren't readily apparent. Squidoo and Google Base are in the beta stage, and both aggregate Other People's Content (OPC, a.k.a. unpaid media). Both services store OPC and its search attributes in one or more databases, which makes them fodder for this blog. Updated December 27, 2005: The Important Beta Bugs section has been moved to the "Squidoo Beta Problems - December 2005" post of December 27, 2005. This update also includes minor revisions for events that occurred after December 20, 2005. Squidoo represents an attempt to reduce the information overload that's resulted from the exponential growth of Internet content. Squidoo pages (called lenses) let writers share their expertise on a particular topic with readers. As Adam Bosworth, vice-president of Google, stated in his "Collaboration, Customization, and Communication" presentation to the Second International Conference on Service Oriented Computing (ICSOC04):

"What has been new is information overload. Email long ago became a curse. Blogreaders only exacerbate the problem. ... "What will be new is people coming together to rate, to review, to discuss, to analyze, and to provide 100,000 Zagat’s, models of trust for information, for goods, and for services. ... "What will be the big enabler? Will it be Attention.XML as Steve Gillmor and Dave Sifry hope? Or something else less formal and more organic? It doesn’t matter. The currency of reputation and judgment is the answer to the tragedy of the commons and it will find a way. This is where the action will be."

Squidoo lenses are intended to be "models of trust for information." Whether lenses can gain similar stature for goods and services remains to be seen.

Google Base, on the other hand, appears to contribute to information overload by duplicating OPC in what could become the world's largest freely-accessible, Internet-based content database. Google Base's saving grace is the ability to categorize content for more precise searching.

Adding Items to Squidoo vs. Google Base

Squidoo offers hosted Web pages to which self-annointed "experts" can add Modules for free-text entry or that generate links to their blogs, Web sites, Flickr images, books, magazine or online articles, items for sale, and/or geographic location with Google Maps (which needs a minor address input fix as of December 15, 2005, but works OK with a fully validated USPS address.)

A Squidoo module is a special-purpose UI for adding and editing a particular type of data, such as RSS 2.0 or Atom 0.3/1.0 for automating multiple links to blog entries, generating and reorganizing lists of books on Amazon.com, manually adding links to Web pages, and processing Flickr photos. Modules enable Squidoo's developers to quickly add, modify, or delete data types. For example, an inoperative Technorati module disappeared on December 15, 2005 and a new Google Maps module arrived the same day.

Squidoo has a much more user-friendly item creation and editing UI than Google Base. I was able to build a reasonably complete "Oakleaf Database Lens" with links to about 70 individual items in less than an hour. Automated, direct import of this blog's Atom 0.3 feed and links to my books on Amazon.com streamlined the lens creation process. There appears to be no limit to the number of items you can import; however, lenses are limited to a single page and modules don't appear to have paging options. Thus, the practical limitation on the number of imported items probably is page height.

Squidoo lacks Google Base's capability to define custom item types, such as taxonomies, and has minimal module customization features. However, Squidoo more than compensates for these limitations by dramatically simplifying the process of bulk-uploading RSS 2.0/Atom 0.3 feeds. Another benefit of aggregating your content with Squidoo is that no Squidoo items self-destruct in 30 days.

The RSS/Atom Feed module updates automatically at user-defined intervals of 30 minutes to one week. Thus, maintaining a current blog entry list is a no-brainer compared with the bulk-update agony described in my "Google Base and Atom 0.3 Bulk Uploads" and "Bulk-Uploaded Items Disappear from Google Base" posts.

The Long Tail, Aggregators, and Filterers Almost all blogs—including this one—and Web sites are destined for the obscurity of the Long Tail. August Capital's David Hornik concludes in his December 13, 2005 "Where's The Money In The Long Tail?" VentureBlog post: [T]here are essentially two general classes of technology [that] will benefit economically from the Long Tail -- aggregators and filterers." Hornik goes on to analyze the roles of aggregators and filterers:

The aggregators are those web businesses that seek to collect up as much of the Long Tail content as is possible, so as to make their "stores" a one stop shop for content no matter how popular or obscure. ... The value to consumers from these content aggregators is that they need not shop in dozens of places on the web in order to acquire a diverse set of content. As a result, aggregators are able to extract a disproportionate amount of value for the sale of each individual piece of content. And while creators are likely to sell slightly more content as a result of the increased ease of salability, they will not likely emerge from the obscurity of the Tail merely because they are made available for sale on Amazon or iTunes. The filterers are those businesses that make it easier to find the content in which we are interested, despite the increasing proliferation of content creators, hosts, aggregators, etc. The purest form of filterer is the search engine. But the more obscure the content, the less effective the generalized search engine will be. ... Again, while these different filtering technologies may make it slightly more likely that an end user finds his or her way to a piece of obscure content, it will not likely be sufficient to catapult an artist into the mainstream. The beneficiary of the filtering is the end user and the filterer, not the content owner per se.
Hornik believes "that it is difficult to be an aggregator without also being a filterer. It will be hard to sustain the scale necessary for an aggregation business if you don't initially also provide some of your own filtering tools."

Filtering by Tagging

Squidoo enables you to assign an arbitrary set of tags to a lens, but not to individual items; Squidoo calls the lens's tag collection a Tag Cloud. As an example, the Oakleaf Database Lens has 30 database-related and a few off-topic tags. Typing database as the tag name in Squidoo's home page and clicking Find It returns a filtered list of lenses that share the tag, as shown here:

You can filter lenses with multiple matching tags by clicking one or more of the Get Picky items, for example sql and xml. You clear the additional filter terms by entering the same or a new key name in the Search text box. (The UI lacks instructions for clearing added search terms.)

Google Base lets you assign custom details name/value attribute pairs and add arbitrary tags to individual items. Searching for individual items by tag name(s) or attribute value(s) enables finer-grained filtering, which is important when filtering large page populations that have popular or broadly scoped tags.

Google is the Internet's most popular and eclectic filtering service, with basic Web page, blog, regional (Google Froogle Local), consumer product (Froogle), video, and (recently) music searches. Google Base intends to automatically assign user-created content to a specific Google filtering property based on its item type. The Google Base Help Center's "Where Will My Item Appear?" topic states:

The type of information in your item will determine which Google property will display it.

For example, any items you're selling will appear on Froogle. Your master's thesis or short story will appear on Google. And your glowing review of the new restaurant down the block would appear on Google Local.

Please note that these are guidelines only. We're unable to make predictions or guarantees about where your content will appear.

Thus, Google, not you, will decide where or if your content might appear. My "Google Base and Blogger Items Missing from Google Search" post has more details on these issues. Increase Blog or Site Traffic with Squidoo? Not Likely. Squidoo's FAQ includes these two unsubstantiated bullet points:
• Increase your traffic: Your lens points (if you want it to) to your blog and to your website. In addition, lenses have huge credibility with search engines, so a lens is going to increase the traffic to your website even for people who don't visit your lens. • [You should build a lens if you] have a Web site and you're not happy with your PageRank in Google, a lens will increase it. That's because a lens provides exactly what search engines are looking for: authoritative insight so people can find what they're looking for.
Seth Godin—the well-known entrepreneuer and author who founded Squidoo—might have authored the preceding claims, but I've found no evidence whatsoever that "lenses have huge credibiility with search engines" or "a lens provides exactly what search engines are looking for." I've yet to find more than one Skidoo page with a Google page rank other than 0; the SquidBlog has a rank of 4/10. Even Chris Anderson's "The Long Tail" lens (#2 of Squidoo's Top 100 lenses) ranks 0 with Google, despite the fact that Chris is credited with coining "The Long Tail" as a proper noun. Chris's blog has a Google rank of 6/10; this blog has a rank of 3/10. To my knowledge, both ranks have been the same for several months. Note: The similarity of the quotes in the preceding "The Long Tail, Aggregators, and Filterers" section from David Hornik's post in Chris's post of December 15, 2005 and this post is coincidental. As far as I can determine, potential lens users must visit the Squidoo site and search for the "expert's" topic to obtain the desired information or links to it. Squidoo appeared to have about 6,500 lenses as of December 15, 2005. But there's no easy way to separate Squidoo's pre-built and unclaimed "starter" lenses from actively-maintained lenses with useful content, so the number of the latter is up in the air. One would need unique visitors counts to determine the value of Squidoo as a whole and page view counts for individual lens activity.

Adding Squiddoo Lenses as Google Base Blog Items

You can add an entry for your Squidoo Lens as a Google Base blog item by signing in to Google Base and selecting the Create Your Own Data Type option on the Dashboard page's Post Your Item region. Type Blogs in the text box, as shown here:

Click Next to open the Edit Item page, which displays custom Details attributes—Home page, Author, and Blog type—for the custom Blogs item type, which doesn't expire. Add up to 10 Labels (tag names), content to the Description textarea, and an optional Skidoo page capture, as shown here:

Click Preview to verify your work, as shown here, and then click Publish to add the item to Google Base:

The newly added items appear in the Posted Items page, as shown here:

Clicking links that display the OakLeaf icon open the page. The other two links open the Oakleaf Systems's [sic] Items page, which is identical to the preceding screen capture.

Whether adding items for your Squidoo Lens(es) to Google Base increases their visibility in Google Web search remains to be seen, because Google search doesn't appear to index Google Base items at this time.

I ran Ping-O-Matic on the Oakleaf Database Lens immediately after completion and initial tests. A lens isn't a blog, so the lens's RSS 2.0 file contains only one item group with title and description elements. Content from modules isn't included as item groups.

Searching Google, MSN, and Yahoo with "squidoo : lenses : " site:www.squidoo.com returns varying numbers of links to others' lenses. After about 10 days I obtained a reference to my lens from Google and MSN (but not Yahoo) search with "squidoo : lenses : oakleaf " site:www.squidoo.com as the search term. It took more than a week for Google to re-spider the Squidoo site.

Comparative Terms of Use

Both Squidoo and Google Base are in the beta testing stage, so there's no guarantee that the services will remain in operation or preserve your content. Both services can terminate your access to the service at will. Thus the termination provisions of the Terms of Use agreements are important. The following is the text of paragraph 12. SQUIDOO CAN TERMINATE YOUR USE OF THE SERVICE of the Squidoo Terms of Service: Squidoo, in its sole discretion, may terminate your password, account or use of or access to the Service (including CO-OP Services), and remove and discard any Lens, for any reason. Some of the more likely reasons for termination are inaccurate information in the registration form, harassment of other Lensmasters, hacking Lenses or the Service, illegal transactions via Squidoo, and otherwise acting in violation of the terms or the spirit of these Terms of Service or other policies making a Lensmaster a fine, upstanding member of the Squidoo community. If Squidoo terminates your use of the Service, then your Lens may be immediately taken down, and your Squidoo Earnings Account may be closed. In this event, Squidoo will not be responsible to you or any third party for any termination of your access to the Service.

The following is the text of Paragraph 10. TERMINATION of the Google Base Terms of Service:

You may cancel your use of Google services and/or terminate this Terms of Service with or without cause at any time by providing notice to Google at googlebase-support@google.com; provided, however, that a terminated account may continue to exist for up to two business days before such cancellation takes effect. Google may at any time and for any reason, including a period of account inactivity, terminate your access to Google services, terminate this Terms of Service, or suspend or terminate your account. In the event of termination, your account will be disabled and you may not be granted access to your account or any files or other content contained in your account although residual copies of information may remain in our system. Except as set forth above or unless Google has previously canceled or terminated your use of Google services (in which case subsequent notice by Google shall not be required), if you have provided an alternate email address, Google will notify you via email of any such termination or cancellation, which shall be effective immediately upon Google's delivery of such notice. Sections 13 through 19 of the Terms of Service (including the section regarding limitation of liability), shall survive expiration or termination.

Business Models

Squidoo adds Google text advertisements to a panel on the right side of each lens. Skidoo claims to share its AdSense revenue with lensmasters by an ambiguous co-operative model, which is inoperative during the beta period. The Squidoo FAQs say the following about the revenue-sharing program:

DOES SQUIDOO MAKE A PROFIT? Yes, Squidoo is an old-fashioned corporation, with real employees and investors. We're not legally organized as a co-op, not in the sense that we've got granola all over the floor or that we are owned and controlled by volunteers. Instead, we've structured the organization so that we're in a partnership with our lensmasters. It's a co-op in the sense that the more you give, the more you get. All lensmasters with traffic get a pro-rated share in the income that we get from the Google AdSense ads that run on every page, for example. In addition, a rotating slate of lensmasters is invited to participate in the panel that chooses the charities that get the money from our charity pool.

We divide up the money we receive in a very public way. First, we pay our bills. That's direct out of pocket expenses like rent and servers and salary and benefits expenses (our CEO doesn't take a salary, and neither does our board of directors). Then, with no other deductions, we pay 5% of our post-expense revenue directly to the charity pool, 50% directly to our lensmasters and retain the rest to pay off investors and employees. Don't quit your day job yet, but you should know that as we all grow, our goal as a co-op is to pay as much money as we can to our lensmasters and to charity.

HOW CAN I MAKE MORE MONEY? Every lens carries Google AdSense ads. Those are used to pay our expenses and to generate royalties for all our lensmaster partners. If you want to increase your royalties, though, you should consider adding commercial modules that the visitors to your lenses will appreciate. You can sell books, point to eBay auctions or generate sales for more than 500 of our partners. Every single one of these modules generates directly attributable revenue for your lens, and we pay a royalty to you or to your chosen charity based on that income.

Build good lenses, feature great stuff and earn more royalties.

Like recording and movie production contracts, the primary issue with advertising and related income distribution is the amount of Squidoo's current and future "direct out of pocket expenses like rent and servers and salary and benefits expenses." A corollary of Parkinson's Law is "Expenses rise to meet [or exceed] income." There's no mention of recovery of start-up expenses, nor is there any cap on amounts to be paid for rent, servers, salary, and benefits. In other words, don't count on Squidoo to pay the rent.

Preliminary Conclusion

Squidoo's closest Web relative probably is Wikipedia. Both services depend on OPC—specifically, information and links provided by individuals who consider themselves experts in a particular subject. Following are the most significant differences between the two services:

  • Wikipedia restricts a topic to a single entry (page).
  • Squidoo encourages multiple lenses (pages) for a particular topic, and a single lens may cover multiple topics, which are specified by tags.
  • Anyone with an Internet connection and a Wikipedia account can edit any topic, which qualifies Wikipedia as a collaborative application. Wikipedia's volunteer editors focus on different fixes, such as countering systemic bias; fact and reference checking; fixing punctuation; and improving grammar. Wikipedia administrators address issues such as vandalism and edit wars.
  • Only the designated lensmaster(s) for a specific Squidoo lens can edit its content. Squidoo relies on individual contributors and doesn't edit content or provide any facility for user feedback by public comments, numeric ratings, or stars. (The five rating stars in the lens's right pane's Lens Stats section currently are unused and read-only.) If enabled in the lensmaster's profile, viewers can send e-mail comments to the lensmaster.
  • Squidoo "use[s] an automated algorithm—LensRank—to rank the lenses. We look at user ratings, lensmaster reputation, clickthrough rates, frequency of updates, inbound and outbound links, and other factors and give the lens a number." (Apparently, lower is better, but—despite a claim of transparency—Squidoo doesn't disclose the basis of its ranking algorithm.)

Safari Software's Bob Walsh, a Squidoo enthusiast, provides independent insight on the value of Squidoo to users, small independendent software vendors (micro-ISVs), and doubters. Jeff Jarvis at Buzz Machine adds a positive review of Squidoo's Web 2.0 preview.

The key to Squidoo's ultimate success and its usefulness to contributors will be ubiquity. Users must associate Squidoo with targeted, accurate information on a wide variety of topics. Wikipedia currently has articles for about 870,000 topics. Type define: database, define: client-server, or define: whatever in the Google search bar and an en.wikipedia.org/wiki/topic link usually shows up in the Definitions list. Ensuring that major search engines return reasonably ranked Squidoo lens references for common search terms will require some heavyweight search-engine optimization (SEO).

Squidoo shares the "guide" approach with the New York Times Company's About.com, but doesn't require guides to be vetted. About.com has been in business since 1997, so it has substantial depth of "consumer information and advice" that's provided by 475 official guides on 50,000+ topics. For example a search on database returns 12,233 references; databases returns 5,363. This surfeit of links minimizes About.com's usefulness to neophyte users. On the other hand, About.com claims it's "a top 15 Web property used by one out of every five people on the Internet," with 22 million monthly users. This might be why the NY Times Co. paid magazine publisher Primedia $410 million to acquire About.com in February 2005. Whether there's a sweet-spot of search specificity and reach for Squidoo remains to be seen.

Squidoo must be prepared to eradicate spam lenses (splenses?) or parked lenses (plenses?) that have minimal or no content. As an example, the Figure Skating lens contains a single link to a page for a Massachusetts figure skating club. Handling spam requires surveillance by Squidoo employees and feedback from viewers or lensmasters. There appear to be thousands of autogenerated empty lenses that should be eradicated. A feature similar to Google Base's Report Bad Item link could prove useful in combatting Squidoo spam and other abuse.

Note: Squidoo provides lensmasters a Report This Lens link in the Lens Stats group of the right frame. The link only appears when a lensmaster is logged on to another's lens. Clicking the link displays this message: "Report this lens only if it contains obscene or illegal content, or if it has adult content and the lens is not marked as Adult." The link also displays a single-line Comments text box.

This link isn't equivalent to Google Base's Report Bad Item link because of its restriction to obscene, illegal, or adult content and lensmaster-only access. Viewers should be able to report lenses as spam or having no or deliberately misleading content to Squidoo. Sending e-mail to the offending lensmaster isn't likely to have the desired (or any) effect.

Technorati: