Automatically Locate where a Mobile Picture Was Taken

Moblogging aka Mobile Weblogging means that you send a picture from your mobile phone per email to your weblog. A new cool technology allows to show a map of where the picture was taken, based on the position of the mobile phone while transferring the picture data.

For example, have a look at this picture on Nob’s Weblog and click on one of the “Location Map” links below the pic – and you will see a map of where the picture was taken.

It would be great if we could transfer the geographic positioning idea as a metaphor to build virtual neighbourhoods of knowledge showing a map of geographic locations where e.g. someone wrote a poem to his Weblog, recorded a lecture and sent the audio stream to his Weblog, etc. This is just an initial idea, I’ll think more about it.

via Roger

MySQL: INSERT … SELECT with Same Table

The latest release MySQL 4.0.14 introduced a neat new feature:

[snip]
Enabled `INSERT’ from `SELECT’ when the table into which the records are inserted is also a table listed in the `SELECT’.
[/snip]

This means you can now issue a statement like

INSERT INTO table ( field ) SELECT field FROM table WHERE field = “data”;

which copies all records meeting the specified criteria to the same table.

The MySQL manual only states the behaviour previous to 4.0.14:

[snip]
The target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query. (The problem is that the SELECT possibly would find records that were inserted earlier during the same run. When using subquery clauses, the situation could easily be very confusing.)
[/snip]

Differences between Italians and Europeans

“This film is dedicated to those who believe that Italians behave the same as all other Europeans.”

You need Flash installed in your browser to view this animation showing all those lovely prejudices about Italians. Turn on your speakers!

About the political background: This animation is circulating in Germany after Berlusconis fatal speech at the European Parliament. You see, the Germans must be humorous persons if they like such movies 🙂

via Timon

RSS Reader Plugin for jEdit

jEdit, my favourite programming tool, comes with a plugin for Weblog feeds. I’ve tried it out and it works nicely.

Had to download the jar and put it into ~/.jedit/jars, then invoked jEdit. To add new feeds, you have to go to Utilities -> Global Options -> Plugin Options -> Headlines; to actually use the plugin, go to Plugins -> Headlines -> Headlines and the viewer will pop up. Also works with the ZZ/OSS Weblog feed at http://www.zzoss.com/weblog/b2rss.php 🙂

via Urs