Subject | Re: [Firebird-Architect] Firebird 3 new features? |
---|---|
Author | Jim Starkey |
Post date | 2010-04-23T18:53:38Z |
Dalton Calford wrote:
architecture which is based on VMS calling standard, circa 1982.
Methinks it's less relevant to the modern world than it once was.
A two level name space (schemas) is a very good idea. A word of
caution, however. JDBC has three levels (database, schema, and object)
that are essentially undefined. Firebird would be well advised to do
only two, leaving the third for database aggregating middleware. MySQL
took advantage of the opportunity to screw with up and made "database"
and "schema" synonyms, confusing everyone in the process.
--
Jim Starkey
Founder, NimbusDB, Inc.
978 526-1376
> I have seen many discussions in regards to extending the length of databaseThe current limitation on identifier name length comes from the DSRI
> object names or adding schema support.
>
> Have any decisions been made in regards to this? Who is the best person to
> ask about the proposed DDL syntax/limits?
>
>
architecture which is based on VMS calling standard, circa 1982.
Methinks it's less relevant to the modern world than it once was.
A two level name space (schemas) is a very good idea. A word of
caution, however. JDBC has three levels (database, schema, and object)
that are essentially undefined. Firebird would be well advised to do
only two, leaving the third for database aggregating middleware. MySQL
took advantage of the opportunity to screw with up and made "database"
and "schema" synonyms, confusing everyone in the process.
--
Jim Starkey
Founder, NimbusDB, Inc.
978 526-1376