Become a fan of Slashdot on Facebook

 



Forgot your password?
typodupeerror

Feed Red Octane looses Guitar Hero II patch for Xbox 360 (engadget.com)

Filed under: Gaming

We're not quite ready to consider this a coincidence, but the hard-working souls over at Red Octane have officially unleashed a patch for the malfunctioning Guitar Hero II axes just in time for the weekend. Recently, it was claimed that axes sporting 95065 and 95055 model numbers could lose responsiveness in the whammy bar, but thanks to Xbox Live, users can download the patch and get back to unadulterated rockin' right away. So what are you waiting for? Finish up those finger exercises, fire up your console, and let us know if in fact the downloadable solution mends the problem.

[Via Joystiq]

Read | Permalink | Email this | Comments

BOLD MOVES: THE FUTURE OF FORD A new documentary series. Be part of the transformation as it happens in real-time

Office Depot Featured Gadget: Xbox 360 Platinum System Packs the power to bring games to life!


Databases

Submission + - MySQL Stored Procedure Programming

Michael J. Ross writes: "MySQL may be the most popular open source relational database management system (RDBMS) in the world, but during the first decade of its existence, it lacked support for stored programs, i.e., store procedures, functions, and triggers. The major commercial RDBMS vendors — including Oracle, IBM, and Microsoft — could point to this deficiency as reason enough to choose their proprietary systems over MySQL or any other open source system, such as PostgreSQL. But with the release of MySQL version 5.0, in October 2005, the "little database engine that could" dramatically improved its position against the competition. The most comprehensive discussion of these new capabilities is in the book MySQL Stored Procedure Programming.

Written by Guy Harrison and Steven Feuerstein, and published by O'Reilly Media in March 2006 under the ISBNs 0596100892 and 978-0596100896, this book is the first one to offer database programmers a full discussion of the syntax, usage, and optimization of MySQL stored procedures, stored functions, and triggers — which the authors wisely refer to collectively as "stored programs," to simplify the manuscript. Even a year after the introduction of these new capabilities in MySQL, they have received remarkably little coverage by book publishers. Admittedly, there are three such chapters in MySQL Administrator's Guide and Language Reference (2nd Edition), written by some of the developers of MySQL, and published by MySQL Press. Yet this latter book — even though published a month after O'Reilly's — devotes fewer than 50 pages to stored programs, and the material is not in the printed book itself, but in the "MySQL Language Reference" part, on the accompanying CD. That material, in conjunction with the online reference documentation, may be sufficient for the more simple stored program development needs. But for any MySQL developer who wishes to understand in-depth how to make the most of this new functionality in version 5.0, they will likely need a much more substantial treatment — and that's exactly what Harrison and Feuerstein have created.

The authors are generous in both the technical information and development advice that they offer. The book's material spans 636 pages, organized into 23 chapters, grouped into four parts, followed by an index. The first part, "Stored Programming Fundamentals," provides an introduction and then a tutorial, both taking a broad view of MySQL stored programs. The remaining four chapters cover language fundamentals; blocks, conditional statements, and iterative programming; SQL; and error handling. The book's second part, "Stored Program Construction," may be considered the heart of the book, because its five chapters present the details of creating stored programs in general, using transaction management, using MySQL's built-in functions, and creating one's own stored functions, as well as triggers. The third part, "Using MySQL Stored Programs and Applications," explains some of the advantages and disadvantages of stored programs, and then illustrates how to call those stored programs from source code written in any one of five different programming languages: PHP, Java, Perl, Python, and Microsoft.NET. In the fourth and final part, "Optimizing Stored Programs," the authors focus on the security and tuning of stored programs, tuning SQL, optimizing the code, and optimizing the development process itself.

This is a substantial book, encompassing a great deal of technical as well as advisory information. Consequently, no review such as this can hope to describe or critically comment upon every section of every chapter of every part. Yet the overall quality and utility of the manuscript can be discerned simply by choosing just one of the aforesaid Web programming languages, and writing some code in that language to call some MySQL stored procedures and functions, to get results from a test database — and developing all of this code while relying solely upon the book under review. Creating some simple stored procedures, and calling them from some PHP and Perl scripts, demonstrated to me that MySQL Stored Procedure Programming contains more than enough coverage of the topics to be an invaluable guide in developing the most common functionality that a programmer would need to implement.

The book appears to have very few aspects or specific sections in need of improvement. The discussion of variable scoping, in Chapter 4, is too cursory (no database pun intended). In terms of the book's sample code, I found countless cases of inconsistency of formatting — specifically, operators such as "||" and "=" being jammed up against their adjacent elements, without any whitespace to improve readability. These minor flaws could be easily remedied in the next edition. Some programming books make similar mistakes, but throughout their text, which is even worse. Fortunately, most of the code in this book is neatly formatted, and the variable and program names are generally descriptive enough.

Some of the book's material could have been left out without great loss — thereby reducing the book's size, weight, and presumably price. The two chapters on basic and advanced SQL tuning contain techniques and recommendations covered with equal skill in other MySQL books, and were not needed in this one. On the other hand, sloppy developers who churn out lamentable code might argue that the last chapter, which focuses on best programming practices, could also be excised; but those are the very individuals who need those recommendations the most.

Fortunately, the few weaknesses in the book are completely overwhelmed by its positive qualities, of which there are many. The coverage of the topics is quite extensive, but without the repetition often seen in many other technical books of this size. The explanations are written with clarity, and provide enough detail for any experienced database programmer to understand the general concepts, as well as the specific details. The sample code effectively illustrates the ideas presented in the narration. The font, layout, organization, and fold-flat binding of this book, all make it a joy to read — as is characteristic of many of O'Reilly's titles.

Moreover, any programming book that manages to lighten the load of the reader by offering a touch of humor here and there, cannot be all bad. Steven Feuerstein is the author of several well-regarded books on Oracle, and it was nice to see him poke some fun at the database heavyweight, in his choice of sample code to demonstrate the my_replace() function: my_replace( 'We love the Oracle server', 'Oracle', 'MySQL' ).

The prospective reader who would like to learn more about this book, can consult its Web page on O'Reilly's site. There they will find both short and full descriptions, confirmed and unconfirmed errata, a link for writing a reader review, an online table of contents and index, and a sample chapter (number 6, "Error Handling"), in PDF format. In addition, the visitor can download all of the sample code in the book (562 files) and the sample database, as a mysqldump file.

Overall, MySQL Stored Procedure Programming is adeptly written, neatly organized, and exhaustive in its coverage of the topics. It is and likely will remain the premier printed resource for Web and database developers who want to learn how to create and optimize stored procedures, functions, and triggers within MySQL.

Michael J. Ross is a Web programmer, freelance writer, and the editor of PristinePlanet.com's free newsletter. He can be reached at www.ross.ws, hosted by SiteGround."
The Internet

US, Asia, Europe Ceding Web Dominance 123

An anonymous reader writes "A new study shows that presence of the US, Asia, and Western European countries on the web is strongly declining. Newly internet-empowered countries are booming; many geographical regions are showing exponential growth, including Eastern Europe and South America. Chris Harrison explains: 'Countries that have never been able to place a website in the top 500 are now pushing dozens of established websites out of this prestigious list. This trend is both recent (within the last two years) and accelerating. Interestingly, Asia is seeing it's presence eroded the fastest, especially China.'"
Censorship

Gary Kasparov Arrested Over Political Fight 427

geddes writes "World chess champion turned opposition leader Gary Kasparov was arrested this morning while leading an march through Moscow in opposition to Russian President Vladamir Putin. Kasporov is a leader of the 'Other Russia' coalition which has been banned by the government from appearing on TV, and had been denied a marching permit. From the New York Times: 'Essentially barred from access to television, members of Other Russia have embraced street protests as the only platform to voice their opposition ahead of parliamentary elections in December and presidential elections next March. Early this month, Mr. Kasyanov's and Mr. Kasparov's Web sites were blocked, though it was unclear by whom.' Kasparov was later released from detention, though he was still fined for participating in the event."

Comment Re:Probably not fair use. (Score 2, Insightful) 713

Before I signed up for a TurnItIn.com account, I read the Terms of Service and all other disclaimers, and NONE of them stated that I was giving them a license to use or archive my work beyond that of fair use.
Seems pretty cut and dry to me: They didn't ask for a license, I did not grant them a license, thus they are infringing.

Overconfidence in SSH Protection 194

nitsudima writes to mention a post on the Informit site about the common misunderstandings surrounding SSH, and how well-intentioned admins may be creating holes in their own security by using it. From the article: "In UNIX, all things are files. To send network traffic, UNIX writes the traffic to the network device file. In this case, the connection to Box A (and that private key used for authentication) is a socket file. This file will shuttle the authentication traffic between Box A and Box P. So what's the risk? Maybe the hacker can't get a copy of the private key through the socket file, but something better (from his/her view) can be done. If the hacker has root on Box D, he or she can point a private copy of the agent forwarding software to that socket file and thereby point the authentication process to the administrator's credentials--the ones kept on the 'safe' intranet. What are the chances that the administrator has configured access to all the DMZ servers he controls?"

Reporter Phone Records Being Used to Find Leaks 971

jackbird writes "Brian Ross, Chief Investigative Correspondent for ABC news says a confidential source informed him that reporter's phone records are being used by the administration to track down leaks. Apparently reporters for the New York Times, ABC News, and the Washington Post are being scrutinized. The fact that ABC News journalists are even seriously wondering about whether the warning is connected to the NSA's domestic surveillance activities indicates just how anxious many people in Washington have become."

PSP Hardware Review Site 71

Busshy writes "DCEmu have opened a new dedicated PSP review website featuring over 40 unbiased reviews of PSP accessories including Neuros MPEG4 Recorder 2, Neo-PSP Pad 8in1 & Intec Sound System."

An Underground Radio to Save Lives 82

Roland Piquepaille writes "The Duluth News Tribune wrote last week about a communication device which could be a lifesaver for miners. This invention is the brainchild of David Reagor, a physicist at Los Alamos National Laboratory (LANL). His prototype radio works at depths of 500 feet and is based on very low frequency electromagnetic radiation and digital signal processors. A commercial version is in the works and could be used not only by workers trapped in a mine, but also by firefighters and other emergency workers to communicate with people in collapsed buildings or subways."

New Disclaimer for the Internet 113

Techdirt has an amusing new disclaimer for the internet penned by lawyer David Canton is response to Rob Hyndman's recent discovery of an impressive disclaimer for a rock preserve. From the disclaimer: "Business is unpredictable and unsafe. The Internet is dangerous. Many blogs have been written about these dangers, and there's no way we can list them all here. Read the blogs. The Internet is covered in slippery slopes with loose, slippery and unpredictable footing. The RIAA can make matters worse. Patent trolls are everywhere. You may fall, be spammed or suffer a DOS attack. There are hidden viruses and worms. You could break your computer. There is wild code, which may be vicious, poisonous or carriers of dread malware. These include viruses and worms. E-mail can be poisonous as well. We don't do anything to protect you from any of this. We do not inspect, supervise or maintain the Internet, blogosphere, ISP's or other features, natural or otherwise."

Linux Version of Democracy Player Released 111

clahey writes "The Participatory Culture Foundation just released Democracy Player 0.8.2 for Linux, the first beta version for Linux. It's a free software internet TV client with built in support for both RSS video podcasts and downloading using BitTorrent. It can even scrape web pages for videos. It's an excellent way to find great internet video. For example, once you've installed Democracy, make sure to check out The Postal Service - Such Great Heights on the Telemusicvision channel."

Windows Vista To Make Dual-Boot A Challenge? 442

mustafap writes "UK tech site The Register is reporting on security guru Bruce Schneier's observation that the disk encryption system to be shipped with Vista, BitLocker, will make dual booting other OSs difficult - you will no longer be able to share data between the two." From the article: "This encryption technology also has the effect of frustrating the exchange of data needed in a dual boot system. 'You could look at BitLocker as anti-Linux because it frustrates dual boot,' Schneier told El Reg. Schneier said Vista will bring forward security improvements, but cautioned that technical advances are less important than improvements in how technology is presented to users."

Slashdot Top Deals

Enzymes are things invented by biologists that explain things which otherwise require harder thinking. -- Jerome Lettvin

Working...