[Nitro] Og prefix, standard primary key

Jonathan Buch john at oxyliquit.de
Sat Mar 24 12:00:18 EDT 2007


Hi,

like I already said to George in #nitro:

I would like to stay with the standard prefix 'og', for the
following reasons:

* easily enough changed
* failes if
     reserved keyword (database depending)
     + not quoted (database depending)
* when quoting, many more method calls, overall speed goes down
* og tables have a common prefix, psql + tab trigger 'ftw'.
* backwards incompatible
* custom sql will have to be changed
   (yes, I know you can just change the default setting again)

These are more or less important, I just don't think there's
enough reason to change the default, as it is really really
easy to change the default.


Changing .oid to .id :

+ 'more transparent' to PHP and AR people
+ one letter less
+ 'id' is more standard for pure DB people
- .id raises warnings (.object_id)
- backwards incompatible, no easy setting
- custom sql will have to be changed

Again, I'd rather stay with .oid after thinking a while about it.
(number one reason for me being the warnings atm)

George, please don't just say 'I disagree with you', but please
be a bit more descriptive when dismissing my main points.  ^^;

Jo

-- 
Feel the love
http://pinkjuice.com/pics/ruby.png


More information about the Nitro-general mailing list