Feature Request: GUIDs as Primary Keys

[ghballiet]

(migrated from my original post in Sails)

I prefer to use GUIDs instead of integer primary keys in my apps, and I'd like to be able to do this within Sails. This is definitely lower priority than, say, associations, but I don't believe I'm the only one who uses this, either (see: http://www.codinghorror.com/blog/2007/03/primary-keys-ids-versus-guids.html).

[glenselle]

It looks like you can specify a primary key, and manually create GUIDs from your application and set those to the respective column. It seems to work just fine. Here's what I did:

I used the node-uuid module (https://github.com/broofa/node-uuid):

var uuid = require('node-uuid');

Then in the model where I wanted to use GUIDs, I just set primaryKey to true and set the default to generate a new GUID.

id: {
    type: 'STRING',
    primaryKey: true,
    defaultsTo: uuid.v4()
}

Also, I set autoPK: false within my model to prevent Waterline from automatically creating a PK column.

[CWyrtzen]

We're closing this to keep things tidy. It has been tracked as a feature request. Thanks for sharing your ideas and feedback. And, as always, you can reopen an issue at any time if you need more support.

[CWyrtzen]

https://trello.com/c/1SEeV9uY

[mikebiglan]

One important note for others that grab @glenselle's helpful snippet above. Make sure not to call the uuid.v4 function or else it will do it once at instantiation and use the same GUID for each new record.

id: {
    type: 'STRING',
    primaryKey: true,
    defaultsTo: uuid.v4
}

[gaurav21r]

@glenselle @mikebiglan +1 👍