Skip to content

22nd Week of 2021

Computer Science⚑

GNULinux⚑

(../computer_science/gnu_linux/apt.md)⚑

  • New: Install apt package from .deb.

(../git.md)⚑

  • New: Remove file but keep locally.

(../computer_science/gnu_linux/jmtpfs.md)⚑

(../computer_science/gnu_linux/luks.md)⚑

  • New: Using a keyfile for LUKS.

(../computer_science/gnu_linux/mdadm.md)⚑

  • New: Extend RAID0.

(../computer_science/gnu_linux/mmv.md)⚑

  • New: Mmv command line utility.

    (https://github.com/itchyny/mmv) is a command line utility to move/copy/append/link multiple files by wildcard patterns.

(../computer_science/gnu_linux/music.md)⚑

  • New: How to spot a fake FLAC file.

(../computer_science/gnu_linux/postgresql.md)⚑

  • New: Stop/kill a process.

  • New: NULLIF function.

    The (https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIONS-NULLIF) function returns a null value if value1 equals value2; otherwise it returns value1.

    It can be useful for avoiding divisions by 0 (e.g. set value2 to 0).

  • New: Numeric data types reference.

  • New: Add column.
  • New: Concat_ws.

  • New: Window functions.

    Window functions allow to perform the calculation across a set of rows related to the current row.

  • New: UPDATE from subquery.

  • New: Truncate date in PostgreSQL.

(../computer_science/hardware/t14_amd_gen1.md)⚑

  • New: BIOS upgrade instructions.

Other⚑