sql


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

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

Search columns in Postgres

Andrés Canavesi - Aug 25, 2020
A simple query to search columns in different schemas

image post

Get all tables in Redshift

Andrés Canavesi - Aug 23, 2020
Get all tables from a given schema

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
Andrés Canavesi - 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 connect to a PostgreSQL database in Node.js

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