The useful commands for Redis
Monitor MONITOR is a debugging command that streams back every command processed by the Redis server. It can help in understanding what is happening to the database. redis-cli monitor
Khuong Dev
The useful commands for PostgreSQL
Common Connect to the database from the command line psql -h 127.1.2.3 -U postgres_user database_name Database Create a new database # Create a new database with the custom lc_collate, lc_cty...
Update all your package.json dependencies interactively
Yarn yarn upgrade-interactive Pnpm pnpm update --interactive [--recursive] [--latest] [--prod] [--dev]
The helpful Git Aliases
# git log -1 HEAD # => git last git config --global alias.last 'log -1 HEAD' # git reset HEAD -- fileA # => git unstage fileA git config --global alias.unstage 'reset HEAD --' # git checkou...
Some Java/Kotlin project examples
Java project Spring boot with redis cache ➜ Refer to: here Kotlin project Barcode Generate & download QRCode ➜ Refer to: here Some utils Date Time,… ➜ Refer to: here
Run the SQL commands on Windows PowerShell
$SqlPath = "$([System.IO.Path]::GetFullPath("$($MyInvocation.MyCommand.Path)\.."))\sql" $DBHost = "localhost" $DBPort = "5432" $DBName = "myapp" $DBUser = "postgres" $DBPassword = "postgres" $Env...
Register Scheduled Task on Windows Task Scheduler
Register Scheduled Task $ScriptPath = "$([System.IO.Path]::GetFullPath("$($MyInvocation.MyCommand.Path)\.."))\script" $TaskName = "CleanData" $TaskFolder = "\MyApp" $Trigger = New-ScheduledTaskTr...
The helpful PowerShell Functions and Commands
1. Check Status and Stop the Service function Stop-Service { Param ( [ValidateSet("TCP", "UDP")] $Method, $Port ) $Process = Get-Process -Method $Method -Port $Port ...
Promise allSettled vs Promise all
Promise all Promise.all([ Promise.reject('✗'), Promise.reject('✗'), Promise.resolve('✓'), Promise.reject('✗'), ]).catch((err) => { console.log('You win at life', err); }) ...
Backup & Restore a database
MySQL Docker Backup with mysqldump 👉 Backup the database from the local Docker container: docker exec [mysql_container_id] sh -c 'exec mysqldump -u[user] -p[password] [database_name]' > back...