22nd Week of 2021

Computer Science⚑

GNULinux⚑

APT⚑

• New: Install apt package from .deb.

Git⚑

• New: Remove file but keep locally.

jmtpfs⚑

• New: Mount andorid.

  jmtpfs is a FUSE and libmtp based filesystem for accessing MTP (Media Transfer Protocol) devices.

LUKS⚑

• New: Using a keyfile for LUKS.

mdadm⚑

• New: Extend RAID0.

mmv⚑

• New: Mmv command line utility.

  mmv is a command line utility to move/copy/append/link multiple files by wildcard patterns.

Music⚑

• New: How to spot a fake FLAC file.

PostgreSQL⚑

• New: Stop/kill a process.

• New: NULLIF function.

  The NULLIF(value1, value2) 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.

Hardware⚑

• New: BIOS upgrade instructions.

Other⚑

• New: UPDATE.

  To update the values of some columns, use UPDATE.

• New: Add FLAC replaygain.