PostGreSQL archives - Enterprise Linux Log

Enterprise Linux Log:

PostGreSQL

Apr 21 2009   6:13PM GMT

Open source community reacts to Oracle-Sun deal



Posted by: Leah Rosin
Oracle, sun microsystems, MySQL, PostGreSQL, Java, open source, Innobase, Open source Solaris

Yesterday’s news that Oracle had entered an agreement to buy Sun sent a bit of a shock wave through the open source community. After weeks of pondering what an IBM buyout of Sun would mean, the IT community now had an entirely different scenario unfolding.

The news was the first thing I noticed when I logged onto Twitter, and I saw that SearchDataCenter.com was working on the story. I “retweeted” Executive Editor Matt Stansberry’s play for feedback and heard back from Tom Howard, who said “IBM missed its chance. I want to know what Oracle’s commitment to Open Office and Solaris are, personally.”

But the bigger fear was from the MySQL folks. Satoshi Nagayasu, an open source database engineer from Tokyo, Japan, asked “Should we say goodbye to MySQL?” He then pointed to a blog from 2005 that was a reaction to Oracle’s purchase of Innobase, and said “Josh’s article gave me some insights why we use community-based open source [PostgreSQL].”

One of the more fun and mood-illustrating reactions was from tartansolutions: “Oracle now owns MySQL?! In related news, the Rebel Alliance has been acquired by Darth Vader for three wookies and a tantan :(“

John Engates, CTO at Rackspace, said “Seems like there’s a lot of concern about Oracle screwing up MySQL. People may look to PostgreSQL as a ‘safe’ open source DB.” He linked to a blog post by Om Malik, providing the GigaOM perspective on the purchase. Of the things Om said, the central point in the concern could be summarized by this paragraph:

At this price, it looks like Oracle found itself yet another bargain and in one fell swoop became a worthy competitor to IBM. It allows Oracle to become a player in the cloud computing business. More importantly, the company ends up acquiring MySQL, the upstart database that has been viewed as Oracle’s Achilles’ heel. In one fell swoop, it has taken out its No. 1 competitor.

Not all in the open source community was doom and gloom though. Jim Zemlin, Executive Director of the Linux Foundation, in his blog post in reaction to the deal looked for a silver lining. Zemlin pointed out that Oracle is strategically aligned with Linux in its position as a Linux distributor, and all its products are developed and run on Linux.

“Oracle is a key supporter of open standards such as ODF and we believe this only strengthens that stance,” said Zemlin. “This acquisition could prove fruitful for Open Office and ODF support in the enterprise.”

I was on the phone for the Canonical Ubuntu 9.04 release press conference, and one of the participants asked Canonical CEO, Mark Shuttleworth, what his reaction was, specifically regarding Java support.

“It is far too early to tell,” said Shuttleworth. “Java has been open, it tends to be a one-way trip – once you’ve made that commitment it makes sense to have it as highly available as possible.”

Shuttleworth also saw the move as a bit of further evidence of the worth of open source in the enterprise software industry.

“This really cements that free software and open source is the driving force today,” he said. “All of the major forces today are either free software or powered by free software — Java, Google, and onward. The software marketplace is consolidating at an extraordinary pace. Part of the reason for that is that open source is dominating the innovation pipeline. The fact that one of those five has just announced a $7 billion acquisition of a company that describes itself as the world’s biggest free and opens source software company proves that open source is the big game in town.”

Lastly, analyst Dana Gardener painted what I feel is the most level-headed picture of what the whole deal means.

Suffice to say that whatever momentum Sun had behind open source everywhere will be muted to open source some times as a ramp to other Oracle stuff, or to grow the community and keep developers happy. If nothing else, Oracle has been pragmatic on open source, not religious.

What do you think this means for open source? Are you considering moving to PostgreSQL if you weren’t already? Are you a programmer worried about Java support? Share your thoughts in the comments

More analysis from TechTarget:
Oracle-Sun combo: What does it mean for enterprise Java?

Will Sun help Oracle eclipse IBM?

VARs turn wary eye on Sun-Oracle combo

Oracle-Sun: A threat to VMware?

Oct 28 2008   7:33PM GMT

SE-Postgres tightens SQL security



Posted by: Caroline Hunter
Security, Linux, PostGreSQL, DataManagement, Administration, interoperability and integration

This post was contributed by Joshua Kramer. For more information about Kramer, go to the EnterpriseLinuxLog About the Editors page.

In the theater of IT operations, security has moved to center stage. Attacks have become more complex, and legislative bodies have passed laws that require data protection. In just the past year, Nevada and Massachusetts introduced legislation requiring that consumer data be protected. 

 In 2006, Oracle introduced its Audit Vault, which purported to restrict access to data even from database management administrators. This kind of tool is extremely valuable in the fight against those trying to steal personal information.  

In early 2009, another player will offer a similar — and perhaps more secure — way to restrict data access As part of its yearly feature update, the PostgreSQL group plans to implement a module called SE-Postgres in the database core. This module inherits security rules and contexts from the SELinux rule set of the host OS to control access to tables, individual rows of data and even individual columns. Currently SE-Postgres is available as a patch to the Postgres 8.3 database (for those who don’t mind compiling source code). 

This inheritance of rules applies to all facets of SELinux and therefore gives you power beyond simply restricting access by role. When SE-Postgres is configured properly, a client’s SELinux context is propagated to all data it touches. For example, rows inserted by a subject with SystemHigh privileges will carry the Secret label. A query submitted by a subject with user_t privileges will not return rows that have such a label. For the most part, referential integrity is preserved; a table join will fail if one of the objects required in a table is disallowed by SELinux context. There are a few minor exceptions, but those will be closed as the project progresses.


Apr 30 2007   12:41PM GMT

Enterprise Linux recap, week of April 23



Posted by: admin
MySQL, PostGreSQL, Red Hat, tips

The buzz from March’s Red Hat Enterprise Linux 5 announcement has seeped into the end of April, it would seem, as this week’s recap is all about RHEL 5:

Oracle Linux gets backing from EMC, others
It was another small step forward for Oracle Enterprise Linux this week as a handful of ISVs pledged support, but it’s still a long road ahead for the Red Hat clone.

Open source monitoring shines light on firm’s servers
A successful Nagios deployment from a previous job led one IT administrator to continue the open source trend at his new data center with Solaris and Linux machines.

BakBone backs up Red Hat Enterprise Linux 5
BakBone is expanding its Linux-based data protection portfolio to include the recently released Red Hat Enterprise Linux 5.

PostgreSQL or MySQL: Which is faster?
TIP - There isn’t always a clear-cut answer in the race between dueling databases, PostgreSQL and MySQL, says an expert. Find out his thoughts and how the two compare.

Red Hat author dishes on RHEL 5
Author Tammy Fox has been working with Red Hat Linux for nearly a decade. In this exclusive interview, she lays out important tips for IT managers looking to test or deploy RHEL 5.

I sense an SELinux-related series of articles in SearchEnterpriseLinux.com’s future, but that’s only because I’m writing them right now.