rvrsh3ll

NOTE

These are NOT product / license keys that are valid for Windows activation.
These keys only select the edition of Windows to install during setup, but they do not activate or license the installation.

Index

• Windows 11
• RTM Generic Keys

poacosta

-- The below query is used to fetch all the role names from the 'pg_roles' system catalog table.
-- It will return a list of all user (role) names in the current PostgreSQL database.
SELECT rolname FROM pg_roles;

-- This command is used to create a new PostgreSQL user with the specified username and password.
-- In this case, the newly created username is 'username' and the password is 'P@55w0rd'.
CREATE USER username WITH PASSWORD 'P@55w0rd';

-- This command grants all privileges to the user 'username' on the database 'dbname'.
-- These privileges include SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, EXECUTE, and USAGE

BalazsGyarmati

//
//  main.swift
//  scroll_to_plusminus
//
//  Created by uniqueidentifier on 2021-01-08.
//  Modified by alex on 2022-07-08 to use modifiers for scrolling
//  Modified by BalazsGyarmati on 2023-01-04 to use command instead of control + respect any keyboard layout for + and -
//

import Foundation

JohnAtl

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<array>
	<dict>
		<key>Activate</key>
		<string>Normal</string>
		<key>CreationDate</key>
		<real>658773622.62719798</real>
		<key>Macros</key>

megahirt

Debugging PHP with XDebug v3 inside Docker using VSCode

Assumptions / Prerequisites

• XDebug v3+ inside Docker (e.g. php:7.3-apache Docker image)
• Running Docker v20.10+
• VSCode with PHP Debug Extension (Felix Becker)
• Using Docker Compose for orchestration

Objective

ivastly

# dumps must be in ./xhprof folder, named like uniqid() . 'appname.xhprof';
# use tideways_xhprof extension to generate them https://github.com/tideways/php-xhprof-extension
docker run --rm -p 81:8080 -v $(pwd)/xhprof:/mnt/files/private/xhprof -d --name xhprof wodby/xhprof

szepeviktor

Download Wistia videos

1. right-click on the playing video, select Copy link
2. find Wistia video ID in the copied link e.g. wvideo=tra6gsm6rl
   • alternative: look for e.g. hashedId=tra6gsm6rl in the page source
3. load http://fast.wistia.net/embed/iframe/ + video ID in your browser
4. look for "type":"original" in the page source and copy the URL from the next line e.g. "url":"http://embed.wistia.com/deliveries/129720d1762175bcd8e06dcab926ec76ad38ff00.bin"

• alternative: look for "type":"hd_mp4_video"

ryanflorence

Everything I Know About UI Routing

Definitions

1. Location - The location of the application. Usually just a URL, but the location can contain multiple pieces of information that can be used by an app
   1. pathname - The "file/directory" portion of the URL, like invoices/123
   2. search - The stuff after ? in a URL like /assignments?showGrades=1.
   3. query - A parsed version of search, usually an object but not a standard browser feature.
   4. hash - The # portion of the URL. This is not available to servers in request.url so its client only. By default it means which part of the page the user should be scrolled to, but developers use it for various things.
   5. state - Object associated with a location. Think of it like a hidden URL query. It's state you want to keep with a specific location, but you don't want it to be visible in the URL.

jeanlucaslima

Remote Jobs general guideline

This is something I compiled during the last weeks while job hunting. If you miss something in this list, please fork or tell me on twitter and I'll add what's missing.

1. Be careful with jobs that are not clear they hire outside US
2. Look for job in niches (like SaaS job boards, language-specific communities, country-focused, and so on)
3. Avoid Upwork (pay to work, no guaranteed results, often bad contracts) and Remote.com
4. Remote.co is not Remote.com, remote.co is ok.
5. There are companies that hire and act as a guild, but only pay as freelancer (X-team, Gun.io, and so on)
6. Not really focused on freelancing, as it is to me more like a one-person business

bmatcuk

# First, we need to find our device. BEFORE inserting your USB drive, run the
# following:
diskutil list

# This will output a bunch of info about all of the disk drives connected to
# your Mac. Each entry will have a header in the form "/dev/diskX", where X is
# some number starting at 0. Now, insert your USB drive and run the command
# again. You should see a new entry. Make note of the name (ie, /dev/diskX).
diskutil list