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

	############################################################################
	# #
	# ------- 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)

	import TTLCache from "@isaacs/ttlcache"
	import axios from "axios"

	const domainsCache = new TTLCache({
	ttl: 1000 * 60 * 60 * 24, // cache for 24h
	})

	const lists = [
	"https://raw.githubusercontent.com/wesbos/burner-email-providers/master/emails.txt", // submiting my findings here
	"https://raw.githubusercontent.com/Igloczek/burner-email-providers/master/emails.txt", // adding my fork, as sometime PRs are stuck unmerged