innodb-optimized-uuid

Generate non-standard InnoDB-optimized UUIDs in JavaScript

About

If you are using MySQL, uuids can add overhead. We can create more performant, but non-standard UUIDs that help speed up insets and is sized to fit inside a binary(16) column.

Here are the steps involved in this process:

1. 13341cb5-c1f8-11e4-91e7-080027880ca6 (Standard UUID v1)
2. 11e4-c1f8-13341cb5-91e7-080027880ca6 (Transposed, non-standard UUID)
3. 11E4C1F813341CB591E7080027880CA6 (Resized, transposed, non-standard UUID)

Usage Instructions

Install and Include (node.js using npm)

npm install innodb-optimized-uuid

var iouuid = require('innodb-optimized-uuid');

Install and Include (browser using bower)

bower install innodb-optimized-uuid

<script src="bower_components/innodb-optimized-uuid/dist/innodb-optimized-uuid.js"></script>

var iouuid = window.innodbOptimizedUuid;

Generate a non-standard InnoDB-optimized UUID

iouuid.generate();

Output

The above steps will output non-standard InnoDB-optimized UUID in this format:

11E4C1F813341CB591E7080027880CA6

Development

Tests

Clone this repo. Run npm install && npm test

Browser example

1. Clone the repo
2. npm install -g liveserver
3. run live-server in the project root

Building

To build, simply execute: gulp build

Increasing (bumping) the current version

Commit all of your changes locally.

For a patch version bump: gulp patch For a minor version bump: gulp feature For a major version bump: gulp release

Then, finally publish to github/bower and npm using: gulp publish