Audit trail with schema versioning for PostgreSQL using transaction-based logging
-
Updated
Mar 11, 2025 - PLpgSQL
#
jsonb
Here are 9 public repositories matching this topic...
Use JSON objects to generate PostgreSQL WHERE clause expressions.
-
Updated
Oct 18, 2017 - PLpgSQL
A Snodgrass standard implementation of bitemporal beahvior without special extensitons
-
Updated
Nov 19, 2025 - PLpgSQL
Lightweight and extensible PostgreSQL DML audit solution - Automatic trigger management, per-schema control, structured JSONB logs for tracking INSERT, UPDATE, and DELETE operations.
auditing dml logging postgresql plpgsql jsonb triggers change-tracking database-security database-audit logging-system
-
Updated
Nov 8, 2025 - PLpgSQL
Star-schema data mart on PostgreSQL built from Goodbooks CSVs. Demonstrates advanced SQL (window functions, JSONB, GROUPING SETS), indexes (covering/partial/GIN/pg_trgm), materialized views, incremental MERGE loads, pgTAP tests, and GitHub Actions CI. Includes Docker quickstart and SSH-tunnel instructions
docker performance sql etl analytics dml postgresql indexing data-warehouse full-text-search jsonb data-modeling pgtap data-mart materialized-views star-schema window-functions grouping-sets pgtrgm
-
Updated
Oct 6, 2025 - PLpgSQL
🗄️ Learn PostgreSQL through real-world scenarios, hands-on exercises, and advanced patterns, guiding you from beginner to expert.
docker sql database analytics postgresql postgis performance-tuning database-administration full-text-search jsonb data-modeling data-quality database-design learning-resources row-level-security database-monitoring database-tutorial postgres-advanced
-
Updated
Dec 15, 2025 - PLpgSQL
Novaera SaaS ERP Database provides a dynamic PostgreSQL architecture with metadata-driven modules, tables, and JSONB records, enabling flexible ERP customization through robust stored procedures and comprehensive role-based permissions.
postgresql plpgsql dynamic-modules jsonb database-schema stored-procedures backend-development role-permissions saas-erp metadata-architecture
-
Updated
Nov 17, 2025 - PLpgSQL
Complete PostgreSQL project with 16 progressive modules covering fundamentals through advanced topics. Features realistic urban datasets for practical experience with PostGIS, JSONB, performance optimization, security patterns, and production deployments. Includes Docker setup for immediate use.
docker sql database analytics geospatial postgresql postgis performance-tuning database-administration full-text-search jsonb data-modeling open-source-project data-quality database-design learning-resources row-level-security database-monitoring database-tutorial postgres-advanced
-
Updated
Sep 1, 2025 - PLpgSQL
Improve this page
Add a description, image, and links to the jsonb topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the jsonb topic, visit your repo's landing page and select "manage topics."