from SHIFT ASIA

Database

8 posts
Pages and Blocks in SQL Databases
Database
members

Pages and Blocks in SQL Databases

A page is the smallest unit of data that a database system reads from or writes to disk, and the smallest unit of memory allocation.
King
King
Understanding SQL Execution Plans
Database
members

Understanding SQL Execution Plans

A database execution plan is a detailed roadmap generated by a database management system (DBMS) to illustrate how a specific SQL query will be executed
King
King
Vector Databases - Explained for Developers
AI
members

Vector Databases - Explained for Developers

As AI systems become more powerful, they also need smarter ways to store and search information. Traditional databases–build for rows, columns, and exact matching–struggle when dealing with meaning. T
MINATO Nguyen
Why Your Database Needs Boundaries: An Intro to PostgreSQL's Row Level Security (RLS)
Database
members

Why Your Database Needs Boundaries: An Intro to PostgreSQL's Row Level Security (RLS)

Most Data Leaks Start With a Missing FilterIf you're building a modern software-as-a-service (SaaS) application, especially one that serves multiple companies or users from a single database, you've l
Fred Pham
Fred Pham
Types of SQL Joins: A Complete Guide for Beginners
Database
members

Types of SQL Joins: A Complete Guide for Beginners

When working with relational databases, your data is often split across multiple tables. To extract meaningful insights, you need a way to combine this data efficiently. That’s where SQL joins come in
Thiago
Understanding NoSQL: Advantages and Real-World Use Cases
Database
members

Understanding NoSQL: Advantages and Real-World Use Cases

In today’s data-driven world, flexibility, speed, and scalability are essential. That’s why NoSQL databases have become a go-to solution for modern applications. Whether you're building a real-time ch
Happy
Understanding Database Indexing: The Key to Faster Queries
Database
members

Understanding Database Indexing: The Key to Faster Queries

What is Database Indexing?Think of a database index like the index of a book. Instead of flipping through every page to find a topic, you can jump directly to the page number listed in the index. Simi
Happy
N+1 queries problem and how to resolve
Database
members

N+1 queries problem and how to resolve

The N+1 query problem is a common performance bottleneck in applications that interact with databases.It occurs when an application executes N additional queries to retrieve data that could have been
Kingsley