Using Drizzle + Neon + Vercel for my app, can someone help me understand the pros/cons to using the websockets vs. http connection. From what I understand the http connection is faster since you don't have to establish a connection, and possible concurrency limits. While websockets gives you transaction support.
I do have one simple transaction (create workspace + create owner member), so I have to swap to websockets to support it, but I'm trying to understand if I'm shooting myself in the foot just to support this one query.