josepereza

Docker Cheat Sheet — Containerization Platform

Complete Docker reference — images, containers, volumes, networks, Compose, Dockerfile, and multi-stage builds.

Images

docker images                        # List images
docker pull nginx:latest             # Pull image
docker build -t myapp:1.0 .         # Build from Dockerfile

SQL Window Functions Examples

This gist provides practical examples of SQL window functions to enhance your data analysis skills. Through these examples, you'll learn how to use various window functions to perform complex calculations like ranking, running totals, moving averages, and more.

1. Assign Row Numbers

SELECT id, salesperson, amount,
       ROW_NUMBER() OVER(ORDER BY amount DESC) AS row_num
FROM sales;

Administración básica de PostgreSQL

Revisión 2021

Indice

Tema 01: Instalación y configuración de PostgreSQL

Postgres SQL query cheat sheet

Hope to enjoy!

SELECT
WHERE
CRUD
Change Configuration
Aggregation & Grouping
Pattern matching

title: Infinite Virtual Scroll with the Angular CDK lastmod: 2018-10-21T18:16:07-07:00 publishdate: 2018-10-21T18:16:07-07:00 author: Jeff Delaney draft: false description: Build an Infinite Virtual Scroll with the Angular CDK tags: - angular

animation

How to use Materialize CSS in Angular 7-8-9

Install the materialize-css node package in your application.

npm install materialize-css --save

Open angular.json file & add below styles & scripts.

  "styles": [
         "./node_modules/materialize-css/dist/css/materialize.css",

Routing ports for lxc containers

Reference: Forward port to LXC guest using UFW, answer by Steve Zahn. March 17, 2014.

The lxd service can be used to manage lxc system containers on Linux hosts, very much like Docker does for application containers. One Docker feature that LXD lacks is a native parameter for routing container ports so they can be accessed on the network beyond the lxd host. Routing using the iptables command

On an lxd host protected by the standard iptables kernel firewall, the following command will route external traffic to a specific port of a specific container:

$ sudo iptables -t nat -A PREROUTING -i ens3 -p tcp --dport 8080 -j DNAT --to 10.1.0.5:80

*Primero se instala:

npm install materialize-css.

En el archivo index.html

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">

	const fetch = require('node-fetch')

	/**********************************************************************************
	OPCION TRADICIONAL
	**********************************************************************************/
	function getNombre(username){
	const url = `https://api.github.com/users/${username}`
	fetch(url)
	.then( res => res.json() )
	.then( json => { console.log(json.name) })

	==========================================================================================
	========== GIT – Guía rápida ==========
	==========================================================================================





	------------------------------------------------------------------------------------------
	------------------------------------------------------------------------------------------