2 posts found under,


There are 3 basic rules for keeping user credentials secure: NEVER store passwords as plain text. ALWAYS use a random salt when encrypting passwords. DO NOT roll your own crypto. Lucky for us, the pgcrypto module in PostgreSQL makes it very easy to follow these rules. Let us take a look at an example. First, we need to enable pgcrypto: CREATE EXTENSION pgcrypto; Then, we can create a table for storing user credentials: CREATE TABLE users ( id

Many applications require keeping track of when database records are created and updated. In PostgreSQL, we can track creation date by adding a created_at column with a default value of NOW(). However, for tracking updates, we will need to make use of triggers. Triggers allow us to define functions to be executed whenever a certain type of operation is performed. In this case, we will need to make sure that before any UPDATE operation, PostgreSQL

Scale your
Development team

We help you execute projects by providing trusted developers who can join your team and immediately start delivering high-quality code.

Hire Developers