Cette page appartient aux archives web de l'EPFL et n'est plus tenue à jour.
This page belongs to EPFL's web archive and is no longer updated.

Geeks blog

Famous SQL queries

$ SELECT finger FROM hand WHERE id=3;

© ThinkGeek

Posted by Franois Bonzon at 14:41
Apple Store opening in Geneva
An Apple Store opened yesterday in Geneva at Rue de Rive, and is the first in Switzerland. Several hundreds people were waiting in line for the opening at 5 pm, including myself. The main reason was the first lucky 1500 visitors received a free Apple T-shirt! The store is pretty much the same than an Apple Store in the US. Same furniture, same Genius Bar, etc. iPhones 3G are on sale only with a two years contract with Swisscom or Orange, just like in their respective stores. A second swiss Apple Store opens today in Zurich.
Posted by Franois Bonzon at 18:35
iPhone customization for M-Budget, yallo and CoopMobile
For many weeks, many speculated about the iPhone official launch in Switzerland on Friday (February 29) and with Swisscom. They were unfortunately all wrong, as we still see nothing coming, and no official announcement about a future release either. Today, I do however have some free goodies for Swiss iPhone owners. If your operator is M-Budget, yallo or CoopMobile, keep on reading this post!

The 1.1.3 firmware introduced the concept of "Carrier Bundle" to store carrier-specific settings on the phone. Like the operator logo on the top left corner, services under Settings > Phone (see screenshot below, with M-Budget Mobile services) and Safari bookmarks. I created bundles for the three aforementioned operators.

To install these bundles:
- you need a jailbreaked 1.1.3 or newer firmware iPhone, with SSH installed;
- download and unzip on your hard disk the ZIP file linked below (SwissPrepaidCarrierBundles.zip);
- copy the three .bundle files over to your iPhone in "/System/Library/Carrier Bundles";
- on the iPhone, run commands:

cd /System/Library/Carrier\ Bundles
ln -s MBudget_CH.bundle 22801
ln -s yallo_CH.bundle 22802
ln -s CoopMobile_CH.bundle 22803


- swap the SIM card in your phone with one from another carrier (e.g. the AT&T card that came with your US iPhone), to force the re-creation of symlinks;
- put your SIM card back in, and restart the iPhone;
- enjoy the new features on your phone.
Posted by Franois Bonzon at 18:57
Media Browser
Eh oui, Mozilla nous a apport Firefox, Thunderbird, Sunbird et Bugzilla. Mozilla nous offre maintenant un complment iTunes, le magnifique Songbird. Songbird est un lecteur de musique intgr un browser web dtectant automatiquement la musique disponible sur le site et vous propose de la downloader comme sur le iTunes Store (iTMS) d'Apple. L'avantage de ce browser-media, c'est qu'il lit les fichiers audio protgs vendus sur le iTMS (pourvu que la machine soit autorise dans iTunes).
Posted by Thomas Gruet at 15:16
Des accus de geek par excellence
Voici une photo des piles de ma souris chrie.
Posted by Thomas Gruet at 13:50
L'iPhone en Suisse chez Swisscom?
Interview par Le Temps de Carsten Schloter, directeur de Swisscom, propos de l'iPhone. Rien d'officiel encore, mais l'entendre, cela ne m'tonnerait pas que Apple choisisse Swisscom pour le distribuer en Suisse...

Posted by Franois Bonzon at 4:22
Pair your Apple Remote
The newer macs come with a handy infrared remote control. Out of the box, any remote control can control any mac. This can bring very funny situations in the classroom, where, while the teacher shows a presentation from his laptop, the students move the slides back and forward, and the teacher going crazy because he thinks his machine is buggy! To cope with this, simply "pair" your Apple Remote with your computer, so that only your personal Apple Remote can control your laptop. To achieve this, hold down the Forward and Menu keys for a few seconds, until your screen shows a successful pairing. If you later decide to remove the pairing, head over to the Security preference pane, and click the Unpair button (see picture). If you have Boot Camp installed on your Intel mac, the procedure to pair the remote control is the same in Windows.
Posted by Franois Bonzon at 23:28
LAME Encoder package Mac OS Universal
LAME is an open source MP3 encoder, especially efficient at mid-high bitrates and at VBR. Both quality and speed improvements are still happening, probably making LAME the only MP3 encoder still being actively developed. More info at lame.sourceforge.net. The .pkg file is linked below.
Posted by Thomas Gruet at 18:22
EPFL VPN on the iPhone
My phone provider doesn't provide any data plan, I am however able to surf the web and check my e-mails on the go with my iPhone at high speed, for free and in a lot of places in Switzerland. How? Thanks to the integrated VPN client on the iPhone and the partnership of EPFL with several hotspots providers. As explained on the page SWITCHmobile : PWLAN, all wi-fi hotspots from Monzoon, TPN, TheNet and Swisscom are accessible for free for all EPFL members. Swisscom provides for example hotspots in all major railway stations, like Lausanne CFF station. Very handy! The screenshot below shows how to configure the iPhone VPN.
Posted by Franois Bonzon at 1:01
Comments (7)
Unlock solution for 1.1.1 firmware
A new firmware v1.1.1 is available in iTunes since a few days. Amongst many little improvements and bug fixes, it notably adds a new iTunes store. If, after unlocking your 1.0.2 iPhone with the anySIM solution, you decide to benefit from these new features and perform the update, you end up with a useless bricked iPhone. This is believed to be intentional by Apple! There is however a solution since yesterday, that I of course tried right away! Unlock your iPhone with the iPhoneSimFree v1.6 software, then use iNdependence v1.2.3 for the remaining. I now have an unlocked iPhone in v1.1.1 running fine, yeah!
Posted by Franois Bonzon at 4:56
Page : 1 2 Next