#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

Read More

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 (similar to Oracle’s PL/SQL). Besides this SQL-like language, PostgreSQL also offers built-in support for using Perl 5, Python and TCL as possible languages to implement functions

Read More

Simple database documentation with SchemaSpy

Recently I was looking for a simple solution to generate visual documentation of the underlying database. The solution should be easy to use, database vendor-independent and automatable e.g. during the CI pipeline. Therefore I found SchemaSpy (GitHub – Homepage) which is a single jar file and is able to generate nice-looking web-based documentation like the following: Sample

Read More