For the full experience: 1) Clone the repo 2) Open the docs folder in Obsidian

Fullchee's Notes

ORM

Initializing search

Fullchee's Notes
Untitled 1
Untitled
Glossary
Inner work
Portfolio
Soft skills
Technical
Web dev

Fullchee's Notes

Fullchee's Notes
Untitled 1
Untitled
Glossary
Inner work
Inner work
- 2021 fullchee.com redesign
- How I use Reddit
- Gift Giving
- Running
- A brief history of humankind
- A history of the world since 1300
- Dragon boat career
- Estimating
- How to avoid getting conned
- How to congratulate your team
- How to give feedback
- Making progress
- Negotiating
- Philosophy of death
- What do I do with my life?
- Why I quit Anki
- Learning how to learn
  Learning how to learn
  - Pomodoro
  - Why Foam instead of MDX
Portfolio
Portfolio
Soft skills
Soft skills
- Interviewing
- Leaving a company
- Management
- Mentorship
- Negotiating After Your Start Date
- Planning for your next role
- Forget Velocity, Let's Talk Acceleration • Jessica Kerr • GOTO 2017
- Learned Helplessness
- TTC
- Debugging
  Debugging
  - Asking for Help
Technical
Technical
- Dates
- Excel
- Latex
- Android Tips
- Build vs Runtime vs Dev Environment
- Performance Reviews
- Slack tips
- [UUIDs explained](https://www.sohamkamani.com/uuid-versions-explained/)
- What does Forma Do?
- Assertions
- Why so many programming languages?
- Docs as code
  Docs as code
- Leetcode
  Leetcode
- Terminal
  Terminal
Web dev
Web dev
- Why `msn.com` is the 38th most visited website
- Security
  Security
  - Auth0
  - JSON Web Tokens (JWTs)
  - Security Inbox
  - Authentication
    Authentication
    
    HTTP Basic Authentication
  - Authorization
    Authorization
    
    [Permissions](https://fullchee-reminders.netlify.app/link/1119)
  - Security Fundamentals
    Security Fundamentals
    
    Encryption
    
    Hashing
  - Vulnerabilities
    Vulnerabilities
    
    CSRF
    
    XSS
- Backend
  Backend
  - Heroku
  - Java
  - Linux
  - Why dotfiles?
  - AWS
    AWS
    
    AWS CLI
    
    AWS CloudWatch
    
    AWS S3
    
    AWS Services for an app
  - Architecture
    Architecture
    
    Monitoring
    
    Content Management Systems (CMS)
    
    Feature Toggle
    
    Client Server Communication
    Client Server Communication
    
    3 Tier Architecture
    
    GraphQL
    
    HTTP 2
    
    History of Client Server Communication
    
    gRPC
    
    HTTP status codes
    
    tRPC
  - Containers
    Containers
    
    Container Overview
    
    Docker
  - Database
    Database
    
    Database Design
    Database Design
    
    Database Normalization
    
    Database Partitioning
    
    N + 1 Problem
    
    ORM
    
    Column databases
    
    Database Indexes
    
    Scaling up database writes
    
    Speed up queries
    
    UUID as primary key?
    
    Sql
    Sql
    
    Distinct
    
    Installing PSQL
    
    Materialized view
    
    MySQL
    
    SQL Security
    
    Connecting to PSQL
    
    Django ORM vs raw SQL
    
    Heroku sql
    
    PSQL Shell
    
    `.psqlrc`
    
    PSQL Performance
    PSQL Performance
    
    Database Locks
    
    Indexing
    
    PSQL Debug Slow Queries
    
    PSQL Query Optimization
    
    PSQL Vacuum
    
    How to
    How to
    
    Exporting SQL
    
    Hardcoded SQL
    
    SQL Aggregation
    
    SQL Arrays and JSON
    
    SQL Boolean
    
    SQL
    
    SQL Conditionals and edge cases
    
    SQL Dates
    
    SQL Sum should be zero even if group by returns no rows
    
    SQL Ranges
    
    SQL Relationships
    
    SQL strings
    
    SQL Window functions
  - Node.js
    Node.js
    
    Testing Node.js
  - Python
    Python
    
    Python Formatting
    
    Python Threads
    
    PyCharm
    
    Standard Python
    Standard Python
    
    Debugging Python
    
    Python Generators and Iterators
    
    Python Imports
    
    Python logging
    
    Python
    
    Square bracket notation
    
    Python Virtual Environments
    Python Virtual Environments
    
    Python when to pin version
    
    Python virtual environment tools
    
    Python data structures
    Python data structures
    
    Data Structures
    
    Python Dates
    
    Python Lists
    
    Python Typing
    
    Python objects
    Python objects
    
    [Python decorators](https://realpython.com/primer-on-python-decorators/)
    
    Python Dictionaries
    
    Python Error handling
    
    Custom classes/objects
    
    Python custom classes
    Python custom classes
    
    Python Custom Classes
    
    Python Dunder syntax
    
    Python strings
    Python strings
    
    Regex
    
    Python String Formatting
    
    Python testing
    Python testing
    
    unittest `patch`
    
    `unittest`
    
    Django
    Django
    
    Django Admin
    
    Where to put Django Business Logic
    
    Django Auth app
    
    Django HTTP
    
    Django inbox
    
    Django `manage.py` scripts
    
    Django Signals
    
    Setting up Django
    
    Django database
    Django database
    
    Django Raw SQL Queries
    
    Django Models
    
    [Django Querying](https://docs.djangoproject.com/en/4.1/topics/db/queries/)
    
    Django rest framework
    Django rest framework
    
    [DRF Serializers](https://www.django-rest-framework.org/api-guide/serializers/)
    
    [Swagger (drf-yasg)](https://drf-yasg.readthedocs.io/en/stable/readme.html)
    
    Django testing
    Django testing
    
    Django Factories
    
    Django Testing Endpoints
    
    Testing Django
    
    Faster Django tests in PyCharm
    
    Pandas
    Pandas
    
    Pandas Inbox
    
    Pandas Writing
    
    Plotting Pandas
    
    Why Pandas
    
    Machine Learning
- Frontend
  Frontend
  - Downsides of CSS variables
  - Accessibility (a11y)
  - Base64
  - Mobile
  - Animation
  - Forms
  - Images
  - Browser
    Browser
    
    CORS
    
    Browser Usage Tricks
    
    Parts of a browser
    
    Video
  - HTML
    HTML
    
    HTML Tags
    
    SVG
  - Css
    Css
    
    CSS Color
    
    CSS Refactoring
    
    CSS Selectors
    
    Stacking Contexts
    
    Tailwind CSS
    
    CSS Browser Tricks
    
    Flexbox
    
    Flow Layout
    
    CSS Fundamentals
    
    CSS Grid
    
    Css images
    
    [CSS Inheritance](https://courses.joshwcomeau.com/css-for-js/01-rendering-logic-1/01-built-ins-and-inheritance)
    
    CSS Modal
    
    Positioned Layout
    
    CSS Questions
    
    CSS Transformations
    
    CSS Tricks
    
    CSS Typography
    
    Customize how Firefox looks
    
    [Grid vs Flexbox](https://fullchee-reminders.netlify.app/link/797)
    
    Media Queries
    
    Sass
    
    Styled Components 💅🏾
    
    Box Model
    Box Model
    
    Border
    
    Margin
    
    Box Model
    
    CSS in JS
    CSS in JS
    
    CSS in JS Frameworks
    
    CSS stuff from JS (no frameworks)
  - Design
    Design
    
    Text Copy
    
    Design
  - Javascript
    Javascript
    
    JavaScript Leetcode
    
    Browser JavaScript
    
    JavaScript Frameworks
    
    JavaScript importing
    
    Single Page App
    
    Spot the bug solutions
    
    Spot the bug
    
    [underscore.js](https://underscorejs.org/)
    
    Async
    Async
    
    Intro to Promises
    
    Multi-threaded JavaScript
    
    Non-intro Promise Notes
    
    Javascript language
    Javascript language
    
    JavaScript Arrays
    
    JavaScript Dates
    
    JavaScript Objects
    
    JavaScript
    
    Js tooling
    Js tooling
    
    ESLint and Prettier
    
    Source Maps on Prod
    
    JS Build Tools
    
    [JS Monorepos](https://fullchee-reminders.netlify.app/link/1694)
    
    Js package managers
    
    React
    React
    
    React Accessibility (a11y)
    
    [Error Boundaries](https://reactjs.org/docs/error-boundaries.html)
    
    Implementing React
    
    [JSX in Depth](https://reactjs.org/docs/jsx-in-depth.html)
    
    [PropTypes](https://reactjs.org/docs/typechecking-with-proptypes.html)
    
    [React Context](https://reactjs.org/docs/context.html)
    
    React hooks
    
    React Performance ⚡
    
    Refactoring React
    
    React libraries
    React libraries
    
    React Query
    
    React Router
    React Router
    
    React Router v6
    
    React Router v5
    
    React frameworks
    React frameworks
    
    Next JS
    
    React Frameworks
    
    React patterns
    React patterns
    
    One way data flow
    
    Epic React 3: Advanced React Patterns
    
    [Compound components](https://kentcdodds.com/blog/compound-components-with-react-hooks)
    
    React testing
    React testing
    
    React Testing Library
    
    Jest
    
    msw (mock-service-worker)
    
    React Testing: Act and Assert
    
    Testing Custom Hooks
    
    Redux
    Redux
    
    Redux
    
    TypeScript and Redux
    
    Storybook
    Storybook
    
    [Why Storybook](https://storybook.js.org/)
    
    Setting up Storybook
    
    Writing your first Story
    
    Using Storybook
    
    Testing Stories
    
    Chromatic
    
    Typescript
    Typescript
    
    Empty TypeScript Types
    
    TypeScript Objects
    
    TypeScript
- System design
  System design

ORM

[[django-orm]]

[[django-orm-or-raw-sql]]

Don't put business logic in models - can accidentally make DB calls - your logic will be slow af

Last update: 2023-02-03

Previous N + 1 Problem

Next Column databases

Copyright © 2022 Fullchee Zhang

Made with Material for MkDocs