[cvsnt] Re: Repository auditing with Oracle

[Paulo Soares]

> -----Original Message-----
> From: cvsnt-bounces at cvsnt.org 
> [mailto:cvsnt-bounces at cvsnt.org] On Behalf Of Tony Hoyle
> Sent: Tuesday, January 10, 2006 10:13 AM
> To: cvsnt at cvsnt.org
> Subject: Re: [cvsnt] Re: Repository auditing with Oracle
> 
> Paulo Soares wrote:
> 
> > All the databases (maybe not sqllite) provide sequences that can be 
> > queried and auto-incremented in an atomic way. Oracle also 
> has rowid 
> 
> On the contrary - Mysql, Mssql, Access, Sqlite... 
> autoincrement support 
> is much more prevalent - only oracle seems to not support it.
> 

Oracle does that with sequences. I have code where I get the next
sequence number and use that number as key for several tables. You are
right that it's virtually impossible to have common queries even if they
all speak SQL; what I don't understand is the reasoning you make that
the only way to do this is with a DB that supports some kind of
auto-increment leaving Oracle outside of the equation as if Oracle is
some kind of an obscure DB. I'm not really complaining (perhaps just a
bit...), it's not critical for me and as far as CVS goes I've yet to see
any program this good.

Paulo