bartdorsey

PostgreSQL Foreign Keys - Quick Reference

1. Basic Foreign Key (Most Common)

CREATE TABLE orders (
    id SERIAL PRIMARY KEY,
    customer_id INTEGER REFERENCES customers(id)
);

bartdorsey

Git Conflict Resolution Guide for Python/FastAPI & Vite Projects

Introduction

Git conflicts occur when multiple developers make changes to the same parts of a file, and Git cannot automatically determine which changes to keep. This guide will help you understand and resolve common conflict scenarios in your Python/FastAPI backend and Vite frontend projects.

Understanding Git Conflicts

What Causes Conflicts?

• Two or more developers modify the same line(s) in a file

bartdorsey

FastAPI architecture

Simple GET /items request without a database

sequenceDiagram
    participant User as 🧑 User
    participant Frontend as 🌐 Frontend (Vanilla JS)
    participant Backend as ⚙️ FastAPI Backend
    participant Memory as 🧠 In-memory List

bartdorsey

How to Debug Code

Okay so your code has a problem. Here's a general guide on steps you should take.

Run the code and reproduce the problem

This should be obvious but you need to be running your code to debug it.

Look at any logs or output for error messages

bartdorsey

Common React Pitfalls

This is a document which tries to collect common Pitfalls that developers fall into when learning React for the first time.

Can't call <<method>> on <<undefined>>

This is usually caused by misunderstanding the component lifecycle. Components in React render synchronously, which means that the first time a component renders it will often have no data, or empty data.

Example:

bartdorsey

WSL Quick Dev Setup

Make sure virtualization is enabled:

1. Open Task Manager
2. Performance Tab
3. Select CPU
4. Check for "Virtualization Enabled"

If virtualization is not enabled

bartdorsey

Excellent Code Wars for Beginners

Logic/Control Flow/Loops

• Rock Paper Scissors
• Flick Switch
• Well of Ideas (Easy Version)

Arrays/Lists

• Merge two sorted arrays into one

bartdorsey

VSCode to Neovim Rosetta Stone

bartdorsey

Neovim LSP Glossary

When setting up Language Server Protocol on Neovim, what plugins do what can be pretty confusing. So this table is a list of the most common plugins people use and what they are and why they are.

Plugin	Role	Why?
lspconfig	Configuring the language servers	You can use neovim's built in vim.lsp.start() function, but often we don't know all the command line arguments and options needed to pass to that function, so lspconfig is really just a database of a bunch of configurations for lsps
mason	Installing language servers	Mason will automatically download and install the actual language server programs. This is optional because if you install an LSP server in your $PATH manually you don't necessarily need this
mason-lspconfig	Automatically setting up lsps when you install them	This glues lspconfig and mason together, So when an lsp is configured the setup function for it will be automatically called, not necessary if you want to manage your LSPs manually

bartdorsey

Neovim must have plugins

This is my curated list of the neovim plugins I can't live without

Note: if you are just starting out, check out kickstart.nvim

• Lazy.nvim - The plugin manager I use. Not to be confused with LazyVim the neovim distribution.
• lspconfig - The must have plugin for configuring LSP support in neovim.
• nvim-cmp - Completion engine for neovim. Without this you won't get autocomplete for anything
• oil.nvim - A magical plugin which lets you browse and edit your files and folders like they are in an editor buffer