Despite CEO drama, plummeting traffic and even declining mobile website usage, MySpace Mobile for Android is the most popular social app in the Android Market and the third most popular downloaded application overall. While Facebook might dominate social networking apps on the iPhone, Facebook for Android leaves much to be desired. It’s [...]
Retweet.com, which put itself up for sale last month, has sold for $250,000 in an online auction on Flippa. The auction saw a fair amount of interest with 45 bids in total, but it appears that the winning party came in with a “buy it now” offer for $48,000 more than the current [...]
Palm has announced the beta release of its Plug-in Developer Kit — or PDK — a new component in the webOS SDK that will make for dramatically better gaming on the Palm Pre, Palm Pixi and all future webOS devices.
Originally announced back in January at the CES show, the release’s venue — the ongoing [...]
Sony Computer Entertainment is proudly shouting “FIRST” (YouTube commenter-style) with an announcement that claims the PlayStation Network is the first online service to sell high-definition movies from all the major movie studios: Universal, 20th Century Fox, Paramount, Walt Disney, Warner Bros and, of course, Sony Pictures.
Some of the content has been around for a [...]
New location-based social search tool FourWhere shows Foursquare tips and comments using Google Maps so you can search and discover what everyone is saying about nearby places.
Users simply input a location or address into FourWhere, right-click (control click) on the map and select display preferences. The map can display all comments nearby, all venues [...]
Aiptek is going to release its new HD-DV projector Z20 (PocketCinema). Aiptek Z20 pocket-sized multimedia projector comes with built-in camcorder function that provides still pictures at up to 8.0megaipxel and High Definition video recording at a resolution of 720pixel. Aiptek Z20 is equipped with new RGB LED technology producing wide range of true colors in [...]
Design your database with caution
This first tip may seems obvious, but the fact is that most database problems come from badly-designed table structure. For example, I have seen people storing information such as client info and payment info in the same database column. For both the database system and developers who will have to work [...]
Just run the following query on your WordPress database, and all revisions (As well as meta associated with it) will be deleted from your database.
Of course, do not forget to make a backup of your database before running the code.
DELETE a,b,c
FROM wp_posts a
WHERE a.post_type = ‘revision’
LEFT JOIN wp_term_relationships b
ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c [...]
BBC News has a very cool interactive chart up, showing how Internet had grown from 1998 to 2008 in various parts of the world.
In 1998., the only countries with significant Internet usage were USA, Canada, Australia, New Zealand, Iceland, Netherlands, Switzerland, Denmark and Sweden. Of course, I remember using the Internet in Croatia every [...]
It’s here: the biggest action movie for gadget geeks, Iron Man, returns with a sequel, and you can see just how high-tech it’ll all be in the Iron Man 2 trailer, now available on YouTube.
Besides a long-haired, electric whip-wielding Mickey Rourke, the movie features more iron man suits than you could ever desire, and [...]
