# RootPrompt.org   Nothing but Unix.[Home] [Features] [Programming] [Mac OS X] [Search]

Cooking with MySQL
On Lamp brings us: Cooking with MySQL.
"It makes a lot of sense for aggregate functions to ignore NULL values. If they followed the usual SQL arithmetic rules, adding NULL to any other value would produce a NULL result. That would make aggregate functions really difficult to use because you'd have to filter out NULL values yourself every time you performed a summary to avoid getting a NULL result. Ugh. By ignoring NULL values, aggregate functions become a lot more convenient."

( Permalink: Cooking with MySQL      Submitted by Noel Tue Nov 26, 2002 )

BSD Disk Images
On Lamp tells us about BSD disk images.
"I'm repeatedly installing OpenBSD on a test machine, but I don't want to waste a keyboard or a monitor on it. While I have the equipment, desk space is precious. That leads me to a serial console. Booting an OpenBSD system with a serial console is pretty easy: enter set tty com0 at either the boot prompt or in /etc/boot.conf. The first won't work in this case. If I had a keyboard and monitor attached, I wouldn't need the serial console."

( Permalink: BSD Disk Images      Submitted by Noel Tue Nov 26, 2002 )

Review of Xandros Desktop 1.0
OSNews has a review of the Xandros Desktop 1.0, which is aimed as an alternative to Win9x users. The author talks about the installation and feature-set of Xandros, but he also did a mini-usability test, putting some of his Windows-oriented friends to use Xandros and he concludes that "what Xandros has achieved in the Windows usability is impressive".

( Permalink: Review of Xandros Desktop 1.0      Submitted by Anonymous Tue Nov 26, 2002 )

Mandrake 9.0
Tweakhound reviews Mandrake 9.0.
"The first thing I did was start surfing the web for info on Linux and Mandrake 9. I also asked for and received feedback from Linux users through the use of a survey. I received 3 Cd's in the mail from MandrakeSoft and armed with some info from other Linux users and the manuals I download I began my install. The way I prepared for my install should be considered unique for my situation and needs. It should not be considered a guide."

( Permalink: Mandrake 9.0      Submitted by Noel Mon Nov 25, 2002 )

Book Review: Real World Linux Security
Greatly written, filled with lot of interesting tips and facts about securing the Linux environment, the book can be used both for pumping your knowledge and as a reference in your future security related work. Read the review at Help Net Security.

( Permalink: Book Review: Real World Linux Security      Submitted by LogError Mon Nov 25, 2002 )

Reading Text Streams in Chunks With head and tail
Have you ever wondered how to read or excerpt text in bite-sized chunks using the head and tail commands? This article introduces these commands, which can be useful for processing chunks of data from both static and dynamic files. It teaches you how to process only a few lines of a file, change the number of lines that a command sends, and reverse the order of lines in a file.

( Permalink: Reading Text Streams in Chunks With head and tail      Submitted by Anonymous Mon Nov 25, 2002 )

Caught in a BIND
Security Focus talks about BIND.
"Weinberg's second law, a decades-old programmers' joke, states, "If builders built buildings the way programmers wrote programs, then the first woodpecker that came along would destroy civilization." There may be no better example of that principal in action than the BIND name server software."

( Permalink: Caught in a BIND      Submitted by Noel Mon Nov 25, 2002 )

E-mail as a System Console
Linux Journal tells us how to issue shell commands using email.
"Create an e-mail-based console application that let's you execute commands and return results via e-mail. If you're stuck with only web access, get a web e-mail account somewhere and use it to send commands over e-mail to your system at home. The e-mail console is a nice way to communicate with your system when normal communications (Telnet, ssh, FTP, what-have-you) are not available."

( Permalink: E-mail as a System Console      Submitted by Noel Mon Nov 25, 2002 )

UnitedLinux Momentum Mounts
Linux Planet reports on UnitedLinux.
"UnitedLinux, though, is signing contracts only with IHVs (independent hardware vendors), as opposed to ISVs, according to Hunter. On the hardware side, the four members of United Linux--SCO, SuSE Linux, Turbolinux, and Conectiva--are teaming with IBM, Hewlett-Packard, and AMD"

( Permalink: UnitedLinux Momentum Mounts      Submitted by Noel Fri Nov 22, 2002 )

Freedom in a Tux
Linux Lookup talks about using Linux in a home office.
"Many people would like to one-day move from being an employee to being their own boss. Linux is the platform I have chosen to use in making that dream a reality. Critical areas of concern were reliability, cost, and support."

( Permalink: Freedom in a Tux      Submitted by Noel Fri Nov 22, 2002 )

Moving from Windows to Linux with Kylix 3
One of the great things about using tools and databases such as Borland® Delphi 7™ Studio and IBM® DB2® Universal Database™ is that moving between platforms is only a matter of a few changes and a recompile. This article shows how to move a functional application from a Delphi 7 application running on Microsoft® Windows® to a Linux® application using Borland Kylix™ 3. This article also goes over DB2 on Linux and minor source code changes.

( Permalink: Moving from Windows to Linux with Kylix 3      Submitted by Anonymous Fri Nov 22, 2002 )

Absolute BSD: The Ultimate Guide to FreeBSD
Unix Review reviews the book Absolute BSD: The Ultimate Guide to FreeBSD.
"While Absolute BSD can be used as a reference, it is laid out in such a way that reading it straight through, as I did, makes sense. The first three chapters cover installing FreeBSD, sources for help with system problems, and how to back up and restore your system. The installation section has some handy tips for dealing with the rather hostile FreeBSD sysinstall program."

( Permalink: Absolute BSD: The Ultimate Guide to FreeBSD      Submitted by Noel Fri Nov 22, 2002 )

Open Source in the Biosciences
Have you ever wondered about the technical software developments that will matter most in bioinformatics over the next year? Bioinformatics and the use of open source in the biosciences are both still in the take-off phase. There are two kinds of bioscience and open source is important to both, but in different ways. The first kind of bioscience is "small" bioscience: natural history, paleontology, limnology, and other traditional pursuits. "Small" referring to budget constraints. The other kind is the biosciences or bioinformatics you see mentioned in business or technology circles.

( Permalink: Open Source in the Biosciences      Submitted by Anonymous Thu Nov 21, 2002 )

MontaVista Linux Professional Edition
All Linux Devices takes a look at MontaVista Linux Professional Edition 3.0.
""MontaVista Linux Professional Edition 3.0 is the most sophisticated commercial-off-the-shelf Linux system software currently available for embedded developers," said Sheila Baker, vice president of marketing, MontaVista Software. "We can provide OEMs in a variety of industries with a solution that is cost-effective and allows them quick time-to-market for their next-generation products."

( Permalink: MontaVista Linux Professional Edition      Submitted by Noel Thu Nov 21, 2002 )

Enjoying Music in Mandrake 9.0
Desktop Linux looks at music under Mandrake 9.0.
"Mandrake Linux offers many ways to enjoy digital music. If you want to listen to audio CDs, MP3s, Ogg files, or create digital files from audio CDs, there's certainly an application to fit the bill."

( Permalink: Enjoying Music in Mandrake 9.0      Submitted by Noel Thu Nov 21, 2002 )

Featured Articles:
Unix and Linux Podcasting Guide

Expect and SSH

The Linux Enterprise Cluster

Book Review: Podcasting: Do-It-Yourself Guide

Remote Backups With Rsync

Weakness and Security

Essential CVS

Spring Into Technical Writing

Other News:
Biodiesel Resources

Older News

Revolution OS
(Fri Mar 22, 2002)

Understanding CVSup
(Fri Mar 22, 2002)

Volution
(Fri Mar 22, 2002)

Ximian GNOME on a Low Resource Machine
(Fri Mar 22, 2002)

Shuttle SS50 Review
(Thu Mar 21, 2002)

The Practice of System and Network Administration
(Thu Mar 21, 2002)

Sun and Linux
(Thu Mar 21, 2002)

Linus's Latest Lieutenant
(Thu Mar 21, 2002)

Roxen WebServer 2.2
(Thu Mar 21, 2002)

Mandrake 8.2 First Impressions
(Thu Mar 21, 2002)

Erlang Is Worth a Look
(Wed Mar 20, 2002)

AbiWord: Open Source's Answer to Microsoft Word
(Wed Mar 20, 2002)

Linux on a Floppy
(Wed Mar 20, 2002)

find: Part Two
(Wed Mar 20, 2002)

zlib Compression Library Bug
(Wed Mar 20, 2002)

Clusters and Image Processing
(Wed Mar 20, 2002)

File Sharing With Samba
(Tue Mar 19, 2002)

Open Source Household
(Tue Mar 19, 2002)

Simple Self Extracting Archives
(Tue Mar 19, 2002)

Lycoris Desktop/LX Review
(Tue Mar 19, 2002)

Hardening Sendmail
(Tue Mar 19, 2002)

Reply to the Article on sorcerer.wox.org
(Tue Mar 19, 2002)

Filewalker Linux PDA
(Mon Mar 18, 2002)

Linux Virus HOWTO
(Mon Mar 18, 2002)

The Top 10 SANs vs. NAS Decision Factors
(Mon Mar 18, 2002)

Lycoris Desktop/LX: The World's Flower Power
(Mon Mar 18, 2002)

GNU-Friends Interviews Arnold Robbins
(Mon Mar 18, 2002)

IPCop: An Overview
(Mon Mar 18, 2002)

How To Get Linux on Your Corporate Desktop
(Sat Mar 16, 2002)

More About Sorcerer
(Sat Mar 16, 2002)

[Latest News] [Newer News] [Older News]

Our content can be syndicated: Main Page Mac Page
(Validate RSS code)

Copyright 1999-2005 Noel Davis. Noel also runs web sites about sailing and kayaking.
All trademarks are the property of their owners.
All articles are owned by their author