PostgreSQL is a database management system, similar to MySQL in many respects but with some key differences. Like MySQL, it’s commonly hosted on Linux. In this guide, we’ll show how to run a PostgreSQL server on Ubuntu 22.04 Jammy Jellyfish, as well as installing the client version in case you just need to connect to an external PostgreSQL database.
database
Using Python to Parse JSON
The objective of this article is to describe how to parse JSON data in Python.
MySQL: Allow root remote access
The purpose of this tutorial is to show how to access MySQL remotely with the root account. Conventional security practice is to disable remote access for the root account, but it is very simple to turn on that access in a Linux system.
MySQL: Allow all hosts
If you wish to access your MySQL server remotely, it will be necessary to configure one or more users to allow access from remote hosts. If you do not know all the IP addresses of the connecting hosts, then you can simply allow connections from all hosts.
MySQL: Allow empty password
If you have installed MySQL on your Linux system and need to have one or more users with an empty password, it is possible to either create new users with empty passwords or reset an existing user’s password to being empty.
MySQL: Allow user to create database
After installing MySQL on your Linux system, you can create one or more users and grant them permissions to do things like create databases, access table data, etc.
MySQL: Allow user access to database
After installing MySQL on your Linux system and creating a new database, you will need to setup a new user to access that database, granting it permissions to read and/or write data to it.
MySQL: Allow access from specific IP address
If you need to allow remote access to your MySQL server, a good security practice is to only allow access from one or more specific IP addresses. This way, you are not needlessly exposing an attack vector to the entire internet.
MySQL: Allow remote connections
After installing a MySQL server on a Linux system, by default it will only accept incoming connections from itself (i.e. the loopback address 127.0.0.1
).
How to set, change and delete music tags with Mutagen
Tagging music files is a way of keeping a music library well organized and let us search for songs on the base of Artists, albums, genre and other parameters. Many graphical and command line applications exist on Linux to manage tags for audio files, like Picard or Quodlibet.
Introduction to MySQL storage engines
MySQL is probably the most famous Relational Database Management System (RDBMS). Developed as a free and open source software, it was originally backed by the MYSQL AB company, but is now owned by Oracle. In MySQL the “storage engine” used for a table determines how data is handled.
How to manipulate Excel spreadsheets with Python and openpyxl
Python is a general purpose programming language that needs no presentations. It was originally written by Guido Van Rossum, and saw its first release in the year 1991. At the moment of writing, the latest stable version of the language is 3.10
. In this tutorial we see how to use it together with the openpyxl library to manipulate Excel spreadsheets.