Postgres Database Utility

Backup database (Linux)

Backup database (Windows – Method 1)

Backup database (Windows – Method 2)

Restore database (Linux)

Restore database (Linux / Windows)

Change default postgres password (Linux)

Create New User (Linux – Method 1)

Create New User (Linux – Method 2)

Create new Database (Linux – Method 1)

Create new Database (Linux – Method 2)

Connect to database

Refresh MaterializeView

 

Install Laravel on Ubuntu 18.x

Installing Apache2

Installing PHP 7.2.x

Installing Mod Apache

Installing Mod For Nginx

Installing Mod MySQL

Installing Mod PostgreSQL

Create Swap Memory (For Low Memory VPS)

Installing Composer 1.x

Or Installing Composer 2.x

Setup Laravel Project

Create project from Laravel repository (Laravel 7.x Framework)

Installing PostgreSQL 10.x

Set password for DB administrator (postgres)

Drop Database

Create another Role

Installing Percona Xtra Cluster MySQL 5.7.x

Add this command to last line

 

Create root user on any address

 

jQuery Datatables and Laravel 6.x Pagination

jQuery DataTables is a table component that is powerful for data management. These plugins provide searching, sorting, pagination, filter per column, and many more. But we have some problems combining jQuery Datatables and Laravel framework.

We separate applications (Rest API and User Interface). For Rest API we use Laravel Framework and for User Interface use Laravel too, but we only Blade component and Guzzle as HTTP Client Library.

We now Laravel has good packages for handle it, as far I know Yajra’s good and incredible packages (you can see Yajra’s package on Github). But using Yajra’s library was not possible at that time, because Yajra was using Eloquent and can’t use HTTP Client (like Guzzle, UniRest, etc). Then we do research to deal with this problem and got results as we would discuss in this post.

On these tutorials, we use an empty Laravel 6.x project with Bootstrap 3, jQuery Datatables plugins. Our goal in this tutorial is to Display User Lists in Datatables (Searching and Sorting also). Ok let’s start the codings. Read More

Benchmarking Using AB

odenktoo001.json content :