Subscribe now!
The Latest
Newsletter
Featured Videos
Set up a secure virtual host in Apache
December 22nd, 2008 by Elliot Isaacson in
Setting up an https server in Apache is easy. This tutorial covers how to create and sign your ssl certificate as well as how to configure the web server.
Recently Popular
From the Magazine
January 2009, #177
It's a battle as old as time: good vs. evil. Fortunately, Linux and FOSS are on our side as we wage the battle against those who try to steal our secrets and invade our systems.
Checking your system's security is best done sooner rather than later. Test the locks with our article on security verification; find out how to use PAM to help secure your systems; use MinorFS and AppArmor to implement discretionary access control; learn more about Samba security in part III of our series; use Darknet to help detect bots and secure your systems; use the Yubikey to increase your site's security; and don't forget to lock the doors, because a cold boot attack could render your security useless if somebody has physical access to your computer.
But, we're not just about sowing the seeds of fear. We also show you how to use memcached in Rails, how to manage multiple servers efficiently, how to deploy applications easily with Capistrano, how to manage your videos with MythVideo, how to mix it up a bit (your audio that is), and even play a few games.
Re: SQL Best-of-Class Selections
On April 17th, 2002 Anonymous says:
What dbms is this syntax for? It's a little different from the big boys I've worked with (Oracle & Sybase) and more advanced than MySQL.
Could this work as a self join? I think it would look something like:
SELECT sent_id, subs_id
FROM sent AS outer_sent, sent AS inner_sent
WHERE outer_sent.subs_id = inner_sent.subs_id
AND outer.date_created = max(inner.date_created)
ORDER BY date_created;
If it works it would be interesting to time the two and see which is faster. Usual rule I've found is that the subquery is always faster than the join query (YRMV).