CRUD Database User Interfaces
Database user interfaces for reading, writing (adding and updating) and deletion are referred to as CRUD database user interfaces.
Posts
Positivism
Positivism is the belief that knowledge comes only from measurements and reasoning about measurements. Positivists ignore what cannot be measured. Positivism was helpful in the development of general relativity and quantum mechanics.
Data Lakes, Data Warehouses & Data Lakehouses
Data lakes are unstructured data optimized data stores.
Data warehouses are structured data optimized data stores.
Data lakehouses are structured and unstructured data optimized data stores.
Data warehouses may allow unstructured data but they are not optimized for it.
ACID Property
Sets of database operations have the ACID property if they have the following properties:
- All operations always successfully complete or as if all never attempted (atomicity).
- All beginning and ending database states are always valid (consistency).
- All operations never depend on other operations in process that are not in the set (isolation).
- All ending database states always survive system failures (durability).
Sets of database operations that have the ACID property are referred to as database transactions.
Kinematics & Dynamics
Kinematics is the subset of mechanics not involving forces and torques. Dynamics is the subset of mechanics involving forces and torques.
Electrostatics & Electrodynamics
Electrostatics is the study of unvarying charges, currents and electromagnetic fields. Electrodynamics is the study of varying charges, currents and electromagnetic fields.
Python Boolean Types
Python booleans are of type bool which is a subclass of type int which is a subclass of type object.
Lunar Cycles
The orbital period of the Moon is about 27.3 days. The phases of the Moon on Earth appear to have a period of about 29.5 days.
Easter
Easter is on the first Sunday after the first ecclesiastical full moon on or after the ecclesiastical spring equinox. Actual spring equinoxes are on various days in March while ecclesiastical spring equinoxes are always on March 21. Ecclesiastical full moons are based on ancient rules and sometimes slightly differ from actual full moons.
Modems
Encoding digital information into waves is referred to as modulation. Decoding digital information from waves is referred to as demodulation. Devices which do modulation and demodulation are referred to as modems. Example use cases include transmission via sound and radio waves.
Information Schema
A common standard database description view set is referred to as the information schema.
DMARC
Domain-based Message Authentication, Reporting & Conformance (DMARC) is a protocol for specifying how email receivers should utilize Sender Policy Framework (SPF) and DomainKeys Identified Mail (DKIM). DMARC specifications are stored in the Domain Name System (DNS).
DKIM
DomainKeys Identified Mail (DKIM) is an email digital signature system that stores public keys in the Domain Name System (DNS).
MX And SPF Records
Mail Exchange (MX) records specify email receivers.
Sender Policy Framework (SPF) records specify email senders. Both are part of the Domain Name System (DNS).
MUAs, MSAs And MTAs
Clients that transfer emails to servers are referred to as mail user agents (MUAs).
Servers that accept emails from clients are referred to as mail submission agents (MSAs).
Servers that transfer emails to other servers are referred to as mail transfer agents (MTAs).
SMTP And Submissions Ports
Servers transfer emails using the Simple Mail Transfer Protocol (SMTP) port (25). Clients transfer emails to servers using one of the submissions ports (465 and 587).
SASL
Simple Authentication And Security Layer (SASL) is an authentication protocol. It compliments the
Transport Layer Security (TLS) encryption protocol.
SQL Join Algorithm
SQL joins return subsets of all possible pairs of rows between two tables and rows of nulls. Note that subsets can be defined by inequalities as well as equalities.