Categories:

Very often, you will have the requirement to concatenate two columns in a table, on the fly in SELECT SQL. For example, first name and last name needed to be combined at username. The + operator is available in MicroSoft's database servers, but it is not part of PostgreSQL or SQL standard. PostgreSQL very well support string concatenation in SQL results. Let us assume that we have a table like

Categories:

PostgreSQL could be configured to limit number of simultaneous connections to the database. The heroku comes with plans having connection limits. The 'Hopby' plans comes with 20 connections where as standard plans comes startings with 120 conection. When we start developing and testing, especially automated testings, the hobby plans raise error PG::Error (FATAL: too many connections for role "xxxxxxx"). If we check the connections with heroku cli, we get

Categories:

Python Python is an interpreted(processed at runtime by the interpreter), object-oriented(supports Object-Oriented style), interactive, simple, easy to learn, portable, extensible, embeddable, high-level programming language for general-purpose programming. Created by Guido van Rossum at the National Research Institute for Mathematics and Computer Science in the Netherlands and first released in 1991. Python is derived from ABC, Modula-3, SmallTalk, Algol-68, C, C++, Unix shell and other scripting languages.Python's source code is avaliable under the GNU General Public License (GPL) which guarantees end users the freedom to run, study, share and modify the software.

Categories:

Python is an interpreted(processed at runtime by the interpreter), object-oriented(supports Object-Oriented style), interactive, simple, easy to learn, portable, extensible, embeddable, high-level programming language for general-purpose programming. Created by Guido van Rossum at the National Research Institute for Mathematics and Computer Science in the Netherlands and first released in 1991. Python is derived from ABC, Modula-3, SmallTalk, Algol-68, C, C++, Unix shell and other scripting languages.Python's source code is avaliable under the GNU General Public License (GPL) which guarantees end users the freedom to run, study, share and modify the software.

Categories:

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 described in few simple steps. The local system has a super user named 'postgres' in the Linux, who can login to local database without password. The operating System - Linux - does have the user postgres, but the password is unknown. The solution is to login to the system as a user with super user privileges. Then use sudo and su commands to login as postgresql

Categories:

When we come to SEO, we usually think about meta tags, structured data etc. But what can a designer/HTML developer do with SEO? HTML developers are the one to start with SEO. They need to take utmost care when starting to build a web page. If they put an image names 1.jpg and the image is actualy that of a car, it wont hep SEO.But for an article about a car, the image car.jpg helps a lot.