#REVIEW: SQL Performance Explained

Recently I’ve read the book SQL Performance Explained from Markus Winand (@MarkusWinand) and want to give you a review of this excellent book about SQL performance. The book contains the following chapters: Anatomy of an Index The Where Clause Performance and Scalability The Join Operation Clustering Data Sorting and grouping Partial Results Modifying Data Execution…

#HOWTO: Writing PostgreSQL functions with Java using PL/Java

The PostgreSQL RDBMS offers a great variety for writing server-side functions and with PostgreSQL 11 now also stored procedures. PostgreSQL comes with a language named PL/pqSQL which enhances plain SQL with control flow predicates and is similar to Oracle’s PL/SQL proprietary language. Besides this SQL-like language, PostgreSQL also offers built-in support for using Perl 5, Python and TCL as possible…