Open in app

Sign In

Write

Sign In

John Alvin Salamat
John Alvin Salamat

32 Followers

Home

About

May 22

Viewing SQL Execution Plans in OutSystems using SQL Sandbox

A lot of what’s happening in our OutSystems app is driven by data and it’s essential that we gain visibility on how queries run inside the database. SQL Execution Plan is a graphical representation of the various steps involved in retrieving data from tables/entities. After executing SQL queries in OutSystems…

Outsystems

3 min read

Viewing SQL Execution Plans in OutSystems using SQL Sandbox
Viewing SQL Execution Plans in OutSystems using SQL Sandbox
Outsystems

3 min read


Mar 7

Optimizing paged SQL queries in OutSystems

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.

Outsystems

2 min read

Optimizing paged SQL queries in OutSystems
Optimizing paged SQL queries in OutSystems
Outsystems

2 min read


May 18, 2022

SQL Query optimization using Statistics in OutSystems

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…

Outsystems

4 min read

SQL Query optimization using Statistics in OutSystems
SQL Query optimization using Statistics in OutSystems
Outsystems

4 min read


Nov 11, 2021

Joining external database through JSON in OutSystems

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…

Outsystems

3 min read

OutSystems joining external database table through JSON
OutSystems joining external database table through JSON
Outsystems

3 min read


Sep 29, 2021

Hand and Face Tracking using Handtrack.js in OutSystems

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…

Handtrack

3 min read

Hand and Face Tracking using Handtrack.js in OutSystems
Hand and Face Tracking using Handtrack.js in OutSystems
Handtrack

3 min read


May 28, 2021

Mario Kart in OutSystems

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

Outsystems

1 min read

Outsystems

1 min read


Mar 26, 2021

Asynchronous Data Refresh in OutSystems

I wanted to start by sharing the average attention span study

Outsystems

3 min read

Asynchronous Data Refresh in OutSystems
Asynchronous Data Refresh in OutSystems
Outsystems

3 min read


Feb 7, 2021

At this stage, most of the major browsers support PWA but there are some differences on how they…

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…

3 min read

At this stage, most of the major browsers support PWA but there are some differences on how they…
At this stage, most of the major browsers support PWA but there are some differences on how they…

3 min read


Dec 12, 2020

UI Test Framework for OutSystems

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…

Ui Testing

3 min read

UI Test Framework for OutSystems
UI Test Framework for OutSystems
Ui Testing

3 min read


Aug 23, 2020

OutSystems PWA Interoperability — Desktop, Tablet and Mobile

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…

Pwa

3 min read

OutSystems PWA Interoperability — Desktop, Tablet and Mobile
OutSystems PWA Interoperability — Desktop, Tablet and Mobile
Pwa

3 min read

John Alvin Salamat

John Alvin Salamat

32 Followers

Tech lead @ PhoenixDX | MVP

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech