Rounding a Datetime Value in MySQL to the Nearest Minute

When you store timestamps in MySQL, the values often include seconds even when your report, dashboard, or grouping logic only needs minute-level precision. Rounding a DATETIME value to the nearest minute is useful for analytics, event logs, scheduling screens, and any query where 2026-07-10 09:14:29 and 2026-07-10 09:14:31 should not be treated the same way. … Read more

Fix libwacom9 dependency issue when upgrade Debian

The following packages have unmet dependencies: libwacom9 : Depends: libwacom-common (= 2.1.0-2) but 1.12-1 is to be installed This should fix the issue on most cases: # apt install libwacom9 libwacom-common=2.1.0-2 If the command above returns error: E: Version ‘2.1.0-2’ for ‘libwacom-common’ was not found Try this: # apt remove libwacom2 When run the command … Read more

Node.js – Convert PDF base64 to PNG base64 on Lambda

I recently developed an application running on Lambda Node.js 14.x, lost lots of time on this part. So I think this post may help someone to save their time. Don’t hesitate to leave a comment below if you found this post is hard to understand or if you have any questions. 1. NPM package I … Read more

How to get Salesforce Sfdx Auth Url

1. Install SFDX Refs: https://developer.salesforce.com/docs/atlas.en-us.sfdx_setup.meta/sfdx_setup/sfdx_setup_install_cli.htm The easiest way is to install via npm: npm install sfdx-cli –global To check if the sfdx is installed or not: sfdx –version 2. Authorize an org with the OAuth 2.0 webserver In this step, you will need to login via a web browser to authorize the CLI application. sfdx … Read more