Your blog description
Live Last read · last published · next check
In this post I'll walk through how I migrated Tabhive from Supabase to PlanetScale + better-auth. If you're looking to do something similar, this might be useful for you. Why Migrate I was using Supabase for two things in Tabhive: the database and authentication. Performance Performance was not great, especially with RLS enabled. RLS adds overhead to every query and it was noticeable. Vendor…
In this post, let's understand how authentication in web applications works. We'll cover two common approaches: Session based authentication Token based authentication (usually JWT) The Core Problem Authentication Solves Imagine a server as a guarded building. Before you're allowed inside, you need to prove who you are. Once you've proven it, the server needs a reliable way to recognize you again…
What Are Database Transactions? Before diving into Supabase implementation, let's understand what database transactions are and why they're crucial for data integrity. The Money Transfer Problem Imagine you're transferring money to your friend. This seemingly simple operation actually involves two critical steps: Debit the amount from your account Credit the amount to your friend's account What…
One of my clients initially built a web app that stored all its data in the browser's local storage. After completing the MVP, they decided to transition to a more scalable solution by moving the data to Supabase and using a proper database for storage. The app already had a few active users. So we couldn't simply switch to Supabase without data migration. We first needed to migrate existing data…
You have built a web app and one of the features it has is link sharing. You want to track how many times a link has been opened. It is simple right? You have to fetch the data from the database, increment it and then update it in DB? SELECT view_count FROM user_link WHERE user_id = '23d70c9e-b86f-4c4a-8c92-79615b6e487c' ; view_count = view_count + 1 UPDATE user_link SET view_count = view_count…
Unless you are living under a rock, you have heard of ChatGPT, Cursor, Bolt, Loveable etc.. and the waves they have created in the last 1 year. There is no doubt, LLMs have changed how humans do things, writing, developing software, asking questions, audio/video generation just to name a few, LLM's & AI have made their way into all of them. You have already lost, if you haven't started using AI…
You have taken on Chrome extension work for a client, you built it out locally and is ready to be handed over. How do you do it? Let's explore all the ways in which you can deliver an extension to a client. There are 3 ways Transfer the code Submit it in your developer account and transfer it after approval Use the clients group publisher account Transfer the code You can transfer the extension…
REST services are slowly becoming the norm. With the raise of SPA (Single Page Applications), REST API's have become the main way of consuming data from the backend. These APIs are designed around resources. A resource can be an object, data, or service that can be accessed by the client. A resource has an identifier, which is a URI that uniquely identifies that resource. For example, the URI for…
If you have built and submitted a Chrome extension, you know about the vague review process and how much time it takes for approval. If you have never published a chrome extension before and you are going to publish one now, you are at the right place. In this post, I will provide guidelines for submitting your extension to the chrome web store. Follow chrome web store submission guidelines…
How to make your first open-source contribution? There are many ways you can contribute to open source and it doesn't have to be exclusive to code. You can contribute by: Writing code Reporting bugs Reviewing pull requests Helping triage an issue Adding/Improving documentation Find a project to contribute to If you are working on a project, check out the Github repositories of the libraries you…
