Become a fan of Slashdot on Facebook

 



Forgot your password?
typodupeerror
×
The Internet

Submission + - JavaScript can kill Web site performance (computerworld.com)

ericatcw writes: JavaScript, so ubiquitous on today's AJAX-heavy Web sites, can slows down most popular sites today, says a Google performance guru. Steve Souders, the creator of the popular, free Yslow diagnostic tool, says that too many sites load too many JavaScript files at the beginning, creating a bottleneck, since browsers can't render or download anything else at the same time. New browsers such as Internet Explorer 8 can do "parallel downloads" of JavaScript, but it only partly solves the problem, says Souders, who calls for JavaScript and CSS files to be rewritten.
Databases

Submission + - SPAM: SQL in a Nutshell

stoolpigeon writes: "The cover of SQL in a Nutshell sports a chameleon, the little lizard well known for its ability to blend in just about anywhere. This is a great choice for the Structured Query Language. SQL has been around since the seventies, helping developers interact with the ubiquitous relational database management system. Thirty some years later, SQL grinds away in the background of just about any interactive web site and nameless other technologies. New alternatives are popping up constantly but I'm going to go out on a limb and say that SQL is going to be around for a long time. Anyone interacting with an RDBMS is in all likelihood going to need to use SQL at some point. For those that do, who also want a handy desktop reference available, SQL in a Nutshell has been there for the last 9 years. The SQL language itself has not stood still over those years, and neither have the products that use SQL, and so now the book has is available in a third edition.

It's pretty easy to sum up what SQL in a Nutshell contains. It covers the entire ANSI SQL2003 standard as well as how that standard is implemented in MySQL 5.1, Oracle Database 11g, PostgreSQL 8.2.1 and Microsoft SQL Server 2008. There is a new ANSI standard more recent than the 2003 standard, ANSI SQL2006. This new standard does not change anything covered in the book, but introduced XML and XQuery which are not covered here. The format for conveying all this information mirrors that of the other "...in a Nutshell" books. There are four sections. The first is a very short (15 pages) history of SQL and the second is a summary of foundational concepts. The vast majority of the book is the third section, "SQL Statement Commands." These commands are given in alphabetical order. There is also a table at the very beginning of the chapter listing every command and showing how it is supported by the four platforms.

Each command is presented by starting with a short summary of what it does. This is followed by a table showing which RDBMS products support the command, the proper syntax for the command, key words, command rules, possible issues that may come up and implementation details and examples for each of the four RDBMS products represented. A couple of the differences between the second and third edition are that two RDBMS products were dropped and there are more examples. The products dropped allowed for there to be more examples while also making the book smaller than earlier editions. Anyone working with Sybase Adaptive Server or DB2 UDB will want to hold onto their second edition copy of this book if they want to have that platform specific content available, because it is not in this third edition.

The book states that the dropped platforms were the least popular of those in earlier editions. For those wondering why their favorite RDBMS is not in the list, that gives the answer. To keep length down the number of specific platforms covered was kept to four. Fortunately the books is still of high value for most readers as most decent RDBMS products will support ANSI SQL standards. On those occasions they do not, the reader would have to look to another resource for help. The length issue is easy to understand when looking at the GRANT statement and seeing that it covers over twenty pages. Most of this space is used to explain the various options available on each platform.

The last section SQL Functions documents all of the standard functions with examples and then contains a list of platform specific extensions, grouped by product. There is not a table showing platform support like there was for SQL statements. This section is much smaller, so it really isn't an issue. The single appendix that follows list standard and platform specific key words.

So who would benefit from SQL in a Nutshell? The most obvious to me is the DBA or developer working across more than one of the four platforms presented, especially if they don't move from one to the other too often. Like an Oracle DBA that needs to go do something in MS SQL Server every so often, or the same type of thing between any of the others. This makes for a quick resource that will sort out forgetting how one or the other does things rather quickly. But even if one isn't moving across multiple platforms, unless the whole standard has been memorized, this is a great help.

The second group I see gaining some real good from this book are those new to working with SQL. I've worked with all four platforms and others not covered in this book and on every single one of them I've hit error messages that were anything but helpful. Being able to go directly to a correct statement of syntax and usage is a real help when the system doesn't want to tell what is really going on. It is important to remember that this is a pure reference book. It is not written with the intent of teaching how to use SQL. That said, it covers the entire standard. Much like a dictionary can be used to increase one's knowledge of a language, reading through this reference can be a good way to learn more about SQL. Many introductory texts aren't going to cover the whole standard or as many platform specific details. The student of SQL would get a real jump by working through this book. It is compact enough that while it wouldn't be a thrilling read, it is completely doable.

Who wont like it? Probably anyone who doesn't like any of the other nutshell books from O'Reilly. This book is pretty much exactly like my Unix in a Nutshell, Linux in a Nutshell and MySQL in a Nutshell books. If the format and approach bothers you, don't look for any radical departure that will make it more palatable here. If you are like me and already know you like the format, then this is pretty much a sure thing. For the vast majority of us that work in the database world, this is the reference. I say this keeping in mind the scope of the book. Is this everything one needs to know about SQL? Obviously not. There is much more to be said about SQL as evidenced by all the words that have been said and are out there in print. But when one wants to know quickly about SQL statements and functions, I can't think of a better resource.
"
It's funny.  Laugh.

Submission + - The Pirate Bay Tries DDDA (therunningtally.com) 1

Drivintin writes: "The Running Tally has an article on The Pirate Bay, and their way of paying their fine. "The guys from the Pirate Bay have a a 30million SEK fine which they say they won't pay. However they have come up with a plan where all their users can join in which works like this. Everyone sends a small amount of money in an electronic transfer to the law firm that represnted the music industry. Suggested amount is 1 SEK (equivalent to 0.13 USD. Apparently the law firm's bank account is only allowed 1000 electronic transactions before it starts to cost them, the account holder money."
Google

Submission + - What Google Knows About You: More Than Your Mom (computerworld.com)

CWmike writes: 'Google knows more about you than your mother.' A few years ago, it might have sounded far-fetched, writes Robert Mitchell. But if you're one of the growing number of people who are using more products in Google's ever-expanding stable, you might wonder if Kevin Bankston, senior staff attorney at the Electronic Frontier Foundation, isn't onto something. The truth comes out... 'Online tools really aren't free. We pay for them with micropayments of personal information,' says Greg Conti, a professor at the U.S. Military Academy at West Point and author on the subject. It is the breathtaking scope of data under Google's control that has put the company at the center of the online privacy debate. Pam Dixon, executive director at the World Privacy Forum, says that 'no company has ever had this much consumer data.' You got a problem with that? Mitchell explains why he's not giving up his Google apps.
Security

Submission + - Obama could soon be able to shut down the internet (worldnetdaily.com) 2

Michael writes: "A pair of bills introduced in the U.S. Senate (773 & 778) by Senator Jay Rockefeller would grant the White House sweeping new powers to access private online data, regulate the cybersecurity industry and even shut down Internet traffic during a declared "cyber emergency. A working draft of the legislation obtained by an Internet privacy group also spells out plans to grant the Secretary of Commerce access to all privately owned information networks deemed to be critical to the nation's infrastructure "without regard to any provision of law, regulation, rule or policy restricting such access.""
Google

Google Urges National Inventory of Radio Spectrum 79

Hugh Pickens writes "Google, the wireless industry, and consumer advocates have come together to support a bill that would require the federal government to take a complete inventory of the national airwaves to determine what spectrum is being used, how it is being used and who is using it. The government needs to clean up its sloppy record keeping, they say, or the US risks running out of wireless capacity with the increasing use of the mobile Internet. 'Radio spectrum is a natural resource, something that here in the US is owned by all of us American citizens,' wrote Richard Whitt, Google's counsel for telecom and media. 'Most of us don't give it much thought — and yet use of these airwaves is precisely what makes many of our modern communication systems possible.' The new law, if passed, would require the Federal Communications Commission and the National Telecommunications & Information Administration to report on the use of all spectrum bands between 300 megahertz and 3.5 gigahertz, including information on the licenses or government user operating in each band and whether the spectrum is actually in use. The unusual alliance between Google, public interest groups, and big telecommunications companies may be temporary. The telecom companies want to have the opportunity to buy any extra spectrum at an auction while Google advocates the use of new technologies that would allow the spectrum to be shared by whoever needs it."

Comment WTF?!?!? (Score 1) 161

Ok in all seriousness, this is fucking retarded. I take this as IBM talking to the public like "Oh hey, look at us society, we may not have fancy cubicles like Google, but we aren't conformists like them because we have shorter meetings." SO let's say for instance, they are about to go bankrupt, and they need to come up with a strategy for conserving revenue and increasing profit... in the middle of John Doe's big important "this is how we save the company" idea, if it hits 41 minutes are they gonna "Sorry dude, outta time, oh well i guess we're fucked" No the fuck they aren't. The length of meetings has nothing to do with productivity. While yes, the approach to the meeting can effect it, a much more reasonable approach would be having all meetings be open-ended with slightly less structure. "We're IBM, we're new age and bad ass, meetings are for pussies" WTF

Slashdot Top Deals

"When it comes to humility, I'm the greatest." -- Bullwinkle Moose

Working...