Marco Fattorel fatto

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)

#Compilng You need g++ 4.9 to compile this code. Follow these steps to install g++-4.9

After installing run the following command to compile

/usr/bin/g++-4.9 -std=c++11 lambda.cpp

#Running

./a.out

Tutorial 0

What is Vulkan

Vulkan is a low-overhead, cross-platform 3D graphics and compute API.

Vulkan targets

Vulkan targets high-performance realtime 3D graphics applications such as games and interactive media across multiple platforms providing higher performance and lower CPU usage.

GPU Optimization for GameDev

Graphics Pipeline / GPU Architecture Overview

2011 - A trip through the Graphics Pipeline 2011
2015 - Life of a triangle - NVIDIA's logical pipeline
2015 - Render Hell 2.0
2016 - How bad are small triangles on GPU and why?
2017 - GPU Performance for Game Artists
2019 - Understanding the anatomy of GPUs using Pokémon
2020 - GPU ARCHITECTURE RESOURCES

	// ImGui - standalone example application for Glfw + OpenGL 3, using programmable pipeline

	#include <imgui.h>
	#include "imgui_impl_glfw_gl3.h"
	#include <stdio.h>
	#include <GL/gl3w.h>
	#include <GLFW/glfw3.h>
	#include <math.h>
	#include <string.h>
	#include <vector>

	import Cocoa

	class AppDelegate: NSObject, NSApplicationDelegate {

	let app: NSApplication
	let controller: NSWindowController

	init(app: NSApplication) {
	self.app = app
	self.controller = NiblessWindowController()

	const glslify = require('glslify');
	const path = require('path');
	const assign = require('object-assign');
	const defined = require('defined');

	// This is the original source, we will copy + paste it for our own GLSL
	// const vertexShader = THREE.ShaderChunk.meshphysical_vert;
	// const fragmentShader = THREE.ShaderChunk.meshphysical_frag;

	// Our custom shaders

	// Despite appearances to the contrary, this does proper error handling. Any error cascades into a failure of the wglGetProcAddress.
	int init_opengl() {
	HWND window = CreateWindowA("edit", "", WS_OVERLAPPEDWINDOW, 0, 0, 0, 0, NULL, NULL, NULL, NULL);

	PIXELFORMATDESCRIPTOR format_desc = {
	.nSize = sizeof(PIXELFORMATDESCRIPTOR),
	.nVersion = 1,
	.dwFlags = PFD_DRAW_TO_WINDOW \| PFD_SUPPORT_OPENGL
	};


	# forays into
	Perfect Spatial Hashing (Lefebvre & Hoppe)
	http://hhoppe.com/perfecthash.pdf

	how it works:

	There are two parts: a slow encoding step, and a fast decoding step.

	Encoding