Can't tell in the video but does Prisma code completion capability require the project to be using Typescript? I have 2 next projects and noticed that the code completion only works in typescript. Hopefully I may have just missed something.
amazing work! documentation is never that clear, they make it look obvious but sometimes is not. A little more explanation like this is gold! My goal is to complete the 3 videos you got here. the extra on your website is pretty nice to follow the video step by step. Great work so far man!
There's an issue with using PostgreSQL and Next API routes: Next API routes are essentially lambda functions, and lambda functions can quickly cause connection issues with a database such as PostgreSQL. PostgreSQL has no built-in connection pooling, so managing the number of connections to the database is left to the application. If your application runs on lambda functions, every new lambda function will create a new connection pool. Since lambda functions cannot share each other's connection pools, the number of connections to the PostgreSQL database will increase as more lambda functions are spawned (that is, as you get more users using the app). As such, it isn't recommended to use lambda functions and PostgreSQL, unless you are using a proxy between the database and your lambda functions to manage the connection pool for those lambda functions. It should be noted that using a proxy will increase your infrastructure costs, since it is yet another server that needs to run alongside your database.
@@SamMeechWard Dude if you're interested do some state management stuff with the app directory. I just set up this current project with the app directory for the first time and I redux working with redux-persist, but I can't help but think there has to be a better way... Also, super solid video. I'm just becoming more of a fan of prisma after being super into mongoose and sqlite for a while and I think I've watched this video like 8 times.