Re: [Lxr-dev] Status of this project?

[Jan-Benedict G. <jb...@lu...>]

On Thu, 2007-03-22 14:29:24 -0400, Paul Smith <ps...@ne...> wrote:
> The only real difference I see is in handling the auto-increment fields:
> I don't know how Oracle does this but MySQL and Postgress handle this
> very differently.  So, that bit would need to be kept local.

Erm, I'm not 100% sure, but as far as I remember, the only difference
for "auto_increment" or "serial" or whatever fields is the CREATE
TABLE statement, at least for MySQL vs. PostgreSQL. Should be enough
to simply omit the auto_increment column's data to get a value
generated.

What may be different is the way to get the newly auto-generated
number back again. But since the INSERT pathes aren't time-critical,
we'd just allow to SELECT for the value instead of playing tricks to
get it.

> > The cruelity of MySQL is that it seems to require '`' instead of '"',
> > what all other RDBMS servers seem to accept...
>=20
> True :-(.  This could be the death of the commonality of the prepare()
> statements (although we could still share at least some of the methods
> since they just invoke execute()).

Heck, this f*ing column name caused so much grief, lets just rename
it!  Yes, that's somewhat painful and we need a Big Fat Warning in the
v1.0 docs that the column needs to be renamed, but I'm all for doing
that.

> Actually there is an "ANSI_QUOTES" mode that we could set, that lets you
> (among other things) use standard "-quoting in MySQL.  That might be a
> valid thing to do.

Is this in the DBI backend or configury on the MySQL server side?

> > The (current) initdb scripts try to first drop table foo, then CREATE
> > it.  Databases implemented different dialects to avoid errors (which
> > in turn could break a transaction), like the "drop table foo if
> > exists" stuff...
>=20
> True.  Note I wasn't suggesting that we would try to unify the initdb-*
> scripts into one script: there's too much variation in the schema
> creation operations to make that worthwhile IMO.

But wrapping around somehow should be done to ease creating tables
with prefixes.

> I just wanted a way to create databases and tables based on the
> information in lxr.conf, without having to edit the appropriate initdb-*
> script by hand.

ACK.

MfG, JBG

--=20
      Jan-Benedict Glaw      jb...@lu...              +49-172-7608481
Signature of:           Ich hatte in letzter Zeit ein bi=C3=9Fchen viel Rea=
litycheck.
the second  :               Langsam m=C3=B6chte ich mal wieder weitertr=C3=
=A4umen k=C3=B6nnen.