Passing Arrays to a PostgreSQL PL/pgSQL Function

It can be handy to pass a collection of strings to a PL/pgSQL stored function via a PostgreSQL array. This…

Read More »

The Latest Twist in the Java IDE Wars: Subscription-based IntelliJ IDEA

I’ve been watching with some interest the discussion surrounding this past week’s announcement that JetBrains is moving to an Adobe-like…

Read More »

Setting PostgreSQL psql Variable Based Upon Query Result

When using PostgreSQL‘s psql command-line tool to interact with a PostgreSQL database via operator interaction or script, it is not…

Read More »

Procedure-Like Functions in PostgreSQL PL/pgSQL

PostgreSQL does not support stored procedures in the sense that a database such as Oracle does, but it does support…

Read More »

Java Numeric Formatting: DecimalFormat

In the post Java Numeric Formatting, I described and demonstrated some of the useful instances provided by NumberFormat static methods…

Read More »

Using Hibernate Bean Validator in Java SE

The main Bean Validation page states that “Bean Validation is a Java specification which … runs in Java SE but…

Read More »

Windows Registry Cleanup after JDK 9 Early Release Installation

In my last blog post, I demonstrated resolution of issues surrounding the Oracle Java symbolic links (C:\ProgramData\Oracle\Java\javapath\ directory on Windows-based…

Read More »

Oracle Java on Windows

I recently downloaded an early access release of JDK 9 (build 68) for my Windows 7-based laptop. Because this is…

Read More »

Generating JSON Schema from XSD with JAXB and Jackson

In this post, I demonstrate one approach for generating JSON Schema from an XML Schema (XSD). While providing an overview…

Read More »