Solving common issues when connecting locally run apps (In my case Strapi v4.x) to a production PostgreSQL database.
Introduction This article is for anyone aiming to connect to a production environment...
Jul 3, 20233 min read1 reactions0 comments
Back to articles Jul 3, 2023 
May 30, 2020
Mar 10, 2020
Mar 9, 2020
Mar 2, 2020
Feb 28, 2020
Tag archive
#knex
M
Apr 7, 2022Multiple approaches of storing data using NodeJS and KnexJS
The Best Approach for Storing Data in a Database When it comes to storing data in a...
Apr 7, 20222 min read11 reactions0 comments
S
Sep 23, 2021Setting up new project
What do you know about solid, kiss and bunch of other things? Fug them. When you are writing any...
Sep 23, 20212 min read11 reactions3 comments
C
Jul 10, 2021CRUD operation with knex & mysql in node.js
In this post I will teach you how to use mysql with knex.js 😊 Knex.js is a SQL query...
Jul 10, 20213 min read6 reactions0 comments
K
May 13, 2021Knex Cheat Sheet
[Migrations] Setting up Create knexfile.js ./node_modules/.bin/knex init...
May 13, 20212 min read21 reactions0 comments
H
Feb 17, 2021How to implement reset password functionality with Node/PostgreSQL/Knex
Have you ever wondered how to implement a reset password functionality on the server with NodeJS and...
Feb 17, 20214 min read13 reactions4 comments
How To Deploy To Heroku Using Postgres
So you've designed your database, built it and it's now running locally on your desktop with no error...
May 30, 20202 min read6 reactions6 comments
H
Apr 26, 2020How to do upserts in Knex.js (PostgreSQL)
How to do upserts in Knex.js (PostgreSQL)
Apr 26, 20203 min read36 reactions4 comments
How to create an API endpoint query with Knex
How to find one single record with a User model in Knex
Mar 10, 20202 min read17 reactions0 comments
Creating a User model file in a REST API
How to keep database logic separate in a model file in a REST API
Mar 9, 20203 min read14 reactions0 comments
How to create a join query with Knex
How to retrieve data from two join tables with Knex
Mar 2, 20203 min read23 reactions2 comments
Query a database with Knex
How to retrieve data from two database tables with Knex
Feb 28, 20203 min read7 reactions0 comments