image post

Better Queue in Node JS

Move heavy processing task to background with better-queue module in Node.js
Aug 03, 2020
A good practice in software development is to delegate as much heavy work as possible to background jobs to avoid blocking the main execution of your application that can be a web app, mobile app, or desktop.

image post

How to convert sforce.apex.execute to Lightning

Use a Lightning Component to make your JavaScript buttons work when your move to Lightning Experience
Jun 18, 2020
Let’s see how to convert a Salesforce JavaScript button that uses sforce.apex.execute in to Lightning Experience. The good news is you will reuse this code and the approach for all your similar buttons.

image post

Migrate sforce.connection.query to Lightning equivalent

Use Lightning Components to move your JavaScript buttons implemented for Classic
Jun 18, 2020
As you probably know, JavaScript buttons are not supported in Lightning Experience (LEX). In particular, you can’t use REQUIRESCRIPT. In this post, the idea is to show how to migrate a particular JavaScript button that uses sforce.connection.query sentence.

image post

javascript lazy load images

javascript lazy load images
Aug 31, 2021
javascript lazy load images


image post

Test Driven Development (TDD) in a nutshell

Jul 24, 2020
Every project has somewhere in the src folder a file called utils.js, Utils.java, utils.py, etc....


image post

Load dynamic data into a table using Lightning Web Component

Create a custom tab to display a Lightning Web Component
Nov 04, 2021

image post

How to configure HTTPS in Node.js

See how to setup a secure environment in our local machine to test HTTPS
Jul 27, 2020
Sometimes we need to configure a secure environment locally to test how our application reacts to HTTPS.

image post

SFDX - Error authenticating with auth code due to: grant type not supported

Common error when authenticating from SFDX CLI
Apr 27, 2021
Error authenticating with auth code due to: grant typw not supported. This is most likely not an error with the Salesforce CLI. Please ensure all information is accurate and try again

image post

Compress a file in Node.js

Jul 27, 2020
Zip a file in Node.js it's easy using zlib

image post

Hash text in Node.js

Hash a text using native crypto module in Node JS. No extra dependencies.
Aug 02, 2020
Hash a string in Node.js without extra dependencies

image post

How to connect to a PostgreSQL database in Node.js

Connect to Postgres database in Node js using pg and parse-database-url packages
Jul 28, 2020
A simple example about how to connect to a PostgreSQL database using Node.js

image post

How to use a GitHub repository as a dependency in Node.js

Aug 30, 2020
Sometimes you need a dependency that is not published as a regular package at npmjs.com

image post

How to configure and use testcontainer in Node.js

testcontainer as a Node.js module to create dynamic containers
Oct 13, 2021

image post

How to publish a message in SQS from SNS

Creating a AWS CloudFormation template to publish to a topic and send it to Amazon SQS queues
May 10, 2021
A CloudFormation template example about how to create an SNS topic to publish a message in SQS in the AWS wolrd

image post

Install Postgres locally in MacOS

Install using Brew package manager
Aug 18, 2020
How to install Postgres database in your MacOS local machine

image post

Optimizing Node JS code

Small actions that may generate big impact in your performance
Aug 03, 2020
At different levels you might optimize your JavaScript code. Sometimes optimization is a matter of good practices such as avoid using logging in loops.

image post

How to render HTML in Jade

Jade is a Node.js template engine that uses indentation as part of the syntax
May 15, 2021
By default, Jade buffers the output so we have to be explicit when we want unbuffered code

image post

Salesforce - Mock callouts in Apex

How to use mockups to tests callouts in Apex
Feb 19, 2021
Tests callouts in Apex

image post

Dealing with concurrency in Node.js

Yeap, race condition is present also in Node.js regardless the single thread Event Loop
Aug 30, 2020
Even though the Event Loop is a single thread we have to take care of race condition since 99% of our code will run in a non main thread.

image post

Customize styles highlight.js

Use your own styles to highlight source code
Aug 02, 2020
Customize styles highlight.js

image post

Full-text search in Node JS - search related data

Search related content using FlexSearch package for Node.js. See an implementation example with Express framewrok
Aug 04, 2020
If you are building a website, e-commerce, a blog, etc., you will need a full-text search to find related content like Google does for every web page.

image post

How to configure http auth basic in Node js and Express

Aug 04, 2020
Let’s build a small site in Node.js using Express that will have one protected page

image post

Migrate $User, $Profile, $Label and $Api to Lightning Components

Rollout to Lightning by migrating non-supported JavaScript buttons
Jun 18, 2020
We can’t use $User, $Profile, $Label and $Api in Lightning. We need to implement a server-side solution.

image post

Detect record changes in a Lightning Component

Listen to events when a record changes outside your Lightning component
Apr 16, 2021
Listening to changes in a Lightning Component from record changes

image post

Mock AWS SDK with Jest in TypeScript

An example mocking some SQS methods
Jul 31, 2021
It's a fact: you will spend some time writing mocks and slow down the development process but in the other hand unit test will run faster with less configuration.


image post

How to write to S3 bucket from Lambda function

AWS SAM template to create a Lambda function and an S3 bucket. Cloudformation world
May 12, 2021
Let's create a SAM template to declare a Lambda function to write into an S3 bucket

image post

Cache implementation in Node.js

A custom cache implementation to show how Promises powerful are
Aug 08, 2020
A cached value it’s dynamic data, expensive to calculate, that we make it constant during a period of time.


image post

Detect if a string is a number with regex

Aug 28, 2020
How to know if a string is a number in JavaScript using a regular expression

image post

How to create files in Salesforce for testing purposes

ContentVersion and ContentDocumentLink creation from Apex
May 21, 2021
Fortunately, dealing with files in Salesforce in a unit text context, is pretty easy.

image post

Lazy load images with javascript

Increase page loading time by requesting your images in background
Aug 12, 2020
Why should you load your images in a lazy way?

image post

5 reasons to host your images on Cloudinary

Images and videos are everywhere. Leverage Cloudinary to manage them easily
Aug 12, 2020
Image and video management are present in almost all of our projects. I would like to share my experience with this.

image post

Load stylesheets in background to increase page speed

Aug 16, 2020
Optimize the page loading time by loading your style sheets in background.

image post

Node.js and typescript project template

Oct 08, 2021
A project template with typescript, jest and linter among others configurations

image post

How to connect to a Redshift database from Node.js

See how to use pg-promise to connect to a AWS Redshift database
Aug 11, 2020
A util piece of code to connect to a Redshift database

image post

Install and run Redis locally

How to configure Redis to run it in your local machine.
Aug 18, 2020
How to install and run Redis in your local machine

image post

How to setup Github Actions workflow lint

Configure a workflow to execute your linter when pushing code
Apr 25, 2021
How to setup Github Actions workflow lint

image post

Get all tables in Redshift

Aug 23, 2020
Get all tables from a given schema

image post

Improve pg-promise stack traces

Aug 27, 2020
When you execute a query with error, we get a pg-promise internal module-specific stack trace.

image post

Search columns in Postgres

Aug 25, 2020
A simple query to search columns in different schemas


image post

Define environment variables in Tomcat

Aug 29, 2020
Sometimes you want to change the behavior of your code without recompiling or deploying.

image post

How to add a pie chart in Campaign’s record page in Salesforce

Add a cool chart in a record page easily. No code.
Aug 30, 2020
What about if we add a component with a pie chart on the Campaign object’s record page?

image post

error authenticating with auth code due to: grant type not supported

error authenticating with auth code due to: grant type not supported
Aug 31, 2021
error authenticating with auth code due to: grant type not supported

image post

Configure Prettier in your Node JS project

How to configure Prettier to format your code as It was written by only one developer
Aug 08, 2020
Prettier is a code formatter that supports many languages and can be integrated with most of the editors

image post

pg-promise self signed certificate error in Postgres

To fix this issue you have to use the package with the following recommendations
Aug 20, 2020
If you are using Node.js with some of these packages: pg-promise or pg probably you are facing this issue.

image post

Magic Mover for Notes And Attachments to Lightning Experience

Get ready for Lightning Experience by migrating your attachments and notes
May 22, 2021
Files are more versatile and provide better functionality than attachments. Attachments can only be attached to a single record, while files...

image post

How to trigger a Lambda Function from S3

Notify a Lambda Function when creating a new file in an S3 bucket
Jun 20, 2021
Using Cloudformation to declare a Lambda Function and an S3 bucket

image post

DB schema updates with knex in Node.js

Run database migration with knex
Feb 06, 2021
Knex is a query builder and among other things, it's an awesome tool to run DB migrations to create tables and modify them as you usually do with SQL scripts

image post

Protect your social networks with two-factor authentication

See how to protect the most used social networks
Apr 29, 2021
Nowadays a super complex password is not enough to avoid being hacked. In fact, most of the times your password is not guessed by brutal force (try until it works).

image post

Download and save a file in Node.js

Get a file from a server and store it in your disk
May 13, 2021
Download a file in Node.js is pretty straightforward. We are going to make an implementation using native modules. No third parties.

image post

Get Visualforce usage stats from VisualforceAccessMetrics

How to find out how often your Visualforce pages are accessed using Visualforce Access Metrics
Aug 08, 2020
If you want to know how frequently your Visualforce pages are accessed, you just have to run a simple query on VisualforceAccessMetrics

image post

How to connect to a MySQL database in Node.js

Oct 12, 2021
To connect to a MySQL database in Node.js is pretty straightforward with the module mysql2.


image post

jsxBracketSameLine - Prettier how to configure

bracketSameLine is the new version of jsxBracketSameLine
Oct 29, 2021
Pro tip: instead of running by hand, you can integrate it with you favorite IDE

image post

Invalid request provided: AWS::AppFlow::FlowCreate - Salesforce integration

This is a common error when a field is mapped in App Flow but it doesn't exist in Salesforce
Nov 19, 2021
Resource handler returned message: "Invalid request provided: AWS::AppFlow::FlowCreate Flow

image post

Salesforce integration with AWS AppFlow, S3, Lambda and SQS

Send data out of Salesforce with AWS AppFlow service in realtime
Aug 24, 2021
There are many ways to sync up our Salesforce data with third parties. One option is a mix of Salesforce and AWS services, specifically Change Data Capture from Salesforce and AppFlow from AWS.

image post

Getting some insights from Jacoco html report

A simple script to count packages that contain classes with low coverage
Nov 29, 2021
After running the Jacoco report generator we can open it and see the coverage results. There are some results the I wanted to know, for example, how many packages contain uncovered classes and how many contain coverage under a given threshold

image post

Lightning data table conditional cell color

Set text or background color for lightning data table rows
Jan 13, 2022
Let say you want to highlight a cell in a Lightning data table (lightning:datatable) when a specific value is invalid. In our example, we want to display those invalid emails in red.

image post

Invoke Apex method from Salesforce Flow Builder

Sometimes the out of the box functionality is not enough to automate all our processes
Aug 04, 2022
Flow Builder is the replacement of Process Builder in Salesforce. Both of them are useful to automate several kinds of process but sometimes the out of the box functionality is not enough

image post

Salesforce inspector: a Salesforce data explorer and exporter

Chrome and Firefox extension to inspect and export data from Salesforce
Jan 18, 2022
A productivity tool for Salesforce administrators and developers to inspect data and metadata directly from the browser without compromising security and privacy

image post

Dark Reader: A Chrome plugin to enable dark mode

Instantly read all your web pages in dark mode
Jan 23, 2022
Dark Reader is a Chrome plugin to start seeing instantly all the web pages in dark mode. It works pretty well with most of the sites

image post

How to send a pushengage notification with node-fetch

Send push notifications using pushengage.com through Node.js and node-fetch module
Jan 14, 2022
Sending push notifications from pushengage.com dashboard is pretty easy but what about f we want to automate some process in our web site?


image post

How to generate a random string in Apex

A Apex method to get a random string given a length
Oct 13, 2021

image post

Get Record Type id by name in Apex - Salesforce

SOQL query to get a record type by name to use it in Apex code
Nov 10, 2021
Based on this query we are going to build a method that gets the record type id by its name

image post

How to build a sitemap xml in Node js using Express

Create a sitemap in Node and Express framework for Search Engine Optimization
Jun 17, 2020
A good sitemap.xml will help you a lot in terms of SEO. It’s a nice starting point if you want to index your site. It’s just a standard XML file that search engines understand.

image post

Get Salesforce ContentVersion file info using node-fetch

How to get a Salesforce file info without downloading the file itself
Jul 07, 2022
Let's say you want to get the file info without downloading it. For example, you want to know the file name and extension.

image post

AWS AppFlow error conflict executing request connector profile is associated with one or more flows

If we try to delete a connector from the AWS console and it is associated with one or many flows, it will display this error.
Feb 09, 2022
Let's say you have a Salesforce connector (it is valid for any other available) and the token expired. The only way so far is to delete and recreate the connection again. Would be nice to keep the same connection and run the handshake again but it is impossible nowadays.

image post

First-time shipped implementation is like going into technical debt

What is technical debt and why you should pay attention to it?
Feb 22, 2022
Technical debt is often asymptomatic, making it difficult to prioritize, but once the symptoms appear, it may be too late and the associated costs may be much higher.

image post

Redirect all requests from HTTP to HTTPS in Node.js and Express

How to redirect all non secure requests to HTTPS in Node.js and Express
Jun 15, 2020
The first step will be to create a method to guess if the HTTP request comes from HTTP or HTTPS (secure or not secure). In some context like AWS or Heroku you will have to ask by the header x-forwarded-proto instead of req.secure.


image post

How to delay an execution in Salesforce Apex

Using Schedulable interface to delay an execution in Apex
Jun 10, 2022
In Java, we can use Thread.sleep(1000) to delay the execution by one second. In Apex is not that easy since Salesforce is a multi-tenant environment.

image post

Salesforce Apex method to get the country name by ISO Code

Convert ISO code into country name in Salesforce Apex
Jul 24, 2022
This method in Apex receives the country ISO code as string and returns the out of the box country name.

image post

Get Accounts with at least one closed-won opportunity in Salesforce

Salesforce SOQL query to get accounts with at least one closed won opportunity
Jul 24, 2022




image post

How to use Queueable interface in Apex

Stay away from the limits in Salesforce by implementing the Queueable interface in our Apex classes
Aug 03, 2022
By using queueable, you will stay away of limits, specially CPU limit.