Tag: Postgres

14 Jan, 2020
Finding Diacritics in a Postgres Table
Recently I had the task to find all the Diacritics in a database table. I had to find an easy way to select every row that has a diacritic in the name. The solution was surprisingly simple, but a bit unintuitive. In this article, I will provide you with...

20 Apr, 2017
Taming of the Subselect: Three ways to use this troublesome SQL Query
Subselects can be used in many ways: filtering, retrieving specific data, and creating custom joins. Writing effective SQL using subselects, though, can be frustrating. While SQL is ubiquitous in software engineering and is a valuable skill for testing, data analysis and reporting, nowadays a lot of SQL is abstracted...

24 Aug, 2016
Springing the JSON Template into Postgresql
Two popular open source components used in full stack development are Spring and Postgres. Spring gives the developer a plethora of opportunities to integrate with third party ORM libraries, such as Hibernate and iBatis. Frequently, rather than use a separate ORM library, developers elect to use the Spring JDBC...