The text explains the complexities of working with time in PostgreSQL, including the differences between timestamp and timestamptz, time zones, time functions, intervals, and timestamp ranges. It provides examples and practical us...
About:
Radim Marek is a consultant and educator passionate about SQL and PostgreSQL, offering resources and insights to help developers master these technologies.
Website:
Specializations:
Interests:
Outgoing Links:
Subscribe to RSS:
0VIEW inlining in PostgreSQL
2025-02-08 • mysql optimization sql postgresql
The text discusses the power of database VIEWs and how they can make developers' lives easier by organizing and reusing common logic. It also explores how PostgreSQL can optimize these views through a process called 'inlining', ma...
0DELETEs are difficult
2024-11-23 •
The article discusses the complexities of DELETE operations in databases, the impact of DELETEs on database performance, and strategies to handle DELETE operations effectively. It explains the intricacies of DELETE commands, the r...
0Text identifiers in PostgreSQL database design
2024-11-09 •
The text discusses the use of text identifiers in PostgreSQL database design, highlighting the reasons for and against using them, and strategies for using them effectively. It emphasizes the need for a balance between leveraging ...
0We need to talk about ENUMs
2024-09-04 •
The article discusses the use of ENUMs in PostgreSQL, highlighting the improvements in support over the years. It explains how ENUMs are implemented, their lifecycle, and limitations. It also explores using CHECK constraints and r...
0Beyond Simple Upserts with MERGE in PostgreSQL
2024-08-25 •
The article discusses the MERGE command in PostgreSQL, comparing it with traditional upsert methods and examining how it can streamline database operations. It provides practical examples and explains how MERGE can simplify comple...
This article provides a gentle introduction to window functions in PostgreSQL, explaining their importance in analyzing data and their differences from aggregate functions. It covers the syntax, components, and practical applicati...
0The time keepers: pg_cron and pg_timetable
2024-06-15 •
The article discusses the importance of job scheduling in PostgreSQL and explores two distinct PostgreSQL-specific tools for scheduled task automation: pg_cron and pg_timetable. It compares the features of both tools and provides ...
The text is the third part of a series called 'Deep Dive into PostgREST' and focuses on authentication and authorization options. It discusses using pgcrypto extension for password hashing, JWT authentication, and fine-grained aut...
0Custom PostgreSQL extensions with Rust
2024-05-24 •
The article explores the pgrx framework, which simplifies the creation of custom PostgreSQL extensions using Rust. It discusses the system load average and how to create a PostgreSQL extension with a function called sys_loadavg() ...
The text is a detailed guide on using PostgREST to create a dedicated API schema for a 'Time Off Manager' application. It covers setting up the schema, creating views, implementing business logic, and managing workflow for time of...
The text is a detailed guide on building a Time Off Manager application using postgREST, focusing on the application logic and exposing raw data. It covers creating a database, setting up the users model, exposing users using post...
0How not to change PostgreSQL column type
2024-05-04 •
The text discusses the complexities of changing a column type in PostgreSQL, highlighting the discrepancy between practice and theory, and the challenges involved in the process. It provides a step-by-step guide to properly change...
0The Bloat Busters: pg_repack vs pg_squeeze
2024-04-27 •
The article discusses the challenges of table bloat in PostgreSQL databases and compares two solutions, pg_repack and pg_squeeze, to help users decide which one is better for their specific use case. It explains the limitations of...
The author reflects on their past perception of databases as boring and unnecessary, and how they have come to appreciate the reliability and importance of databases, particularly PostgreSQL. They emphasize the enduring significan...
0When and Why PostgreSQL Indexes Are Ignored
2024-04-14 •
The text explains why PostgreSQL indexes might be ignored, including cases of missing conditions, the importance of column order, low selectivity, and outdated statistics. It emphasizes the need for thoughtful implementation and m...