Issue 2022-W18

Published on

This week has been about database identifiers, uncertainty in project management, a tool to run SQL on CSV, Python and WebAssembly, Datasette lite and CSS layers.

# Datasette Lite: a server-side Python web application running in a browser

An article announcing a version of Datasette compiled to WebAssembly. The example linked in the article will give you a good idea of its possibilities.

# Pyodide

A port of CPython to WebAssembly/Emscripten to use Python in the browser and Node.js.

# trdsql

A command-line tool that can execute SQL queries on CSV, LTSV, JSON and TBLN.

# The Future of CSS: Cascade Layers (CSS @layer)

An article on how the CSS @layer works and how it is expected to help managing the effects of the cascade.

# Identity Crisis: Sequence v. UUID as Primary Key

An article on the trade-offs between UUID and sequential integers as primary keys in a relational database. The article focuses on Postgres but it is mostly transferable to other relational databases.

# σ-driven project management: when is the optimal time to give up?

An article superficially exploring project management approaches based on amount of uncertainty. Although I like the initial framing it lacks depth around variable uncertainty.

Particularly on software projects it says:

Everyone's job is simultaneously building features and building tools that makes it easier to build features. We end up with layers and layers of abstractions, and each layer reduces the work we have to spend in the layer below. This is obviously great for productivity! It does however mean that software projects will be hard to estimate, and a lot of software projects will be abandoned.

I agree in principle but lacks factors like the impact of abstractions in reduction of future flexibility, internal or external rot (e.g. cutting corners, technical debt, world changing).