If you use atom... download & install the following packages:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# MySQL: convert BINARY(16) to GUID (Microsoft-style UUID) | |
# 0x11223344556677889900AABBCCDDEEFF → '44332211-6655-8877-9900-AABBCCDDEEFF' | |
# Usage: CREATE TABLE example (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, guid BINARY(16) NOT NULL UNIQUE); | |
# SELECT id, uuid_from_bin(guid) FROM example; | |
# Tested on: MySQL 5.6, 5.7, 8.0 | |
CREATE FUNCTION uuid_from_bin(b BINARY(16)) | |
RETURNS char(36) CHARSET utf8 | |
DETERMINISTIC | |
BEGIN |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# MySQL: convert GUID (Microsoft-style UUID) to BINARY(16) | |
# '11223344-5566-7788-9900-AABBCCDDEEFF' → 0x44332211665588779900AABBCCDDEEFF | |
# Usage: CREATE TABLE example (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, guid BINARY(16) NOT NULL UNIQUE); | |
# INSERT INTO example (guid) VALUES (uuid_to_bin(UUID())); | |
# Tested on: MySQL 5.6, 5.7, 8.0 | |
CREATE FUNCTION uuid_to_bin(s CHAR(36)) | |
RETURNS binary(16) | |
DETERMINISTIC | |
RETURN UNHEX(CONCAT( |
chmod
Forget the chmod octals (the numbers). Set permission the easy way using the keywords
// know the ownerships:
u = User (you)
g = Group
o = Other (aka. 'World')
a = All of the above
A non-exhaustive list of WebGL frameworks and libraries. It is mostly for learning purposes as some of the libraries listed are outdated/not maintained anymore.
- three.js: JavaScript 3D library
- stack.gl: an open software ecosystem for WebGL, built on top of browserify and npm.
- PixiJS: Super fast HTML 5 2D rendering engine that uses webGL with canvas fallback
- Pex: Pex is a javascript 3d library / engine allowing for seamless development between Plask and WebGL in the browser.
- Babylon.js: a complete JavaScript framework for building 3D games with HTML 5 and WebGL
- Filament: Filament is a real-time physically based rendering engine for Android, iOS, Windows, Linux, macOS and WASM/WebGL
- ClayGL: A WebGL graphic library helping you to