PostgreSQL – Create superusers
PostgreSQL represents users as roles. There are roles that can log in called login roles. There are roles contain other roles. There are roles that both can log in and contain other roles. Continue Reading
PostgreSQL – Terminate active connections
SQL statement to terminate active connections Continue Reading
PostgreSQL – List settings defined in postgresql.conf and overriden by postgresql.auto.conf
SQL statements to list settings defined in postgresql.conf and overriden by postgresql.auto.conf. Continue Reading
PostgreSQL – List locations of configuration files
SQL statement to list all locations of configuration files. Continue Reading
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. Continue Reading
Maven – Redirect console output to file
Sometimes when working with an IDE, all the console output are not displayed. This is normal as some IDEs are with default configuration to show only the last part of the overall output which still may consists of a few hundred lines. If the output is too huge, chances are, not all lines are displayed. Continue Reading
Create React Native Project – Working Setup for Android
This post demonstrates a working setup of React Native project. Continue Reading
Laravel 5.7 Mailgun Configuration
Configuring Laravel to use Mailgun is easy. We only need an account at mailgun.com and, for testing, some authorized recipient email address. Continue Reading
Using pgloader in docker container for host’s databases
This post demonstrates how to migrate from MySQL to PostgreSQL instance running in Windows using pgloader running in a Docker container. Continue Reading
Convert TypeScript to JavaScript
This post demonstrate the basic process of converting TypeScript codes to JavaScript. Continue Reading
Recent Comments