This post shows how to log in as another user to pgAdmin 4 accessible via a web browser.
PostgreSQL – Create superusers If You Don’t Have Them
During the initial phase of our application development, we need superusers for our database, especially when we are starting with greenfield projects and no prior databases exist. Most of the time, we use this type of user to run DDL
PostgreSQL Terminate Active Connections
Sometimes we need to terminate active connections to a database forcefully. Doing such requires two things, determining which active connections to target and running the command to terminate them. This post shows how to terminate active connections using some SQL
PostgreSQL postgresql.conf And postgresql.auto.conf
SQL statements to list settings defined in postgresql.conf and overriden by postgresql.auto.conf.
List PostgreSQL Configuration Files Using SQL Select
SQL statement to list all locations of configuration files.
Laravel 5.7 – How to use Database Transaction with Eloquent ORM and Query Builder
This post demonstrates how to use database transaction both for Eloquent ORM and Laravel’s Query Builder.
Maven – Redirect console output to file
Sometimes we need to redirect Maven console output to a file. Your favorite IDEs may not display all the console output. It is normal as some IDEs have a default configuration to show only the last part of the overall
Create React Native Project – Working Setup for Android
This post demonstrates a working setup of React Native project.
Laravel 5.7 Mailgun Configuration To Send Mail
Configuring Laravel to use Mailgun is easy. We only need an account at mailgun.com and, for testing, some authorized recipient email address.
Migrate from MySQL to PostgreSQL Using Pgloader Docker Container
This post shows how to migrate a database from MySQL to a PostgreSQL instance running on Windows using the pgloader (running as a Docker container) to perform the migration from MySQL to PostgreSQL. From within the container, we use docker.for.win.localhost