Discover gists

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)

Install PostgreSQL on Manjaro

Source: https://wiki.archlinux.org/index.php/PostgreSQL

Install postgresql package sudo pacman -S postgresql
Switch to the postgres user account and initialize the database cluster:

sudo -iu postgres

How to use clangd C/C++ LSP in any project

tl;dr: If you want to just know the method, skip to How to section

Clangd is a state-of-the-art C/C++ LSP that can be used in every popular text editors like Neovim, Emacs or VS Code. Even CLion uses clangd under the hood. Unfortunately, clangd requires compile_commands.json to work, and the only way to painlessly generate it is to use CMake.

But what if I tell you you can quickly hack your way around that, and generate compile_commands.json for any project, no matter how compilcated? I have used that way at work for years, originaly because I used CLion which supported only CMake projects - but now I use that method succesfully with clangd and Neovim.

Method summary

Basically what we need to achieve is to create a CMake file that will generate a compile_commands.json file with information about:

Prerequisite

sudo apt update
sudo apt install software-properties-common -y

	;;; -- tab-width: 2 --

	;;; These four lines go at the beginning of almost every code file. 16-byte iNES header

	.inesprg 1 ; one bank of program code
	.ineschr 1 ; one bank of picture data
	.inesmap 0 ; we use mapper 0
	.inesmir 1 ; Mirror setting always 1

	;;; BANKING

	############################################################################
	# #
	# ------- Useful Docker Aliases -------- #
	# #
	# # Installation : #
	# copy/paste these lines into your .bashrc or .zshrc file or just #
	# type the following in your current shell to try it out: #
	# wget -O - https://gist.githubusercontent.com/jgrodziski/9ed4a17709baad10dbcd4530b60dfcbb/raw/d84ef1741c59e7ab07fb055a70df1830584c6c18/docker-aliases.sh \| bash
	# #
	# # Usage: #

	import { zodResolver } from "@hookform/resolvers/zod";
	import * as z from "zod";
	import { Form, FormControl, FormField, FormItem, FormLabel, FormMessage } from '@/components/ui/form'; //shadcn ui folder
	const MAX_FILE_SIZE = 1024 * 1024 * 5;
	const ACCEPTED_IMAGE_MIME_TYPES = [
	"image/jpeg",
	"image/jpg",
	"image/png",
	"image/webp",
	];

	<!DOCTYPE html>
	<html>

	<head>
	<meta charset="utf-8">
	<title>High Resolution Canopy Height</title>
	<meta name="viewport" content="initial-scale=1,maximum-scale=1,user-scalable=no">
	<link href="https://api.mapbox.com/mapbox-gl-js/v3.2.0/mapbox-gl.css" rel="stylesheet">
	<script src="https://api.mapbox.com/mapbox-gl-js/v3.2.0/mapbox-gl.js"></script>
	<style>

	#!/usr/bin/env bash

	# Abort sign off on any error
	set -e

	# Start the benchmark timer
	SECONDS=0

	# Repository introspection
	OWNER=$(gh repo view --json owner --jq .owner.login)