Subject | One Generator To Rule Them All |
---|---|

Author | sugi |

Post date | 2003-09-06T18:11:50Z |

Dear firebird-support list,

For some time now, I've been thinking about means to alleviate the

complexity caused by the use of generators (i.e. having to

declare/implement X number of generators and before insert triggers for

X number of different tables, I'm lazy...:).

Now here's some crazy idea:

What if we just use one generator for all table PKs in a database?

It's just a surrogate key, and by doing this, we achieved

'enterprise-level uniqueness' (coined by scott ambler, i think) at the

same time.

The obvious problem is the limit of 32bit integers, which is plenty, but

not inexhaustible. Any suggestions or comment on whether this is a good

idea?

Many thanks in advance,

sugi.

For some time now, I've been thinking about means to alleviate the

complexity caused by the use of generators (i.e. having to

declare/implement X number of generators and before insert triggers for

X number of different tables, I'm lazy...:).

Now here's some crazy idea:

What if we just use one generator for all table PKs in a database?

It's just a surrogate key, and by doing this, we achieved

'enterprise-level uniqueness' (coined by scott ambler, i think) at the

same time.

The obvious problem is the limit of 32bit integers, which is plenty, but

not inexhaustible. Any suggestions or comment on whether this is a good

idea?

Many thanks in advance,

sugi.