Right, but use a check constraint and not a data type constraint (i.e. `varchar(... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		jeffdn on June 28, 2022 \| parent \| context \| favorite \| on: SQLite or PostgreSQL? It's Complicated Right, but use a check constraint and not a data type constraint (i.e. `varchar(x)`). That sounds more like a code review issue -- `blob` would've been an appropriate storage type in that case.

pphysch on June 28, 2022 | [–]

> That sounds more like a code review issue -- `blob` would've been an appropriate storage type in that case.

No, it was supposed to be a short text field. Not an infinite storage endpoint!

Pv9KKy3 on June 28, 2022 | [–]

I use and prefer varchar(1000) personally, extremely easy to change in the future if needed.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact