Skip to content

Instantly share code, notes, and snippets.

View vuon9's full-sized avatar
🍊
chịu

Vuong vuon9

🍊
chịu
View GitHub Profile
@vuon9
vuon9 / json_extract_c.sql
Created November 9, 2020 06:49
JSON_EXTRACT_C func for parsing json string in mysql
DELIMITER $$
DROP FUNCTION IF EXISTS `json_extract_c`$$
CREATE FUNCTION `json_extract_c`(
details TEXT,
required_field VARCHAR (255)
) RETURNS TEXT CHARSET utf8
BEGIN
SET details = TRIM(LEADING '{' FROM TRIM(details));
@vuon9
vuon9 / slackymous.css
Last active December 14, 2020 08:51
Slackymous - Stylish CSS script for "URLs on the domain: app.slack.com"
body {
font-family: Arial, "Segoe UI", "Roboto", "Oxygen", "Ubuntu", "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;
-webkit-font-smoothing: antialiased;
-moz-osx-font-smoothing: grayscale;
}
.c-avatar, .c-avatar--interactive {
display: none;
}
@vuon9
vuon9 / gilded-rose-original.go
Created May 14, 2021 16:54
GildedRose Refactoring Kata in Go
package main
func UpdateQualityOld(items ...*Item) {
for i := 0; i < len(items); i++ {
if items[i].name != "Aged Brie" && items[i].name != "Backstage passes to a TAFKAL80ETC concert" {
if items[i].quality > 0 {
if items[i].name != "Sulfuras, Hand of Ragnaros" {
items[i].quality = items[i].quality - 1
}
@vuon9
vuon9 / README.md
Last active April 12, 2024 18:41
Powertoys - Keyboard Manager - Common macOS keys mapping

How to install

  • cd C:\Users\${username}\AppData\Local\Microsoft\PowerToys\Keyboard Manager
  • Backup file existing one of default.json
  • Download default.json and add it to the current folder

Mapped keys

key
Esc
@vuon9
vuon9 / gpg_git_signing.md
Created November 12, 2021 14:19 — forked from alopresto/gpg_git_signing.md
Steps to enable GPG signing of git commits.

If anyone is interested in setting up their system to automatically (or manually) sign their git commits with their GPG key, here are the steps:

  1. Generate and add your key to GitHub
  2. $ git config --global commit.gpgsign true ([OPTIONAL] every commit will now be signed)
  3. $ git config --global user.signingkey ABCDEF01 (where ABCDEF01 is the fingerprint of the key to use)
  4. $ git config --global alias.logs "log --show-signature" (now available as $ git logs)
  5. $ git config --global alias.cis "commit -S" (optional if global signing is false)
  6. $ echo "Some content" >> example.txt
  7. $ git add example.txt
  8. $ git cis -m "This commit is signed by a GPG key." (regular commit will work if global signing is enabled)
@vuon9
vuon9 / settings.json
Created January 31, 2022 04:27
Go (golang) - editor.tokenColorCustomizations vscode settings
{
"editor.tokenColorCustomizations": {
"textMateRules": [
{
"scope": [
//following will be in italic (=FlottFlott)
"comment",
"entity.name.type.class", //class names
"keyword", //import, export, return…
"constant", //String, Number, Boolean…, this, super
@vuon9
vuon9 / README.md
Created February 20, 2022 12:33 — forked from tombigel/README.md
How to Change Open Files Limit on OS X and macOS Sierra (10.8 - 10.12)

How to Change Open Files Limit on OS X and macOS

This text is the section about OS X Yosemite (which also works for macOS Sierra) from https://docs.basho.com/riak/kv/2.1.4/using/performance/open-files-limit/#mac-os-x

The last time i visited this link it was dead (403), so I cloned it here from the latest snapshot in Archive.org's Wayback Machine https://web.archive.org/web/20170523131633/https://docs.basho.com/riak/kv/2.1.4/using/performance/open-files-limit/

Mac OS X

To check the current limits on your Mac OS X system, run:

@vuon9
vuon9 / gist:8a7a132dc66542950d4e150b90718401
Last active March 6, 2023 10:30
Easily confused glyphs
// Source: https://news.ycombinator.com/item?id=11718653
* b69B80Oo
* 1Il|
* ij
* 5S
* 9gq
* co
* rn m
* cl d
* vv w
@vuon9
vuon9 / README.md
Last active July 27, 2023 05:42
Sequel Ace bundle - Copy as Cucumber table

Copy a bundle command to a new one then change it to similar like the below settings.

How the bundle setting looks like

This will help to copy via context menu:

image

@vuon9
vuon9 / README.md
Created August 18, 2023 03:18
Sequel Ace bundle - Copy as JSON (modified)

To not have "data" as root level but just pure array of data.