Son Tran

Software engineer and indie founder with 15+ years of experience. Built Schemity: a native desktop ERD tool for developers who want their schema in Git, not someone else's cloud. Based in Hanoi, VN.

Hanoi, Vietnam Joined on Jun 22, 2018 tbson87@gmail.com https://schemity.com

Son Tran

Oct 23

How to Track Schema Changes in PostgreSQL: DDL Logging, an Event Trigger or a Schema Snapshot

#postgres #database #sql #devops

9 min read

Want to connect with Son Tran?

Create an account to connect with Son Tran. You can also sign in below to proceed if you already have an account.

Create Account

Already have an account? Sign in

Son Tran

Oct 22

How to Auto-Update an updated_at Column: MySQL ON UPDATE vs a Database Trigger vs the ORM

#mysql #postgres #database #sql

10 min read

Son Tran

Oct 21

SQL Server INT to BIGINT Primary Key: Four Ways to Change It and What Each One Costs

#sqlserver #database #sql #dotnet

11 min read

Son Tran

Oct 20

Round-Tripping TPC-DS and a Snowflake Feature Schema Through a Database Diagram: What Snowflake Lost and What We Fixed

#snowflake #database #datawarehouse #sql

13 min read

Son Tran

Oct 20

Round-Tripping Campfire and Jellyfin Through a Database Diagram: What SQLite Lost and What We Fixed

#sqlite #rails #dotnet #database

13 min read

Son Tran

Oct 20

Round-Tripping Bitwarden and Smartstore Through a Database Diagram: What SQL Server Lost and What We Fixed

#sqlserver #database #dotnet #efcore

15 min read

Son Tran

Oct 20

Round-Tripping Invoice Ninja and Sylius Through a Database Diagram: What MySQL Lost and What We Fixed

#mysql #database #laravel #symfony

15 min read

Son Tran

Oct 20

Round-Tripping Mastodon and Saleor Through a Database Diagram: What Broke and What We Fixed

#postgres #database #rails #django

18 min read

Son Tran

Oct 19

MySQL UNSIGNED Primary Keys: Signed or Unsigned, and How to Fix Error 3780 When They Mix

#mysql #database #laravel #sql

12 min read

Son Tran

Oct 19

Foreign Keys Between Modules in a Modular Monolith: Keep, Restrict, or Drop?

#postgres #architecture #database #softwareengineering

10 min read

Son Tran

Oct 19

PostgreSQL: Changing an Integer Column to Boolean - In Place or a New Column, and the Four Errors on the Way

#postgres #database #sql #webdev

10 min read

Son Tran

Oct 19

What Breaks When a Database Diagram Reaches 1,000 Tables, and What We Redesigned

#database #performance #postgres #erd

13 min read

Son Tran

Oct 19

PostgreSQL Constraint Naming Convention: Which Pattern to Use, and How to Find the Names That Drifted

#postgres #database #sql #webdev

8 min read

Son Tran

Oct 19

PostgreSQL: Cannot Alter Type of a Column Used by a View - How to Change It, and How to Find Every View in the Way

#postgres #database #sql #webdev

9 min read

Son Tran

Oct 5

PostgreSQL serial vs identity: Which to Use, and How to Convert Old serial Columns

#postgres #database #sql #webdev

9 min read

Son Tran

Oct 1

Database MCP Server: Should an AI Agent Run SQL or Only Read the Schema?

#ai #postgres #database #security

7 min read

Son Tran

Oct 1

Changing a Column Type in SQLite: The Table Rebuild and What It Deletes

#sqlite #database #sql #webdev

8 min read

Son Tran

Oct 1

ON DELETE SET NULL vs CASCADE vs RESTRICT in PostgreSQL: Which to Use

#postgres #database #sql #webdev

8 min read

Son Tran

Oct 1

A PostgreSQL Role That Reads the Schema but Not the Data: What to Grant

#postgres #database #security #sql

8 min read

Son Tran

Oct 1

Adding a NOT NULL Column to a Large PostgreSQL Table: Constant Default, Backfill or NOT VALID

#postgres #database #sql #webdev

10 min read

Son Tran

Sep 28

PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices

#postgres #database #sql #webdev

9 min read

Son Tran

Sep 27

PostgreSQL Generated Column vs Trigger: Which to Use for a Derived Column

#postgres #database #sql #performance

10 min read

Son Tran

Sep 26

PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table

#postgres #database #sql #migrations

9 min read

Son Tran

Sep 25

Polymorphic Associations in PostgreSQL: One commentable_id Column or a Foreign Key per Table?

#database #postgres #sql #rails

7 min read

Son Tran

Aug 21

Column Comments in PostgreSQL and MySQL: How to Document Columns Without a Migration

#database #documentation #sql #postgres

7 min read

Son Tran

Aug 19

Circular Foreign Keys: Why the First Row Cannot Be Inserted

#database #sql #postgres #mysql

10 min read

Son Tran

Aug 19

PostgreSQL timestamp vs timestamptz: Which to Use and How to Find the Wrong Ones

#database #postgres #sql #orm

8 min read

Son Tran

Aug 17

Export a Database Data Dictionary: HTML, Markdown and Excel from Your ERD

#database #documentation #sql #postgres

7 min read

Son Tran

Aug 14

Schema Linting vs Migration Linting: Which Database Problems Each One Can See

#database #sql #postgres #architecture

11 min read

Son Tran

Aug 13

Postgres Array Column vs Junction Table: What Each One Does to Your ERD

#database #postgres #sql #architecture

10 min read

Son Tran

Aug 6

DrawSQL Alternative: An Offline Desktop ERD Tool With No Table Limits

#database #sql #tooling #programming

21 min read

Son Tran

Aug 4

You Cannot Tell Which of Your ERD Files Are Under Version Control

#database #git #sql #tooling

5 min read

Son Tran

Aug 4

Why Schemity Has No Zoom: Fuzzy Search and a Minimap Instead

#database #ux #design #tooling

7 min read

Son Tran

Aug 2

Database Views in Your ERD: Read-Only Entities, Not Fake Tables

#database #sql #postgres #architecture

5 min read

Son Tran

Aug 2

SSMS Database Diagrams: Your ERD Is Trapped Inside the Database It Documents

#database #sqlserver #sql #documentation

6 min read

Son Tran

Aug 1

Supabase Schema Diagram: Get an ERD You Can Keep, Not a Dashboard View

#database #postgres #supabase #sql

6 min read

Son Tran

Jul 30

ON DELETE CASCADE Is Invisible in Your ERD and in Your Database Logs

#database #sql #mysql #postgres

10 min read

Son Tran

Jul 25

Lucidchart ERD Alternative: A Desktop ERD Tool That Connects to Your Database

#database #sql #tooling #programming

10 min read

Son Tran

Jul 23

Comparing Staging and Production Database Schemas Side by Side

#database #devops #sql #postgres

6 min read

Son Tran

Jul 23

Roles and Permissions Schema Design for Multi-Tenant RBAC (Part 2)

#database #sql #saas #security

17 min read

Son Tran

Jul 22

Many-to-Many in an ERD Shouldn't Mean Hand-Building the Junction Table

#database #sql #beginners #tutorial

9 min read

Son Tran

Jul 22

Why ERD Tools Draw Your 1:1 Relationship as 1:N

#database #sql #mysql #postgres

6 min read

Son Tran

Jul 22

Your DDD Context Map Is Already in Your Foreign Keys

#database #architecture #ddd #softwareengineering

9 min read

Son Tran

Jul 22

Why Your ERD Export Turns Blurry - and How SVG Export Fixes It

#database #svg #mermaid #documentation

6 min read

Son Tran

Jul 18

The Data Dictionary Should Live in the ERD, Not in a Spreadsheet

#database #documentation #sql #markdown

5 min read

Son Tran

Jul 18

Schemity vs DbSchema: The Lightweight Alternative

#database #sql #tooling #programming

8 min read

Son Tran

Jul 18

You Don't Need a Diagram of All 800 Tables

#database #sql #documentation #architecture

5 min read

Son Tran

Jul 18

Keeping Your ERD Updated Shouldn't Be a Second Job

#database #documentation #devops #sql

4 min read

Son Tran

Jul 18

Switching ERD Tools Shouldn't Mean Starting Over

#database #sql #dbml #programming

6 min read

Son Tran

Jul 18

ERD Tool Free-Tier Limits: 15-Table and 60-Object Caps Distort Models

#database #sql #productivity #tooling

6 min read

Son Tran

Jul 18

How to Keep ERD Relationship Lines Readable: Hops, Waypoints, Colors

#database #sql #design #programming

6 min read

Son Tran

Jul 18

AI ERD Design With Ollama: Schema Help That Never Leaves Your Machine

#ai #ollama #database #privacy

5 min read

Son Tran

Jul 18

Supabase Studio and pgAdmin Won't Keep Your Schema Diagram Layout

#database #postgres #supabase #sql

5 min read

Son Tran

Jul 18

Finding a Column Shouldn't Take a SQL Query

#database #sql #postgres #productivity

5 min read

Son Tran

Jul 18

Your ERD Shouldn't Be Able to Just Disappear

#database #git #backup #programming

5 min read

Son Tran

Jul 18

Schemity vs ChartDB: The Offline Desktop Alternative

#database #sql #ai #tooling

11 min read

Son Tran

Jul 18

Entity Templates: How to Stop Schema Naming and Field-Order Drift

#database #sql #bestpractices #programming

5 min read

Son Tran

Jul 18

Documenting Your Production Database Shouldn't Feel Dangerous

#database #devops #security #documentation

5 min read

Son Tran

Jul 18

Your Client's Schema Doesn't Belong in Your Cloud Account

#database #freelance #privacy #career

4 min read

Son Tran

Jul 18

Stop Hand-Translating Between SQL and Your ERD

#database #sql #productivity #programming

4 min read