- 전체보기(68)
- mysql(6)
- db(5)
- sql(4)
- ubuntu(3)
- 맥북(3)
- 맥북셋팅(3)
- PostgreSQL(3)
- aws(2)
- API(2)
- JavaScript(2)
- Flask(2)
- mac(2)
- git(2)
- Database(2)
- typescript(2)
- dbapi(2)
- 파이썬(2)
- http(2)
- 우분투(2)
- linux(2)
- WSL2(1)
- redis(1)
- cubejs(1)
- centos(1)
- 알고리즘(1)
- diagram(1)
- service(1)
- python(1)
- mqtt(1)
- cmd(1)
- hppts(1)
- 소스트리(1)
- English(1)
- mongodb(1)
- docker(1)
- CS(1)
- postman(1)
- brew(1)
- unixtime(1)
- regex(1)
- mosquitto(1)
- shellscript(1)
- 타입(1)
- winodw(1)
- 영어(1)
- dbeaver(1)
- CSS(1)
- html(1)
- portforwarding(1)
- GitConvention(1)
- erd(1)
- content_type(1)
- log(1)
- max_connections(1)
- console(1)
- C(1)
- pm2(1)
- curioustore(1)
- 특강(1)
- codingConvention(1)
- 리눅스(1)
- variable generator(1)
- 변수명(1)
- 맥(1)
- 정규화(1)
- datetime(1)
- Date(1)
- algorithm(1)
- 도커(1)
- vscode(1)
- session(1)
- 시각화(1)
- 정규표현식(1)
- slack(1)
- RESTfulAPI(1)
- carnac(1)
- npm(1)
- schema(1)
- serialnumber(1)
- server(1)
- keycaster(1)
- sourcetree(1)
mysql createdAt updatedAt
default - CURRENT_TIMESTAMPextra - DEFAULT_GENERATED on update CURRENT_TIMESTAMP
Datetime to Unixtime (mac, linux)
How to convert DATE to UNIX TIMESTAMP in shell script on MacOS - https://stackoverflow.com/questions/3817750/how-to-convert-date-to-unix-timestam
keycaster 키보드단축키
keycastercarnachttps://ko.altapps.net/soft/carnac?platform=mac
정규표현식
https://www.codemshop.com/manual/docs/members-s2/uses-guide/field-regexp-settings/
pm2 오류 (ProcessContainerFork)
rm -rf ~/.pm2https://github.com/Unitech/pm2/issues/1943
source tree 인증
https://pingfanzhilu.tistory.com/entry/GitHub-%EC%86%8C%EC%8A%A4%ED%8A%B8%EB%A6%ACSourcetree%EC%97%90%EC%84%9C-push%EC%8B%9C-%ED%86%A0%EA%B7%BC-%
AWS- ec2 포트 포워딩(port forwarding)
https://velog.io/@jinseoit/ec2-port-forward
AWS에서 사용자에 대해 MFA 디바이스 활성화
https://docs.aws.amazon.com/ko_kr/IAM/latest/UserGuide/id_credentials_mfa_enable.html
TypeScript 설정, 강의 준비
install vscode extension "JavaScript and TypeScript Nightly"install npm module \*\*"npm i ts-node -g"install npm module \*\*"npm i typescript" or "npm
Restful API
restful api 참고1\. 마소 - https://learn.microsoft.com/ko-kr/azure/architecture/best-practices/api-design
정규화, sql, nosql
참고링크 - https://gyoogle.dev/blog/computer-science/data-base/SQL%20&%20NOSQL.html
schema, instagram schema
링크 - https://velog.io/@seungsang00/Database-Instagram-%EC%8A%A4%ED%82%A4%EB%A7%88-%EB%94%94%EC%9E%90%EC%9D%B8
Database 스키마/ 테이블/ 컬럼 네이밍 설계 방법 (DB Naming Rule)
링크 - https://jeongkyun-it.tistory.com/186
ONLY_FULL_GROUP_BY : GROUP BY
ONLY_FULL_GROUP_BY : GROUP BYANY_VALUE() 함수를 사용하여 정상적으로 Query의 결괏값을 받을 수 있다. 참고 - https://info-lab.tistory.com/274