We are in 2019. Who uses triggers you may wonder? That's a valid question. But if you plan to do a database migration you may find them handy. Let's say that part of the migration you create new separate schema which you plan to use it for the new version. Or you could break one… Continue reading Triggers and deadlocks – MySQL
Java 12 Features (GC Saga continues)
It was released on March 19, 2019. It's a non LTS release. Here's an overview of the most relevant updates for developers. Switch Expressions It has passed a long time since the last update to switch statement, more specifically the switch on strings in JDK 7. Five versions later we have a new update. switch… Continue reading Java 12 Features (GC Saga continues)
Java 11 features
It was release on September 25, 2018. This version has LTS so it is recommended to upgrade to this one in production. Unfortunately this is the first version that we need to pay for(oracle version). The openjdk is still open-source so this will be the choice for most of the developers. Oracle version is free… Continue reading Java 11 features
Deadlocks 101 – MySQL
Ahh deadlocks. Few words have the same impact as this in the software world. Doesn't matter if you're a DBA or developer you will get impatient. Some deadlocks take days for fixing, they are hard to reproduce, some of them reproduce only on prod machines. It's not unusual to do blind fixes, you just don't… Continue reading Deadlocks 101 – MySQL
Java 10 features
It was released on March 20, 2018. It is a short-term release without LTS support. Let's get into details. Local-Variable Type Inference Ahh...good'ol javascript. Well this is more like a sugar syntax. Instead of declaring inside a method a local variable with private void method(){ List<String> strings = new ArrayList<>(); // do other stuff }… Continue reading Java 10 features
Java 9 features
Java 8 release represented a new stepping stone in the history of java. It marks the transition to functional style programming. Most of us are working with 8, but let's see what it was introduced in 9. It is a minor release, but we must understand where java is going because of the 6 month… Continue reading Java 9 features
B-Tree index structure
At some point we all worked with a relational database. We all had problems with query performance and we fixed them usually by first looking at indexes. We looked at the columns, at the foreign key for the presence of an index. We noticed there some kind of B-tree structure. Now I'm gonna explain how… Continue reading B-Tree index structure