This page serves as the index for our PostgreSQL tutorials. It will be updated as new articles in the series are added. This guide is intended for developers who are just getting started with PostgreSQL and are looking for a simple resource to get them up and running. PostreSQL Guide Introduction: What is PostgreSQL? Why Use It ?
Welcome to LinuxScrew
View our featured tutorials and projects in the slider below or scroll down to see all recent articles.
This article will show you how to use while loops in Bash/Shell scripts, and provides some code examples. Bash scripts let you automate tasks in the linux shell. Often, you’ll want to repeat a task for a set of data or repeated user input – that’s what while loops are for – they let you loop or iterate over a sequence of data or input, making it easy to build scripts that repeat a set of actions. The while loop syntax demonstrated below will also work for the Zsh shell and … Read more
This review will show you what KDE Plasma 5 and KDE Neon look like in 2022, from installation to the desktop, and provide some thoughts on usability and how it stacks up against other GUIs like Gnome and MATE. What is KDE? KDE is a Desktop Environment mainly used on Linux systems. It has since grown into a large development communitity working on a variety of desktop software projects including UI frameworks for use with the KDE desktop environment, and a suite of applications including … Read more
GB Studio is an easy to use game development tool that lets you make make games in a simple drag-and-drop interface. Here’s a short review including screenshots of GB Studio running in Linux. In this article, I’ve taken some screenshots and made some notes as I installed and got up and running with GB Studio – it serves as a quick guide/review so you know what to expect if you decide to check it out. What is GB Studio? GB Studio is probably one of … Read more
The case statement is used to choose which code to execute based on the value of a variable or expression. Here is how to use it in your Bash scripts. What Does the case Statement Do? The case statement is a convenient alternative to using multiple if/if else statements when you are deciding what action to take based on the value of a variable or expression. For example, if you have a variable called weekday, you can executed different code based on which day of the week is named in the variable, … Read more
This article is part of the LinuxScrew Guide for Developers Learning PostgreSQL. PostgreSQL is a relational database management system. It is similar to other networked SQL database servers like MySQL/MariaDB and Microsoft SQL, but there are some key differences in features and functionality. PostgreSQL vs Other Database Systems You can see a comparison of PostgreSQL and other database systems here. In short, while MySQL is the most popular open source database system, PostgreSQL is more advanced. PostgreSQL is object oriented, can store a larger number of types … Read more
This article will provide a simple introduction to multiprocessing in Python and provide code examples. The code and examples in this article are for Python 3. Python 2 is no longer supported, if you are still using it you should be migrating your projects to the latest version of Python to ensure security and compatibility. What is Multiprocessing? Usually, Python runs your code, line-by-line, in a single process until it has completed. Multiprocessing allows you to run multiple sets of instructions simultaneously in separate processes, enabling your … Read more