Tuesday, October 28, 2008

Roses in the Snow

This has been a very strange fall here. My roses are particularly confused this morning.

Saturday, October 25, 2008

OpenOffice Base With and Without MySQL

Here are some more useful links I've dug up in my search for tools to use in cataloging the Pocahontas County historic collections. In addition to using specially-written front-end programs for MySQL, I've found that Open Office can also interact with MySQL. Here are the references I found most useful for this project.

OpenOffice Base With and Without MySQL

Friday, October 24, 2008

Mantis Portraiture

All summer, this mantis (or a series of sibs) watched over the house-building process. Earlier this month, I took some pictures, then turned her loose. The next day, we noticed her walking deliberately up edge of the roof. When she reached the peak she paused, facing out over the yard as if surveying her territory. She would have made a great gargoyle model. The hard frost we had this week probably was the end of her.

I had never noticed the red coloring on mantis mouthparts before. Lipstick on a mantis? It seems like that conceit is going around. Pit bulls and pigs are cute and cuddly compared to these creatures.

Friday, October 17, 2008

Archives and Digital Collections

Along with selecting, installing and testing archival databases, I've been trying to learn the archivist-lingo, so that I may understand the best ways to proceed with cataloging and digitizing the history-related collections around Pocahontas County. (Hence many hours in front of the computer screen, yet no blog posts.) Here are some of the things I've been reading lately.

Helpful Resources for Archive and Collection Management

Exemplar Archives

More References

Friday, October 10, 2008

Roof, Doors, and Windows

The roof is on, and the house wrap, doors, and windows make it look like a solid structure. We will have to look at the home improvement store advertising until the hemlock siding is cut and ready for us. I hope that will be soon, but, like so many things, the lumber will be ready when it's ready.

Tuesday, October 07, 2008

Wordpress, MAMP, Drupal, LAMP--Linux Is Easier Than Mac

I was very taken with the idea of MAMP: One-click solution for setting up your personal webserver. MAMP is installed in the typical Mac fashion: very easily. MAMP will not compromise any existing Apache installation already running with your OS X. You can install Apache, PHP and MySQL without starting a script or having to change any configuration files! Furthermore, if MAMP is no longer needed, it is sufficient to delete the MAMP folder and everything returns to its original status (i.e. MAMP does not modify any of the "normal" OS X).

I really liked the idea that I could install a CMS, play around with it, and just dump the whole database and loalhost content if I messed it up. I thought it would be easiest to start out with Wordpress, rather than Drupal or one of the digital library CMS's, because so many people use Wordpress successfully. It must be easy, right?

Well, it didn't work that way. I installed MAMP successfully, I thought, but I couldn't get Wordpress to communicate with the MySQL database. Eventually, I gave up and turned to my Debian desktop, where I installed the usual LAMP setup. Drupal worked almost right "out of the box." The only problem I had was that I had an old version of Apache 1.3 installed, from my efforts to configure a network file system (NFS) back in March. Once I removed that and reinstalled Apache 2, it was a cinch to install Drupal on localhost.

This gave me an idea--I thought I had turned off all the network services in the Mac "System Preferences: Sharing" window, but when I poked around a bit more, I found "Apple Share" turned on. Once that was turned off, Wordpress installed easily on MAMP's localhost:8888 just as advertised. Here are a couple of resources that helped me with the Wordpress/MAMP install.

So, it probably would have been easier to start with Drupal in the regular /var/www directory for localhost on the Mac. Here are the directions I found helpful for that process.

Guides to a "Full-blown" LAMP setup for Mac OSX Leopard

  • Installing WordPress On Your Apple MacAn interesting but often overlooked feature of an Apple Mac is that it comes bundled with a fully functional copy of the Apache web server and PHP - the language of WordPress. Add a MySQL database server to the mix and you have a fully functional, but personal, web server where, like me, you can test your website and write and debug code without ever exposing it to public view.
  • Leopard: How to Install Wordpress also details adding MySQL, turning on PHP5, installing your CMS of choice (Wordpress again), and running localhost.

Monday, October 06, 2008

The Meme of Unspectacular Facts

Sherry Chandler tagged me for the "six unspectacular things about you" meme. I actually still owe Sherry a post for the page 123 meme from February 25 of this year. In that meme, you were supposed to pick up the book nearest you, turn to page 123, find the fifth sentence, and post it. Sherry had high hopes for me, maybe some arcane local history book. In fact, the nearest book was How to Make Sewing Patterns by Donald H. McCunn. Page 123 of that book, "Gathered Sleeve Cap," had only four sentences. The next nearest books were four shelves of odd-sized books: music books, cookbooks, knitting books, sheet music, and pamphlets. Book after book either lacked page 123, or had no sentences there. At that time, I was substituting daily at the middle school, and by day's end, my supply of resourcefulness was utterly depleted.

I'm still feeling guilty about that activity, so I'd better get after the current meme. I suppose all facts about me are unspectacular, so it shouldn't be hard, eh?

  1. I'm left-handed.
  2. My earliest childhood memory is of a caterpillar.
  3. I have always preferred tea to coffee.
  4. I learned to read from the funny papers in the Des Moines Register.
  5. My fingers are long and spatulate, but my thumbs are relatively short. This dashed my dreams of playing Irish or Cajun button accordion.
  6. I have the same birthday as Katherine Anne Porter, she was born the same year as my maternal grandmother (two weeks earlier), and I lived for five years (1987-1992) in the town where she died (Silver Spring, MD). I knew none of this when I first read Pale Horse, Pale Rider in 1974, but I had a disturbing sense of deja vu about "Miranda."

I've never had any luck tagging anyone with a meme, so if no one's tagged you and this sounds like fun, go ahead and meme away. The meme terms & conditions are: "1. link the person who tagged you; 2. mention the rules on your blog; 3. list 6 unspectacular things about you: 4. tag 6 other bloggers by linking them."

Apache Server, MySQL, and PHP On Mac OS X

I have a Macintosh laptop to use for work now (Woo hoo!), so I need to get more comfortable with Unix-y things on OS X. Currently, I'm learning about databases and Web 2.0 on Debian Linux, then grabbing the laptop and trying to do the same thing there. Sometimes, everything works, sometimes it doesn't. Here are my relevant helpful links:

Apache Server, MySQL, and PHP On Mac OS X

Sunday, October 05, 2008

More Messages From the Kingdom of Vegetables

I picked the last cabbage from our garden for cole slaw last week. These red cabbages made small but tasty heads. It was the vivid color that sent me outside in mid-chop to take some pictures.

There's something a little hypnotic about the sliced cabbage pattern. My parrots are very fond of cabbage, but they were afraid of the red cabbage cores--they wouldn't even go in their cages until I removed the scary vegetables. What do you suppose the cabbage told the parrots?

Learning About PHP and MySQL

I've been trying to teach myself PHP (among other things) for my latest joblet. Terry attests to its empowering effect, and I do get giddy when I learn something new. Terry recommends Larry Ullman's PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide, and I will probably have to buy it, but I am profoundly cheap, and have limited book shelf space, so I'm trying to figure things out with free Web tutorials. My inevitable list of links follows.

PHP Tutorials and Advice

MySQL Tutorials, Documentation, and Installation Tips

Saturday, October 04, 2008

Famous Wolf River Apples

Ever since I moved to Pocahontas County, people have been telling me about the old-time apple variety "Wolf River." This was once a popular variety, but most trees have died out. Apple fans say of them, "One apple, one pie." Last week, a neighbor brought us some Wolf River apples--the three red ones in the picture. The green apple is a normal-sized variety. I've been assured that these are smallish specimens. I really like the color and texture of the skin. I'll be cutting into these today, but I had to catch a picture of them first.

Wednesday, October 01, 2008

An End To Transparency

This is probably the last picture of the house as see-through structure. Now the roof tin will shut out the sky (especially the rain!), windproof wrap will stand in for the exterior walls, and the doors and windows will assume their intended positions.

Tuesday, September 30, 2008

Catnip

Some modest, late season catnip blossoms, to break up my lists of computer project resources. (And I have more...much more.)

Sunday, September 28, 2008

Still More Digital Library Resources

I continue to shop around, kicking the tires on content management systems for Web sites and software for digital collections libraries. I'm planning to download Drupal (digital content management for Web sites) and experiment with it. As for Digital Collection management, I'm leaning strongly toward Archon, and have downloaded and started to play with it as a tool in managing the historical society's cataloging project.

However, all this shopping is a recursive project. As I've tried to understand the tools I've selected, I keep finding more tools that also deserve a look. The essay Drupal as a digital library content management system pointed me to these interesting applications:

  • Greenstone Digital Library Software Greenstone is a suite of software for building and distributing digital library collections. It provides a new way of organizing information and publishing it on the Internet or on CD-ROM....The aim of the Greenstone software is to empower users, particularly in universities, libraries, and other public service institutions, to build their own digital libraries. It requires Apache; it also has some nice features only available on the Windows version....
  • STREETPRINT.ORG, A growing community of public web archives powered by the Streetprint Engine. This package actually looks very nice, but there's no recent sign of life on the Web site, where the newest post on the forums is dated 2007.
  • ContentDM from OCLC (Online Computer Library Center) is a nonprofit, membership, computer library service and research organization dedicated to the public purposes of furthering access to the world's information and reducing information costs. You have to email to request a quote, and it seems Windows-centric. They say the server runs on UNIX platforms, but it doesn't sound like they've tested on Linux since kernel 2.4 came out.
  • digitizationblog focuses on digitization and related activities (such as electronic publishing) in libraries, archives, and museums, and is intended to be a source of news relevant to people who manage and implement digitization projects. Even though there are several excellent sources of digitization news such as the DigiCULT Newsletter and RLG DigiNews (and this blog certainly isn't intended to replace them), there is a lack of space on the web where implementors can share ideas and useful pointers. digitizationblog is intended to fill part of this gap.
  • Welcome to the WebAPP, Web Automated Perl Portal!: WebAPP is the most fully-featured, versatile, free and open-source, flat-file Perl portal script available today! Acronym for Web Automated Perl Portal, WebAPP is easily installed on virtually any UNIX-based server. WebAPP requires no SQL backend, no PHP, only a hosting environment offering support for Perl. This seems very attractive to me because I wouldn't have to learn much new stuff, and I could get Web sites up quickly, for me and for the library project. Also, it wouldn't be vulnerable to these spam SQL-insertion attacks that have been going around lately.

Thursday, September 25, 2008

Digital Collections and Library Resources

Here are some links and references about libraries, digital archives, and software designed to store and share collections data. There is an immense amount of information about these topics, and this is just a sample of things I found that look promising for our county history project.

Case Studies: Library Archives and Web Sites

  • Open Source Digital Image Management Took Us from Raging Rivers to Quiet Waters. This is a case study of a library with a fast-growing digital image collection. They were trapped between the under-powered proprietary database suite they'd been using and a pending university-wide move to a large, complex database system. As an interim measure, they adopted a MySQL database, and were very pleased with the results.
  • Library Success: A Best Practices Wiki: created to be a one-stop shop for great ideas and information for all types of librarians. All over the world, librarians are developing successful programs and doing innovative things with technology that no one outside of their library knows about. There are lots of great blogs out there sharing information about the profession, but there is no one place where all of this information is collected and organized. That's what we're trying to do. Includes a section on Digitization, which points to a long pdf on local history, Local History in E-Books and on the Web : One library's experience as example and model by Don Litzer and Andy Barnett. (from the Spring 2004 Reference and Users Services Quarterly). A peer reviewed article analyzing the value and impact of digitized local historical documents.
  • About ACVA: About the Project--Atlantic Canada Virtual Archives. Another case study, including nuts and bolts details about file types, formats, programs used.

Software Tools for Libraries

  • Digital Library Construction Tools: Software from The British Columbia Digital Library. Definitive list of links with brief descriptions.
  • Archon: The Simple Archival Information System. Hardly a simple system, Archon was developed at The University of Illinois at Urbana-Champagne, and is open source and free. Archon is a web-based tool for archivists and manuscript curators. It automatically publishes archival descriptive information and digital archival objects to a user-friendly website. With Archon, there is no need to encode a finding aid, input a catalog record, or program a stylesheet. Archon's powerful scripts will automatically make everything in the system searchable and browseable on your repository's website! Archon will simplify your workflow and save you time. Once you've input or edited information using some simple web forms, Archon automatically uploads the files, publishes the website, and generates EAD and MARC records.
  • DLXS: Digital Library Extension Service. This is the software used by the University of West Virginia Library's Archives. Developed by the University of Michigan, DLXS has a free, "lite" version and a supported, for-pay version for "heavy-duty use."
  • The Fedora Project: An Open-source Digital Object Repository Management System. This is the original publication of the Fedora project, describing it to other informatics specialists. Fedora is scalable for large, complex digital collections. The Library of Congress uses it, but smaller projects, like online encyclopedias of limited scope find it usable as well. For those interested in using Fedora, Fedora Commons provides sustainable technologies to create, manage, publish, share and preserve digital content as a basis for intellectual, organizational, scientific and cultural heritage by bringing two communities together. There's an active support community, quick download directions, and many users' online presentations are available for examination.
  • Omeka is a web platform for publishing collections and exhibitions online. Designed for cultural institutions, enthusiasts, and educators, Omeka is easy to install and modify and facilitates community-building around collections and exhibits. Omeka is free and open source. System requirements include: Linux operating system; Apache server (with mod_rewrite enabled); Mysql 5.0 or greater; PHP 5.2.x or greater; ImageMagick
  • How To Set Up A Debian Linux Database Server Using MySQL. Step by step directions from aboutDebian.com--If you decide this is what you want to do, this page tells you exactly how to set up MySQL.
  • How to install MySQL on Ubuntu/Debian. Another approach to installing MySQL on Linux.
  • The phpMyAdmin Project: phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields. This is the download and official documentation site.
  • Organize Your Images in a MySQL Database- Tips for creation of a MySQL database with images. This article is written for individuals wanting to organize personal collections of digital images, but the basic information is applicable for any project.
  • Managing websites using Unix--A CVS tutorial. Making and managing a Web site repository using command-line programs and shell scripts. Must try this!

Library Weblogs Addressing Digital Collections and Web Presence

Wednesday, September 24, 2008

Natural and Unnatural

To make up for recent computational excesses, here are more photos from Seneca State Forest the last week in July. I always prefer to use natural light for my pictures, but these are some dark hollers where the sun refuse to shine. The flash gives dramatic results, and I should learn to use it more effectively, but there's something special about the colors you see in the dim light.

New (To Me) CSS and HTML Tutorials

I'm hand-coding Web sites now, which means static (and faster loading) pages for the short term. Of course, nothing works the way I expect it to, so I've had to brush up on my HTML and CSS skills. Here are some of the free resources I've been using.

Web Design Tutorials and Resources

CSS Layouts: Fixed versus Fluid

Tuesday, September 23, 2008

Web Editors and Tools in Linux

Another aspect of my recent Linux Geekfest has had me studying and trying out different "web development tools." My tool of choice for Web work has been Emacs, the One True Editor, but I'm looking at tracking some larger, more complex projects, and possibly training someone else to work on the Website someday. Strangely, I've never successfully converted anyone to the Church of Emacs, so it seems prudent to add some easier-to-adopt tools to my kit.

Several years ago, I used Bluefish Editor, (native to the Gnome desktop environment) but I became frustrated with all the mouse-clicking it required, and, after I discovered html-helper-mode for Emacs, I abandoned it. I did miss the colorful way it displayed html-markup, but I got over it.

Since then, I have switched from Gnome to KDE because I didn't like the new Gnome screensaver program. (I had originally adopted Gnome for an equally trivial reason, back in 2002.) The html-editor of choice for KDE is Quanta-Plus, so I thought I'd give it a whirl. In fact, because I have both Gnome and KDE desktops installed, I can use either Quanta-Plus or Bluefish, or both.

These editors do the same things equally well--I can't really say one is better than the other, but I have spent more time using Quanta Plus. Actually, I still write the html in Emacs, then open it in the fancy editor, check for errors, use the project management tools, and generally fine-tune the pages.

The tools I have found most useful are Firefox add-ons and extensions, and small utilities. Here is my list of favorites:

  • Agave Colorscheme Designer: Agave is a very simple application for the GNOME desktop that allows you to generate a variety of color schemes from a single starting color. Really fun to play with, but also quite helpful. You can grab a color out of a photograph, and generate a color scheme to match it.
  • Web Developer extension for Firefox adds a menu and a toolbar to the browser with various web developer tools. It is designed for Firefox, Flock and Seamonkey, and will run on any platform that these browsers support including Windows, Mac OS X and Linux. This is really great. I've learned a lot by going to Web sites that I like the look of, and taking a look at the CSS to see how it works.
  • Firebug. You can edit, debug, and monitor CSS, HTML, and JavaScript live in any web page. It lets you see the CSS and HTML just as Web Developer does, but it also lets you "mess with it," change stuff and see what happens. Very cool!
  • Web Development Tools on Linux. A clear, easy to understand description of many "tools" (programs) that make Web sites work these days.

Web Editors For Linux-Land

Monday, September 22, 2008

Shopping For Content Management Systems

More Linux geekery: What tools to use in planning, developing, and maintaining my own Web site and the one I'm developing for a county historical preservation project? Should I have static Web pages? PHP and MySQL? Could I get by with Perl (which I already know how to use)?

I'm not very knowledgeable in Web 2.0 database driven stuff, but I'm going to need a photo gallery, thumbnails, and a database for the county Web site. That's why I've been reading up on "Content Management Systems." Here's a list of links showing what I've learned about so far.

  • Drupal requires Apache, PHP, MySQL. Drupal is a free software package that allows an individual or a community of users to easily publish, manage and organize a wide variety of content on a website. Tens of thousands of people and organizations are using Drupal to power scores of different web sites.
  • Joomla! is an award-winning content management system (CMS), which enables you to build Web sites and powerful online applications. Many aspects, including its ease-of-use and extensibility, have made Joomla! the most popular Web site software available. Best of all, Joomla is an open source solution that is freely available to everyone. It requires mySQL and PHP, which most ISP's provide.
  • Comparing Open Source CMSes: Joomla, Drupal and Plone. Another review of relative merits.
  • Drupal vs Joomla! comparison on Drupal's General Discussion Forum. The consensus seems to be that Joomla! is easier to use out of the box, but Drupal is better in taxonomy, search engine optimization, and customizability.
  • phpWebSite provides a complete web site content management system. Web-based administration allows for easy maintenance of interactive, community-driven web sites. phpWebSite's growing number of modules allow for easy site customization without the need for unwanted or unused features. Client output from phpWebSite is valid XHTML 1.0 and meets the W3C's Web Accessibility Initiative requirements. Founded and hosted by the Web Technology Group at Appalachian State University, phpWebSite is developed by the phpWebSite Development Team, a network of developers from around the world. phpWebSite is free, open source software and is licensed under the GNU GPL and GNU LGPL.
  • blosxom :: the zen of blogging: Blosxom (pronounced "blossom") is a lightweight yet feature-packed weblog application designed from the ground up with simplicity, usability, and interoperability in mind....Despite its tiny footprint, Blosxom doesn't skimp on features, sporting the lion's share of features one would find in any other Weblog application or full-blown content management and publishing system. Blosxom's plug-in architecture allows the core of Blosxom to remain small and sleek while providing room for extension and integration into different environments and uses....Blosxom is simple, straightforward, minimalist Perl affording even the dabbler an opportunity for experimentation and customization.
  • WordPress. It's not just a blogging tool, WordPress is a state-of-the-art publishing platform with a focus on aesthetics, web standards, and usability. WordPress is both free and priceless...
  • Plone" Plone is a ready-to-run content management system that is built on the powerful and free Zope application server. Plone is easy to set up, extremely flexible, and provides you with a system for managing web content that is ideal for project groups, communities, web sites, extranets and intranets. Zope doesn't seem to be supported that widely by ISP's.
  • PHPMYADMIN is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.
  • CMS Mini (very very small CMS): A small PHP application for manage content for small web sites. Not intended for a cooperative group of editors and rewiers: simply one editor can insert new contents, immediatly pubblished on web: "one task, one click"The editor can edit through a browser interface; sounds really nice, but it seems there are security vulnerabilities.

Sunday, September 21, 2008

Coral Diving in Pocahontas County

Lest the weblog gets too Linux-geeky, here's another, different coral fungus from Seneca State Park.