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.
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.
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.
Load dynamic data into a table using Lightning Web Component
Create a custom tab to display a Lightning Web Component
Nov 04, 2021
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.
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
Why I adopted Heroku
Heroku is a platform as a service (PaaS) acquired by Salesforce in 2011
Jul 31, 2020
Heroku is a platform as a service (PaaS)
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
5 reasons to choose WordPress as your content management tool
Popularity. Flexibility. SEO. Free and paid plans. Awesome editor
Jul 31, 2020
As Engineer I installed WordPress many times, facing issues such as performance and security. When you host WordPress by your own...
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
Template of Java web and Heroku
Jul 31, 2020
I’ve worked in several projects with Java, specially Java web using Tomcat as a web container and then Glassfish as application server.
How to configure and use testcontainer in Node.js
testcontainer as a Node.js module to create dynamic containers
Oct 13, 2021
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
Install Postgres locally in MacOS
Install using Brew package manager
Aug 18, 2020
How to install Postgres database in your MacOS local machine
Download Salesforce metadata using SFDX
How to download Salesforce metadata to your local machine using SFDX CLI
Feb 23, 2021
Download Salesforce metadata using SFDX
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.
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
Salesforce - Mock callouts in Apex
How to use mockups to tests callouts in Apex
Feb 19, 2021
Tests callouts in Apex
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.
Customize styles highlight.js
Use your own styles to highlight source code
Aug 02, 2020
Customize styles highlight.js
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.
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
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.
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
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.
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
Delete all keys by a prefix in Redis cluster
Reset a cache implemented in Redis for some specific keys with a prefix
Aug 04, 2020
Delete all the keys by a given prefix in a Redis cluster.
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.
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server
mysql and knex
Sep 07, 2021
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
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.
How to send a message to AWS SQS queue from Salesforce Apex class
Surprisingly, making a callout to put a message in AWS SQS queue is tricky in Apex
Jan 31, 2021
How to post a message in an AWS SQS queue from an Apex class in Salesforce
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?
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.
Load stylesheets in background to increase page speed
Aug 16, 2020
Optimize the page loading time by loading your style sheets in background.
How to use node-cache to accelerate queries
Using node-cache package to cache heavy and frequent queries in Node.js
Aug 25, 2020
Database access is usually expensive so you should optimize roundtrips as much as possible.
Node.js and typescript project template
Oct 08, 2021
A project template with typescript, jest and linter among others configurations
Mock Axios with Jest
Mock request made by Axios using Jest in Node.js. Unit tests more unit
Jan 31, 2021
Mock Axios with Jest using successful and error response
Sitemap xml creation
A sitemap is very important if you want to search engines discover and index your site properly.
Sep 09, 2021
No matter the language you are using in your site, this is the right way to create a sitemap.
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
How to download a Salesforce file from Node.js
A JavaScript snippet to download a Salesforce file using the Rest API
Apr 20, 2021
Download a file from Salesforce using Node.js
Dealing with customers
Give feedback, provide updates. Put in your customer's shoes
Aug 30, 2020
A post wrote by Jozsef Torsan that I would like to share here.
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.
Show failing tests after running a dry deployment (--checkonly) in Salesforce
Salesforce - SFDX CLI
Aug 24, 2021
jsonplaceholder: a free fake API for testing and prototyping
JSONPlaceholder is a free online REST API that you can use whenever you need some fake data.
Sep 13, 2021
Prettier config
Prettier is a code formatter that supports many languages and can be integrated with most of the editors.
Sep 09, 2021
With Prettier you will be able to define your own rules, however default rules are enough at the beginning.
How to download a file from Salesforce using Java Rest API
A Java snippet to download a Salesforce file through the Rest API
Apr 20, 2021
Let say we want to download a file stored in Salesforce. We'll have to deal with ContentVersion
How to make Load and Smoke testing with Artillery
Artillery is a CLI tool installed easily through npm
May 20, 2021
Artillery is a modern load testing and smoke testing solution designed for cross-functional teams that run microservice-based systems on AWS and rely on CI/CD to ship at high velocity
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?
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
Clean up more than two spaces and new lines with regex
A simple JavaScript method that removes all newlines and multiple spaces from a given text
Aug 28, 2020
A simple JavaScript method that removes all new lines and multiple spaces (including tab spaces) by a single space
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
Salesforce client for an Apex RESTful web service
Expose a Rest service from an Apex class using RestResource annotation
Aug 29, 2020
An example about how to consume a Salesforce api rest
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...
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
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
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).
P2: the collaboration tool from WordPress
"Fewer emails. More progress." it's a good argument to test it.
Sep 02, 2020
As communication moves increasingly online, staying organized can be a challenge. The way we work at WordPress.com is unique.
Mysql full text search (search related data)
Search related data in MySQL easily using Match and Against
Sep 01, 2020
Search related data in Mysql it's pretty easy
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
flexsearch example
A super simple example to show how to index a collection of data and then run a full-text search
Sep 09, 2021
flexsearch It's an awesome package to index in-memory data
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.
flexsearch tutorial
We are going to build a small example to see how it works.
Nov 10, 2021
It's a module available through npm or yarn to index in-memory data.
With this module, you will be able to search or display related data on your site.
We are going to build a small example to see how it works.
Node.js Express Mysql stack deployed on Heroku
How to build a rest API from zero using Node.js, Express and MySQL
Oct 09, 2021
Let's build a Rest API from scratch that uses a MySQL database. We are going to use Node.js and Express as a framework to generate some scaffolding for our Rest API
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
AppFlow Salesforce: how to sync up relationships
An elegant solution to sync up relationships from Salesforce to AppFlow
Nov 10, 2021
Only basic types such as strings or numbers can be passed through AppFlow which means that look-up fields will be ignored. There's a way you can do it with some work from using the Salesforce out-of-the-box Process Builder tool, a custom object and some lines of Apex code.
Call an Apex method from Process Builder
See how to configure a Flow with process builder to execute an Apex method in Salesforce
Nov 11, 2021
As a thumb of rule in Salesforce you should always try to create new business logic through point-and-click but sometimes our logic it's a bit special and we need some Apex code.
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
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.
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
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.
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
Bye bye FindBugs. Hello SpotBugs
Even FindBugs is no longer maintained we have an alternative called SpotBugs.
Aug 08, 2020
I used to use FindBugs plugin in my Java projects to detect and learn about issues and potential issues in my source code.
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
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?
jsonplaceholder - free and unlimited json API placeholder
Mock backend data with a free and unlimited json API
Jan 05, 2022
Frandom is a JSON Placeholder fake REST API that is mainly used for prototyping and testing.
Frandom API placeholder
Mock your backend using a placeholder API that returns random data
Oct 29, 2021
A simple API to generate random data such as companies and persons. It is open to the public. No API key required. No registration required.
What is Node.js and what is the Event Loop
Node.js is a JavaScript runtime environment to run server-side web applications
Dec 03, 2021
Node.js provides simplicity in development because of its non-blocking I/O and even-based model results in short response time and concurrent processing, unlike other frameworks where developers have to use thread management.
How to generate a random string in Apex
A Apex method to get a random string given a length
Oct 13, 2021
Salesforce rest api download ContentVersion
Download a Salesforce file (ContentVersion) through the API using Node.js with jsforce package
Sep 09, 2021
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
redis delete all keys with prefix
Delete all the keys by a given prefix in a Redis cluster.
Aug 31, 2021
Delete all the keys by a given prefix in a Redis cluster.
redis delete all keys
Delete all the keys by a given prefix in a Redis cluster.
Aug 31, 2021
Delete all the keys by a given prefix in a Redis cluster.
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.
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.
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.