On The Margins

Tuesday August 26, 2008

[ Technology ] 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".)

2008-08-26 23:25:37.0 -- Comments [2] ; Permalink ; Trackback.
databases open-solaris postgresql solaris sparc technology

Thursday February 07, 2008

[ Sun Microsystems Inc. ] 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.

2008-02-07 22:39:32.0 -- Comments [3] ; Permalink ; Trackback.
apache databases derby mysql open-solaris open-source postgresql sxde

Tuesday February 05, 2008

[ Technology ] 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:

• PostreSQL 8.3 ups performance, XML support -- Computerworld AU, 2/5

• PostgreSQL 8.3: UUID, XML, ENUMs… -- Orangeis My Favorite Color, 2/4

• PostgreSQL 8.3 Released -- AjaxLine (also appeared on Massimiliano Dessì's blog), 2/4

• PostgreSQL 8.3 Released -- UNIX System Administration, 2/4

• Postgresql 8.3 released -- Profoss News, 2/4

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

2008-02-05 18:13:20.0 -- ; Permalink ; Trackback.
databases open-solaris postgresql programming solaris technology

Thursday January 24, 2008

[ Technology ] 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" ...

2008-01-24 14:22:44.0 -- ; Permalink ; Trackback.
databases migration open-solaris programming solaris technology