dungdm93

format = """
$username\
$hostname\
$directory\
$git_branch\
$git_commit\
$git_status\
$git_state\
$kubernetes\
$golang\

dungdm93

kafkacat -b bootstrap.kafka.host:9092 \
  -C -t topic \
  -s avro -r http://schema-registry.host:8081 \
  -f '
  Key (%K bytes): %k
  Value (%S bytes): %s
  Timestamp: %T
  Partition: %p
 Offset: %o

dungdm93

tar

# extract
tar -xvf archive.tar

# List files in archive.tar
tar -tvf archive.tar

# compress
tar -cvf archive.tar foo bar

dungdm93

-- Show all databases
SELECT
	database_id,
	name,
	create_date
FROM sys.databases;
--or using Stored Procedure  
EXEC sp_databases;

-- Switch database

dungdm93

PostgreSQL

Monitoring Progress of Index Construction

PostgreSQL 12+

SELECT 
  now()::TIME(0), 
  a.query, 
  p.phase, 
  p.blocks_total, 
  p.blocks_done, 

dungdm93

plugins {
  id "com.dorongold.task-tree" version "1.5"
}

task resolveDependencies {
    setDescription "Resolves all projects dependencies from the repository."
    setGroup "Build Server"

 doLast {

dungdm93

Canonical regex

/^
(?'MAJOR'
    0|(?:[1-9]\d*)
)
\.
(?'MINOR'
 0|(?:[1-9]\d*)

dungdm93

count=1
while true; do
    echo $((count++));
    kubectl get pod -A > /dev/null;
    sleep 1;
done;

dungdm93

Django Staticfiles

Django staticfiles is the most common problem you need to solve before putting your app on the production. In this tutorial, I and you will walk through the solution options, included.

• runserver: Only in development environment.
• gunicorn: Use gunicorn as your app server.
• nginx: Put nginx web server in a front of your app server (gunicorn).
• whitenoise: Let your django app self-serve static files.

dungdm93

#!/bin/bash

##### Color table #####
# Black        0;30     Dark Gray     1;30
# Red          0;31     Light Red     1;31
# Green        0;32     Light Green   1;32
# Brown/Orange 0;33     Yellow        1;33
# Blue         0;34     Light Blue    1;34
# Purple       0;35     Light Purple  1;35
# Cyan         0;36     Light Cyan    1;36