Writing / Topic
PostgreSQL & databases
Data modelling and database design: multi-tenant architecture with Row-Level Security, the hidden cost of OFFSET pagination, and Sequelize with PostgreSQL.
Multi tenant scalable database architecture with data isolation
Three ways to isolate tenant data in a multi-tenant SaaS: separate databases, separate schemas, or shared tables with PostgreSQL Row-Level Security.
Is using offset in SQL a hero or a silent evil?
Pagination is one of the common things that every backend dev has to perform on API whether it is REST or GraphQL. Pagination is the…
Sequelize with expressjs and postgres
In my previous blogs, I discussed setting up expressjs, middleware, and jwt token authentication. In this blog, I will be writing about…
Setting up GraphQl with nodejs, sequelize, and postgres
GraphQl is a powerful query language for writing APIs, where front end can ask for the data they need rather than backend telling them the…