db

image post

DB schema updates with knex in Node.js

Run database migration with knex
Andrés Canavesi - 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

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.