Recent Posts

SQL to get Products and related data from PostgreSQL

SQL to get Products and related data from PostgreSQL

The objective of this exercise for me was to dump all the product data as CSV / JSON so I could index them into Algolia. The exercise consisted of multiple steps to get to the required form of data. I will run through all those steps and explain what is happening.

Prisma Migrate: Consolidate / Squash Migrations

Prisma Migrate: Consolidate / Squash Migrations

When working on a new feature requiring schema updates, you may end up creating multiple fragments of migrations. This YouTube video explains how you could consolidate or squash these migrations without having to lose your local data.

Prisma Migrate: Baselining your existing database

Prisma Migrate: Baselining your existing database

I have been using KeystoneJs for one of my projects. Keystone uses Prisma. I have been putting off using migrations for a while now so, I already have my production site with data and I do not want to lose my data to start using migrations. For this purpose, there is a technique called baselining […]

JavaScript Tutorial for Beginners

JavaScript Tutorial for Beginners

I have tried to put together a video tutorial series on YouTube. Please support by subscribing to my YouTube and leaving your feedback on the videos.

Google chrome debugger tool walkthrough

Google chrome debugger tool walkthrough

Debugging is important in programming. There are debugging tools available for different languages one can use to help debug their code. Luckily if you are writing javascript to run in a browser, all major browser’s come with a built-in debugger tool. I have created a youtube video where I walk through Google Chrome’s debugger tool.

ReactJs tutorial for beginners in Nepali

ReactJs tutorial for beginners in Nepali

Here is my attempt to create a Video tutorial for ReactJs beginners’ course in Nepali. Watch all the videos in the series on this Youtube Playlist Episode: 1 Content Introduction to React and Frontend Dev landscape Bootstrapping a project using CRA React Component basics Props States Introduction to React What is an SPA? What is […]

Handling Push Notification Subscription for multiple devices

Handling Push Notification Subscription for multiple devices

If you have added a push notification feature on your PWA. You might have stumbled upon one problem. Identifying subscription records How do I identify the subscription so that I can later notify it? The easiest way is to add a user’s ID field to it and save it in your database. For example: Max […]

Heroku PostgreSQL database backup and restore

Heroku PostgreSQL database backup and restore

If you are new to Heroku and PostgreSQL and need to backup/restore data to and from your PostgreSQL database in Heroku, it might be overwhelming to get it right. This post has everything you will need to do just that.

Building SVG Clock using ReactJs

Building SVG Clock using ReactJs

DEMO: https://df2y4.csb.app/ GitHub: https://github.com/dejavu1987/react-svg-clock This blog post is an exercise from my previous blog post Introduction to Polar Coordinates, plotting on radial diagrams. If you have not read the post and have no idea how radial coordinates work. Please go to the post and read and come back. If you are confident, lets go build […]

Introduction to Polar Coordinates, plotting on radial diagrams

Introduction to Polar Coordinates, plotting on radial diagrams

Trigonometry “the foundation” the branch of mathematics dealing with the relations of the sides and angles of triangles and with the relevant functions of any angles. Google Basics of Trigonometry Trigonometry in its core has a very simple foundation. Although being so simple, it blows my mind that its the base to all the complex […]

Tag cloud