Database Migration
intermediateDefinition
A small, saved script that changes how a database is laid out, such as adding a column, and runs in order so every copy of the database ends up the same shape.
In the wild
To start storing customers' phone numbers, a team writes a migration that adds a phone column to the customers table, then runs it on every copy of the database.
More from Backend & APIs
API (Application Programming Interface)
A set of agreed requests one program can send to another to get data or have something done, like ordering from a restaurant menu without seeing the kitchen.
Authentication vs Authorization
Authentication checks who you are (usually when you log in), and authorization checks what you're allowed to do once the app knows who you are.
Backend
The part of an app that runs on a server, out of sight: it stores the data and does the work behind what you see on the screen.
Connection Pool
A small set of open database connections an app keeps ready and shares between requests, instead of opening a new one every time.
CORS (Cross-Origin Resource Sharing)
A browser safety rule that stops a web page from reading data from a different website unless that other website says it's allowed.
CRUD (Create, Read, Update, Delete)
The four basic things an app does with saved information: add a new item, look at it, change it, and remove it.