Why varchar instead of text in T3 postgres/Drizzle schema?
Hi! First question here so please be kind
I've started a new app with
create-t3-app
create-t3-app
, with Next Auth, PostgreSQL and Drizzle ORM. The starting schema[1] for auth and a post example uses
varchar
varchar
all over the place.
So now I have a (potentially dumb) question: why is
varchar()
varchar()
used there instead of
text
text
? According to the official docs[2] there's no perf benefit, there's even a small cost for the length check.
I assume the original author may not see this but if anyone has any ideas that would be great! (my current assumption is that this is a holdover from the mysql version)