In OutSystems, SQLs help address complex data requirements. Often, we consider optimization by retrieving only data that’s needed a.k.a lazy loading . One of the common ways to do this is paging the data.

SQL Sandbox has been part of every project that I’ve worked on. It’s my go-to tool to have a view on data and to build complex queries. In query performance consideration, we rely a lot on the time the query gets executed but undeniably sometimes this is not enough to…

Data is King — you’ll see this phrase everywhere. When talking about enterprise level applications you would more than likely come across with a requirement of joining data from different databases from different systems. OutSystems does not support joining tables from two different databases due to inefficiency it will bring…

A lot of things are changing due to pandemic and technology is the number one channel to help address the remoteness that this event brought to us. My country, Philippines, is one of the heavily affected countries and I could imagine that even after getting the right numbers in terms…

I came across with an interesting use case seeing my daughter playing an online game where mobile is used as the controller and the game is loaded on TV browser. With knowledge in web socket, I immediately thought that this can be done using OutSystems. I spent some time trying to figure out what I could do as a proof of concept and found this 14kb Mario Kart Javascript code written by Jacob Seidelin. I port it in Reactive web application and downloaded the component Firestore in Forge. After spending like 6h here’s what I’ve come up

I wanted to start by sharing the average attention span study

At this stage, most of the major browsers support PWA but there are some differences on how they adopt it. With PWA getting more popularity and traction, I recently dealt with a proof of concept where I will need to offer a better UX in installing a.k.a “add to home…

Don’t have to reinvent the wheel just attach it to a new wagon. -Mark McCormack Yet another Test Framework? While UI testing seats at the top part of the Test Pyramid, there are advantages that you can get in having them. UI encapsulates a lot of operations, things like services…

I have been asked a few times before whether there’s a way that a developer could build a single solution that would work both mobile and web. Unfortunately, back then I didn’t have a good answer until I worked with my recent project that gave me a chance to work…