Skip to content
  • July 9, 2025

Thnk And Grow

Let's Do It!

×

Thnk And Grow

Let's Do It!

  • Home
  • All topics
  • Ruby
    • Ruby on Rails
    • Gems
  • Architecture & Design
    • AWS
    • Docker
    • Security
  • Database
    • PostgreSQL
    • MySQL
    • NoSQL
  • NodeJS
    • Javascript/Typescript
    • Realtime
      • Socket.IO
  • Others
    • Interview Question
    • Tips
    • Notes
    • Tools
  • About us
  • Home
  • Postgresql
June 29, 2025
All topics Database Gems MySQL Others PostgreSQL Ruby Ruby on Rails Tips

How a Simple Migration Took Down Our System for 20 Minutes — And How to Never Let That Happen Again

"ALTER TABLE looked harmless. On staging, it ran in 0.4s. In production, it locked the…

author-image
Lê Hoàng Tâm
0 Comments
Read More
October 22, 2024
All topics Database PostgreSQL

Postgres Index Methods: Things you need to know

In PostgreSQL, different types of index methods are used to optimize query performance, especially for…

author-image
Lê Hoàng Tâm
0 Comments
Read More
October 21, 2024
All topics Architecture & Design Database PostgreSQL

How to prevent table lock when add/drop index in Postgres?

The CONCURRENTLY option in PostgreSQL is used when creating or dropping indexes to avoid locking…

author-image
Lê Hoàng Tâm
0 Comments
Read More
September 25, 2024
All topics Architecture & Design Database PostgreSQL Ruby on Rails

A Deep Dive into Schema-Based Multi-Tenancy: Scaling, Maintenance, and Best Practices

Introduction As your application scales and serves multiple tenants, choosing the right multi-tenancy architecture is…

author-image
Lê Hoàng Tâm
0 Comments
Read More
September 12, 2024
All topics Database PostgreSQL

Understanding PostgreSQL WAL and How It Can Save Your Data

PostgreSQL’s Write-Ahead Logging (WAL) system is a fundamental component that ensures database durability, data integrity,…

author-image
Lê Hoàng Tâm
0 Comments
Read More
Understanding DROP COLUMN in PostgreSQL
April 18, 2024
Database

Shedding Some Light: How the DROP COLUMN Command Works in PostgreSQL

Imagine your PostgreSQL database as a filing cabinet. Over time, you might accumulate folders you…

author-image
Lê Hoàng Tâm
0 Comments
Read More
December 24, 2021
All topics

How to get `previous` and `next` record in PostgreSQL/ MySQL with LAG and LEAD function

1 bài toán cơ bản, nhỏ nhỏ lúc làm việc thôi. Đề bài là: Tìm…

author-image
Lê Hoàng Tâm
0 Comments
Read More

Recent Posts

  • 🔐 sqlmap: Automate SQL Injection Testing Like a Pro in 2025 July 8, 2025
  • How a Simple Migration Took Down Our System for 20 Minutes — And How to Never Let That Happen Again June 29, 2025
  • Prompt Injection: The Hidden Security Risk in AI Agents (And How to Prevent It) June 24, 2025
  • The Ultimate Guide to Image Rendering in ReactJS: Performance, SEO, and Best Practices (2025) June 11, 2025
  • Essential Responsive Design Tips for React Developers June 10, 2025

Categories

  • AI (1)
  • All topics (107)
  • Architecture & Design (34)
  • AWS (15)
  • CSS (6)
  • Database (20)
  • Design patterns (6)
  • Docker (6)
  • Gems (3)
  • Generation (3)
  • Interview Question (11)
  • Javascript/Typescript (16)
  • MySQL (14)
  • NodeJS (14)
  • NoSQL (6)
  • Notes (3)
  • Others (13)
  • PostgreSQL (12)
  • Realtime (2)
  • Ruby (21)
  • Ruby on Rails (11)
  • Security (11)
  • Socket.IO (3)
  • Tips (45)
  • Tools (10)

authentication AWS AWS SQS Backend Backend Performance Best Practices compare Database Database Questions Deploy Deployment Docker Docker swarm Interview Questions iRedMail Javascipt javascript MailGun Mail Server Multiple Threads mysql NextJS Nginx optimize database optimize performance Optimize Queries optimize query Popular Postgresql Rails Realtime Application redis RESTFul API ruby Ruby on rails S3 Seamless Connections Security SEO sql injection SQS Tech Interview Tips Traefik Web Development

authentication AWS AWS SQS Backend Backend Performance Best Practices compare Database Database Questions Deploy Deployment Docker Docker swarm Interview Questions iRedMail Javascipt javascript MailGun Mail Server Multiple Threads mysql NextJS Nginx optimize database optimize performance Optimize Queries optimize query Popular Postgresql Rails Realtime Application redis RESTFul API ruby Ruby on rails S3 Seamless Connections Security SEO sql injection SQS Tech Interview Tips Traefik Web Development

  • July 2025
  • June 2025
  • May 2025
  • March 2025
  • February 2025
  • January 2025
  • December 2024
  • November 2024
  • October 2024
  • September 2024
  • August 2024
  • June 2024
  • May 2024
  • April 2024
  • August 2023
  • May 2023
  • April 2023
  • April 2022
  • January 2022
  • December 2021
  • October 2021
  • September 2021
  • June 2021
  • May 2021
  • April 2021
July 2025
SMTWTFS
 12345
6789101112
13141516171819
20212223242526
2728293031 
« Jun    

blog.thnkandgrow © 2025 | Powered By SpiceThemes