innodb-optimized-uuid
v1.1.1
Published
A library that generates non-standard uuids that are optimized for fast writes in MySQL InnoDBs
Downloads
1,777
Readme
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 = 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
- 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