SQL Optimistic Lock in Rust
Last time, I discussed implementing optimistic locking using PostgreSQL's raw type xmin. As a Rust lover, I attempted to replicate this in Rust. However, I encountered unexpected challenges. Let me share the changes I encountered and how I overcome the problem.
SQL Optimistic Lock in .Net
Once again, I've encountered a concurrency issue recently. The data I attempted to modify didn't yield the desired results. There's evidence showing that more than two applications accessed this data simultaneously. Identifying the application exhibiting conflicting behavior is really difficult. Optimistic locking is a solution for this issue.
Large Jsonb Value Performance in Postgres
Introduction
Recently, our team encountered some performance issues with our APIs. Typically, such issues arise from inefficient querying strategies. However, we stumbled upon a particularly interesting case. This specific API was solely responsible for update operations.In this post, we'll share our experience with this unique case and delve into the JSONB performance during update actions within PostgreSQL.
How to Migrate to a Monorepo
Introduction
There are many articles that analyze the pros and cons of using a monorepo. However, if you have already decided to migrate from a polyrepo to a monorepo, it can be hard to find tutorials or discussions about the process. I want to share my recent experience and discuss the challenges encountered during the migration. This will provide insights into the steps I took and the considerations made in achieving this goal.
