Messages

1

Software / What is the best Open Source database?

« on: May 28, 2004, 05:31:02 pm »

Thanks! =)

About a year ago I wanted to try this datababe out, but when I went to their site... it\'s wasn\'t free.  Is MySQL free?  ...or was I just looking at the wrong place?

yes it is free.
He have the GPL license, so you can use it as free software.
MySql society have the all the right on this software so it can also sell it with another license (it sell it with a commercial license).

The DB features that are most important to me are:
* Relational Tables (I think you said that all of the ones above count as that)
* Grouping ( \"GROUP BY\" clause in the query... I don\'t think MS Access supports this, but Oracle and SQL Server do)
* Views
* Snapshots or MaterializedViews (This one may not be supported in many places)

Does MySQL do these well?  I was previously thinking of switching to MySQL...

I don\'t know what is materialized views.
I think there are all basic task that all relational db have.

2

Software / What is the best Open Source database?

« on: May 28, 2004, 05:05:06 pm »

I work with Oracle in a very large database with hundreds tables (normally each of they have 1 million to 33 million records), hundreds views, ..., links with other local and remote db, ...

I used at home PostgreSQL and I think it is very good db, for some things it is better than Oracle. I have managed tables up to 22 million records with not too much problem with a t-bird 1000 Mhz

Some year ego I have used sql-server and I think that this one is not a \"database\" (if you use a databse for woriking and not joiking)