|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 )
"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
"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
"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
( Permalink: E-mail as a System Console Submitted by Noel Mon Nov 25, 2002 )
|UnitedLinux Momentum Mounts|
|Linux Planet reports on
"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 )