News for hackers. Stuff that matters.
Re:Homebrew removes MongoDB from core formulas by ldng on Monday September 02, 2019 @06:27PM (#20862170)
PostgreSQL do have a variable unlimited length datatype : text. AFAIK, Varchar is internally a subtype that bound the text type. So in extreme situations you might even get a very slight performance advantage using text instead of varchar.
Re:Homebrew removes MongoDB from core formulas by pkrefta on Monday September 02, 2019 @06:48PM (#20862277)
This is exactly how it is. You can find confirmation in Postgres docs [1]

[1] https://www.postgresql.org/docs/9.1/datatype-character.html

Re:Homebrew removes MongoDB from core formulas by benatkin on Monday September 02, 2019 @06:55PM (#20862312)
Interesting. When is there an advantage of using varchar in postgres, other than limiting the field length?
Re:Homebrew removes MongoDB from core formulas by nicoburns on Monday September 02, 2019 @07:01PM (#20862348)
I think never, except if you want your SQL to be portable to other dbs.