Skip to content

June of 2021

Computer Science⚑

Android⚑

Xiaomi Redmi Note 9S⚑

  • Improvement: OrangeFox recovery.

    Works better than previous PitchBlack.

GNULinux⚑

APT⚑

  • New: Install apt package from .deb.

Docker⚑

  • New: .dockerignore.

    Reduce building times by not copying unnecessary files and directories.

FFmpeg⚑

  • New: Record screen.

find⚑

  • New: Find files larger than.

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: Change passphrase.

    cryptsetup luksChangeKey {device}

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.

NeoMutt⚑

  • New: Use local timezone.

PDFtk⚑

  • New: Extract a page range of a PDF.

    To extract a page range of a PDF you could print to file using evince selecting a page range. The drawback of this method is that the text might be converted to images an thus no longer be searchable. A faster alternative that also keeps the text intact is using pdftk.

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.

qutebrowser⚑

  • New: Greasemonkey plugins.

SSH⚑

  • New: Create SSH key.

Hardware⚑

reMarkable⚑

  • New: Stream reMarkable over SSH.

Programming⚑

Plotly⚑

  • New: Facet plots.
  • Correction: Image link.
  • New: Dash reverse proxy configuration.

Countries⚑

Turkey⚑

Touristic visa⚑

  • New: Turkey touristic visa.

Work⚑

  • Correction: Work permit in Turkey for EU citizens.

Other⚑

  • New: UPDATE.

    To update the values of some columns, use UPDATE.

  • New: Add FLAC replaygain.

  • New: Get weekday name from datetime.