/explore
|
You are here 
|
avestura.dev | ||
| | | | |
blog.codefarm.me
|
|
| | | | | SQL (pronounced /?s?kju?l/ S-Q-L; or alternatively as /?si?kw?l/ "sequel") stands for Structured Query Language, which is both an ANSI and ISO standard language that was designed to query and manage data in relational database management systems (RDBMSs). An RDBMS is a database management system based on the relational model (a semantic model for representing data), which in turn is based on two mathematical branches: set theory and predicate logic. "NULL marker" or just "NULL" (/n?l/) is not a NULL value but rather a marker for a missing value. SQL comprises several sub-languages for managing different aspects of a database: Data Definition Language (DDL) defines and manages the structure of database objects with statements such as CREATE, ALTER, and DROP. ... | |
| | | | |
troels.arvin.dk
|
|
| | | | | [AI summary] The provided text is a detailed, comprehensive overview of SQL standards, database systems, and their respective features, including information about schemas, tables, views, constraints, and metadata queries. It also touches on differences between SQL dialects (PostgreSQL, MySQL, Oracle, Informix, DB2, MSSQL) in terms of syntax, case sensitivity, and support for SQL standards. | |
| | | | |
pgdba.org
|
|
| | | | | [AI summary] This technical article explains the Multi-Version Concurrency Control (MVCC) and transaction isolation levels in PostgreSQL, including how XIDs work and common concurrency issues. | |
| | | | |
planetscale.com
|
|
| | | Learn about the database sharding scaling pattern in this interactive blog. | ||
