valmayaki

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

valmayaki

add forwarding interface:
netsh interface portproxy add v4tov4 listenport={srcPort} listenaddress={srcIp} connectport={DesPort} connectaddress={DesIp}

show interface:
netsh interface portproxy show v4tov4 

delete interface:
netsh interface portproxy delete v4tov4 listenport={srcPort} listenaddress={srcIp}

----------------------------- 

valmayaki

Modern PHP Tooling

This is my personal collection of modern PHP Tooling that I setup for all of my Laravel projects.

Linting

1. Pint - Formatting

• Install Laravel Pint
• Setup strict config pint.json
• Setup PHPStorm File Watcher for Pint

2. PeckPHP - Fix Typos

• Install PeckPHP

valmayaki

[[+Home]] %% tags:: #MOC %% 

# Meetings MOC
Meetings are timestamped events with other people, where information is exchanged and collected. Meeting notes are intrinsically ephemeral. They're stored in a separate Space than other Umami notes (`Timestamps/Meetings`) and rarely reviewed. If there's information in a meeting that needs to be accessed later, it should be moved into a more evergreen note in the Umami folder. 

**Template:** [[Template, Meeting]]

```meta-bind-button
label: New Meeting
hidden: false

valmayaki

---
created: <% tp.file.creation_date() %>
---
tags:: [[+Daily Notes]]

# <% moment(tp.file.title,'YYYY-MM-DD').format("dddd, MMMM DD, YYYY") %>

<< [[Timestamps/<% tp.date.now("YYYY", -1) %>/<% tp.date.now("MM-MMMM", -1) %>/<% tp.date.now("YYYY-MM-DD-dddd", -1) %>|Yesterday]] | [[Timestamps/<% tp.date.now("YYYY", 1) %>/<% tp.date.now("MM-MMMM", 1) %>/<% tp.date.now("YYYY-MM-DD-dddd", 1) %>|Tomorrow]] >>

---

valmayaki

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

valmayaki

#!/bin/bash

# Assume the role using locally configured AWS credentials, then pass the assumed role to the container via environment 
# variables!

ASSUMED_ROLE=$(aws sts assume-role \
        --role-arn "arn:aws:iam::000000000000:role/our-role-to-assume" \
        --role-session-name "session_name" \
        --output text)

valmayaki

People

:bowtie:	😄 :smile:	😆 :laughing:
😊 :blush:	😃 :smiley:	☺️ :relaxed:
😏 :smirk:	😍 :heart_eyes:	😘 :kissing_heart:
😚 :kissing_closed_eyes:	😳 :flushed:	😌 :relieved:
😆 :satisfied:	😁 :grin:	😉 :wink:
😜 :stuck_out_tongue_winking_eye:	😝 :stuck_out_tongue_closed_eyes:	😀 :grinning:
😗 :kissing:	😙 :kissing_smiling_eyes:	😛 :stuck_out_tongue:

valmayaki

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

valmayaki

  {
      "description": "Maps button 5 and 4 as modifiers for button 1 and 2 to switch spaces and desktops",
      "manipulators": [
        {
          "type": "basic",
          "from": {
            "pointing_button": "button4",
            "modifiers": {
              "mandatory": [],
              "optional": [