2 posts found under,

postgresql

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 use [...]

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
postgresql