Daily Shaarli

All links of one day in a single page.

July 4, 2023

Douglas Hofstadter changes his mind on Deep Learning & AI risk (June 2023)? — LessWrong

An interview of Douglas Hofstadter on recent AI development.

How I added C-style for-loops to Python

A clever way of adding new syntax to Python - through the # coding: xxx option with a custom encoding handler.

# coding: cursed-for
for (i = 5; i < 10; i += 2):
    print(i)
Joins 13 Ways

The SQL Join can be thought of as the follows:

  • A join is a lookup
  • A join is a nested loop over rows
  • A join is a nested loop over columns
  • A join is compatible alternate realities
  • A join is flatMap
  • A join is the solution to the N+1 problem
  • A join is paths through a graph
  • A join is a minimal model
  • A join is typechecking
  • A join is an operation in the Set monad
  • A join is the biggest acceptable relation
  • A join is a…join
  • A join is a ring product

These are nice ways to illustrate a non-trivial algebraic structure.