Discover the art of custom logging and change tracking in OutSystems with our latest article. This first part of a two-part series dives deep into the core concepts of developing bespoke logging and tracking solutions. Learn how to lay the groundwork for an effective, reusable, and adaptable system tailored to fit the unique demands of your OutSystems applications.

Databases handle thousands or even millions of records, and they need to be able to return results in milliseconds. Thus, it is imperative to optimize data fetching: indexes. This article explains indexes and how to implement them in OutSystems.

Have you ever been faced with a hierarchical data tree where you need to get a specific path or make a validation before adding/editing a node? In this post, we’ll show you how to do that by using CTEs / CONNECT BY on advanced queries on SQL and Oracle.

To show you how you can optimize your queries to fetch only the records you want or how to apply some logic to manage heavy tables, let’s go on a trip where we’ll visit our beloved aggregates and, the ones feared by many, SQL queries.