PHP 7.1: Easy Syntax, Amazing Speeds

PHP 7.1 Installation:

Server OS: Version:

> sudo apt-get update

>add-apt-repository ppa:ondrej/php -y

>apt-get update -y

>apt-get upgrade -y

>apt-get install php7.1 -y

>apt-get install php7.1-curl php7.1-pgsql php7.1-mysql php7.1-mcrypt php7.1-curl php7.1-pgsql php7.1-mysql php7.1-mcrypt -y

LoveTech's PHP 7.1 Auto-Installer:

Download Installer

Why PostgreSQL?

PostgreSQL is an excellent free database that offers world class relational and object data storage.

Great Schema Free Object Support

PostgreSQL offers the jsonb type which allows storage of JSON data with no pre-defined schema.

Read More

Great Relational Performance

PostgreSQL offers exceptional performance with highly related data which rival higher priced alternatives such as Microsoft SQL and Oracle.

Read More

Excellence

Love is just a four letter word

Read More

After the install, there will only be one user(postgres). Let's run the following commands to add another user that matches are Linux Username to make life easier

sudo -u postgres psql

postgres=> alter user postgres password 'apassword';

postgres=> create user yerusername createdb createuser password 'somepass';

postgres=> create database yerusername owner yerusername;

postgres=> \q


now as your regular user 'yerusername' you can connect to postgres, and have the privileges to create new users and databases.

Now, you can simply use the psql command to access the PostgreSQL command shell