Submitted by Bernd Helmle on Thu, 25/02/2010 - 12:02
The PostgreSQL project just released the Alpha 4 of its upcoming PostgreSQL 9.0. The Alpha4 version of the upcoming PostgreSQL 9.0 release is ready for download. It is planned that Alpha4 will be the last Alpha version before the Beta release cycle for PostgreSQL 9.0. Some highlights of this release are:
Submitted by Bernd Helmle on Thu, 25/02/2010 - 11:57
The series "PostgreSQL Optimiser Bits" will introduce the strategies and highlights of the PostgreSQL optimiser. We start today with a new feature of PostgreSQL 8.4: Semi and Anti Joins.
Since version 8.4, PostgreSQL has been offering a new optimisation strategy for the optimisation of certain queries: Semi and Anti Joins.
A Semi Join is a specific form of a join, which only takes the keys of relation a into account if these are also present in the associated table b. An Anti Join is the negative form of a Semi Join: that is, a key picked in table a will be taken into account if it is not present in table b.
Submitted by Roland Wolters on Thu, 25/02/2010 - 11:18
The Debian project has announced that its internal DNS infrastructure is gradually moving over to DNSSEC. Thus from now on, all DNS answers for debian.com, amongst others, will be digitally signed to verify their authenticity. The Domain Name System (DNS) is one of the core components of the Internet. However, the initial design of DNS is vulnerable against some quite serious attacks, among them cache poisoning which means faking of DNS answers. To avoid this problem, DNSSEC was introduced (DNSSEC in Wikipedia, see also dnssec.net).
Submitted by Roland Wolters on Wed, 24/02/2010 - 16:09
One of the fastest ways to restrict the access to a web server path is to use .htaccess files. These are placed in the to-be-restricted path and contain the information how to restrict the access. A simple example is given below:
Submitted by Roland Wolters on Wed, 17/02/2010 - 13:42
A couple of hours ago Nokia and Intel announced that they plan to merge their mobile Linux platforms to create a common base: MeeGo. Giants Intel and Nokia have had their own Linux platforms for some time; Nokia was developing Maemo while Intel pushed Moblin forward.
Submitted by Roland Wolters on Tue, 16/02/2010 - 11:23
One of the many advantages of vim is the possibility to use syntax highlighting: different terms and chars are displayed in different colors according to their meaning and function.The more colours are available, the better - however, in many cases vim falls back to 8 or 16 colors by default. This can be quickly changed with an entry in ~/.vimrc:
Submitted by Roland Wolters on Mon, 15/02/2010 - 14:05
The Skolelinux team has released version 5.0 of its popular school server, which is now based on Debian Lenny. The distribution Skolelinux, also known as Debian-Edu, is a Debian version adapted for running school networks with Linux. It enables even non-geek users to quickly set up a central school server with a terminal server, thin clients, workstations and laptops as desktop computers. With the release of version 5.0, Skolelinux was lifted to the current Debian software base.
Submitted by Roland Wolters on Fri, 12/02/2010 - 14:25
This week the KDE project released version 4.4 of its software compilation. Besides new scientific programs, this version focuses on stability and enhancements of the current programs and functions. The KDE project released version 4.4 of its "KDE Software Compilation" (KDE SC) package.
Submitted by Bernd Helmle on Thu, 11/02/2010 - 11:36
PostgreSQL is taking some big steps forward this year. The publishing of version 9.0 is just around the corner, while some of the older versions are coming to the end of their lifetime.
2010 will see PostgreSQL release its first major new version for a long time: version 9.0. The release of version 9.0 is an important milestone in the evolution of PostgreSQL. Integral to this release are new features such as the operation of standby servers in read-only mode (hot standby) and an integrated replication solution.
Submitted by Roland Wolters on Wed, 10/02/2010 - 11:31
The 2010 Debian Bug Squashing Party turned out to be a great success: around 200 bugs were fixed, ready for the forthcoming version of Debian. The weekend of 22-24 January saw this year's Bug Squashing Party hosted yet again by credativ. The aim of the weekend was to find and fix bugs in the next Debian release. The results were as follows: