Hot Computers & Programming Posts

How To: Execute a Basic SQL Query Using dbForge Studio GUI for MySQL

If you need to build a SQL query, you can choose one of two alternatives. The first and a rather old way is using a console. But if you build your queries in MySQL console, you have to remember all the commands and keys. This is not a convenient way, because query execution is a time-consuming process. Another way is to use some graphical interfaces for MySQL. It can fulfill many developers' requirements, including query execution.

Chromebook: The World's First Web-Only Laptop Computer Coming Soon

It's been about five months since Google first unveiled their prototype future computers running Chrome OS, and the time is nearly here for the Chromebooks to be unleashed on the public. But there are a lot of qualms over the release of Chromebooks, with most criticism coming from their lack of traditional laptop-based features such as an optical drive, storage space and the ability to run comprehensive software programs like Adobe Photoshop.

News: Are You a Mac Yuppie or a PC Nerd? Find Out if You Fit the Stereotype

With over 60 commercials, chances are you've seen one of the Get a Mac spots run by Apple, which brands Mac as intuitive and hip, compared to their boring and clunky PC counterpart. You also probably saw Microsoft's response in their I'm a PC campaign. But who are Mac and PC users really? Do jeans and hoodie-wearing yuppies really use Macs? Are the suit-and-tie types strictly operating PCs?

News: Are You Noob-Positive or Noob-Negative?

noob - Short for "newbie." Someone with little to no experience or skill. In some gaming communities, there is fierce debate over the distinction between "noob" and "newb"—one being derogatory while the other simply indicates being a novice. While some may argue the semantic differences, "noob" is the most common spelling seen around the internet, for both purposes.

How To: Clean Up Hard Drive Space by Deleting iOS Device Backup Folders from iTunes

By now, you probably know that your iPhone secretly tracks and stores the locations you've visited in a backup folder on your computer's hard drive. The files are unencrypted, which means anyone with access to your computer or device can retrieve the information, which is downright scary. But Pete Warden and Alasdair Allan are making it fun with their iPhone Tracker application, which lets you map out everywhere you've been with your smartphone.

Cheat Sheet: Keyboard Shortcuts for Both Mac & Windows

If you already have your basic keyboard shortcuts under control—we're talking classics here, Control-C (copy for PC) or Command-C (copy for Mac)—it's time to load up your memory bank. There are endless shortcuts available (truly endless—since you can customize them yourself), but you don't need to memorize them all, only those you expect to use most. Below, two cheat sheets for upping your keyboard maneuvering status from "basic" to "intermediate" for both Mac and PC users.

How To: Keep Your PC Running Smoothly

Introduction This is one of the things I am asked the most and there are so many different answers. It is hard to just tell you without know your computer's current speed or what type of hardware it has. So here I will talk about how to speed up a slow computer and how to keep your computer running fast.

Classic Commodore 64 Reborn: Get a 2011 PC in Retro Skin

Back in 1982, the Commodore 64 home computer was released by Commodore International for $595 (which would now be close to $1,300). It featured an 8-bit microprocessor, 16-color video microchip, awesome sound chip, parallel and serial capabilities, and a whopping 64 kilobytes of memory, all of which helped make it the best selling home computer from 1983 to 1986. It surpassed anything IBM had out at the time. Its greatest competitors were the Apple II and Atari 8-bits, 400 and 800. And it had...