The best way to do primary keys?

Rails
1

I’ve just made a simple test app - it’s a very basic blog. I ran this
(or something vaguely like this):
ruby script/generate scaffold article title:string body:text
id:primary_key

Now, I’ve got the scaffold, but it shows an ID field. Is there any
special shortcut for getting Rails to automatically fill in the primary
key, or do I have to sort that out manually?

2

Never mind, I’m an idiot. Rails automatically gives objects a primary
key.

It’s always one step ahead of me; I need to catch up.

3

On Mar 1, 2008, at 1:45 PM, Peter B. wrote:

Never mind, I’m an idiot. Rails automatically gives objects a primary
key.

It won’t automatically create an index on it, though, so you might
consider that.

4

On 01 Mar 2008, at 20:52, George B. wrote:

Never mind, I’m an idiot. Rails automatically gives objects a primary
key.

It won’t automatically create an index on it, though, so you might
consider that.

The primary key (in mysql at least, but i’d doubt it be otherwise in
other dbms) is automatically indexed, that’s part of being a primary
key. No need to put an index on it.

Best regards

Peter De Berdt

5

Peter De Berdt wrote:

On 01 Mar 2008, at 20:52, George B. wrote:

Never mind, I’m an idiot. Rails automatically gives objects a primary
key.

It won’t automatically create an index on it, though, so you might
consider that.

The primary key (in mysql at least, but i’d doubt it be otherwise in
other dbms) is automatically indexed, that’s part of being a primary
key. No need to put an index on it.

Best regards

Peter De Berdt

PostgreSQL and SQL Server (unless it’s changed recently) automatically
index primary keys, but not foreign keys. In the PostgreSQL docs, I’m
pretty sure it says that a primary key is enforced via a unique index.

Peace,
phillip