Son Tran

Senior SWE by day, indie hacker by early morning ☕. Built Schemity: a no-cloud, keyboard-first ERD tool for devs who take database design seriously.

[Son Tran @tbson87]

Your ERD dies at the implementation handoff: someone retypes it into ORM models and it becomes a souvenir.

Alternative: design in bounded contexts, export each context's SQL as the AI prompt, let migrations own the DB, re-sync the diagram forever.

The ERD never writes a single statement.

https://t.co/VY4VYHw6zP

[Son Tran @tbson87]

Just shipped Schemity Lite: a free, browser-based ERD tool.

Map tables, columns, and relationships. Drag-and-drop 1:N / 1:1 / N:N with auto junction tables and FK naming. Save to the cloud, share a public link, import SQL, export to images.

No install. No credit card.

https://t.co/nYjNfZpvGM

[Son Tran @tbson87]

Same multi-tenant table, two ERD tools.

Question: how many unique constraints, and which columns belong to each?

Visual Paradigm: four identical red U marks. Open the constraint dialog to find out.

Schemity: three colors = three composite UCs. tenant_id+user_id, tenant_id+sso_sub, tenant_id+sso_id. One glance.

The grouping is the information. Most tools throw it away.

[Son Tran @tbson87]

@sagarshiroya_x To do so, the product_inventories must to have an unique together of product_id, color and size to ensure the uniqueness of that combination right?

[Son Tran @tbson87]

@RanjanNaya3519 @Hiteshdotcom @ChaiCodeHQ @piyushgarg_dev Thanks Ranjan! Day 83 is real commitment. Most people quit by day 10. I really liked your Comic-Con parking model.

[Son Tran @tbson87]

If your MySQL migrations break halfway and ROLLBACK doesn't save you, it's not your code.

MySQL silently COMMITs before every DDL statement. CREATE, ALTER, DROP, TRUNCATE. Schema changes can't be rolled back as part of a transaction.

Postgres has transactional DDL. MySQL doesn't. Plan migrations accordingly:
- Separate schema and data changes
- Make every step idempotent
- Always have a manual recovery path

The engineers who stop losing sleep over MySQL migrations are the ones who stop expecting them to be atomic.

[Son Tran @tbson87]

Most ERD tools slow you down.

Schemity is built for speed of thought - Vim-style navigation, offline-first, multi-DB support, schema diffing & migration gen. All without touching the mouse.

Built for architects. Not just drawers.

https://t.co/1KP9PIM4dV #ERD #DatabaseDesign

[Son Tran @tbson87]

Loving #summernote so much but current Summernote wrapper for #reactjs doesn't work with Bootstrap 4. So I create one for me and every one love #summernote https://t.co/4etKsNFHqJ

[Son Tran @tbson87]

Giải thích sơ về tham số hoá decorator trong Python: https://t.co/aaj1xtFlvY