{"repo":"h4kbas/pgcalendar","free":true,"listed":false,"github":"https://github.com/h4kbas/pgcalendar","clone":"git clone https://github.com/h4kbas/pgcalendar.git","description":"A PostgreSQL extension that provides infinite calendar functionality for recurring schedules with exceptions.","language":"TypeScript","stars":141,"topics":["calendar","event-management","exceptions","pgxn","postgresql","postgresql-extension","recurrence","recurring-events","scheduling","sql"],"license":"MIT","category":"databases-storage","readme_excerpt":"pgcalendar - Infinite Calendar Extension for PostgreSQL A powerful PostgreSQL extension for managing recurring events with infinite projections, multiple schedule configurations, and exception handling. Overview pgcalendar provides a robust system for managing recurring events where: - Events represent logical entities (meetings, tasks, etc.) - Schedules define non-overlapping time configurations that generate projections - Exceptions modify individual instances (cancellations, modifications) - Projections are the actual calendar occurrences generated from schedules Installation Prerequisites - PostgreSQL 12.0 or later - PostgreSQL development tools (for building from source) Method 1: Install from PGXN (Recommended) Method 2: Install from Source Method 3: Manual Installation Method 4: Direct SQL Installation Verification Quick Start Usage Examples Daily Schedule Weekly Schedule Monthly Schedule Yearly Schedule Adding Exceptions Multiple Schedule Configurations Advanced Functions Schedule Transition Safely transition to a new schedule configuration without overlaps: Overlap Checking Check if a schedule would overlap with existing schedules: Querying Projections Get Projections for an Event Get All Events with Details Use the Calendar View Schema Reference Tables - events - Main event definitions - schedules - Non-overlapping schedule configurations - exceptions - Individual projection modifications Functions - get event projections(event id, start date, end date) - Get projec","default_branch":null,"files":null,"tree":[],"storefront":"/r/h4kbas","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/h4kbas/pgcalendar/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}