PostgreSQL maintains its own package repositories for binary packages for the most common Linux distributions and operating systems, which allows you to stay up to date through your familiar package manager. If you are running Debian 6 (Squeeze), you may be using the default PostgreSQL 8.4 and if you are running Debian 7 (Wheezy) it ships with PostgreSQL 9.1. Every major version of PostgreSQL comes with significant performance improvements and feature upgrades.
To update your Debian machine to the latest PostgreSQL version all you need to do is to create an additional apt-get source list /etc/apt/sources.list.d/pgdg.list and insert the following line for Debian 6: deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main
or the following line for Debian 7: deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main
Furthermore you will have to import the PostgreSQL repository signing key wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | \
apt-key add -
After updating your package repositories, and upgrading apt-get update ; apt-get upgrade
PostgreSQL should be upgraded and you should have two database server versions running. In my case 8.4 with all the previous data and 9.2 with no data.
To migrate the database content from the old version to the new database system (8.4 and 9.2 on my machine) you switch to the postgres user and erase the database that was created during installation of the new database system. Afterwards a pg_upgrade command will dump the data of the old server and import it into the new server. su postgres
pg_dropcluster --stop 9.2 main
pg_upgradecluster 8.4 main
Finally you can uninstall your old version of PostgreSQL.
Wow! Today’s update for Google Glass is huge. XE7 – Version 7 of the Explorer Edition ships a mobile web browser that allows you to open links from your google search results. Also try searching “youtube <your favorite show>” to get the video stream displayed right on Glass. After XE6, which brought Photo quality improvements, XE7 seems like a big Power Up. Google Glass just became so much more powerful.
We just won $1000 – One Thousand US Dollars! Awesome! Thank you Intel!
During the time of December 17th to February 20th Intel held the Perceptual Computing Challenge Phase 1. I entered “Google Earth Controller”, an application demonstrating touch-free navigation of Google Earth utilizing an Interactive Gesture Camera and the Intel Perceptual Computing SDK.
It allows you to fly like Superman across Earth or other planets while staying seated in your favorite chair! See video below.
Yesterday afternoon the winners were announced and Team “W” is happy that “Google Earth Controller” was awarded with Second Place. While this was just a weekend warm-up hack we are getting ready for Phase 2 of the challenge. Stay tuned!
Apple’s annual Worldwide Developers Conference is an exciting event providing an in-depth and inside look at the latest in iOS and OS X. Tickets are always high in demand and have sold out within two hours this year. In addition to the regular tickets, which sold for $1599, Apple accepted applications for one of 150 scholarships.
I have been very excited all day when I received an email from Apple granting me a scholarship to attend WWDC 2012. Thank you, Apple!
At today’s keynote of the Intel Developer Forum 2011, Intel CEO Paul Otellini presents Intel’s vision about the future of computing. It came by surprise to see Google’s Senior Vice President of Mobile Andy Rubin get on stage during the keynote. Paul Otellini and Andy Rubin announced a strategic partnership between Google and Intel for delivering x86 phones and tablets running Android. So that raises the question: what is going to happen to Intel’s own Linux platform for tablets and phones MeeGo? Paul Ottelini reassured the audience, that Intel will keep the collaboration with industrial partners utilising MeeGo on embedded devices.
Furthermore for laptops the trend goes towards Ultrabooks says Paul Otellini. Intel focusses on making them lighter, faster, cheaper, less power consuming and more responsive. A few Ultrabooks are exhibited on stage. A demo computer shows in which direction mobile computing may go: an ultra low voltage cpu prototype powered by a solar cell and executing Windows.
Cisco shows the next generation office phone. It looks like their current line of IP phones, however it’s color screen is actually a detachable android tablet powered by an atom cpu, I guess.
For a seamless collaboration of mobile and stationary gadgets, Paul Otellini presents Intel Pair & Share, which enables phones, tablets, computers and TVs to connect to each other and show notifications and messages on the currently used device.
I consider myself lucky, getting one of the ~5000 Tickets for this year’s Google I/O, which sold out in 59 minutes. We heard exciting news about the next Version of Android “Ice Cream Sandwich”, which will fuse the latest Phone and Tablet Operating Systems Gingerbread and Honeycomb. On Day 2 Google announced the shipment of Chromebooks from different manufacturers. Chrome OS is Google’s Client system for Cloud based computers. Traditionally – like every year – attendants got a huge gift pack. I have to admit, I have never been so thrilled at a Technology Conference.
For full details about Google I/O, check out their excellent online session catalogue: Google I/O 2011.
I am very excited to announce, that as of today, AquaChem is available in the BlackBerry App World. AquaChem is a handy tool to solve common Aquatic Chemistry equations for determination of Activity Coefficients, Ionization Fractions and Equilibrium Constants. The application provides students with a simple means of performing laborious calculations, the underlying chemistry of the problem being studied can be the primary focus rather than the calculations.
Research in Motion announced: everyone who submits an application for the BlackBerry PlayBook by March 15, would receive a free PlayBook tablet. Since I am very excited about the BlackBerry PlayBook, it’s Hardware, and it’s underlying QNX realtime operating system and I am waiting for it to appear on the market, a free Tablet is enough incentive to look into how to code for the PlayBook as an early adopter. I implemented AquaChem – an Adobe Air application – from scratch, after spending a couple of hours going through a comprehensive tutorial with Source Code.
AquaChem is based on the idea of iChem. The purpose of the application is to bring Aquatic Chemistry on modern Handheld devices to the classroom. AquaChem has just been submitted to the BlackBerry App World.
Microsoft’s Kinect Sensor is a nice peace of Hardware and considerably cheap for a camera that also provides a 640×480 depth image. Soon after it appeared on the market in November 2010, it was reverse engineered for users to interface it from the computer without the Xbox 360.
Technology Enthusiasts and Roboticists all over the world picked up a Kinect to see what they can do with it. My personal motivation is to improve Perception for my Service Robot. Shortly after the publication of the Kinect Hack, Microsoft and PrimeSense decided to release an official SDK: the OpenNI Framework.
Eric Butler published an easy to use Firefox extension which captures session cookies from broadcast media such as public wifi networks. It allows anyone, to collect Facebook, Twitter, Flickr, etc session cookies and do anything with these accounts with just a click.
I hope social network providers start implementing end-to-end encryption via https soon. Until then, be careful from where you access your social networks. On the other hand easy identity stealing brings social networking to a new level.
This year’s Intel Developer Forum from September 13th to 15th was all about Data Center Applications, Cloud Computing, and Embedded Systems. I was happy about the opportunity to present a Poster about my Leonardo Robot Project in the academic track. The conference was accompanied by Intel’s AppUp Elements developer meeting which occurred for the first time this year.
iChem is a case study to bring aquatic chemistry calculations on the iPhone to the classroom. The computational nature of aquatic chemistry lends itself well to the iPhone platform and by providing students with a simple means of performing laborious calculations, the underlying chemistry of the problem being studied can be the primary focus rather than the calculations.
The application features Activity Coefficient, Ionization Fraction and Equilibrium Constant computations. The goal is to provide a user friendly tool for chemistry students, which enables them to quickly solve standard computations on their fingertips. The tool will be made available to the public, soon.
 Martin Wojtczyk, Mark A. Nanny, and Chetan T. Goudar. Aquatic Chemistry on the iPhone: Activity Coefficient, Ionization Fraction and Equilibrium Constant determination. In 239th American Chemical Society National Meeting & Exposition, San Francisco, USA, March 2010.
The Wii Remote got plenty of attention among Roboticists to improve Human-Robot-Interfaces and to lower anxiety for complex machines. Therefore I implemented WiiDrive for the Leonardo Robot Project. WiiDrive is a Wii Mote Control application to enable anybody to move the Leonardo Robot, without typing complex commands at the keyboard (see Video).