어느용

NodeJs VSCode 에 Debugging 환경 구축

node를 실행

yarn start

1	yarn start

vscode에 launch.json

{
	// IntelliSense를 사용하여 가능한 특성에 대해 알아보세요.
	// 기존 특성에 대한 설명을 보려면 가리킵니다.
	// 자세한 내용을 보려면 https://go.microsoft.com/fwlink/?linkid=830387을(를) 방문하세요.
	"version": "0.2.0",
	"configurations": [
		{
			"type": "chrome",
			"request": "launch",
			"name": "Launch Chrome against localhost",
			"url": "http://localhost:3000",
			"webRoot": "${workspaceFolder}/src"
		}
	]
}

{

// IntelliSense를 사용하여 가능한 특성에 대해 알아보세요.

// 기존 특성에 대한 설명을 보려면 가리킵니다.

// 자세한 내용을 보려면 https://go.microsoft.com/fwlink/?linkid=830387을(를) 방문하세요.

"version": "0.2.0",

"configurations": [

{

"type": "chrome",

"request": "launch",

"name": "Launch Chrome against localhost",

"url": "http://localhost:3000",

"webRoot": "${workspaceFolder}/src"

}

]

}

NodeJs VSCode 에 Remote Debugging 환경 구축

터널링 구축

ssh -N -L 9221:localhost:9229 [remoteIP]

1	ssh -N -L 9221:localhost:9229 [remoteIP]

node를 inspection 모드로 변경 & 웹 서버 실행

node --inspect &
yarn start

1 2	node --inspect & yarn start

vscode에 launch.json

{
	// IntelliSense를 사용하여 가능한 특성에 대해 알아보세요.
	// 기존 특성에 대한 설명을 보려면 가리킵니다.
	// 자세한 내용을 보려면 https://go.microsoft.com/fwlink/?linkid=830387을(를) 방문하세요.
	"version": "0.2.0",
	"configurations": [
		{
			"address": "localhost",
			"localRoot": "${workspaceFolder}",
			"name": "Attach to Remote",
			"port": 9229,
			"remoteRoot": "...",
			"request": "attach",
			"skipFiles": [
				"<node_internals>/**"
			],
			"type": "pwa-node"
		}
	]
}

{

// IntelliSense를 사용하여 가능한 특성에 대해 알아보세요.

// 기존 특성에 대한 설명을 보려면 가리킵니다.

// 자세한 내용을 보려면 https://go.microsoft.com/fwlink/?linkid=830387을(를) 방문하세요.

"version": "0.2.0",

"configurations": [

{

"address": "localhost",

"localRoot": "${workspaceFolder}",

"name": "Attach to Remote",

"port": 9229,

"remoteRoot": "...",

"request": "attach",

"skipFiles": [

"<node_internals>/**"

"type": "pwa-node"

}

]

}

Ubuntu 20.04 에 Bitcoin Core 설치

# Install Dependencies
# -----------------------------------------------------------------------------------------------------------
# Build requirements:
sudo apt install git build-essential libtool autotools-dev autoconf automake pkg-config bsdmainutils python3 libssl-dev libssl-dev

# Install required dependencies
sudo apt install libevent-dev libboost-system-dev libboost-filesystem-dev libboost-test-dev libboost-thread-dev

# Install the BerkeleyDB from Ubuntu repositories:
sudo apt install libdb-dev libdb++-dev libsqlite3-dev

# Optional: upnpc
sudo apt install libminiupnpc-dev

# Optional ZMQ:
sudo apt install libzmq3-dev

# For GUI:
sudo apt install libqt5gui5 libqt5core5a libqt5dbus5 qttools5-dev qttools5-dev-tools libprotobuf-dev protobuf-compiler

# For QR Code support
sudo apt install libqrencode-dev

# Install Bitcoin
# -----------------------------------------------------------------------------------------------------------
git clone https://github.com/bitcoin/bitcoin.git

# Move into project directory
cd bitcoin

# Config
# -----------------------------------------------------------------------------------------------------------
# Generate config script
./autogen.sh

# If debugging symbols not required, amend compile flags:
./configure --with-incompatible-bdb CXXFLAGS="-O2"

# ...lot's of checking...

# Make
# -----------------------------------------------------------------------------------------------------------
make

# Install - sudo is required to install binaries in /usr/local/bin
sudo make install

# Install Dependencies

# -----------------------------------------------------------------------------------------------------------

# Build requirements:

sudo apt install git build-essential libtool autotools-dev autoconf automake pkg-config bsdmainutils python3 libssl-dev libssl-dev

# Install required dependencies

sudo apt install libevent-dev libboost-system-dev libboost-filesystem-dev libboost-test-dev libboost-thread-dev

# Install the BerkeleyDB from Ubuntu repositories:

sudo apt install libdb-dev libdb++-dev libsqlite3-dev

# Optional: upnpc

sudo apt install libminiupnpc-dev

# Optional ZMQ:

sudo apt install libzmq3-dev

# For GUI:

sudo apt install libqt5gui5 libqt5core5a libqt5dbus5 qttools5-dev qttools5-dev-tools libprotobuf-dev protobuf-compiler

# For QR Code support

sudo apt install libqrencode-dev

# Install Bitcoin

# -----------------------------------------------------------------------------------------------------------

git clone https://github.com/bitcoin/bitcoin.git

# Move into project directory

cd bitcoin

# Config

# -----------------------------------------------------------------------------------------------------------

# Generate config script

./autogen.sh

# If debugging symbols not required, amend compile flags:

./configure --with-incompatible-bdb CXXFLAGS="-O2"

# ...lot's of checking...

# Make

# -----------------------------------------------------------------------------------------------------------

make

# Install - sudo is required to install binaries in /usr/local/bin

sudo make install

NginX 이중화

upstream myserver {
	# 기본 round robin
	server localhost:3000;
	server localhost:3001;
}

server {
	listen 8080;
	listen [::]:8080;

	# server_name xxx.anyons.net;
	root /nodejsPath;

	location / {
		allow 192.168.1.0/24;
		deny all;
		# First attempt to serve request as file, then
		# as directory, then fall back to displaying a 404.
		# try_files $uri $uri/ =404;
		try_files $uri @myserver;
	}

	location @myserver {
		proxy_redirect off;
		proxy_http_version 1.1;
		proxy_pass http://myserver;
		proxy_set_header X-Real-IP $remote_addr;
		proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
		proxy_set_header Host $host;
		proxy_set_header X-NginX-Proxy true;
		# proxy_redirect http://myserver http://$server_name;
	}
}

upstream myserver {

# 기본 round robin

server localhost:3000;

server localhost:3001;

}

server {

listen 8080;

listen [::]:8080;

# server_name xxx.anyons.net;

root /nodejsPath;

location / {

allow 192.168.1.0/24;

deny all;

# First attempt to serve request as file, then

# as directory, then fall back to displaying a 404.

# try_files $uri $uri/ =404;

try_files $uri @myserver;

}

location @myserver {

proxy_redirect off;

proxy_http_version 1.1;

proxy_pass http://myserver;

proxy_set_header X-Real-IP $remote_addr;

proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;

proxy_set_header Host $host;

proxy_set_header X-NginX-Proxy true;

# proxy_redirect http://myserver http://$server_name;

}

Ubuntu zsh vim Setting

apt install build-essential
apt install net-tools
apt install openssh-server
systemctl enable ssh
systemctl restart ssh
apt install curl
apt install tmux
apt install mc
apt install git

apt install zsh
sh -c "$(curl -fsSL https://raw.githubusercontent.com/ohmyzsh/ohmyzsh/master/tools/install.sh)"
chsh -s /usr/bin/zsh # logout 필요
zsh # 일단 한번 실행
git clone https://github.com/zsh-users/zsh-autosuggestions.git $ZSH_CUSTOM/plugins/zsh-autosuggestions
git clone https://github.com/zsh-users/zsh-syntax-highlighting.git $ZSH_CUSTOM/plugins/zsh-syntax-highlighting
vi .zshrc

d2coding 설치

apt install neovim
curl -sLf https://spacevim.org/install.sh | bash
vi
vi init.vim
vi init.toml
curl -fLo ~/.vim/autoload/plug.vim --create-dirs https://raw.githubusercontent.com/junegunn/vim-plug/master/plug.vim
vi # 실행후 :PlugInstall
cd ./vim/bundle/vimproc.vim
make

apt install nodejs
apt install npm
npm install jshint

apt install build-essential

apt install net-tools

apt install openssh-server

systemctl enable ssh

systemctl restart ssh

apt install curl

apt install tmux

apt install mc

apt install git

apt install zsh

sh -c "$(curl -fsSL https://raw.githubusercontent.com/ohmyzsh/ohmyzsh/master/tools/install.sh)"

chsh -s /usr/bin/zsh # logout 필요

zsh # 일단 한번 실행

git clone https://github.com/zsh-users/zsh-autosuggestions.git $ZSH_CUSTOM/plugins/zsh-autosuggestions

git clone https://github.com/zsh-users/zsh-syntax-highlighting.git $ZSH_CUSTOM/plugins/zsh-syntax-highlighting

vi .zshrc

d2coding 설치

apt install neovim

curl -sLf https://spacevim.org/install.sh | bash

vi init.vim

vi init.toml

curl -fLo ~/.vim/autoload/plug.vim --create-dirs https://raw.githubusercontent.com/junegunn/vim-plug/master/plug.vim

vi # 실행후 :PlugInstall

cd ./vim/bundle/vimproc.vim

make

apt install nodejs

apt install npm

npm install jshint

.zshrc

# Set name of the theme to load --- if set to "random", it will
# load a random theme each time oh-my-zsh is loaded, in which case,
# to know which specific one was loaded, run: echo $RANDOM_THEME
# See https://github.com/ohmyzsh/ohmyzsh/wiki/Themes
ZSH_THEME="agnoster"

# Uncomment the following line if you want to change the command execution time
# stamp shown in the history command output.
# You can set one of the optional three formats:
# "mm/dd/yyyy"|"dd.mm.yyyy"|"yyyy-mm-dd"
# or set a custom format using the strftime function format specifications,
# see 'man strftime' for details.
# HIST_STAMPS="mm/dd/yyyy"
export HISTSIZE=10000
export SAVEHIST=10000
setopt EXTENDED_HISTORY

# Which plugins would you like to load?
# Standard plugins can be found in $ZSH/plugins/ # Custom plugins may be added to $ZSH_CUSTOM/plugins/
# Example format: plugins=(rails git textmate ruby lighthouse)
# Add wisely, as too many plugins slow down shell startup.
plugins=(
	git
	zsh-syntax-highlighting
	zsh-autosuggestions
	tmux
	colored-man-pages
	colorize
	svn
)

# Set name of the theme to load --- if set to "random", it will

# load a random theme each time oh-my-zsh is loaded, in which case,

# to know which specific one was loaded, run: echo $RANDOM_THEME

# See https://github.com/ohmyzsh/ohmyzsh/wiki/Themes

ZSH_THEME="agnoster"

# Uncomment the following line if you want to change the command execution time

# stamp shown in the history command output.

# You can set one of the optional three formats:

# "mm/dd/yyyy"|"dd.mm.yyyy"|"yyyy-mm-dd"

# or set a custom format using the strftime function format specifications,

# see 'man strftime' for details.

# HIST_STAMPS="mm/dd/yyyy"

export HISTSIZE=10000

export SAVEHIST=10000

setopt EXTENDED_HISTORY

# Which plugins would you like to load?

# Standard plugins can be found in $ZSH/plugins/ # Custom plugins may be added to $ZSH_CUSTOM/plugins/

# Example format: plugins=(rails git textmate ruby lighthouse)

# Add wisely, as too many plugins slow down shell startup.

plugins=(

git

zsh-syntax-highlighting

zsh-autosuggestions

tmux

colored-man-pages

colorize

svn

)

./.SpaceVim/init.vim

"=============================================================================
" init.vim --- Entry file for neovim
" Copyright (c) 2016-2020 Wang Shidong & Contributors
" Author: Wang Shidong < wsdjeg@outlook.com >
" URL: https://spacevim.org
" License: GPLv3
"=============================================================================
   
call plug#begin("~/.vim/plugged")
   
Plug 'vim-airline/vim-airline'    " vim status bar
Plug 'airblade/vim-gitgutter'   " Show git status in vim
Plug 'iamcco/markdown-preview.nvim'

call plug#end()

execute 'source' fnamemodify(expand('<sfile>'), ':h').'/main.vim'

filetype plugin on

set vb
set nu
set nuw=5             " 줄 번호 표시 너비
set backspace=eol,start,indent

" 편집 기능 설정
set sol
set sm

" 검색 기능 설정
set hlsearch
set ignorecase
set showmatch

" indent 설정
set cindent
set autoindent
set smartindent
set tabstop=4
set shiftwidth=4
set softtabstop=4
set noet              " 탭 -> 공백 변환기능 no

" Turn off swap
set noswapfile
set nobackup
set nowb

set whichwrap+=<,>,h,l,[,]

"=============================================================================

" init.vim --- Entry file for neovim

" Author: Wang Shidong < wsdjeg@outlook.com >

" URL: https://spacevim.org

" License: GPLv3

"=============================================================================

call plug#begin("~/.vim/plugged")

Plug 'vim-airline/vim-airline' " vim status bar

Plug 'airblade/vim-gitgutter' " Show git status in vim

Plug 'iamcco/markdown-preview.nvim'

call plug#end()

execute 'source' fnamemodify(expand('<sfile>'), ':h').'/main.vim'

filetype plugin on

set vb

set nu

set nuw=5 " 줄 번호 표시 너비

set backspace=eol,start,indent

" 편집 기능 설정

set sol

set sm

" 검색 기능 설정

set hlsearch

set ignorecase

set showmatch

" indent 설정

set cindent

set autoindent

set smartindent

set tabstop=4

set shiftwidth=4

set softtabstop=4

set noet " 탭 -> 공백 변환기능 no

" Turn off swap

set noswapfile

set nobackup

set nowb

set whichwrap+=<,>,h,l,[,]

./.SpaceVim.d/init.toml

#=============================================================================
# basic.toml --- basic configuration example for SpaceVim
# Copyright (c) 2016-2020 Wang Shidong & Contributors
# Author: Wang Shidong < wsdjeg at 163.com >
# URL: https://spacevim.org
# License: GPLv3
#=============================================================================

# All SpaceVim option below [option] section
[options]
# set spacevim theme. by default colorscheme layer is not loaded,
# if you want to use more colorscheme, please load the colorscheme
# layer
colorscheme = "onedark"
colorscheme_bg = "dark"
# Disable guicolors in basic mode, many terminal do not support 24bit
# true colors
enable_guicolors = false
# Disable statusline separator, if you want to use other value, please
# install nerd fonts
statusline_separator = "nil"
statusline_iseparator = "bar"
buffer_index_type = 4
windows_index_type = 3
enable_tabline_filetype_icon = false
enable_statusline_mode = false
statusline_unicode_symbols = false
# Enable vim compatible mode, avoid changing origin vim key bindings
vimcompatible = true

# Enable autocomplete layer
[[layers]]
name = 'autocomplete'
auto_completion_return_key_behavior = "complete"
auto_completion_tab_key_behavior = "cycle"
[[layers]]
name = 'shell'
default_position = 'top'
default_height = 30

#=============================================================================

# basic.toml --- basic configuration example for SpaceVim

# Author: Wang Shidong < wsdjeg at 163.com >

# URL: https://spacevim.org

# License: GPLv3

#=============================================================================

# All SpaceVim option below [option] section

[options]

# set spacevim theme. by default colorscheme layer is not loaded,

# if you want to use more colorscheme, please load the colorscheme

# layer

colorscheme = "onedark"

colorscheme_bg = "dark"

# Disable guicolors in basic mode, many terminal do not support 24bit

# true colors

enable_guicolors = false

# Disable statusline separator, if you want to use other value, please

# install nerd fonts

statusline_separator = "nil"

statusline_iseparator = "bar"

buffer_index_type = 4

windows_index_type = 3

enable_tabline_filetype_icon = false

enable_statusline_mode = false

statusline_unicode_symbols = false

# Enable vim compatible mode, avoid changing origin vim key bindings

vimcompatible = true

# Enable autocomplete layer

[[layers]]

name = 'autocomplete'

auto_completion_return_key_behavior = "complete"

auto_completion_tab_key_behavior = "cycle"

[[layers]]

name = 'shell'

default_position = 'top'

default_height = 30

2021년 mac 에서 사용하고 있는 프로그램 목록

구입목록에 있는 프로그램들 전부 설치 및 업데이트
- Microsoft Remote Desktop
- Microsoft OneNote
- OneDrive
- Notability
- CheetSheet
- GoodNote 5
- VsCode
- Valentina Studio
- Friendly Streaming Browser
- Facebook Messenger
- Skype
- Amphetamine
- SnailGit
- SnailSVN
- HazeOver
- Slack
- deepClock
- 한컴오피스 한글 2014 VP 뷰어
- 무비스트
- 카카오톡
- 네이트온
- Band
- Telegram
- isHUD
- MachineProfile
- Blackmagic Disk Speed Test
각 홈페이지 가서 설치해야 하는 프로그램
- Chrome
- Karabiner
- Ridi Books
- Filezilla
- Near Lock
- TunnelBlick
- SwitchResX
- Macs Fan Control
- Spectacle
- Google 백업 및 동기화
- Übersicht
  - https://tracesof.net/uebersicht/
  - http://tracesof.net/uebersicht-widgets/
- D2Coding Font
- Parallels 12
  - Windows 10 + VisualStudio 2019
  - Ubuntu Linux 20.04
- coccinellida
Command Line tools
Brew Install
- composer
- git
- go
- htop
- midnight-commander
- neovim
- nmap
- node
- php-code-sniffer
- php-cd-fixer
- python3
- sdl2
- subversion
- tmux
- zsh
- zsh-completions
- tickeys
- casks font-hack-nerd-font
- casks iterms
- casks meld
쓰고 싶은 프로그램
- keycastr

MSSQL History

SELECT
	db_name(st.dbid) DBName
	, object_schema_name(objectid, st.dbid) SchemaName
	, object_name(objectid, st.dbid) SPName
	, qs.total_elapsed_time
	, creation_time
	, last_execution_time
	, text
FROM
	sys.dm_exec_query_stats qs
CROSS APPLY
	sys.dm_exec_sql_text(qs.plan_handle)st
JOIN
	sys.dm_exec_cached_plans cp
ON
	qs.plan_handle = cp.plan_handle

SELECT

db_name(st.dbid) DBName

, object_schema_name(objectid, st.dbid) SchemaName

, object_name(objectid, st.dbid) SPName

, qs.total_elapsed_time

, creation_time

, last_execution_time

, text

FROM

sys.dm_exec_query_stats qs

CROSS APPLY

sys.dm_exec_sql_text(qs.plan_handle)st

JOIN

sys.dm_exec_cached_plans cp

qs.plan_handle = cp.plan_handle

통계용 쿼리 샘플

select year as '년', month as '월', count(*) as count
from (
	select
		YEAR(us.fd_dtcreate) as 'year',
		MONTH(us.fd_dtcreate)  as 'month'
	from tb_ykfile as us
	where us.fd_dtCreate > '2020-08-01' and us.fd_dtCreate <= '2022-01-01'
) tb
group by year, month
order by year, month
;

select year as '년', month as '월', count(*) as count

from (

select

YEAR(us.fd_dtcreate) as 'year',

MONTH(us.fd_dtcreate) as 'month'

from tb_ykfile as us

where us.fd_dtCreate > '2020-08-01' and us.fd_dtCreate <= '2022-01-01'

) tb

group by year, month

order by year, month

;

SELECT    CONVERT(varCHAR(10),Dateadd(d, a.number,'2020-08-01 00:00:00'),120) AS dt
          ,Isnull(b.count, 0)                            AS count
FROM      master..spt_values a 
LEFT JOIN 
          ( 
                   SELECT   count(*)                    AS count, 
                            CONVERT(CHAR(10), b1.fd_dtcreate,120) AS fd_dtcreate
                   FROM     tb_ykfile b1 WITH(nolock) 
                   GROUP BY CONVERT(CHAR(10), b1.fd_dtcreate, 120)
		 ) b 
ON        CONVERT(CHAR(10), Dateadd(d, a.number,'2020-08-01 00:00:00'), 120) = b.fd_dtcreate 
WHERE TYPE = 'P' AND CONVERT(CHAR(10), DATEADD(D, NUMBER, '2020-08-01'), 120) <= '2022-01-01'
order by dt
;

SELECT CONVERT(varCHAR(10),Dateadd(d, a.number,'2020-08-01 00:00:00'),120) AS dt

,Isnull(b.count, 0) AS count

FROM master..spt_values a

LEFT JOIN

(

SELECT count(*) AS count,

CONVERT(CHAR(10), b1.fd_dtcreate,120) AS fd_dtcreate

FROM tb_ykfile b1 WITH(nolock)

GROUP BY CONVERT(CHAR(10), b1.fd_dtcreate, 120)

) b

ON CONVERT(CHAR(10), Dateadd(d, a.number,'2020-08-01 00:00:00'), 120) = b.fd_dtcreate

WHERE TYPE = 'P' AND CONVERT(CHAR(10), DATEADD(D, NUMBER, '2020-08-01'), 120) <= '2022-01-01'

order by dt

;

MSSQL Paging

          SELECT row_number() OVER(ORDER BY fd_nIdService DESC) AS PagedNumber, *
          FROM [tb_Service] AS [t]
          WHERE 1=1
          ORDER BY [fd_nIdService] DESC
          OFFSET ((2 - 1) * 10) ROWS FETCH NEXT 10 ROWS ONLY

SELECT row_number() OVER(ORDER BY fd_nIdService DESC) AS PagedNumber, *

FROM [tb_Service] AS [t]

WHERE 1=1

ORDER BY [fd_nIdService] DESC

OFFSET ((2 - 1) * 10) ROWS FETCH NEXT 10 ROWS ONLY

VIM Encoding

encoding 은 화면에 보이는 것, 시스템이나 터미널에 관련되어 있지 파일 자체에는 관계 없다
Shell
:e ++enc=utf-8 :w ++enc=utf-8
1
2
:e ++enc=utf-8
:w ++enc=utf-8
fileencoding 은 파일에 저장되는 코드, encoding 과 fileencoding 이 같으면 (보통 euc-kr 이나 cp949?) 상관없고 이 둘이 다르면 파일을 읽거나 쓸 때 변환이 된다.
fileencodings 에는 여러 인코딩 룰을 적어주면 파일을 읽을 때 하나씩 검사해서 맞는 인코딩을 찾아내어 자동으로 fileencoding 을 세팅해준다.
Shell
:set fileencoding=utf-8
1
:set fileencoding=utf-8

어느용

참고자료

보관함

NodeJs VSCode 에 Debugging 환경 구축

NodeJs VSCode 에 Remote Debugging 환경 구축

Ubuntu 20.04 에 Bitcoin Core 설치

NginX 이중화

Ubuntu zsh vim Setting

2021년 mac 에서 사용하고 있는 프로그램 목록

MSSQL History

통계용 쿼리 샘플

MSSQL Paging

VIM Encoding

메타

최신 글

참고자료

보관함

메타

최신 글

태그