Database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'jenv_jenvetterli.wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_date < '2025-01-15 21:33:33' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
Apologies once again for the lack of posts over the last several days. I’ve been having some ISP trouble, which will take a few more days (so I’m told) to resolve.
With any luck, there’ll be new content up here sometime early next week.
In response to my previous post, a friend sent me this link:
Cultronix - The Conceptual Space of Collage
Collage is a critical paradigm of the information age because it opens the range of possibilities through which we interpret information artifacts. Cut and paste enables semiotic construction that simultaneously leverages and detourns the means of production embodied by particular media elements. The recombination of genetic codes of meaning creates hybrid forms. Through these cross-currents, culture, and even knowledge, evolve.
I got to thinking about a few online news sites that rely heavily on a collage effect to transmit many news items in a visual way:
Are we going to rely more on interfaces like this to cope with information overload? When are we going to get RSS aggregators that look this?
Atomiq - Beyond the Page and Atomiq - Beyond the Page (the return)
alt tags - The Content Inventory: Roadmap to a Succesful CMS Implementation
(via Column Two)
Here are some additional resources on how to do a content inventory:
The following are examples that you can look at or download:
Update: See also Bloug - Applications to Aid in Content Inventories?, for ideas and pointers to tools for performing content inventories in large, distributed enterprise environments.
Spotted this quick news release via kottke (a while back now – this blog post has been sitting in my “Drafts” folder for a couple weeks):
EurekAlert! - How much can your mind keep track of?
Which, of course reminded me of this (in)famous article:
The Psychological Review - The Magical Number Seven, Plus or Minus Two: Some Limits on Our Capacity for Processing Information by George A. Miller (1956, vol. 63, pp. 81-97)
Everybody knows that there is a finite span of immediate memory and that for a lot of different kinds of test materials this span is about seven items in length. I have just shown you that there is a span of absolute judgment that can distinguish about seven categories and that there is a span of attention that will encompass about six objects at a glance.
Which has since been repudiated in its applicability to interface design:
Internetworking - Three Numbers That (Should) Have Nothing To Do With User Interface Design
(E)ven when it is cited correctly, Miller’s work is discussed as if the scientific understanding of short-term memory had not advanced at all in the last half century… More contemporary experiments show that an individual’s capacity for short-term remembering depends heavily on the nature of what is being remembered.
At best, Miller’s 7 ± 2 figure applies to immediate serial recall for a sequence of familiar, easy-to-pronounce, unrelated, verbal stimuli presented auditorily with no distracting sounds within earshot.
Net Return - Seven, plus or minus two. What’s the relevance for web design? (PDF, 90 kb)
See also:
Also picking up on the news release from EurekAlert!:
beyond bullets - 7 x 20 = Overload
Many people justify 7 bullet points per slide by citing the George Miller article, but what’s always missing in the arithmetic is the total number of bullet points across all of the slides; e.g., 7 bullets per slide times 20 slides equals 140 bullet points.
In turn, beyond bullets links to these two items:
© Jennifer Vetterli, 2005