|  | From Scott Orgera, your About Programming Editor This week we discuss the safety risks of open source software, describe how to rotate server log files with a Perl script, teach you the benefits of pattern matching in SQL, and provide an overview of the JDBC API. | | Just How Safe is Open Source Software? If you know anything about technology, you're probably all too familiar with the fact that bad people want to do not-nice things to your computers and mobile devices. And while you may be used to hearing about security vulnerabilities in Microsoft Windows and OS X, is the situation really limited to proprietary products or is open source software at risk, too? Worse yet, can open source software itself contain malicious code? | How to Rotate Your Server Log Files with Perl Web servers like Apache have access and error log files, and depending on how much traffic you're dealing with these files can get quite large in a very short amount of time. Enter Perl, which is great for simple one-off system administration scripting. Instead of letting those log files build up and become unmanageable, lets write a simple Perl script to compress and archive those files every night at midnight. | Making Deep Copies in Ruby It's often necessary to make a copy of a value in Ruby. While this may seem simple, and it is for simple objects, as soon as you have to make a copy of a data structure with multiple array or hashes on the same object, you will quickly find there are many pitfalls. | Pattern Matching in SQL Server Queries You may often need to create a SQL Server query that performs inexact pattern matching through the use of wildcard characters. The use of wildcards allows you to find data that fits a certain pattern, rather than specifying it exactly. For example, you can use the wildcard 'C%' to match any string beginning with a capital C. | | | | Related Searches | | | | Featured Articles | | | | | | Sign up for more free newsletters on your favorite topics | | | | You are receiving this newsletter because you subscribed to the About.com Programming newsletter. If you wish to change your email address or unsubscribe, please click here. If you would like to unsubscribe from all newsletters sent from About.com, please send an email to optout@about.com with "Unsubscribe" as the subject line. About.com respects your privacy: Our Privacy Policy Contact Information: 1500 Broadway, 6th Floor New York, NY, 10036 © 2014 About.com | | | | | Advertisement | |