Databases قواعد البيانات
The storage engines behind every dynamic site — SQL fundamentals, MySQL and its alternatives, indexing, collation and replication.
10 terms in this categoryDatabase قاعدة البيانات
The structured store behind every dynamic website — users, products, posts and settings all live in one. Relational data...
MySQL
The world's most deployed open-source relational database and the default engine of the hosting universe — WordPress, Jo...
SQL لغة SQL
Structured Query Language — the standard language for talking to relational databases: SELECT reads, INSERT adds, UPDATE...
MariaDB
The community fork of MySQL, created by MySQL's original author after the Oracle acquisition. It is a drop-in replacemen...
PostgreSQL
The most advanced open-source relational database — strict standards compliance, rich types (JSON, arrays, geospatial vi...
phpMyAdmin
The classic web interface for managing MySQL and MariaDB — browse tables, run queries, edit rows, import and export dump...
Redis
An in-memory key-value store famous for sub-millisecond reads — the standard engine for caching, sessions, queues and re...
Database Index فهرس قاعدة البيانات
A lookup structure (usually a B-tree) that lets the database find rows without scanning the whole table — the difference...
Collation ترتيب المحارف (Collation)
The rule set a database uses to compare and sort text — whether "a" equals "A", how accents rank, and how Arabic letters...
Database Replication النسخ المتماثل لقواعد البيانات
Continuously copying a database to one or more replica servers. Replicas serve read traffic (scaling), stand by as failo...