Programming

Home » Programming

Python NumPy Crash Course – A Simple Tutorial and Example

by
Python Numpy Course Tutorial Example

Python’s NumPy library is the standard for working with numerical data. This article will explain why that is, and how to use it. In addition to this, code examples for basic usage will be shown, and we will build a real-world example that implements NumPy to work with some example data. Python and Arrays Whether you are working with data collected for scientific or business reasons, it is usually collected in the form of arrays of data presented as tables with single or multiple columns. … Read more

Home » Programming

Python Virtual Environments with virtualenv and Anaconda

by
python virtualenv

This article will explain and demonstrate virtual environments in Python using virtualenv and in Anaconda. What is a ‘Virtual Environment’? In Python, a virtual environment is an isolated directory that contains all of the dependencies of a Python project. By default, when you install a package using the pip package manager, it is installed globally – that version of the package is available to all Python scripts running on your system. This can cause problems. It clutters up your global Python installation, and all projects … Read more

Home » Programming

PHP $this Variable – What It Is, How To Use It [Examples]

by
PHP this

This article will explain the PHP $this variable – what it is, what it does, and how to use it – with code examples. PHP Objects and Classes PHP is an object-oriented programming language. Code and data can be stored in an object which represents the items your code represents with a set of properties and methods. For example, you might have objects that represent sales invoices, or cars, or pets, or people – each containing code and data relevant to the thing they represent. The properties or attributes of … Read more

Categories PHP

Home » Programming

How to Use Variable Variables in PHP, with Examples

by
PHP Variable Variables

Variable variables let you dynamically access variables by their name. Sound confusing? This article will explain PHP variable variables, and provide code examples. What is a variable? In computer programming, variables store a value, or reference to a value, for later use. Variables have names, and when you access a named variable, the value it contains can be read or updated. Declaring variables in PHP In PHP, a variable is declared when it is first used: Above, a variable named $myVariable is declared using the = (equals) operator, and assigned the … Read more

Categories PHP

Home » Programming

Top 3 Best (FREE) GUIs for PostgreSQL in 2022

by
PostgreSQL Best GUI

PostgreSQL is one of the most popular database systems in use today. GUIs make working with data in PostgreSQL simpler for beginners – here are the best free GUIs you can use on Linux in 2022. What is PostgreSQL PostgreSQL is an object-relational database management system (ORDBMS) for storing structured data. It provides a networked database server that can be used as the backend for your mobile apps, APIs, and webapps. It is also used for storing data for processing in analytics and data science. It’s free to … Read more

Home » Programming

How to Check that PostgreSQL Server is Running on Linux (Ubuntu/Debian/Red Hat/Fedora)

by
Check PostgreSQL Server Running

This tutorial will show you how to check that the PostgreSQL Server service is running on your Linux system. To install PostgreSQL follow our tutorial here. Checking PostgreSQL is Running on Ubuntu/Debian To check whether the PostgreSQL server service is running successfully on your Debian or Ubuntu system, run: Checking the Firewall By default PostgreSQL runs on port 5432 and is not restricted by host name. When installing PostgreSQL on Ubuntu, usually a firewall rule will be created automatically allowing access to the database server. You can confirm … Read more

Home » Programming

How to Update PostgreSQL on Linux (Ubuntu/Debian/Arch/RedHat)

by
How to Update PostgreSQL

This article will instruct you how to update the PostgreSQL database server on Linux – Redhat, Ubuntu, Debian, and Arch Linux. If you’re looking to install PostgreSQL server on your Linux system, follow our instructions here. Take Care, and Back Up! Note that this article is about updating the PostgreSQL package from your software repository. This will not upgrade to the next major release. Before you do update, however check which version will be installed and ensure it is compatible with the software you are connecting to the database. … Read more

Home » Programming

How to Upgrade the Release of PostgreSQL (Ubuntu/Debian/Red Hat)

by
How to Upgrade PostgreSQL

This article will show you how to safely upgrade the PostgreSQL database server to the latest version on your Linux system. First, Back Up Your Databases! Before making any changes to your system, you should perform a full backup – that way if something goes wrong, you can roll back to a working version quickly. At the very least, make sure that you’ve backed up your PostgreSQL Databases to protect from data loss. What is a Major/Minor Release? A major release is an update that greatly changes the functionality or … Read more

Home » Programming

How to Start, Stop, and Restart PostgreSQL in Linux

by
Start Stop Restart PostgreSQL

This short tutorial will show you how to start, stop, and restart PostgreSQL servers on your Linux system. PostgreSQL is a flexible database system that allows you to run multiple versions of the server software on the same host. This can get a bit confusing, but thankfully PostgreSQL includes all of the tools you need to make sense of things and control each server individually. How to Start PostgreSQL Service/Server To start the default or primary PostgreSQL server on your system, simply run the following … Read more

Home » Programming

PostgreSQL – Default Password/Resetting the Default Password

by
PostgreSQL Default User Password Reset

This post will explain how user accounts by default work in PostgreSQL, and how you can change the default password. PostgreSQL works a bit differently to other database servers like MySQL when it comes to the default behaviour of user accounts, so read on to find out how to manage access as the default PostgreSQL admin user. PostgreSQL uses the system users The default PostgreSQL configuration uses ident for authentication – this method uses the hosts operating systems usernames and compares them against the permissions stored for each database. This means … Read more