{"id":42869,"library":"innodb-optimized-uuid","title":"innodb-optimized-uuid","description":"Generates non-standard UUIDs optimized for fast writes in MySQL InnoDB tables. Current stable version is 1.1.1, released under an MIT license. The library transforms standard UUID v1 values by transposing the time components and removing dashes to create a compact binary(16) format, which reduces index fragmentation and improves insert performance. It is distributed as a single file usable in both Node.js (via npm) and browsers (via Bower or direct script include). Unlike typical UUID generators, it prioritizes database write speed over uniqueness or standard compliance.","status":"maintenance","version":"1.1.1","language":"javascript","source_language":"en","source_url":"https://github.com/fisdap/innodb-optimized-uuid","tags":["javascript","uuid","innodb","mysql"],"install":[{"cmd":"npm install innodb-optimized-uuid","lang":"bash","label":"npm"},{"cmd":"yarn add innodb-optimized-uuid","lang":"bash","label":"yarn"},{"cmd":"pnpm add innodb-optimized-uuid","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"CommonJS only; no ES module distribution.","wrong":"import iouuid from 'innodb-optimized-uuid';","symbol":"innodbOptimizedUuid","correct":"var iouuid = require('innodb-optimized-uuid');"},{"note":"Direct property access works, but requires correct require.","wrong":"var generate = require('innodb-optimized-uuid').generate; generate();","symbol":"generate","correct":"var iouuid = require('innodb-optimized-uuid'); iouuid.generate();"},{"note":"Browser global exposed only when using the built dist file.","wrong":"var iouuid = window.innodbOptimizedUuid; // if script not loaded","symbol":"window.innodbOptimizedUuid","correct":"<script src=\"dist/innodb-optimized-uuid.js\"></script>\nvar iouuid = window.innodbOptimizedUuid;"}],"quickstart":{"code":"// Node.js\nvar iouuid = require('innodb-optimized-uuid');\nvar uuid = iouuid.generate();\nconsole.log(uuid); // e.g., '11E4C1F813341CB591E7080027880CA6'\n\n// Browser (after including dist file)\nvar iouuid = window.innodbOptimizedUuid;\nvar uuid = iouuid.generate();\nconsole.log(uuid);","lang":"javascript","description":"Shows how to generate an InnoDB-optimized UUID in Node.js and browser."},"warnings":[{"fix":"Only use for MySQL InnoDB primary key columns stored as BINARY(16). Do not use in contexts requiring standard UUIDs.","message":"Generated UUIDs are non-standard and not RFC 4122 compliant; they cannot be compared lexicographically and will not work with standard UUID parsers.","severity":"gotcha","affected_versions":"*"},{"fix":"If you need v4 or v5, use a dedicated library like 'uuid' and consider alternative indexing strategies.","message":"The library only generates UUIDs from v1 (time-based) values. It does not support modern random (v4) UUIDs or hashed (v5) UUIDs.","severity":"gotcha","affected_versions":"*"},{"fix":"Review the codebase for security issues or consider using a maintained alternative.","message":"The project's dependency graph shows outdated packages (e.g., gulp, codeclimate) and it has not been updated since 2016. It may contain security vulnerabilities.","severity":"deprecated","affected_versions":"*"},{"fix":"For browser use, include the dist file directly or bundle it with your own tooling. For new projects, use npm and a bundler.","message":"Bower is now deprecated; the browser distribution may not be reliable for modern module bundlers.","severity":"gotcha","affected_versions":"*"}],"env_vars":null,"search_vec":"'1.1.1':22 '16':48 'binari':47 'bower':74 'browser':72 'compact':46 'complianc':92 'compon':39 'creat':44 'current':18 'dash':42 'databas':85 'direct':76 'distribut':60 'fast':12 'file':64 'format':49 'fragment':53 'generat':5,82 'improv':55 'includ':78 'index':52 'innodb':2,16,95 'innodb-optimized-uuid':1 'insert':56 'javascript':93 'librari':29 'licens':27 'mit':26 'mysql':15,96 'node.js':68 'non':7 'non-standard':6 'npm':70 'optim':3,10 'perform':57 'priorit':84 'reduc':51 'releas':23 'remov':41 'script':77 'singl':63 'speed':87 'stabl':19 'standard':8,31,91 'tabl':17 'time':38 'transform':30 'transpos':36 'typic':80 'uniqu':89 'unlik':79 'usabl':65 'uuid':4,9,32,81,94 'v1':33 'valu':34 'version':20 'via':69,73 'write':13,86","created_at":"2026-06-05T16:57:03.356116+00:00","updated_at":"2026-06-05T16:57:03.356116+00:00","problems":[{"fix":"Run 'npm install innodb-optimized-uuid' in your project root.","cause":"Package not installed or not in node_modules.","error":"Error: Cannot find module 'innodb-optimized-uuid'"},{"fix":"Ensure the script tag for dist/innodb-optimized-uuid.js is added before any usage, and reference window.innodbOptimizedUuid.","cause":"Browser script not loaded before usage, or wrong global name.","error":"ReferenceError: innodbOptimizedUuid is not defined"},{"fix":"Use 'var iouuid = require('innodb-optimized-uuid');' as the package does not support ES imports.","cause":"Incorrect require or import (e.g., using ES module syntax with CommonJS package).","error":"TypeError: iouuid.generate is not a function"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/fisdap/innodb-optimized-uuid","github":"https://github.com/fisdap/innodb-optimized-uuid","docs":null,"changelog":null,"pypi":null,"npm":"innodb-optimized-uuid","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}