PostgreSQL & PHP Tutorials - Group Concat - Simple Example
Topic: Technology
3:48 am EDT, Jun 4, 2008
The subquery has to do a join based on the outside id (which happens to be a self join - ie back to the same database table), then we group & order the results together.
select id, count(outside_example.*), array_to_string ( array( select val from example inside WHERE inside.id=outside_example.id ), ',' ) FROM example outside_example GROUP BY outside_example.id ORDER BY outside_example.id ;
How To Index For Joins With MySQL From time to time I see people asking "What do I index to join these tables efficiently?" Often, someone just gives them an answer without really explaining the basic theory behind how to index for joins. The purpose of this document is to describe the basic theory behind indexing for joins with MySQL, starting first with a very simple example that demonstrates the basic principle of MySQL joins, and then applying the principle to a more complex 4 table query.
On the same day Barack Obama could clinch the Democratic nomination for president, a new poll out Tuesday shows the Illinois senator holds a slight lead over presumptive Republican nominee John McCain among likely voters nationwide.
The new USA Today/Gallup survey shows the Illinois senator with a 5 point advantage over McCain among likely voters, 49 percent to 44 percent. That margin is just outside the poll's 4 point margin of error, meaning Obama appears to hold a slight advantage over the Arizona senator with five months remaining until voters weigh in at the polls.
The survey shows Hillary Clinton also leads McCain, though with a margin that is just with the poll's sampling error. According to the survey, the New York senator bests McCain by 4 points, 48 percent to 44 percent.
'Sleeping' driver ploughs into bike race - World - smh.com.au
Topic: Miscellaneous
1:09 pm EDT, Jun 3, 2008
MONTERREY, Mexico: This dramatic photograph shows a car ploughing into cyclists in a race along a highway near the US-Mexico border.
One rider was killed and 10 others injured in the incident. The 28-year-old driver was apparently drunk and fell asleep when he crashed into the cyclists, said a police investigator, Jose Alfredo Rodriguez.
JavaScript Information Visualization Toolkit (JIT)
Topic: Technology
12:42 pm EDT, Jun 3, 2008
JavaScript Information Visualization Toolkit (JIT) What’s the JIT?
The JIT is an advanced JavaScript infovis toolkit based on 5 papers about different information visualization techniques. The JIT implements advanced features of information visualization like Treemaps (with the slice and dice and squarified methods), an adapted visualization of trees based on the Spacetree, a focus context technique to plot Hyperbolic Trees, and a radial layout of trees with advanced animations (RGraph).
For Escobar, it at first paid off spectacularly, with Forbes magazine ranking him among the world's 10 richest men in 1989, when he was in his thirties.
Escobar purchased the 22sq km (8.4 sq miles) Napoles Estate, about 320km (200 miles) from the capital Bogota, in 1978.
He turned it into a fantasy land with concrete dinosaurs, a bullfighting ring and a private zoo that would have made Michael Jackson jealous, with giraffes, elephants, kangaroos and hippopotamuses.
To keep them company, he built a herd of concrete dinosaurs.
Above the entrance gate to the estate, the never-subtle Escobar put a plane he had used to smuggle cocaine into the US.
Testicle Ear Pops Like Grape | James Thompson’s Cauliflower Ear (pic)
Topic: Sports
8:03 pm EDT, Jun 2, 2008
This is a post-fight ear picture, after Kimbo Slice punched in head-on and busted it wide open. Don’t forget to vote in our Poll (left column of the site) regarding your opinion on James “Colossus” Thompson’s ghastly ear!
This was the most disgusting thing I have seen. A bunch of us were watching the fight when Kimbo punched Thompson's ball-like ear, and it POPPED, and then what appeared to be a chunk of cartiledge fell out onto the mat. One girl ran out of the room puking. It was awesome.
Barack Obama | Change We Can Believe In | Technology Opportunities
Topic: Current Events
7:55 pm EDT, May 30, 2008
Write Software, Change Washington
Obama for America is looking for exceptionally talented web developers who want to play a key role in a historic political campaign and help elect Barack Obama as the next President of the United States. (Interested in a security expert position?) This six-month opportunity will allow you to:
* Create software tools which will enable an unprecedented nationwide voter contact and mobilization effort * Help build and run the largest online, grassroots fundraising operation in the history of American politics * Introduce cutting-edge social networking and online organizing to the democratic process by empowering everyday people to participate on My.BarackObama
You must have:
* At least 5 years of professional web development experience * A deep understanding of LAMP development processes and best practices * Experience building complex applications using PHP and MySQL * Advanced or expert CSS, Javascript, and AJAX skills * An abiding desire to put your technical wizardry to work for democracy and for our country
Unfortunately, you have to move to Boston, or I'd be all over this.
Catalog your books, movies, music, software, toys, tools, electronics, & video games.
When we demo Delicious Library to people, about ⅔ of them instantly say this:
“Wait, I just hold a CD or DVD or video game or book or whatever up to my webcam, and it magically reads the UPC and downloads that item’s cover and all pertinent information about it, and displays all my stuff on photorealistic shelves? I’ll take it! Right now! This is why I bought a computer in the first place! ”
But a few people are skeptical, or slightly less obsessive. “Ok,” they say, “then I have my stuff in my computer. Big whoop. I can just look at my real shelf, right now, for free.”
