DBD::File insert/update (was: [svn:dbi] r14096 - dbi/trunk/lib/DBD)

On Fri, Jun 04, 2010 at 04:12:18AM -0700, [email protected] wrote:
>  
> +This modules uses hash interfaces of two column file databases. While
> +none of supported SQL engines have a support for indeces, following

s/indeces/indices/

> +statements really do the same (even if they mean something completely
> +different):
> +
> +  $sth->do( "insert into foo values (1, 'hello')" );
> +
> +  # this statement does ...
> +  $sth->do( "update foo set v='world' where k=1" );
> +  # ... the same as this statement
> +  $sth->do( "insert into foo values (1, 'world')" );

Is this really necessary? Can't we get duplicate inserts and
updates of non-existent rows to behave in a sane manner?

The hash/DBM style databases should be modeled as two column tables
with a unique constraint on the key column.

Tim.