Re: If you were inventing CoBOL...

From: Richard (riplin_at_Azonic.co.nz)
Date: 09/06/04 

Date: 5 Sep 2004 19:13:38 -0700

Robert Wagner <robert@wagner.net.yourmammaharvests> wrote

> >'Pico? Too delicate for vi, are we... why not go all out, then, and just
> >use a Mac?'
>
> Macs are for aging hippies.

These days Macs run Unix - a BSD variety.
 
> DB2 has good performance, but administration frustrates even seasoned
> DBAs. Changes seldom work right the first time. For ease of
> maintenance, I'd rank databases from best to worst:
>
> Informix
> SQLServer/Sybase
> Oracle
> DB2/UDB

You had made a comment that you had not seen db admin done from
programs. I couldn't see why this was not so. Then I found one
reason:

In PostgreSQL admin functions are transactional. For example a
program can add a field to a table and then populate that field as one
transaction and then commit. Other accesses to that table will only
see the added fields after the commit and so can continue to access,
but may notice that the rows are locked.

There is no need, as there seems to be in Oracle, of taking down the
db for this admin, so it can safely be put in a db check funtion in
the program.

> For performance:
>
> Informix
> DB2/UDB
> Oracle
> SQLServer/Sybase

For read only performance, such as driving web sites, nothing beats
MySQL.

OTOH, it's not much chop at update performance.

Relevant Pages

  • Re: Long Discussion Re Relational
    ... To explain what I mean I'll use Visual Studio and Oracle as an equivalent... ... > For OSMOSiS, the BASIC editor, file manager, and system admin tools ... > What you're saying though is that this should come from the MV vendor. ...
    (comp.databases.pick)
  • Re: help me understand how a Mac is virtually immune to viruses?
    ... I am a user of multple single-user single account Macs. ... >When you set up a new Mac, you set up a default admin account. ...
    (sci.astro.amateur)
  • Re: Security Update 2006-002 Released
    ... I need to do admin tasks often too, and nearly all of them can be done from a non-admin account. ... A non-admin user simply gets prompted for an administrator's username and password when doing something that needs admin rights. ... For the record I use and support Macs all day long at work, and at home when I'm not using this OpenBSD laptop for email and web access I'm using my Mac primarily for Photoshop, Google Earth, digitizing vinyl, and iTunes. ... the hassles of working in a non-admin account outweigh the benefits. ...
    (comp.sys.mac.system)
  • Re: Tech In Education
    ... >>> The fact that the admin gave out the admin password makes the Macs ... >That has nothing to do with the security of the platform. ... >interesting that hackers are breaking into Windows boxes by the millions ...
    (comp.sys.mac.advocacy)
  • Re: Security Update 2006-002 Released
    ... I need to do admin tasks often too, and nearly all of them can be ... And you think malware is always going to pop up an authentication ... have always been that way throughout the 20 years I've been using Macs. ... The root account is disabled by default. ...
    (comp.sys.mac.system)