Some queries, mostly reporting ones, have to be optimised when they use tables with millions of rows because their execution times make them unusable. We will see how to improve their performance including certain features that are specific for Oracle databases.
Category Archives: Development
Contract testing using Spring Cloud
As applications grow it is normal to break them down into smaller pieces that are easy to combine and maintain. The challenge comes in the integration between these pieces as an small change in one of them may break the communication with the others, and we may not notice it until we get emails from users. We are going to see how to detect this automatically using contract testing.
Continue reading
How to handle the lack of transactions across microservices using the Saga pattern
One of the challenges of using microservices is the lack of transactions in operations that span multiple services. We will see how to solve it using a standard patten.
Continue reading
How to do pagination across domains in microservices architectures
One of the challenges of the microservices architectures is that the data is managed by different services what makes difficult to do queries across multiple domains. Let’s see a few approaches and the advantages and drawbacks of each of them.
How to integrate your applications with external systems
Organisations cannot work on their own as they have to integrate with customers and suppliers. I will explain some of the integration types I have worked on until now.
How to model user data using SQL and NoSQL databases
There are many debates about which type of database is better. I will focus on how to use them for a specific case and how to evolve the design as needed.
The importance of code quality in IT projects
Code quality is usually underrated in some organisations because it is an aspect that customers don’t see and don’t pay for. However it is quite important in both the short and long term. I will expose some of the reasons.
The importance of the stabilisation periods
Startups are usually in a rush to deliver features as fast as possible to compete with other companies. However this makes them sometimes go slower and lose customers. Let’s see why it is important to dedicate some time to stabilise the platform.
Takeaways about security from Devoxx
I have assisted this week to a technical event called Devoxx and have tried to learn as much as possible about security because it is the area in which I have to improve most. I will summarise what I have learnt as many of you may also be interested in it.
Lessons learnt helping grow an engineering team
Startups usually have a big growth after receiving investments. Many people think that the challenge is to find the candidates in a city as competitive as London, but that’s the easy part. I will share what I learned being part of a team that multiplied its size in just a few months