db

image post

Mysql full text search (search related data)

Search related data in MySQL easily using Match and Against
Andrés Canavesi - Sep 01, 2020
Search related data in Mysql it's pretty easy

image post

Improve pg-promise stack traces

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

image post

How to use node-cache to accelerate queries

Using node-cache package to cache heavy and frequent queries in Node.js
Andrés Canavesi - Aug 25, 2020
Database access is usually expensive so you should optimize roundtrips as much as possible.

image post

pg-promise self signed certificate error in Postgres

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