TROUBLING INFORMATION

A FAQ on linking databases to Openoffice.org, another FAQ with answers about specific databases, and links to external resources addressing these issues, all at dba.openoffice.org. OpenOffice, ODBC, and MySQL HowTo (PDF). Using Microsoft Access databases in OpenOffice.org. Rick Morris asks “are there any good reasons to choose PostgreSQL over MySQL?” and answers “yes.” Buy Database Design for Mere Mortals by Michael J. Hernandez. MySQL Gotchas and Why Not MySQL? Yet another PostgreSQL vs. MySQL review. How to relate tables and databases with MySQL using phpMyAdmin. phpMyEdit — a phpMyAdmin alternative? The MySQL Manual.

“Exploring the Java Archive (JAR) Format” by Kulvir Bhogal. A terse Samba tutorial. Debian’s Apt How-To. Extant Gopher servers at Floodgap.com and Quux.org. Bash programming guides at arachnoid.com and Rutgers University. Furl, an online “filing cabinet” for saved webpages. Ad-blocking host files and advice about curbing ads and spyware under Windows. A big collection of links to online computer books at Ju Rao’s homepage.

Jukka Korpela on footnotes and endnotes in webpages. You can use OpenOffice.org, which records linked notes in its HTML-editing mode just fine. Don’t forget to count the words in footnotes.

The fundamental differences between the Winworld and the Nixworld. A page that explains, in a roundabout way, how to set up the appropriate relationships between /var/www/users and /home. Meanwhile, Apache virtual host documentation. comp.os.linux.misc on Google Groups. A serial laplink howto. IBM’s Windows-to-Linux overview pages. A guide to Linux groups on Usenet.
The beginnings of wiki.linuxquestions.org.

A script that allows the Knoppix CD to achieve LAMP with a MySQL database stored on a USB stick. A package that allows the CD to access a bundled copy of phpMyAdmin and a test PHP website. A Knoppix Samba FAQ. Using update-rc.d to add services on boot (this is also useful). Use /etc/init.d/bootmisc.sh to start the odd hardware driver or other processes. A script and a package list that are both helpful for apt-get-removing clutter from a hard-disk installation of Knoppix. Three knoppix.net discussions (one, two, three) on sorting out problems with mounting removable media. Godot’s Debian/Knoppix page. Klik installs key software to Persistent Home. Apt-get and dpkg tutorial and links. Configuring /etc/apt/sources.list using any number of mirror sites.

The Text Encoding Initiative: “TEI is an international and interdisciplinary standard that helps libraries, museums, publishers, and individual scholars represent all kinds of literary and linguistic texts for online research and teaching, using an encoding scheme that is maximally expressive and minimally obsolescent.” Jeffrey Veen on accessible design, with links to examples. Position Is Everything: a CSS site with an emphasis on designing around browser quirks (good links, too). CSS column layouts compatible with Netscape 4.x (and more here, too). How to use CSS to make line spacing consistent when using superscript and subscript characters. Design Detector pulls an extreme CSS stunt.

A Vim regular expressions tutorial. One hundred and one reasons to like Vim. On using macros in Vim. Steve Oualline’s Vim Cookbook. comp.editors, a Vi-dominated newsgroup.

Coppermine is a package of PHP scripts that lets you serve galleries of images from a server. Coppermine has a FAQ, an online manual, and a forum full of help, as well as an online demo. There’s also a stylesheet guide that helps with changing Coppermine themes.

Mike Dobson’s Squeek Machine reference pages, including clips of SQL code for MySQL. FAQts.com’s mySQL resources. Sanders Kaufman explains how to use MSAccess as a frontend for MySQL databases.

For Firefox: Mozedit text editor extension. Adblock and Flash Click to View to civilize commercial websites, and Linky and Magpie for chasing links and saving tabs. Spiderzilla for mirroring. Firesomething for rebranding. MiniT-drag enables tab rearrangement. Sort your bookmarks. Many more.

IceWM theme creation HowTo. Jeff Covey’s “How to Create and Use Themes” page (cross-window-manager information — more on implementing than creating).

Afghani war rugs. The Classic and Antique Bicycle Exchange. A gallery of Band-Aid boxes. Photos of toy cars in real parking places. Matchstick rockets. Death Stick hammers. The first computer bug. Embedded optic fiber yields translucent concrete.