Programming FlashCards - Learn Coding Concepts

Filter by Technology

PostgreSQL Unlogged Tables

Unlogged tables are high-performance tables that skip writing to the write-ahead log (WAL), providing faster writes at the cost of durability and crash recovery.

PostgreSQL

PostgreSQL Range Types

Advanced data type for storing ranges of values with built-in range comparison and overlap operations, useful for time, date, and numeric ranges

PostgreSQL

PostgreSQL Async Notifications

Use LISTEN and NOTIFY for real-time inter-process communication within the database, enabling event-driven architectures without external messaging systems.

PostgreSQL

PostgreSQL LISTEN NOTIFY

Asynchronous inter-session communication mechanism allowing real-time event notifications across database connections without polling.

PostgreSQL

EXPLAIN ANALYZE

Detailed query performance analysis tool in PostgreSQL that shows actual execution plan, runtime statistics, and helps optimize query performance.

PostgreSQL

PostgreSQL Array Aggregation

Combine multiple rows into a single array column using array_agg() function, useful for grouping and transforming query results efficiently.

PostgreSQL

Partial Index

Create an index on a subset of rows that match a specific condition, reducing index size and improving query performance for filtered data.

PostgreSQL

PostgreSQL Pub/Sub

Use LISTEN and NOTIFY for real-time event-driven communication between database sessions without external messaging systems.

PostgreSQL

CTE Recursion

Common Table Expressions (CTEs) in PostgreSQL support recursive queries, enabling complex hierarchical data traversal like organizational structures or tree-like data.

PostgreSQL

JSONB Column Type

PostgreSQL's JSONB data type allows storing JSON data with efficient indexing and querying capabilities, supporting complex nested structures.

PostgreSQL

JSONB Indexing

Learn how to create efficient indexes on JSONB columns to speed up queries on JSON data in PostgreSQL

PostgreSQL

JSONB Operators

Powerful JSON manipulation operators in PostgreSQL that allow efficient querying, updating, and extracting data from JSONB columns with advanced filtering.

PostgreSQL

Lateral Joins

PostgreSQL's LATERAL JOIN allows subqueries in FROM clause to reference columns from preceding tables, enabling more complex and dynamic query structures.

PostgreSQL

Table Inheritance

PostgreSQL supports table inheritance, allowing child tables to automatically inherit columns and constraints from a parent table, enabling hierarchical data modeling.

PostgreSQL

Window Functions

PostgreSQL window functions perform calculations across a set of rows related to the current row, enabling advanced analytics without reducing result rows.

Previous Page 1 of 1 Next