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

attacus

This guide is unmaintained and was created for a specific workshop in 2017. It remains as a legacy reference. Use at your own risk.

Running your own encrypted chat service with Matrix and Riot

Workshop Instructor:

• Lilly Ryan @attacus_au

This workshop is distributed under a CC BY-SA 4.0 license.

What are we doing here?

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

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

jbaranski

Here are the steps needed to run a self hosted Open Street Map server (using Docker):

1. Download desired pbf files (like south-carolina-latest.osm.pbf) from https://download.geofabrik.de or just use the following empty planet below:

   
     <?xml version='1.0' encoding='UTF-8'?>
     <osm version="0.6" generator="osmconvert 0.8.8" timestamp="2019-10-23T20:18:02Z">
       <bounds minlat="42.4276" minlon="1.412368" maxlat="42.65717" maxlon="1.787481"/>
     </osm>
   

REDVM

import requests
import os
from collections import defaultdict

# I have photos in subfolders like : 
# /mnt/media/Photos/2023-08 Holidays
# /mnt/media/Photos/2023-06 Birthday
# /mnt/media/Photos/2022-12 Christmas
# This script will create 3 albums
# 2023-08 Holidays, 2023-06 Birthday, 2022-12 Christmas

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!

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`