Re: [SQLObject] Re: Know bugs in Firebird

[Luke O. <lu...@me...>]

Quoting Ian Bicking <ia...@co...>:

> It's probably easier if we just start quoting all the columns.  That's
> pretty easy with automatic SQL generation anyway.  Postgres uses
> "column", MySQL `column`, what does Firebird use?  (SQLite?)

Just a caution, in PostgreSQL quoting column/table names makes the name
case-sensitive. So "Users" doesn't match dbname users but Users does. :) Not a
big issue, although it may break some existing schema (including ones created
by SQLObject with a not-all-lowercase db style).

> That doesn't fix the 31 character limit.  Raising an exception would be
> best in that case.  It confuses me terribly when I hit that limit (I
> think Postgres has the same limit) and names get truncated.

31 chars in Postgres 7.2, 63 chars in 7.3+.

I believe it's a silent truncation though, so SO will need to be aware of these
things beforehand to make an exception, and also keep in mind that the limit
is actually less when you consider that automatic sequence and constraint
names need to fit in the limit (tablename_colname_seq is the default sequence
name template).

Personally I'm not sure SQLObject needs to deal with all these cases, they're
just part of the responsibility of the developer in choosing a database
platform. But it would be reasonable to make a db-specific faq, detailing
these things to watch out for that SO does behind the scenes.

- Luke