Vicente Russo vicenterusso

USER

You are a professional note taker with background experience as a professional book writer and editor. Because of this, all of the notes you take have exceptional grammar and spelling and are very high quality.

I will provide you with text to take notes on, and you will follow the below list of requirements exactly as they are listed before providing a response, checking at every step to ensure that all requirements and suggestions within the following list are met and upheld for each line of notes that you write.

All of your output will be in a Markdown code block You will extract the most important information from the provided text, including but not limited to: Content that could appear in a quiz. Context that provides background information. Examples related to the context or information being presented.

To be honest, I use grep, awk, cut, sort, uniq and 'ccze -a' to colorize output from the commandline way more than anything else. It's worth learning them and key options - it will pay off many orders of magnitude.

A few quick commandline examples:

case insensitive match 'error' in nginx access.log and colorize output

grep -i error /var/log/nginx/access.log |ccze -A

how many 404 errors today?

Learning Plan for Test Driven Development (TDD)

These learning resources primarily focus on Test Driven Development (TDD).

There is an emphasis on learning using PHP, Laravel and PHPUnit.
All these resources are free (at the time of writing)

PostgreSQL: Find slow, long-running, and Blocked Queries

For active queries, PostgreSQL has a "statistics collector" subsystem that collates data on table, server, query, index, and connection activity. The database exposes information through a number of "pg_stat" predefined views and some lower-level statistic functions for power users.

Additionally, there are several system information functions that can extract session and system information on processes and queries that are currently ongoing.

The key tables and functions that I've found useful are:

pg_stat_activity: A table with one entry per server process, showing details of the running query for each.

Run the command to install

docker run -it \
    --device /dev/kvm \
    -dns=8.8.8.8 \
    -p 50922:10022 \
    -v /tmp/.X11-unix:/tmp/.X11-unix \
    -e "DISPLAY=${DISPLAY:-:0.0}" \
    -e GENERATE_UNIQUE=true \

	+-------+-------------------------+------------+------+------------------------------------------------------------------------------------------------------------+------+
	\|id \|time \|request_time\|method\|request \|status\|
	+-------+-------------------------+------------+------+------------------------------------------------------------------------------------------------------------+------+
	\|1375611\|2023-03-21 04:47:53+00:00\|3.252 \|POST \|POST /v1/pedidos/create-array HTTP/1.1 \|201 \|
	\|1378387\|2023-03-21 05:07:27+00:00\|2.142 \|POST \|POST /v1/pedidos/create-array HTTP/1.1 \|201 \|
	\|1379081\|2023-03-21 05:12:11+00:00\|2.052 \|POST \|POST /v1/pedidos/create-array HTTP/1.1 \|

	version: '3'
	services:
	mysqldb:
	image: mysql:5.7.22
	container_name: mysql_container_name
	restart: always
	ulimits:
	nproc: 65535
	nofile:
	soft: 20000

	class SingletonDefaultExportInstance {
	constructor() {
	this._type = 'SingletonDefaultExportInstance';
	}

	singletonMethod() {
	return 'singletonMethod';
	}

	static staticMethod() {

	Change the following flags in Advanced Tab:

	useSSL = false
	allowPublicKeyRetrieval = true

	FROM php:7.2-fpm
	COPY app /var/www/
	EXPOSE 9000