Is it worth taking part in this race of projects proliferation or would you rather improve an existing product and provide more and more value?
Author Archives: andronicust
Ignore nulls in Postgres
Despite the lack of ignore nulls syntax in postgres, we can mimic the required behavior by defining custom aggregates. Albeit being simple, it has several advantages.
Oracle SQL certificate – is it worth it?
Some time ago I have passed an exam 1Z0-071 Oracle Database SQL and received the certificate. I have stumbled across many problems, majority of them being of organizational nature. Here is a wrap up of how it looks like and what to expect. Note: I am not going to address the content of the exam, particularContinue reading “Oracle SQL certificate – is it worth it?”
[My] Top 7 JPA and SQL performance pitfalls [EN]
Some time ago I had a pleasure to speak at Wrocław JUG about performance issues I have faced when working with persistence layer. These are not the most frequent ones, but rather the most tricky – not visible at the first sight and causing quite a lot of trouble in production.
Poor man’s fuzzy search
0. The problem When I hear the term fuzzy searching, I think of high computation cost, but this is not always the case. In the great book Art of Computer Programming by D. Knuth, vol. 3, ch. 6: Searching we can read about the soundex algorithm. It was originally used to deal with misspelled EnglishContinue reading “Poor man’s fuzzy search”
Java’s type parameter’s and wildcard’s (lack of) equivalence
Yet another post based on an interesting question I have encountered on StackOverflow quite a while ago. But let us start with a slightly different thing. Once upon a time there was a question: what is the difference between ? extends Sometype and T extends Sometype? For example: <? extends Number> and <T extends Number>Continue reading “Java’s type parameter’s and wildcard’s (lack of) equivalence”
Top mistakes when working with JPA (Hibernate) and SQL [PL]
Recently I have given a talk about top (in my opinion) performance issues we are challenged with when working with JPA (Hibernate) and SQL (Postgres, Oracle). The talk is in polish.
Calculating moving median in Postgres
0. The problem Some time ago I’ve stumbled on this interesting question on stackoverflow (as stated in the title). I could not find any satisfactory answer at that time, so I came up with this solution. I think the problem is interesting enough to make it into a blog post. The following table shows theContinue reading “Calculating moving median in Postgres”
Hello world
Most of the adventures in the IT world start with the hello-world project. In this post I’d like to introduce myself and highlight the topics I’ll cover here. My name is Jędrzej. Currently, I live in Wrocław, Poland. I’m a full-stack developer at iteratec, where my main responsibility is to develop a backend of aContinue reading “Hello world”