MySQL
MySQL is an open-source relational database management system that stores data in tables and uses SQL to query and manage it.
InnoDB: InnoDB is MySQL’s default storage engine, supporting transactions, row-level locking, and foreign keys. It supplies the transactional storage and crash recovery behind most MySQL tables.
Relational database: A database that organizes data into relations, commonly represented as tables with rows and columns. MySQL belongs to this database family and follows its table-centered model.
PHP: PHP is a general-purpose scripting language widely used to build web applications. PHP applications commonly connect to MySQL to store and retrieve site data.
PostgreSQL: PostgreSQL is an open-source object-relational database system with extensive support for SQL standards and advanced data types. It is a widely used alternative when applications need different SQL features or extensibility.
SQL: SQL is a language for defining, querying, and managing data in relational database systems. MySQL uses SQL statements as its main interface for working with relational data.
Database schema: A database schema defines the structure of a database, including its tables, columns, and constraints. A MySQL schema specifies the structures that its tables and queries use.
WordPress: WordPress is an open-source content management system used to create and manage websites. WordPress stores site content, settings, and user data in MySQL-compatible databases.
SQLite: SQLite is an embedded relational database engine that stores a database in a file without a separate server process. Unlike typical MySQL deployments, SQLite is often embedded directly into an application.
B-tree: A B-tree is a balanced search-tree structure that keeps data ordered for efficient lookup and range scans. InnoDB indexes commonly use B-tree structures to speed up searches and sorting.
Primary key: A primary key is a column or set of columns that uniquely identifies each row in a table. MySQL uses primary keys to identify records and organize InnoDB table storage.