Skip to content

Instantly share code, notes, and snippets.

View bilashcse's full-sized avatar
👨‍💻
Coding is fun

Nazmul Hossain bilashcse

👨‍💻
Coding is fun
View GitHub Profile
@bilashcse
bilashcse / ts-boilerplate.md
Created January 15, 2023 09:58 — forked from silver-xu/ts-boilerplate.md
Setup a Node.js project with Typescript, ESLint, Prettier, Husky

Setup a Node.js project with Typescript, ESLint, Prettier, Husky

1_D8Wwwce8wS3auLAiM3BQKA

Starting a personal node project could be easy; starting a team node project could be challenging.

I am a developer currently working in SEEK Australia.

In my experience, common mistakes developer make when starting a projects are:

  • No Linting
@bilashcse
bilashcse / query_finder.sql
Last active May 14, 2020 08:59 — forked from mezis/query_finder.sql
Finding long-running queries in MySQL
SELECT id,state,command,time,left(replace(info,'\n','<lf>'),120)
FROM information_schema.processlist
WHERE command <> 'Sleep'
AND info NOT LIKE '%PROCESSLIST%'
ORDER BY time DESC LIMIT 50;
@bilashcse
bilashcse / query_finder.sql
Created November 26, 2018 07:47 — forked from mugli/query_finder.sql
Finding long-running queries in MySQL
SELECT id,state,command,time,left(replace(info,'\n','<lf>'),120)
FROM information_schema.processlist
WHERE command <> 'Sleep'
AND info NOT LIKE '%PROCESSLIST%'
ORDER BY time DESC LIMIT 50;