Lexicon
Tools
What's it called?Screenshot identifierPrompt improver
Learn
Learning pathsPractice
Library
All terms A–Z01UI components1502Layout & design1203Interaction & UX1304Data & backend1205Users & access1006AI & automation1107Shipping & ops1108Working with agents12
How Lexicon growsFirst run Mon · in 2d 20h
Lexicon
Lexicon
Tools
What's it called?Screenshot identifierPrompt improver
Learn
Learning pathsPractice
Library
All terms A–Z01UI components1502Layout & design1203Interaction & UX1304Data & backend1205Users & access1006AI & automation1107Shipping & ops1108Working with agents12
How Lexicon growsFirst run Mon · in 2d 20h
Category 04 · 12 terms

Data & backend

Where information lives and how it moves.

0 of 12 learnedPractice this category
FrontendThe part of an app you see and touch in the browser or on your phone: screens, buttons, and forms.
BackendThe behind-the-scenes part of an app that stores data, enforces rules, and does the work you don't see.
DatabaseWhere an app keeps its information permanently, organized so it can be found and updated quickly.
TableOne list in the database holding one kind of thing, like customers or orders, laid out in rows and columns.
FieldOne piece of information about a thing, like a customer's email, stored as a column and often typed into a form.
SchemaThe blueprint of an app's data: which tables exist, what fields each has, and how they connect.
APIA defined way for one piece of software to ask another for data or to do something, like a menu with an order window.
CRUDCreate, Read, Update, Delete: the four basic things you can do with any piece of data in an app.
Demo
RelationshipHow two kinds of data connect, like one customer having many orders.
QueryA specific question the app asks the database, like "all unpaid invoices from this month, newest first."
File storageWhere an app keeps files like photos, PDFs, and videos, separate from its database records.
Seed dataRealistic fake records loaded into an app so you can see and test it before real data exists.