SQL to get Products and related data from PostgreSQL

SQL to get Products and related data from PostgreSQL

3 years ago, October 19, 2021

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

3 years ago, September 25, 2021

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.

JavaScript Tutorial for Beginners

JavaScript Tutorial for Beginners

3 years ago, August 28, 2021

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

3 years ago, August 9, 2021

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

3 years ago, July 24, 2021

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

3 years ago, July 24, 2021

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 […]

© 2024 Anil Maharjan