Mar 12 · 2 min read · Here is the correct way to create a PostgreSQL database, user, and give full permissions on Ubuntu. 1️⃣ Login to PostgreSQL sudo -i -u postgres psql 2️⃣ Create Database CREATE DATABASE "the-ai-shift
Join discussion
Feb 4 · 2 min read · psql is the interactive terminal client for PostgreSQL. It lets you connect to databases, run SQL queries, and use powerful meta commands for database management. Connecting to PostgreSQL (Note : here the user is named as “potatoes“, and DB as “mypo...
Join discussion
Jan 19 · 6 min read · Partition is a very sensitive topic for some people. Like the 1947 India-Pak partition which lead to so many families getting devasted. But some partitions are not that bad. For e.g., partitioning your relational table. This blog talks about the good...
Join discussion
Dec 31, 2025 · 8 min read · If you are a beginner in your developer journey tasked with optimizing a database query, you must have read about applying indexes. But not all indexes bring performance gains. Some can even degrade it. Read this blog before your create your next ind...
Join discussion
Dec 22, 2025 · 5 min read · Postgres or PSQL Database is a type of relational database widely used across the industry. Various big tech corporations across the globe use it to store mission-critical data. The language it understands is SQL. People are already familiar with man...
Join discussion
Nov 11, 2025 · 3 min read · Oracle APEX combina lo mejor del desarrollo declarativo con el poder del código PL/SQL, y si ya viste cómo podemos aplicar estilos dinámicos con APEX_CSS, ahora vamos un paso más allá: inyectar y ejecutar código JavaScript directamente desde PL/SQL. ...
Join discussion
Sep 14, 2025 · 20 min read · When working with PostgreSQL as a DBA, DevOps, or SRE, one of the most important concepts you’ll deal with is how PostgreSQL manages memory and disk I/O. Today, I explored shared buffers, dirty pages, checkpointers, and even ran some hands-on queries...
Join discussionAug 18, 2025 · 5 min read · Managing PostgreSQL roles securely is crucial, especially when decommissioning application users or consolidating database accounts. Simply dropping a role can fail if it owns objects, databases, or has privileges scattered across multiple databases....
Join discussion
