Shawn-Armstrong

#C_libpq_linking_error.md

• Issue was resolved.
• Solution was performed on Ubuntu 20.04 using WSL2 for Windows10.
• Compilation command needed a path to libpq resources for linking.
  • The default path to this directory is typically /usr/include/postgresql.

Test file

Shawn-Armstrong

#C libpq essentials

Overview

• libpq is a C library that enables a programmer to connect with a PostgreSQL database to send queries and access related results.
• C code compiled with gcc (Ubuntu 11.3.0-1ubuntu1~22.04) 11.3.0
• Database instance running PostgreSQL 14.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit
• Test was performed on Ubuntu 20.04 using WSL2 for Windows10.
• Your credentials need to be added for the test file to produce the output section.

Shawn-Armstrong

#PostgreSQL cursor setting multiple variables

Overview

• The following document demonstrates how to use a cursor within a PostgreSQL function to set multiple variable in a single fetch statement.
• Test code was executed using the online platform DB Fiddle with a PostgreSQL 14 instance.
  • Live demo

Test File / Usage

Shawn-Armstrong

#Ubuntu_Guest_Additions_Install.md

Overview

• The following document provides instructions for installing guest additions on Ubuntu.
• This installation was performed on 12/15/2022 running Ubuntu 20.04 as a guest machine using VirtualBox 6.1 on Windows10.

Insturctions

1. Open a commandline on Ubuntu and execute the following commands:

Shawn-Armstrong

#Ubuntu_nodejs_install.md

Overview

• The following document provides instructions on installing the most current Node.js long-term-support (LTS) version.
• This installation was performed on 12/15/2022 which installed Node.js LTS version 18.12.1 for Ubuntu 20.04.

Instructions

1. The most current LTS version can be identified on the official Node.js homepage.

Shawn-Armstrong

#Reactjs_general_notes.md

Overview / Supplementary notes

• This document contains notes that I've identified to be critical points within Maximillian's React.js course.
• The notes are organized numerically by module.
• Course resources can be referenced in the official repository.
  • Each module has it's own branch; access it with the following :

Shawn-Armstrong

#Markdown_collapsible _codeblock.md

Overview

• Document demonstrates how to use GitHub's markdown syntax to make a collapsible codeblock.

Usage

* Concept 1

Shawn-Armstrong

#GitGub_mermaid.md

Overview

• This document provides critical notes for useful Mermaid functionality within GitHub's markdown Syntax.
• Daigrams are only visible after publishing the file; they cannot be viewed using the preview changes option.

Example 1

Shawn-Armstrong

#Distributed_systems_lamport_summary.md

Overview

• The following file gives a summary and notes organized by section based on Leslie Lamport's paper related to distributed systems.
• Document: Time, Clocks and the Ordering of Events in a Distributed System
• Supplemental document 1
  • Provides more details related to necessary math prerequisites in context to logical clocks.
• Supplemental video 1

Shawn-Armstrong

#The_Art_of_Multiprocessor_Programming_appendix_b_notes.md

Overview

• This file contains notes related to The Art of Multiprocessor Programming, Appendix B organized by section.
• Appendix B covers prerequisite knowledge related to systems such as processors, threads, memory and communication abstractions as well as concurrency concerns.

Introduction (and a Puzzle)

• Programming a multiprocessor requires knowledge about the computer's architecture.