josepereza

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

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",

	-- ==========================================
	-- 1. CREACIÓN DE TABLAS
	-- ==========================================

	CREATE TABLE clientes (
	id SERIAL PRIMARY KEY,
	nombre VARCHAR(100),
	email VARCHAR(100),
	telefono VARCHAR(20),
	fecha_registro TIMESTAMP DEFAULT CURRENT_TIMESTAMP

	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 ==========
	==========================================================================================





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