On Fri, Jun 04, 2010 at 04:12:18AM -0700, rehs...@cvs.perl.org 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.
