| sudo systemctl stop postgresql | Stop PostgreSQL service | Linux |
| brew services stop postgresql | Stop PostgreSQL on macOS using Homebrew | macOS |
| net stop postgresql | Stop PostgreSQL on Windows | Windows |
| python -m venv venv | Create a virtual environment using venv | All |
| source myvenv/bin/activate | Activate virtual environment on Linux/macOS | Linux |
| venv\Scripts\activate.bat | Activate virtual environment in cmd.exe on Windows | Windows |
| venv\Scripts\Activate.ps1 | Activate virtual environment in PowerShell on Windows | Windows |
| pip install -r requirements.txt | Install dependencies from requirements.txt | All |
| alembic revision --autogenerate -m "Add users table" | Generates a new migration file based on detected model changes. [2025-04] | Linux/macOS/Windows |
| alembic upgrade head | Applies all pending migrations to the database. [2025-04] | Linux/macOS/Windows |
| export FLASK_APP=app.main && export FLASK_ENV=development | Sets Flask environment variables for development mode. Use `set` instead of `export` on Windows. [2025-04] | Linux/macOS |
| flask run | Runs Flask’s built-in dev server. Assumes env variables are set. [2025-04] | Linux/macOS/Windows |
| cd backend && uvicorn app.main:app --reload | Runs FastAPI app using Uvicorn with live reload. Ensure `cd` to backend directory. [2025-04] | Linux/macOS/Windows |
| npm create vite@latest my-app | Scaffolds a new React project with Vite. Choose `react` or `react-ts` when prompted. [2025-04] | Linux/macOS/Windows |
| cd my-app && npm install | Installs project dependencies for the newly created Vite app. [2025-04] | Linux/macOS/Windows |
| npm run dev | Starts the development server for a Vite-based React app. [2025-04] | Linux/macOS/Windows |
| npm start | esp for Docusaurus, but also Starts the development server for a React app created with Create React App. (for docusaurus - do cd to docs first) [2025-04] | Linux/macOS/Windows |
| ollama | shows the list of avialable commands [2025-04] | Linux/macOS/Windows |
| ollama run <model_name> | runs the model [2025-04] | Linux/macOS/Windows |
| uvicorn file_name:fastapi_app_name --reload | Starts a FastAPI server with hot reloading. [2025-04] | Linux/macOS/Windows |
| export API_KEY=your_api_key | Sets an environment variable for API key on macOS/ Linux. Has to be in the same terminal session. [2025-04] | Linux/macOS |
| npm install | installs all the dependencies on your machine. esp use it when you have a new project or cloned project. [2025-07] | Linux/macOS/Windows |
| npx @google/gemini-cli | starts up gemini cli | Linux |
| git pull origin main | get the latest content from the main branch | all |
| lsof -i :5000 | get what program is using the given port | linux |
| kill -9 0000 | kill a program with their pid. you can get pid from the lsof command | linux |
| npx drizzle-kit generate --name filename | generate sql migrations file based on schema. drizzle ORM, typescript. optional, you can add name | all |
| npx drizzle-kit migrate | apply the generated changes from the sql file | all |