Tuesday Aug 26, 2008

PostgreSQL BuildFarm on Solaris on Sparc

Check out a new PostgreSQL buildfarm set up by Zdenek Kotala. (By the PostgreSQL community convention, I'm referring to it as a "buildfarm" but it should probably be better known as a "testfarm".)

Thursday Feb 07, 2008

Three Open Source Databases in Solaris SXDE 1/08

 

These three open-source databases, now in OpenSolaris SXDE 1/08, offer all the needed features for most of the applications out there.

"Three databases to run them all"...

... and of course, Sun offers solutions with commercial database vendors, like the Sun and Oracle's Enterprise Grid Solutions.


Tuesday Feb 05, 2008

PostgreSQL 8.3 is Released

Josh Berkus has just announced the release of PostgreSQL 8.3.

Bjorn Munch has posted a note on the release of the Solaris binaries for PostgreSQL 8.3 on the OpenSolaris database community discussion forum.

Munch also has a wiki entry that describes how to build PostgreSQL for youself. (Important note: As should be expected, Sun provides support only for PostgreSQL versions that it itself ships with Solaris. While this should be kept in mind, we also like developers to know how to build and develop PostgreSQL on Solaris. Hence the wiki entry!)

This, I believe, is the first time official Solaris binaries of a GA release of PostgreSQL become available also through PostgreSQL.org.

About this release, there has been a lot of commentary in the press and in blogsphere. These were forwarded by a colleague. I selected some of the news and blog items below, giving the relevant links:

 

If interested, you should also consult the official PostgreSQL 8.3 release announcement.

Finally, I would also recommend checking out Sun PostgreSQL web site and the OpenSolaris database community for discussion and other topics related to PostgreSQL and databases in general!

Addenda:

"Open Source PostgreSQL 8.3 Better Suited For Web Applications: New features include a full text search tool, improved overall throughput, and ANSI standard SQL/XML support ," InformationWeek, 2/7

Thursday Jan 24, 2008

The Friendly Elephant and the Rising Elephine

Amol Chiplunkar describes his experience migrating an application to PostgreSQL. Here's how he describes the server requirements met by PostgreSQL.


Courtesy of Petr Zahradnik

The product has a central server layer that collects data from tens or sometimes hundreds of systems periodically. The collected data needs to be processed and stored in the database for generating reports and graphs. The data retainment policy is to keep on rolling it up so that the data stays over a long duration at a gradually reducing granularity level with time. Which means the freshly collected data should be the most granular while the older data should be summarized over a period of time and purged out as and when required.

In the meantime, Bjorn Munch describes how to build PostgreSQL for Open Solaris ... and Zdenek Kotala presents the "rising elephine" ...

About

MortazaviBlog

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today