This page permanently redirects to gemini://gemini.techrights.org/2023/09/15/psql-16/.

● 09.15.23

Gemini version available ♊︎

● Links 15/09/2023: PostgreSQL 16 Released and Krita 5.2 Release Candidate

Posted in News Roundup at 7:08 pm by Dr. Roy Schestowitz

GNU/Linux

=> ↺ Geeky Gadgets ☛ ClockworkPi uConsole Linux handheld PC from $139

• The uConsole is the latest offering from ClockworkPi, a company known for their innovative game shell and dev term handheld gaming uConsoles. This new kit provides everything necessary to assemble the device, with the exception of the 18650 batteries. The uConsole is powered by a Raspberry Pi CM4, a choice made for its compatibility with ongoing community development. This compatibility ensures that the uConsole remains up-to-date and relevant in the fast-paced world of gaming technology.

=> ↺ Embedded.com ☛ Foundries.io helps Arduino SoM meet EU security straight out-of-the-box

• Foundries.io has announced that its security technology provides capabilities making the Arduino Portenta X8 the first system-on-module (SoM) to meet all the requirements of the European Union’s Cyber Resilience Act (CRA) on shipment to a customer.

• The company said that under normal circumstances, SoM manufacturers supply their boards with a sample Linux distribution that is not maintained after shipment to the customer, and with none of the security infrastructure such as an software bill-of-materials (SBOM) tool and over-the-air (OTA) update utility required to maintain device security for life.

=> ↺ 14 Amazing Fanless Mini Pc for 2023 [Ed: Many of these target or accept GNU/Linux]

• Introducing the 14 Amazing Fanless Mini PC for 2023. In the ever-evolving world of technology, compact yet powerful devices have become a necessity for professionals and gadget enthusiasts alike. Mini PCs have gained tremendous popularity due to their ability to tick all the boxes with their small form factor, efficient performance, and noiseless operation. As we look ahead to 2023, the market is poised to offer an extensive range of fanless mini PCs that promise to revolutionize the way we work and play. These remarkable devices are engineered to deliver exceptional computing power while ensuring a noise-free environment, making them ideal for various applications such as entertainment centers, home offices, and even industrial use. Get ready to explore the latest innovations and cutting-edge features that these 14 amazing fanless mini PCs will bring to the table in 2023.

Audiocasts/Shows

=> ↺ The BSD Now Podcast ☛ BSD Now 524: Legendary Unix Recovery

• On the Loss and Preservation of Knowledge, Unix Recovery Legend, Useful Unix commands for data science, Tarsnap outage post-mortem, OpenBSD 7.3 on a twenty year old IBM ThinkPad R31, and more

=> ↺ mintCast Podcast ☛ mintCast 419.5 – Bill & Majid’s Bogus Journey

• In our Innards section we talk about cloud storage solutions and attempt to demystify some of the procedures for hosting your own cloud storage.

• In “Check This Out” On August 12, 1981 IBM Introduces Personal ComputerDownload

Applications

=> ↺ Linux Links ☛ Best Free and Open Source Alternatives to Apple ColorSync Utility

• In 2020, Apple began the Apple silicon transition, using self-designed, 64-bit ARM-based Apple M1 processors on new Mac computers. Maybe it’s the perfect time to move away from the proprietary world of Apple, and embrace the open source Linux scene.

• ColorSync Utility is a tool that lets you change a device’s colour profile. When you install devices, such as cameras, displays or printers, a colour profile containing the colour capabilities and limits for each device is created.

• It’s proprietary software and not available for Linux. We recommend the best free and open source alternatives.

=> ↺ It’s FOSS ☛ 7 Lesser Know but Unique Web Browsers For You to Explore

• Looking for something different? These unique web browsers can help you make things interesting.

=> ↺ Make Use Of ☛ The Top 9 Free-to-Use Image-Editing Apps for Linux

• A plain picture can sometimes be boring. Transform your images into works of art by processing them with these free image-editing Linux apps.

Instructionals/Technical

idroot

=> ↺ ID Root ☛ How To Install Vim Text Editor on Debian 12

• In this tutorial, we will show you how to install Vim Text Editor on Debian 12. This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS.

=> ↺ ID Root ☛ How to Use Stat Command on Linux

• The Linux operating system offers an array of powerful tools that empower users and administrators to gain deep insights into their file systems. One such tool is the stat command, a versatile utility designed to provide an in-depth understanding of files and directories.

=> ↺ ID Root ☛ Restarting Ubuntu System Using Command Line Interface

• Restarting your Ubuntu system is a routine task, but knowing how to do it via the Command Line Interface (CLI) can be incredibly useful for system administrators and advanced users.

howtoforge

=> ↺ HowTo Forge ☛ How to Install Ruby on Rails on Debian 12

• Ruby on Rails or RoR is a free and open-source web application framework written in Ruby and released under the MIT license. Rails is a full-stack web framework for easily building enterprise-grade applications.

=> ↺ HowTo Forge ☛ How to Install GLPI IT Inventory Management on Debian 12

• GLPI is an open-source IT asset and Helpdesk management solution written in PHP. In this guide, I’ll show you how to install GLPI IT Management Software on a Debian 12 machine.

=> ↺ HowTo Forge ☛ How to Install and Configure Nginx with PHP-FPM on CentOS 8

• Nginx is a free, open-source, and one of the most powerful web servers worldwide. This tutorial will teach us how to install Nginx with PHP-FPM support in CentOS 8.

=> ↺ HowTo Forge ☛ How to Install ERPNext on Debian 12

• ERPNext is an open-source enterprise resource planning (ERP) solution. In this tutorial, we will guide you through the installation of ERPNext on the Debian 12 server. You will install ERPNext with a MariaDB database server, Nginx as a reverse proxy and a supervisor process manager.

=> ↺ HowTo Forge ☛ How to Manage Multiple Node.js Versions using NVM (Node Version Manager)

• NVM or Node Version Manager is a command-line tool for managing multiple Nodejs versions. In this tutorial, I will show you how to install and use NVM for managing multiple Nodejs versions on your computer.

=> ↺ HowTo Forge ☛ How to Rename Network Interfaces to eth0 on CentOS

• In this article, we will learn about the Linux interface naming. You will learn how the network interface on Linux named eth(X), ens(X), eno(X), etc.

=> ↺ HowTo Forge ☛ How to Install a Secure FTP Server with vsftpd on Debian 12

• vSFTPd or Very Secure FTP Daemon is a free and open-source FTP server software. In this tutorial, you will learn how to set up and create a secure FTP server with vsftpd on a Debian 12 server. In this guide you will also learn how to secure your FTP server installation via UFW (Uncomplicated Firewall) and how to connect to the FTP server using the FTP client FileZilla.

=> ↺ HowTo Forge ☛ Guide to Install Django Web Framework on Debian 12

• Django is a free and open-source Python Web Framework used to develop dynamic websites and applications. This guide will show you how to install the Django web framework on a Debian 12 server.

=> ↺ IT Pro Today ☛ How To Remotely Manage Linux Users and Groups

• Managing Linux users and groups starts by understanding what a user is – an individual who has access to the system. A user can be a standard or privileged user.

• A group, meanwhile, is essentially a collection of user accounts with the same permissions. Groups provide a practical way to implement Role-Based Access Control, or RBAC, which assigns a group of users access to the same resources and permissions based on their role. For instance, you can have groups like “accounts,” “developers,” or “managers.”

• Within Linux, there are two distinct types of users: system users and regular users. Regular users don’t have sudo or root access, which grants elevated privileges. In every Linux system, there is a root account, which functions as the administrator account with unrestricted privileges. On the other hand, a sudo account offers limited administrative access, and these users are typically listed in the /etc/sudoers file.

=> ↺ Network World ☛ Sorting, joining, shuffling, skipping and numbering lines on Linux

• Whenever you need to work with lists that are stored as text files on Linux – especially long ones – you can take advantage of some easy commands to make manipulating them a lot easier. Any text file can be easily sorted, but you can also randomly arrange the lines, number them or join files when two share an initial common field. In fact, if you only want to see every other line or every fifth line in a file, you can do that too. This post runs through the commands to do all of these things.

=> ↺ Make Use Of ☛ How Can You Fix a “Permission denied (publickey)” SSH Error on Linux?

• SSH is a useful tool for connecting to remote machines, but you may run into a “Permission denied (publickey)” error involving your public key on Linux. Fortunately, there are some easy fixes you can try to troubleshoot it.

=> ↺ Vitux ☛ How to Install ERPNext on Debian

• ERPNext is a free and open source ERP system written in Python and JavaScript using a Frappe framework. It is designed for small and medium-sized businesses and offers all the features of an ERP system. It helps you manage business processes such as finance, sales, human resources, production, purchasing, services, helpdesk and more.

=> ↺ OSNote ☛ Installing Debian via Internet Mirror and PXE Server

• In this tutorial I will show you how to install the latest version of Debian 9 via a PXE server at your site. The machine is booted over the network and the system is installed via remote HTTP mirror sources on the Internet provided by Debian archive mirrors.

=> ↺ OSNote ☛ Install ZurmoCRM on Debian

• This topic shows you how to install and configure the latest version of the Zurmo CRM platform on a Debian 9 server to deploy a free online web platform for your business. Zurmo CRM is a flexible, web-based, software-independent CRM platform suitable for businesses and designed for sales processes.

=> ↺ It’s FOSS ☛ How to Use Subtitles with VLC

• A beginner’s guide to playing and managing subtitles with the VLC media player.

=> ↺ It’s FOSS ☛ 7 Tips and Tweaks to Get More Out of Thunar File Manager of Xfce

• Thunar is a good file manager by Xfce. You can enhance your experience by using these tweaks and tips.

=> ↺ It’s FOSS ☛ Create Table of Contents, Figures and Index of Tables in LibreOffice

• Learn to create table of contents, table of figures and index of tables in LibreOffice Writer.

=> ↺ It’s FOSS ☛ Colors in ls Command Output: What do They Mean?

• Wondering what are those colors in the ls command output? Where do they come from and how to set it? This article answers it all.

=> ↺ It’s FOSS ☛ How to Rotate a Video With VLC Media Player

• The versatile VLC media player allows you to rotate the video orientation as well. Quite handy for watching smartphone recorded videos on desktop.

=> ↺ Own HowTo ☛ How to install Arduino IDE on Ubuntu

• Arduino IDE is a software that you can use to connect to your arduino board.

• You basically write your code on Arduino IDE and then you upload it to your arduino board.

=> ↺ OSNote ☛ How to Install Automad CMS on Fedora Linux

• Automad is a file-based open-source content management system and template engine written in PHP. Instead of using a database, Automad uses human-readable text files to store content, hence making it portable and easy to install.

=> ↺ TecAdmin ☛ How to Install Memcache Server on Ubuntu 22.04

• Memcached is a high-performance distributed memory cache service that is primarily used to speed up sites that make heavy use of databases. It does so by caching data and objects in RAM, which reduces the need to access the database on subsequent requests.

=> ↺ 11 Tips for Syncing Bookmarks and Passwords Between Firefox and Chrome

• Google Chrome and Mozilla Firefox are the most popular web browsers that have been used by people across the world, for quite some time now.

=> ↺ MWL ☛ 60 Seconds of WIP, 14 September 2023

• Today we have a tidbit from Run Your Own Mail Server, where I discuss debugging submission at the command line. Don’t leap straight to OpenSSL or a TLS-aware netcat, though. Submission doesn’t take a straight username and password.

=> ↺ Install Cockpit Flatpak Client on Debian BookWorm (12.1) (KDE Desktop)

• Post below might be useful for Debian BookWorm Clones like SparkyLinux7 Orion Belt or any similar distro based on Debian 12.1.

=> ↺ Vitux ☛ How to Install Odoo ERP on Debian Linux

• Odoo, also known as OpenERP, is a free and open-source enterprise resource planning application based on Python. It is a full-featured application and includes open-source CRM, point of sales, human resources management, point of sales, invoicing and accounting, event management, email marketing, order tracking, etc.

=> ↺ nixCraft ☛ How to install wget on Fedora Linux using the dnf command

• Wget is a command-line tool to download files from the Internet or local servers. It is not a graphical user interface (GUI) program, and it must be used by typing commands into a terminal application. You can download files from the web. It supports HTTP, HTTPS, FTP, and other protocols. It can mirror entire websites or directories. Wget can resume downloads interrupted due to a network error or a power outage. Wget can start the download again from where it left off. Thus saving you bandwidth and download time. Let us see how to install wget under Fedora Linux.

=> ↺ Make Tech Easier ☛ How to Self-Host and Install Ghost on Your Linux Server

• Ghost is an open-source content management program that allows you to easily create a blog and a newsletter service. You can choose to subscribe to the Ghost(Pro) service to use the CMS, or, if you are more technically inclined, self-host it on your server. Here we show you the latter – self-host Ghost on your Linux server.

=> ↺ It’s FOSS ☛ Install VSCodium on Ubuntu [Ed: This still helps Microsoft. Better explore editors not tied in any way to Microsoft.]

• Not happy with telemetry in VS Code? Install VSCodium, a 100% open source clone of VS Code.

Games

=> ↺ Giz China ☛ How to Run Steam Games on Linux OS – Gizchina.com

• Valve has dedicated years to improving Linux as an operating system for Steam, and it has achieved significant success. Linux is the default OS for the Steam Deck, and it can smoothly run non-native games using the Proton compatibility layer. If you’re using a Linux PC, you can also get Steam on it. However, the process of installing Steam may vary in complexity depending on the Linux distribution you’re using.

• Typically, the most reliable way to install Steam is either through Valve’s official installation software or by using a repository. While there are app stores like Snap and Flathub that offer Steam installations, it’s worth noting that, at the time of writing, using these methods can lead to various glitches and, in some cases, render Steam unusable. Therefore, we’ll guide you through the traditional installation method. Don’t worry; you’ll only need to do this once, and you won’t have to manually install updates in the future.

=> ↺ GeekWire ☛ Here’s why so many video game developers are suddenly abandoning the Unity engine [Ed: This Mono/.NET infection is better off dead. Developers should use better frameworks anyway.]

• In the wake of a controversial policy change by game engine developer Unity, dozens of small independent video game studios have announced they’ll abandon the engine and/or have called upon Unity to reverse course.

• Unity Technologies, headquartered in San Francisco, might be best-known for its cross-platform game engine Unity. For over a decade, Unity has been a go-to toolset for video game production, particularly in the mobile and indie spaces.

• Just this year, several of 2023’s highest-profile games were built in Unity, such as Oxenfree II, Dave the Diver, Sea of Stars, Arcadian Atlas, and Venba. For Pacific Northwest productions that we’ve covered on GeekWire, you can also include BattleTech and The Fall Part 2.

Desktop Environments/WMs

K Desktop Environment/KDE SC/Qt

=> ↺ Krita ☛ Krita 5.2 Release Candidate is out

• The release candidate is here for Krita 5.2, this means that we are confident that all the major bugs brought on by the changes in Krita 5.2 have now been fixed, and would like you to give it another round of testing.

• Please pay extra attention to the following features of Krita, since they got updated or reworked since Beta2…

=> ↺ Scarlett Gately Moore: KDE: KDE neon user edition updates! Debian updates, Snaps on hold.

• I had to make the hard decision to put snaps on hold. I am working odd jobs to “stay alive” and to pay for my beautiful scenery. My “Project” should move forward, as I have done everything asked of me including finding a super awesome management team to take us all the way through. But until it is signed sealed and delivered, I have to survive. In my free time I am helping out Jonathan and working on KDE Neon, he has done so much for me over the years, it is the least I can do!

• So without further ado! Carlos and I have been working diligently on new Frameworks 5.110, Plasma 5.27.8, and Applications 23.08.1! They are complete and ready in /user! With that, a great many fixes to qml dependencies and packaging updates. Current users can update freely and the docker images and ISO are building now.

=> ↺ KDE Videos ☛ Discover GCompris

• GCompris includes well over a hundred fun educational activities. In this video you will learn how they are divided into categories and see a number of examples of what you can find in the GComrpis treasure trove.

GNOME Desktop/GTK

=> ↺ OMG Ubuntu ☛ 10 Best Features in GNOME 45

• But I figured I’d whet your appetite before then.

• In this post I list improvements, changes and new features in GNOME 45 that have caught my eye. What follows is by no means exhaustive (i.e. there’s more included than what I mention) but this rundown will give you a good idea of what the biggest user-facing additions are.

• GNOME 45 is due for release on September 20, 2023. It will include the changes I spotlight below. However, not everything mentioned will feature in Ubuntu 23.10 as, like other Linux distros, Ubuntu “curates” the GNOME desktop experience to suit its own needs, wants, and desires.

• The good news is that it’s (usually) trivial to manually add, re-enable, or install anything Ubuntu omits.

• Waffle dished out it’s time scroll on to find out what’s new!

=> ↺ Medium ☛ Pratham Gupta: GSOC 2023 Final Report

• This is the final report for my project. Here i will be explaining about the method we took to find anagrams.

• Although still under development, Editor is a important part of Crosswords application for GNOME. It allows us to create basic crosswords with grids and clues.

Distributions and Operating Systems

SUSE/OpenSUSE

=> ↺ ZDNet ☛ OpenSUSE seeks a Leap replacement, but will distro community rise to the challenge?

• Will it be Slowroll or Linarite — or nothing at all? Programmers are conflicted about where the venerable Linux distro should go from here.

Fedora Family / IBM

=> ↺ Linuxiac ☛ Fedora 40 to Offer KDE Plasma 6 Desktop

• A proposal for next year’s release of Fedora 40 has been submitted to include the KDE Plasma 6 desktop environment.

=> ↺ PipeWire 0.3.80 Released

Debian Family

=> ↺ Ubuntubuzz ☛ Collection of Recommended Applications on Debian 12 Bookworm

• Here’s our compilation of recommended applications and games for Debian 12 users. We write this especially for those who use GNOME Desktop but it works with any other desktop too. You will find below bonus recommendation links where you can download and try out ready to use sample documents or templates to be productive. We hope this will be helpful for you. So what to wait? Let’s try it out.

=> ↺ LWN ☛ The Debian Project mourns the loss of Abraham Raji

• The Debian project is mourning Abraham Raji, who was killed in an accident on September 13.

Canonical/Ubuntu Family

=> ↺ Medium ☛ Sysadmin Basics: Webmin

• Webmin is a powerful web-based control panel that simplifies server administration tasks, making it an essential tool for server administrators. In this step-by-step guide, we’ll walk you through the process of installing Webmin on your Ubuntu Server, allowing you to manage your server with ease through a user-friendly web interface.

Open Hardware/Modding

=> ↺ Help Net Security ☛ Librem 11 tablet sets new standard for privacy and security with Linux-based PureOS

• Purism introduced the new Librem 11 tablet running secure PureBoot and Linux kernel-based PureOS. Librem 11 is made for individuals, organizations, government agencies, law enforcement agencies, and businesses that need security and privacy with powerful portability.

Mobile Systems/Mobile Applications

=> ↺ Android Police ☛ One UI 6 lets you choose which apps to update when installing new Android versions

=> ↺ India Times ☛ Emergency Alerts: Government ‘explains’ emergency alerts sent to Android phone users – Times of India

=> ↺ Android Police ☛ Google Chrome adds a Material Design theme to the omnibox on Android

=> ↺ Android Police ☛ How to activate predictive back navigation on Android 14

=> ↺ Android Police ☛ How to use lockdown mode on Android

=> ↺ Behind The Screens – A Fairphone Documentary

• Fairphone & Waterbear present “Behind the Screens”. Unveil the truth behind your screen with this immersive documentary, exposing the reality of creating our most personal devices.

Free, Libre, and Open Source Software

=> ↺ OSI Blog ☛ To trust AI, it must be open and transparent. Period. [Ed: And yet the corrupt sellouts at OSI, bribed by Microsoft, are shilling GitHub and defending Copilot, which is in effect an attack on the GPL, set aside the trust issues. The OSI is corrupted beyond recognition.]

=> ↺ OSI Blog ☛ To trust AI, it must be open and transparent. Period. [Ed: And yet the corrupt sellouts at OSI, bribed by Microsoft, are shilling GitHub and defending Copilot, which is in effect an attack on the GPL, set aside the trust issues. The OSI is corrupted beyond recognition.]

=> ↺ Peter Czanik: The syslog-ng Insider 2023-09: MongoDB; UDP; sngbench; contribute;

• Dear syslog-ng users,

• This is the 112th issue of syslog-ng Insider, a monthly newsletter that brings you syslog-ng-related news.

=> ↺ LWN ☛ Videos from FOSSY released (Software Freedom Conservancy)

• The Software Freedom Conservancy (SFC) has announced the availability of videos from the first-ever Free and Open Source Yearly (FOSSY) conference, which was held in July in Portland, Oregon in the US.

Web Browsers/Web Servers

Mozilla

=> ↺ Nick Fitzgerald: My WasmCon 2023 Talk

• WebAssembly programs are sandboxed and isolated from one another and from the host, so they can’t read or write external regions of memory, transfer control to arbitrary code in the process, or freely access the network and filesystem. This makes it safe to run untrusted WebAssembly programs: they cannot escape the sandbox to steal private data from elsewhere on your laptop or run a botnet on your servers. But these security properties only hold true if the WebAssembly runtime’s implementation is correct. This talk will explore the ways we are ensuring correctness in the Wasmtime WebAssembly runtime and in its compiler, Cranelift.

SaaS/Back End/Databases

=> ↺ PostgreSQL ☛ PostgreSQL 16 Released!

• September 14, 2023 – The PostgreSQL Global Development Group today announced the release of PostgreSQL 16, the latest version of the world’s most advanced open source database.

• PostgreSQL 16 raises its performance, with notable improvements to query parallelism, bulk data loading, and logical replication. There are many features in this release for developers and administrators alike, including more SQL/JSON syntax, new monitoring stats for your workloads, and greater flexibility in defining access control rules for management of policies across large fleets.

=> ↺ Linuxiac ☛ PostgreSQL 16 Released with Notable Improvements

• PostgreSQL is a powerful open-source relational database management system (RDBMS) known for its robustness, scalability, and extensibility. Its various extensions, tools, and support for advanced data types make it a popular choice for web applications, data warehousing, geospatial databases, and more. With the release of PostgreSQL 16, this powerful database system takes another significant leap forward, reinforcing its position as the “world’s most advanced open-source RDBMS.”

• So, let’s explore how this new major version elevates the database management experience, making it more robust, efficient, and secure than ever before.

=> ↺ Silicon Angle ☛ Open-source database PostgreSQL 16 brings performance and scaling enhancements

• The developer behind the popular open-source PostgreSQL database software, the PostgreSQL Global Development Group, today announced the release of PostgreSQL 16 that includes enhancements to security, scaling and performance. PostgreSQL is a relational database management system, also known as Postgres, which is free and open source.

=> ↺ Venture Beat ☛ PostgreSQL brings more performance, security to open-source database

• The open-source PostgreSQL 16 database is out today, adding new features that will help improve performance for all types of workloads, including AI.

=> ↺ LWN ☛ PostgreSQL 16 released

• Version 16 of the PostgreSQL database manager has been released.

Productivity Software/LibreOffice/Calligra

=> ↺ LibreOffice 7.6.1 Community available for download

• Berlin, September 14, 2023 – LibreOffice 7.6.1 Community, the first minor release of the 7.6 family of the volunteer-supported free office suite for desktop productivity, for Windows (Intel/AMD and ARM processors), macOS (Apple and Intel processors) and Linux is immediately available from www.libreoffice.org/download. LibreOffice is the only open source office suite for personal productivity…

=> ↺ ZDNet ☛ How to set the next style in LibreOffice and why you should

• If LibreOffice is your office suite of choice, then you should know how easy it is to customize. One option is to define what style comes, which can make you life considerably easier.

Content Management Systems (CMS)

=> ↺ WordPress ☛ Openverse Wins the 2023 OEG Open Infrastructure Award

• WordPress is excited to announce that Openverse has been awarded the 2023 Open Education Award for Excellence in the Open Infrastructure category! The Open Education Awards for Excellence, organized by the non-profit organization Open Education Global (OEG), celebrate people, resources, and initiatives that have significantly contributed to the open education field and community.

Share in other sites/networks: These icons link to social bookmarking sites where readers can share and discover new web pages. Permalink  Send this to a friend

=> Techrights

➮ Sharing is caring. Content is available under CC-BY-SA.