One most important questions….

whats the vertica database License cost??

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/state-of-the-database-2008-vertica-part-1-26171!***!

I didn’t get a chance to go to OSCON 2008. Bummer. But I can live vicariously through google. So, along with all of the announcements you’ve heard from OSCON, I know present the OSCON 2008 – Google popularity contest. This is a completely unscientific survey of google hits. I was searching blogs and news. I started with just news but the blogs hits really upped the numbers.

To run these searches, I use “oscon 2008″ and the search term, for example:

“oscon 2008″ mysql

In the case of open source, I also quoted “open source”.

I’m using google’s about number. I didn’t sit and count each hit.

Yesterday I posted about the results of the EnterpriseDB open source survey. In that post, I said:

I’d like to see the survey again and compare the results to the survey itself.

I discovered that, as of right now, the survey is still online.

Still no information as to when, or if, the entire survey results will be released. That’s what I am most interested in.

LewisC

Technorati : database, enterprisedb, open source, postgres

Have you heard of Drizzle? It was announced at OSCON yesterday and is all over the blogosphere. From the Drizzle FAQ:

* So what are the differences between is and MySQL?

No modes, views, triggers, prepared statements, stored procedures, query cache, data conversion inserts, ACL. Fewer data types. Less engines, less code. Assume the primary engine is transactional.

Also from the FAQ is that, right now at least, there is no intention to make this run natively on windows and they make the point:

* “This is not a SQL compliant relational…”

Very true, and we do not aim to be that.

It is a fork of MySQL that takes it backward to pre-5.0 in features but hopefully greatly reduces the bugs and instabilities.

I was browsing the web on this lazy Sunday afternoon and ran across a good article on the Rarest Words blog. The author was trying to get Django installed and running with Postgres. From the author’s own admissions, he is not a Postgres fanatic.

Well, this and last year I hear everywhere that PostgreSQL is the way to go and that usage of mySQL in 2008 makes people puke… But without any real arguments (besides “Postgres is the way to go”).

After some not so compatible errors with these not so compatible databases, the author did get it working and ran some benchmarks. Postgres did not turn out faster than MySQL.

LewisC’s An Expert’s Guide To Oracle Technology

The datastore in Postgres (which is what Advanced Server is based on) is quite a bit different than the way Oracle stores data. Gone are the usual logical storage components. Data blocks, extents and segments just don’t exist in a Postgres database. Actually, segments do exist when a table gets bigger than 1GB but that’s a story for a different entry.

Postgres stores data as files and directories. Tablespaces are directories and tables (and indexes) are files inside that directory. Postgres ships with two tablespaces installed by default: pg_default and pg_global. The tablespaces cannot be changed or dropped.

LewisC’s An Expert’s Guide To Oracle Technology

An ITToolbox user recently asked a question on the EnterpriseDB discussion group, Oracle equilant UTL_I18N.STRING_TO_RAW IN ENTERPRISEDB.

Basically, Sreenivas asked which functions in EnterpriseDB could be used to implement dbms_crypto, hex_to_raw, string_to_raw, etc. I believe he is using EnterpriseDB Postgres Plus Advanced Server which is the product that gives Oracle Compatibility. The short answer to his question is that right now, there are no compatibility functions for those. The long answer is that you can re-implement that functionality using native PG functionality.

If you look at Sreenivas’s message you can see how his existing code works.

LewisC’s An Expert’s Guide To Oracle Technology

Do you know which open source feature is the most important? Do you know which open source database rocks and which one sucks? Is MySQL better than Postgres? Is Ingres worth considering? How does Firebird compare? Have you used, or have you considered using, an open source database?

Take a survey. It’s only 15 questions so it takes just a few minutes.

I’ll post a link where you can get the results once they have been compiled and prepared.

BTW, this isn’t my survey. I’m just passing on the link.

LewisC

There is a new wiki comparing MySQL to PostgreSQL. Because it’s a wiki, hopefully it can be kept updated so that it’s current AND accurate.
The wiki is MySQL vs PostgreSQL.
Personally, I’d like to see this grow into a universal comparison site that the community could keep updated.
LewisC

There is a new wiki comparing MySQL to PostgreSQL. Because it’s a wiki, hopefully it can be kept updated so that it’s current AND accurate.
The wiki is MySQL vs PostgreSQL.
Personally, I’d like to see this grow into a universal comparison site that the community could keep updated.
LewisC

postgresql mysql

Feature comparisons, in addition to being somewhat lame and almost always biased, are very dependent on versions. If you throw in performance considerations, they are also dependent on hardware and configuration. Even so, I like to read comparisons, for historical information if nothing else.
Here are some comparisons that I have found. I make no recommendations or even commentary about them. Read through them as if you are a database anthropologist. Dig for the nuggets that increase your existing base of knowledge but remember that a human, probably one with an agenda, put these comparisons together.

Have you ever wondered why you should choose one open source database over another? What features would make the most sense for your Organization? Maybe you’re a developer looking to learn a database and can’t choose where to start?

The folks at PostgreSQL have put together a wiki, Why PostgreSQL instead of MySQL. It’s, by no means, complete at this time but it is a good start.
The wiki is not editable by the public but it is open for reading. The wiki entry compares PostgreSQL 8.1 and MySQL 5.0.