<h1 id="bitemporal-data-model-making-it-happened-in-postgres">Bitemporal Data Model: Making it happened in Postgres<a aria-hidden="true" class="anchor-heading icon-link" href="#bitemporal-data-model-making-it-happened-in-postgres"></a></h1>
<ul>
<li>url: <a href="https://www.youtube.com/watch?v=MGSdq6EYaKk">https://www.youtube.com/watch?v=MGSdq6EYaKk</a></li>
</ul>
<h2 id="highlights">Highlights<a aria-hidden="true" class="anchor-heading icon-link" href="#highlights"></a></h2>
<h3 id="the-linguistic-problem">The Linguistic Problem<a aria-hidden="true" class="anchor-heading icon-link" href="#the-linguistic-problem"></a></h3>
<p>Too many common terms with overlapping meaning.
•	Valid Time
•	Transaction Time
•	System Time
•	State Time
•	Inscription Time
•	Application Time
•	Speech Act Time
•	Assertive Time
•	Effective Time</p>
<ul>
<li>! Assertive Time and Effective Time are their recommendations</li>
</ul>
<hr>
<strong>Backlinks</strong>
<ul>
<li><a href="/wiki/notes/gksoywxa18kxwc9g8r7b2v8">Data Temporality</a></li>
</ul>

Bitemporal Data Model: Making it happened in Postgres

public-notes


Welcome! And beware!  

## Purpose

This vault is the "[[learning-in-public|ar.swyx.learn-in-public]]" part of my Second Brain. If you share some of my interests, please [reach out](https://djradon.github.io)! 

## Contents

- [[t]] my personal wikipedia
- [[idea]] (not necessarily mine)
- Resource Notes, including highlights, thoughts and metadata, for various things:
  - [[ar]] mostly articles, papers and web pages
  - [[book]]
  - [[community]]
  - [[course]]
  - [[event]]
  - [[game]]
  - [[loc]]
  - [[org]]
  - [[user]] 
  - [[prdct]] mostly software products, but also ontologies
  - [[recipe]]
  - [[video]] movies, tv episodes, youtube, etc
- [[vs]]
- [[wanted]]
- Some "Metadata Notes":
  - [[tags]] which may refer to any and multiple (or none) of the above
  - [[c]]: ways to categorize resources
  - [[p]]: ways to assert things about resources (mostly abandoned)

In terms of the [[t.km.zettelkasten]] method, this wiki is a commingling of literature notes with something @Sönke-Ahrens warned about: a "personal Wikipedia or a database" [^1]. 

In terms of [[t.tm.getting-things-done]], it's references, someday-maybe, next actions, and public projects.

## Beware!

This is a cluttered cupboard of jumbled jottings riddled with inaccuracies, confusion, and mistakes.

## What This Is Not

- evergreen-notes/digital-garden: for "synthesized" / original-ish publishable big-idea notes that should evolve over time, props to @andy-matuschak and @maggie-appleton
- blog: for "point-in-time" items to be shared: personal news, articles, etc.
  - e.g., [[ar.substack.carpe-noctem]]


[^1]: [[book.how-to-take-smart-notes]]  