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:
- 13341cb5-c1f8-11e4-91e7-080027880ca6 (Standard UUID v1)
- 11e4-c1f8-13341cb5-91e7-080027880ca6 (Transposed, non-standard UUID)
- 11E4C1F813341CB591E7080027880CA6 (Resized, transposed, non-standard UUID)
Usage Instructions
Install and Include (node.js using npm)
npm install innodb-optimized-uuid
var iouuid = ;
Install and Include (browser using bower)
bower install innodb-optimized-uuid
var iouuid = windowinnodbOptimizedUuid;
Generate a non-standard InnoDB-optimized UUID
iouuid;
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
- Clone the repo
npm install -g liveserver
- 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