Server setup hints

[Collins Richey]

On 8/6/06, Chong Yu Meng <chongym at cymulacrum.net> wrote:
>
> > On Sun, 6 Aug 2006, Ben Duncan wrote:
> >
> > > I always thought the beauty of SQL is that it was always SQL,
> > > regardless of the DBM behind it , no ?
>
> Unfortunately, there are a lot of differences between database products,
> because databases are much more than just SQL. If you're just focused on
> development, then the differences between databases is not much
> (exceptions: MS SQL Server and Sybase which use Transact-SQL compared to
> the rest, autoincrement and indexing is implemented differently by
> different database vendors)
>
> If you need to install and maintain databases, then the differences are
> huge.

> If I had a choice, I would choose IBM's DB2 any day because of its
> really easy installation, graphical tools and easy performance tuning.
> For less demanding environments, I'd choose Apache Derby for its small
> footprint and almost zero configuration.
>
> But if I was an employee at a company with a sufficiently large training
> budget, I would go for Oracle -- not because of its technical merits (I
> can't even think of one!), but because certification would instantly put
> me in a much much higher tax bracket!
>

Well said.

I'm not a database designer/developer, so any little bits I get the
opportunity to learn are much appreciated. And, I've never absorbed
the belief exhibited by many (most?) Linux enthusiasts that commercial
products are evil.

-- 
Collins Richey
     If you fill your heart with regrets of yesterday and the worries
     of tomorrow, you have no today to be thankful for.