Create a database, create a user and grant privileges in PostgreSQL Database

To create a database, create a user and grant privileges to the user on command line is often a requirement only when a new project is initialized. The process is …

PG::Error (FATAL: too many connections for role "xxxxxxx")

PostgreSQL could be configured to limit number of simultaneous connections to the database. The heroku comes with plans having connection limits. The 'Hobby' plans comes with 20 connections where as …

Concatenate two columns in results of SQL query in PostgreSQL

Very often, you will have the requirement to concatenate two columns in a table, on the fly in SQL. For example, first name and last name needed to be combined …

Django - check for null in database

In django, the NULL valuein the database field is tested with field lookup It takes eitheror, which correspond to SQL queries ofand, respectively. Example: SQL equivalent:

Search database with regular expression in Django

Regex and iregex are the two field lookups that enable us to search database with regular expressions. regex is case-sensitive where as iregexis case-insensitive. The regular expression syntax is that …

Django database Aggregate functions Cheat sheet