Store UUIDs as Binary(16) about bhima HOT 3 CLOSED

The one shortcoming of this method is we may not be able to do

var sql = 'INSERT INTO table SET ?;';

Is there any way to make this a trigger on UUID tables? That way none of the server side code has to change?

from bhima.

This proposal is crucial to having manageable database sizes. Before this can be properly considered, we will need a prototype that attempts to demonstrate INSERT syntax on a table that uses UUIDs, to understand how that will change out current API creation process.

If it is as simple as a TRIGGER, I say we go for it as soon as possible and update our APIs to use BINARY(16). If it more complex than that, we will have to have a discussion of the pros/cons in more depth.

from bhima.

Closing this as #152 has been merged.

from bhima.