July 2007
111 posts
Simulating LIMIT with offsets in SQL →
How can you do this (x is number of rows to fetch, y is offset): SELECT * FROM my_table LIMIT x, y (Mysql) or this: SELECT * FROM my_table LIMIT x OFFSET y (PostgreSQL) in a DBMS that doesn’t support LIMIT statements (take Oracle for example). In Oracle, you can use ROWNUM, which holds the current row number: SELECT * FROM (SELECT ROWNUM limit, * FROM my_table ORDER BY order_field) WHERE...
iPhone "Hello World" binary released →
The busy beavers of the #iphone IRC channel, whose collective efforts have built the first unauthorized iPhone GUI application (in true hacker fashion, it displays “Hello World” and does nothing else), have released the source for the demo app, buildable with the community-built toolchain and UIKit.
FUTURAMA returns November 27th →
The first of four feature-length DVD movies will arrive in stores on November 27th!
PICTURES: Incredible Polish Movie Posters →
“This gallery of mostly-Polish vintage movie posters, many for American-made films, is absolutely amazing…”
Llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliog... →
um, just look.
Craziest Captchas on the Web [PICTURES] →
Ever worried about too much traffic? Try these captchas to get rid of those annoying visitors. Collection of unreadable and funny captchas.
This is supposed to be impossible →
This is a once-in-a-million, genetically impossible occurrence of a mule giving birth.
Star Wars vs. Harry Potter - Death Match →
Who would triumph in a fight to the death? If these Star Wars characters were pitted against the corresponding characters in Harry Potter in a no-holds-barred tournament of magical galactic combat, who would prevail?
BBC Corrupted by Microsoft! Take back the BBC,... →
Today the BBC made it official — they have been corrupted by Microsoft. With today’s launch of the iPlayer, the BBC Trust has failed in its most basic of duties and handed over to Microsoft sole control of the on-line distribution of BBC programming. From today, you will need to own a Microsoft operating system to view BBC programming on the web.
Aquafina: Pepsi Admits It's Just Tap Water →
The label on Aquafina water bottles will soon be changed to spell out that the drink comes from the same source as tap water, the brand’s owner said Friday.
Can Videogames be Considered Art? →
A film critic makes the case that perhaps it doesn’t matter after all.
Game: Jade Empire - Special Edition →
So I picked up Jade Empire for the PC a few days ago. I was astonished because I didn’t even know it was released for the PC. (I’ve been jealous of console owners who could play the game and then I even miss the PC release!) So after I quick install I was ready to go. I was more than happy to experience a new Bioware-experience. As coincidence would have it, I had been playing a few...
Launching A Pig Into The Upper Atmosphere [pic] →
shocking pictorial…
time may not exist! →
Most of us tend to think of time the way Newton did: “Absolute, true and mathematical time… flows equably, without regard to anything external.” But as Einstein proved, time is part of the fabric of the universe… something that’s independent of the universe. In fact, says Lloyd, clocks don’t really measure time at all.
British government has bizarre response to... →
“I hate to intrude on the British love of a disaster, but haven’t the emergency services done brilliantly? As I write, we do not know of anybody who has died as a direct result of the floods. Strenuous work overnight by the military and the fire service saved the power stations from flooding. The Government has proved itself calmly competent.”
The REAL Threat to Americans [PIC] →
On September 11, 2001, nearly 3000 Americans were killed. Since then, about 10 million Americans have died of preventable causes.
Will It Blend: Bic Lighters →
Some people might say it’s not a very smart idea to throw 6 lighters into a blender. Those people would be right.
Best Game Setup Ever [Pic] →
Speaks for itself.
Canonical launches Web-based systems management... →
Canonical, the company behind the Ubuntu Linux distribution, announced on July 22 at the Ubuntu Live conference in Portland, Ore., the availability of Landscape, its Web-based systems management program for Ubuntu servers and desktops.
Watch
CONFIRMED: More top-tier PC manufacturers offering... →
At Ubuntu-Live by Mark Shuttleworth.
New Ubuntu Linux Laptop (System 76 darter ultra... →
Everyone remember that spiffy white 13.3 inch screen ultra portable laptop offered by system 76. Well they didn’t change the name, they are still calling it the darter ultra, but now its sporting a built in webcam, a smaller 12.1 inch screen, and much better internal specs, (the improvements?: socket P, 10/100/1000, and bigger sata hard drives)
Britons Must Reveal Political Opinions When Flying... →
Highly sensitive information about the religious beliefs, political opinions and even the sex life of Britons travelling to the United States is to be made available to US authorities when the European Commission agrees to a new system of checking passengers.
50 Things You Need to Know About Ubuntu (50-41) →
A timely list developed by TechIQ during the Ubuntu LIVE conference today in Portland, Oregon. Here’s part one of five.
Debian swirl logo used in PA State Museum gift... →
Today I decided to take a few pictures of the State Museum of Pennsylvania in Harrisburg PA. They have a gift shop in the lower level called the Radius Gallery, which features artwork from Harrisburg Area Community College students. And as you can see from the pictures below, it seems that they have borrowed the Debian “swirl” logo.
Heroes nominated for best drama; Hiro Nakamura... →
Superhero drama “Heroes” has been nominated for Outstanding Drama Series at the 59th annual Primetime Emmys, Variety reports. The freshman series created by Tim Kring is competing against a eclectic mix of shows for the coveted award Additionally, “Heroes” star Masi Oka has been nominated for an award for Supporting Actor in a Drama.
Teen Girls Accused Of Setting Kitten Ablaze. →
Burning these fucking bitches would be the only just punishment.
iPhone v1.0 Bugs →
68 reproducible iPhone bugs
German toilets... →
PSP Custom Firmware v3.51 M33 →
Dark ALex may have left the PSP Scene but a new russian Hacking group have released a new custom firmware for 3.51 and its a dream release featuring Direct launching of PS1 images, All functions of v3.51 firmware retained - PS1 support, high video resolution, MP3 visualizer, internet navigation, PS3 connection etc. More Via LInk
McDonalds first commercial - clown will scare you... →
If you weren’t afraid of clowns before, you will be after watching the first McDonalds commercial.
I agree
“Why doesn’t Digg ever remember that I’m logged in?” — http://tumblelog.marco.org/post/5683263 I’m having the exact same problem… Every x diggs it asks me to relogin again.
The New Audi A5 - A Rytmn Of Lines →
Fun marketing site. And man I want that car!
