maqnouch

⚠️ Obsolete guide

Please check the new Guide

Signal Server Installation Guide

Author: Aqnouch Mohammed aqnouch.mohammed@gmail.com

rgreenjr

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

heroheman

Ranger Cheatsheet

General

Shortcut	Description
ranger	Start Ranger
Q	Quit Ranger
R	Reload current directory
?	Ranger Manpages / Shortcuts

lukechilds

get_latest_release() {
  curl --silent "https://api.github.com/repos/$1/releases/latest" | # Get latest release from GitHub api
    grep '"tag_name":' |                                            # Get tag line
    sed -E 's/.*"([^"]+)".*/\1/'                                    # Pluck JSON value
}

# Usage
# $ get_latest_release "creationix/nvm"
# v0.31.4

nekiee13

CMD prompt - verify WSL2 is installed

`wsl --list --verbose`     
or   
`wsl -l -v`

git clone CUDA samples - I used location at disk d:\\LLM\\Ollama , so I can find samples with ease

`d: && cd d:\LLM\Ollama`
`git clone --recursive -j6 https://github.com/NVIDIA/cuda-samples.git`

navarrothiago

Turn your smartphone or tablet (e.g., Iphone, Ipad, Samsung, Motorola, etc) camera into a WebCam to make video conference (e.g., Google Meeting, Zoom, Discord, etc) in Linux.

Setup - IPCamera App + OBS

Install an app IP camera in your smarthphone

Examples:

• Apple store https://apps.apple.com/us/app/ipcamera-high-end-networkcam/id570912928
• Google play https://play.google.com/store/apps/details?id=com.pas.webcam&hl=en

plembo

You need spice-vdagent

Debian or Kali Linux installed to as KVM (libvirtd) guests do not automatically have qemu-guest-agent or spice-vdagent installed. This will prevent seamless movement of the mouse cursor between the guest and host desktop in Virtual Machine Manager (requiring the use of a Ctrl-Alt to release the cursor from the guest window).

To cure this, install both qemu-guest-agent and spice-vdagent on each guest and reboot (the guests).

$ sudo apt install qemu-guest-agent
$ sudo apt install spice-vdagent

ClemRz

How to download the KML from an AllTrails page without PRO account

1. Open a trail page in your favourite browser, for instance: https://www.alltrails.com/explore/trail/us/arizona/south-kaibab-to-phantom-ranch-to-bright-angel-trail
2. Open the developper console
3. copy and paste the script below (script.js)
4. execute it, you should see a KML file being downloaded

The last file below is for advanced users.

Enjoy!

huyng

#!/usr/bin/env python
# Reflects the requests from HTTP methods GET, POST, PUT, and DELETE
# Written by Nathan Hamiel (2010)

from BaseHTTPServer import HTTPServer, BaseHTTPRequestHandler
from optparse import OptionParser

class RequestHandler(BaseHTTPRequestHandler):
    
    def do_GET(self):

nrk

ffprobe -v quiet -print_format json -show_format -show_streams "lolwut.mp4" > "lolwut.mp4.json"