Bart Dorsey bartdorsey

PostgreSQL Tips and Tricks

Checking to see if PostgreSQL is running:

Running these commands should tell you if postgres is running or not.

Ubuntu Linux:

sudo service postgresql status

Make Tree

This problem was inspired by a Fun Fun Function video: https://www.youtube.com/watch?v=k7-N8R0-KY4

Write a recursive function makeTree(categories, parent) that takes an array of categories objects, each of which have an id property, and a parent property and returns a nested tree of those objects using the parent properties to construct the tree.

Keybase proof

I hereby claim:

I am bartdorsey on github.
I am bartdorsey (https://keybase.io/bartdorsey) on keybase.
I have a public key ASCEQoTmhwrzLjydn4UXu76n0dmQDT3j5-K_6B8fgwx_Awo

To claim this, I am signing this object:

VSCode Extentions I find to be valuable for JavaScript development

Back and Forth
- Adds backwards and forwards buttons to the toolbar in VSCode
- https://marketplace.visualstudio.com/items?itemName=nick-rudenko.back-n-forth
Bracket Pair Colorizer 2
- Colors matching brackets so it's easier to tell which brackets match.
- https://marketplace.visualstudio.com/items?itemName=CoenraadS.bracket-pair-colorizer-2
Babel Javascript
A better syntax highlighter for JavaScript code

	upstream app_servers {
	server app:4000;
	}

	server {
	listen 80;

	location / {
	proxy_pass http://app:4000/;
	}

	version: '3'
	services:
	nginx-proxy:
	image: 'jc21/nginx-proxy-manager:latest'
	restart: unless-stopped
	ports:
	- '80:80'
	- '81:81'
	- '443:443'
	volumes:

	import { useEffect } from 'react';

	export default function useAsyncEffect(callback, dependencies) {
	useEffect(() => {
	(async() => {
	return await callback();
	})();
	}, dependencies);
	}

	Write-Host @'
	=============================
	< Windows Subsystem for Linux >
	< (Ubuntu >= 20.04) installer >
	=============================
	\
	\
	.--.
	\|o_o \|
	\|:_/ \|

	AWSTemplateFormatVersion: 2010-09-09
	Description: EC2 based SSH dev environment for VSCode Remote SSH
	Parameters:
	Key:
	Type: String
	Description: The name of your amazon EC2 security key
	Resources:
	DevEnvironmentSubnet:
	Type: 'AWS::EC2::Subnet'
	Properties: