Search Results for: mysql

This guide explains how to list databases and tables using MySQL or MariaDB using simple commands. Managing your databases from the Linux shell is quick and efficient compared to some of the bloated database management tools available. Here’s a quick primer on seeing what databases and tables you’ve got set up on your MySQL or MariaDB server. Listing Databases Once you’ve logged in to your database, simply enter the following to list your databases: SHOW DATABASES; You’ll get a list of all of the databases … Read more

This article will explain the differences between PostgreSQL and Oracle Database, and help you to decide which you should use in your project (The answer is PostgreSQL). Choosing the right database for your application, whether it’s a webapp, mobile app, or desktop application is vital. Changing database backend mid-development could be a costly (in both your time or money) and frustrating experience. Trying to decide between other databases like MySQL, MariaDB, MongoDB, SQLite and MSSQL? Check out our other guide here. Oracle Database Oracle Database, otherwise … Read more

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

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

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

This tutorial will show you how to import data from a CSV file into a PostgreSQL database table. What is a CSV File A CSV (Comma Separated Values) file is a text file that contains tabulated information. The rows in this data each take up a line in the text file, while the values in each column on each row are separated by a comma – hence, comma-separated. CSV files are versatile. Because the data within is stored as plain text, they can be opened … 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