PostgreSQL: constraints
In PostgreSQL, constraints are rules applied to columns or tables ti prevent invalid data from entering the database. They ensure the accuracy, reliability and integrity...
Search Results
Blog Archive
Explore by topic
HUML: Human-oriented Markup Language
So I am scrolling youtube and I got this video of Kailash Nadh explaing HUML and how it solve some of the hard bit on...
PostgreSQL: ALTER TABLE command
In SQL, the ALTER command is used to modify the structure of an existing database object such as a table, column, or constraint. Unlike the...
PostgreSQL: Sorting, Filtering & Aggregation
These three operations are typically performed using the following clauses in a SELECT statement: Operation SQL Clause Function Filtering WHERE Selects which rows to include...
PostgreSQL: data types
Understanding data types is foundational for optimizing database design, ensuring data integrity, and enhancing application performance. Choosing the Right Data Type Selecting the proper data...
CRUD operations in PostgreSQL
CRUD operations in PostgreSQL are the four basic actions you perform on table data: Create, Read, Update, Delete. These are done with standard SQL commands that...
Postgress: Login to a PostgresSQL
Logging in Using pgAdmin Logging in Using psql Command Line Commands List all databases Connect to the database named postgres Disconnect Create database Drop database...
PostgreSQL: Database vs Schema vs Table
As the above image represents “Database vs Schema vs Table,” these are the fundamental hierarchy in a PostgreSQL (and most relational) database system. 1. Database...
GraphQL vs REST API
GraphQl and REST(Representational State Transfer) are popular architecture for designing APIs to exchange data between a client and server. They achieve the same goal but...
JWT-based authentication system for WordPress
A modern, JWT-based authentication system for WordPress that provides enhanced security, REST API endpoints, OTP verification, and mobile app support. This plugin transforms WordPress from...