sql

image post

How to connect to a MySQL database in Node.js

Andrés Canavesi - Oct 12, 2021
To connect to a MySQL database in Node.js is pretty straightforward with the module mysql2.

image post

Node.js Express Mysql stack deployed on Heroku

How to build a rest API from zero using Node.js, Express and MySQL
Andrés Canavesi - 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


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