T

teaching

Inspired by e.g. GitHub ClassRoom, Travo is a lightweight Python toolkit that helps you turn your favorite GitLab instance into a flexible assignment management solution. It does so by automating steps in the assignment workflow through Git and GitLab's REST API.

Host a Git repository on GitLab and work with it from WSL or from Windows.

Uniprot is a freely accessible database of protein sequences with many entries derived from genome sequencing projects.

Unit tests are small isolated tests that check whether a method, class, feature, or component correctly implements its business logic.

The join clause joins two tables by the column they share.

A view is a query saved with a name, which you then query as if it were just another table.

A foreign key is the column that points to the primary key of another table.

An entity is a table where each row has something that identifies it.

The where clause lets you request only the rows that meet a condition.

The group by clause splits the table into groups and calculates a value for each group.

The SQL select statement is used to select data from a table.

Run a GitLab job inside a container every time you update the project.

source code for my software articles, including the popular series "Starting Systems Programming" and "Backend from the Beginning"

The computer's file system lets us persist data in secondary memory.

The program chooses between different paths depending on a condition.

A program is a set of statements that run one after another.

A query is a set of expressions applied to a context.

Sample CSV datasets — world education and income, happiness and population — used in the Polars activities.

A form collects data from whoever reads the document and sends it to a server.

A web document can link to and embed any resource accessible through a URL