PinnedVedran BilopavlovićinDev GeniusWhy I Always Use PostgreSQL Functions For EverythingAs a general rule, every single command or query for the application use — I always wrap up in a PostgreSQL user-defined function!Aug 2711Aug 2711
PinnedVedran BilopavlovićUnit Testing and TDD With PostgreSQL is EasyNote: this is a repost from my personal blog: Unit Testing and TDD With PostgreSQL is EasyJul 32Jul 32
Vedran BilopavlovićAutomatic Temporal Tables Schema Management With PostgreSQLIn my previous article, I explored a simple way how to automatically create and maintain temporal tables with historical data using nothing…Aug 22Aug 22
Vedran BilopavlovićPostgreSQL Utility FunctionsThese are some PostgreSQL utility functions that someone may find useful when either doing PostgreSQL administration or development.Aug 20Aug 20
Vedran BilopavlovićCustom Temporal Tables in PostgreSQLDescription of a simple, trigger-based solution that enables temporal features on selected tables in the PostgreSQL database.Aug 8Aug 8
Vedran BilopavlovićPostgreSQL Arrays 🐘Traditionally in relational databases, many-to-many data design is implemented using three tables.Jul 15Jul 15
Vedran BilopavlovićModern Software Architecture is a JokeSQL is the most misunderstood language in computer history. By far.Jul 62Jul 62