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

Canonical regex

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

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

alias ..='cd ..'

if [[ ! "$PATH" =~ (^|:)"$HOME/.local/bin"(:|$) ]]; then
    export PATH="$HOME/.local/bin:$PATH"
fi

export SDKMAN_DIR="$HOME/.sdkman"
[[ -s "$SDKMAN_DIR/bin/sdkman-init.sh" ]] && source "$SDKMAN_DIR/bin/sdkman-init.sh"

export NVM_DIR="$HOME/.nvm"

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

dungdm93

import jinja2

loader = jinja2.FileSystemLoader(searchpath="./")
env    = jinja2.Environment(loader=loader)

TEMPLATE_FILE = "template.j2"
template = env.get_template(TEMPLATE_FILE)

output = template.render()
print(f"[{output}]")

dungdm93

Arrays.stream(TimeZone.getAvailableIDs()).forEach(id -> {
  boolean flag = false;
  try {
    ZoneId.of(id);
    flag = true;
  } catch (Exception e) {
    //ignore;
  }
  if (!flag)
    System.out.printf("[%s] %s%n", flag ? "x" : " ", id);

dungdm93

<web-fragment version="3.0"
              xmlns="http://java.sun.com/xml/ns/javaee"
              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
              xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-fragment_3_0.xsd">
</web-fragment>