News for hackers. Stuff that matters.

A comment on SQLite or PostgreSQL? It's Complicated. Parent comment

Re:SQLite or PostgreSQL? It's Complicated by jeffdn on Tuesday June 28, 2022 @12:43PM (#31910002)
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.

[ Parent | on HN ]
Re:SQLite or PostgreSQL? It's Complicated by pphysch on Tuesday June 28, 2022 @05:49PM (#31913483)
> 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!

[ Parent | on HN ]
Re:SQLite or PostgreSQL? It's Complicated by Pv9KKy3 on Tuesday June 28, 2022 @01:21PM (#31910436)
I use and prefer varchar(1000) personally, extremely easy to change in the future if needed.
[ Parent | on HN ]