Tuesday, March 12, 2019

World Wide Web: 30 years

World Wide Web - Wikipedia

The World Wide Web turns 30: our favorite memories from A to Z - The Verge

"On this day 30 years ago (1989-03-12), Tim Berners-Lee submitted a proposal with the dreary title “Information Management” to his superior at the European physics laboratory CERN."

History of the Web – World Wide Web Foundation

Tim Berners-Lee: world wide web inventor calls for 'fight' to protect internet on its 30th birthday - CNN

SQL Server Temporal Tables

Temporal Tables - SQL Server | Microsoft Docs

"SQL Server 2016 introduced support for temporal tables (also known as system-versioned temporal tables) as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time. Temporal is a database feature that was introduced in ANSI SQL 2011."
"How does temporal work?

System-versioning for a table is implemented as a pair of tables, a current table and a history table. Within each of these tables, the following two additional datetime2 columns are used to define the period of validity for each row: SysStartTime, SysEndTime "

PostgreSQL doesn’t support these features natively, but this temporal tables approximates them.