They FINALLY Fixed Prisma (By Deleting GraphQL)

[@BlitzkriegHD]

“If you make something 2x faster, you probably did something smart. If you make something 10x faster, you probably stopped doing something dumb.” - Archimedes or something

[@romanchuk_vlog]

(с) Jason Statham

[@mrelec1000]

a drizzle/kysely/prisma comparison video might be fun👀

[@ShafterPlay]

Yes, please!

[@MikeBifulco]

☝ this!

[@kumarvishalben]

YESSS

[@kumarvishalben]

Fastest on edge

[@0xMukesh]

YES!

[@nullzeon]

These sub to Theo sections are getting more and more creative

[@keoni_k]

Kudos to prisma for pushing forward! Tough to do with all this competition. Keep it up!

[@jocdiazm]

That subscribe line was so smooth that my phone fell from my hands. 10/10 would subscribe again

[@voidmind]

I gotta admit that when I discovered your channel, I wasn't sure all these opinionated rants on tech were of any use, but clearly it's making a difference. I had seen your video on the Prisma cold start and while the library seemed interesting, there was no way I was going to introduce it in my stack if it was that slow. But now that they fixed it, thanks to you bringing people's attention to it and your community bugging the Prisma devs about it, I see the value. Same thing for the whole thing about moving away from create-react-app.

[@dddmasterduel4749]

The problem is still that they don't really use database-native joins (instead full db scan of individual tables) in most cases which is not scalable at all

[@imanmokwena1593]

You building a new army of coders. Suggestion.. please make a fullstack Playlist and document the best practices of making a production ready app while you making it.

[@goshmain982]

I really really strugle with authentication and JWT

[@jasoncavanaugh1556]

Strange seeing Theo in anything besides a dress shirt

[@t3dotgg]

Strange wearing anything other than a dress shirt tbh but I wanted to get this out asap

[@cheema33]

I am avoiding the cold start problem the easy way. By not using serverless functions. Servers are cheap. As long as you don't get them from the big 3 expensive players.

[@simonthordal303]

These subscription plugs are getting out of hand. I live for it.

[@hicoop]

Prisma is probably the only reason I'm not using serverless. Trying to run anything even remotely realtime like games isn't feasible when you're expecting a 600ms delay. Hot servers like an always running docker container give me more realistic 100-200ms delay

[@RolandAyala]

Cool, but I can't see myself ever going back to Prisma after getting my feet wet with Drizzle. Integrates very nicely w/ Planetscale serverless, end-to-end TS (i.e., no defining schemes externally and generating TS types), and native support for Zod. Keeping it real, there are some things I miss about Prisma, but the benefit Drizzle provides def outweigh the cons for my purposes.

[@kH-ul4hk]

drizzle is 0.23, its pre-release version, 1.0 (which will be released in 2023 still), will have all what you have with prisma. And they said the core would get even faster

[@Cuptial]

That little shoutout, "less than half of you are subscribed", was just beautiful lol

[@albertszymanski7177]

Could you cover MikroORM in some of your videos? It's a well designed ORM used by many in production but it somehow does not have a lot attention from developers. All the time I hear about Prisma, Drizzle (both are awesome) or TypeORM and Sequelize but MikorORM is not as widespread as the previously mentioned orms. I think MikroORM needs to be spoken of a lot more and you have quite a big audience so your word about it could make a huge difference. An example is Drizzle of which I found out in one of your videos.

[@christianohlzon]

Would you use Prisma over Drizzle now? Been using Drizzle with Planetscale, though Drizzle is fast the documentation and developer experience is quite bad compared to Prisma IMO.

[@williamx0]

I've also started using drizzle lately. In what way do you find the developer experience not as good? Just not as many examples as the fully featured docs on prisma? In terms of speed, Drizzle is still faster isn't it...? Or... I'd be open to another people's insight

[@jacoblockwood4034]

I've used both Prisma and Drizzle for a bit now and can say that for me personally, Prisma is a better choice, but Drizzle is better if you are more comfortable with the actual SQL that's being built under-the-hood.

[@williamx0]

@@jacoblockwood4034 thanks! lmao... I'm totally not comfortable with SQL coming from MongoDB and mongoose and then prisma. But I enjoy learning so thought drizzle is currently a nice way to learn about transactions and views and joins and stuff with SQL. Feels kinda cool to be slightly more "lower level" writing the actual SQL statements, but maybe once I learn it I'll think prisma is just more convenient lol. But... at the end of the day, whichever one is faster and more lightweight I think is one of the main factors for me once I'm comfortable with both. I'm not sure if Prisma works with this but all the adapters for Drizzle are for all the leading edge databases.. like Turso and cloudflare D1...

[@sangletech]

I'm currently building my app with Drizzle and I'm finding the documentation to be quite poor. I've been struggling to convert my schema from Mongoose to Drizzle, and even after asking the Drizzle team for feedback on my converted schema, I haven't received any response. I'm wondering when the new version of Prisma will be available. If it's coming soon, I'm seriously considering jumping ship to Prisma since it has better documentation and support for the T3 stack. Could you provide an update on when the new Prisma will be released? Thank you!

[@sirisaac8727]

@@sangletech drizzle is 0.23, its pre-release version, meaning its literally only a handful of months old. Its bleeding edge tech, after 1.0 (which will take probably couple of years if not a year or two), you'll have all what you have with prisma. Their devs are great and the community is pretty cool, it has a lot of potentional

[@akosbalint3485]

Thanks, its huge! Polimorphism and sqlite enums left and it will become a good orm.

[@brielov]

I don't use it anymore. They've been refusing to implement really basic features. Issues that have 3 years old now. Until they decide to implement them, prisma will remain a toy orm for small / side projects, unless you're using it for the migration and connection system and doing raw queries. But that would defeat the purpose of their beautiful typescript api.

[@mrsuperjuan10]

I totally agree with you.

[@odra873]

Good Job for explaining your issues so that ppl that didnt found them yet can be aware of them, oh wait you didn’t…

[@brielov]

@@odra873 Support for union types / polymorphic relationships, postgis support, recursive relationships, group by & aggregate over date ranges, soft deletes. Does this makes you happy?

[@lilililliilil]

Which db r u currently using rn?

[@brielov]

@@lilililliilil EdgeDB

[@netssrmrz]

Best prisma performance improvement we ever made was getting rid of prisma, the orm, and graphql.

[@supercompooper]

Much truth here

[@austincodes]

This sounds really interesting. I wonder when I'll be able to see the benefits of this in my apps

[@MentierD]

Prisma is by far my favorite ORM of all time. It’s got a fantastic community and it’s constantly improving

[@tehArgento]

well, that cold start sure is better than my free hosted docker spring boot rest api (2min+ lol)

[@sohn7767]

What about docker springboot graphQL

[@tehArgento]

@@sohn7767 it's running on a free instance so nothing of that would matter

[@maxwebstudio]

Thank you so much for all the work you do for sharing with us the latest updates 👾

[@ropoxdev]

That cold load time is the sweet spot for UX, how strange but users may be dissatisfied when page immediately loads on first try

[@ropoxdev]

This makes users feel "something” is going on there, for me thus satisfying them

[@martg0]

great news🎉 massive impact!!!

[@fev4]

I actually laughed out loud with the subscribe plug on the post LOL

[@ymi_yugy3133]

Does anyone know why databases connections are such a pain. They have pretty good throughput, but even modern databases can be pretty limited in the number of connections they accept and establishing the connection can take a surprisingly long time. Are there good reasons for this or are these just the remnants of a time when a database would ordinarily be connected to a single continuously running application server?

[@darylphuah]

no matter how fancy your database is, you still can't run away from the fact that it takes a CPU to process the request, Network to transfer the data and HDD/SSD to perform the I/O. Exceed any of these 3 and you'll have major performance issues. The initial database connection does quite a few things, from opening up the actual connections to validating the user, their permissions, etc. The larger your DB, the longer this can take simply because there's just more stuff to validate. If your app has high traffic, re-creating connections is likely going to be resource expensive. Which is why most systems now use a connection pool that's shared across multiple requests. A connection pool of around 10 could easily handle hundreds of requests/second.

[@Shri]

Uggh it came a bit too late for me. I moved on to Drizzle (after switching from Kysely). Now don't feel like going back to Prisma. Especially after having used Drizzle.

[@owenwexler7214]

I also fixed my app by deleting GraphQL but I did it much earlier, before initial release thankfully

[@riolly]

Finally, they focused on improving performance now.

[@tyu3456]

Don't forget about MikroORM. Unlike drizzle, It's ready for production

[@Xe054]

Are Prisma's large binary sizes still a barrier to deploying on the edge? If so, are there plans to fix that in the future?

[@wesleycoder]

Pingchan T-shirt?!? I want it badly now

[@RhysSullivan]

These subscribe callouts are starting to get too good

[@yarrichar]

Any word on when this will be available? What version?

[@Antebios]

Does Prisma still select the whole table before doing joins, this wasting bandwidth and time?

[@williamx0]

Damit, just when I changed over to Drizzle. Drizzle still seems a hair more lower level though being able to essentially write SQL but in typescript format. I'm thinking I'll still stick to Drizzle for the time being...

[@lilililliilil]

Could you please make a video that explains how to use edge functions with T3 app?

[@gerardvanhelden6891]

Sacrificing security (TLS) for performance is A Bad Idea™.

[@twinlamp]

Yeah I'm a little concerned that there was no "don't do this unless you know and accept the consequences" warning. For anyone who doesn't know, disabling ssl/tls will make all data transferred between the server and database readable by all the hops in-between your server and the database (ie: the entire internet, theoretically). Only ever consider doing this for truly public data and be damn sure you know that sensitive data is being fetched over a tls connection.

[@sortof3337]

Hello Theo, can you take a look at Turso. I switched from ps to Turso and my end to end latency got improved a lot. I love ps becaues it let's me do stuff so easily, but I am abhored by the latency in the asia.

[@zuma206]

yes! this!

[@patricknelson]

1:23 … bamboozled!

[@imanmokwena1593]

Thanks!

[@andresribeiroo]

I WAS LOOKING FOR THIS TODAY

[@KnightMirkoYo]

Chirp for some reason only shows ~5 days of posts and then loops them over again. Also the latest post you've added doesn't show without a refresh.

[@t3dotgg]

It shows the last 100 posts hard-coded and I didn't paginate it. I left those additions as challenges for viewers

[@croxx5f]

Dang, I had to subscribe after this one.

[@Pptruenoz]

When will this be available?

[@t3dotgg]

Already is! jsonProtocol is the flag

[@milon27]

everyone saying prisma has performance issue no good for production. what's your take on that?

[@dweblinveltz5035]

Now if I could only convince fellow devs to stop installing mongoose (or worse, momentjs).

[@pixelinercom]

I never got GraphQL, I mean it has it's advantages but performance wise it has always been bad. Every major company I worked with that used GraphQL has removed it

[@ABdStark]

Can you make a video on your pc setup

[@kayh_online]

these subscribe ctas are getting out of hand 😭😭

[@riskitall7421]

Looking rough here Theo. Groom up you handsome fella!

[@x911]

They need to add multiple schema file support

[@cornheadahh]

I still have no idea what GraphQL is and why I would need it.

[@atomauro]

Is really the t3 stack the best fking thing in the universe?

[@Leto2ndAtreides]

So now it needs DatabaseJS integration?

[@wezter96]

What is the performance difference like now between Prisma and Drizzle?

[@dddmasterduel4749]

sql joins

[@nicolasguillenc]

credit where credit is due!

[@luispirela7196]

please theo, convince them to add a way to code split the schema

[@t3dotgg]

Why?

[@aeghohloechu5022]

Wow they were using graphql for wire. Like just nobody saw any issues with that.

[@Disorrder]

that's makes no sense while Prisma has no soft-delete feature out of the box

[@kousheralam]

Hey theo bro, how many subscriber you got from Bangladesh 🇧🇩 ?

[@binitrupakheti4246]

Nope. It still doesn't do native joins when you're querying relations. That's inefficient as shit.

[@jonathankurtis]

Hey wait a second, I see what you did there.

[@HaozheYuda1989]

i was thinking to use prisma in our next project, i am more convinced now, thx

[@HaozheYuda1989]

and i smashed hard on the `subscribe` button!!!

[@Oscarvedo]

Don't do it lol

[@HaozheYuda1989]

@@Oscarvedo it was a total disaster! bed speed, bed stability, bed dev ux, hell schema, hell migration.... terrible terrible experience

[@drelroy]

Well done Theo

[@anonanon7368]

Why didn't you show how to do it?

[@boian-inavov]

You just add a json protocol flag to your schema. Have a look at their docs for that

[@nosticx8025]

@@boian-inavov Where in the docs does it say that?

[@nosticx8025]

@@boian-inavov great thank you very much

[@lumdermaku]

so tldr without the clickbait: it was a wrong usage/implementation of graphql instead of graphql itself.

[@Gorlik1337]

Because of that cold starts i moved to use raw sql queries just because of performance. Maybe i can come back

[@wolffparkinson]

Finally !!!

[@cody_codes_youtube]

Hahahahahahhahaha. I laughed just because of the graphql thumbnail

[@cody_codes_youtube]

Their use case seems so bizarre to me. I wonder how that architecture was presented to be implemented in the first place

[@Akhbash]

Theo 9x is 800% faster not 900%, "times" increase is multiplicative and percent is additive

[@Requiem100500]

prisma balls

[@alkolaqi83]

Prisma ❤

[@an-eios7125]

Yo What's with the primagen stache? 😂

[@Danielo515]

I’m not surprised, graphql sucks in everything except the idea

[@cristianmargineanu1458]

you're welcome mfer

[@kH-ul4hk]

Drizzle still better though

[@gungun974]

Nice 🎉

[@taufiqdev]

re-subscribed

[@pencilcheck]

interesting

[@simonfarre4907]

WHY did they rewrite the IPC to use JSON?!?!?!?!???!!?!!?! They literally could have used protobuf, capnproto or messagepack. All faster. All better. I swear web developers will plunge our society into darkness 😅

[@t3dotgg]

If you think protobuf would be faster here, you don’t actually understand what is slow. I sincerely hope you’re not making technical decisions for teams with this much misplaced confidence.

[@wahidislamlinad]

just write it in rust

[@t3dotgg]

It’s literally written in Rust that’s part of the problem

[@abbashussain7298]

it’s really cringey and off putting when you use these segues like in the last few videos to mention that people should subscribe to your channel. i always thought of you as a nonchalant, not really caring about numbers sort of creator and that’s what attracted to me to being a subscriber. this is a major fall from grace

[@alejkun4923]

Has this affected the value he provides? I get to pick his brains and expertise for free. He shares information and perspectives that are high quality and super valuable to me, for free.

[@_sjoe]

Dude, he’s literally trying to make a living out of providing you with free, high quality content. “Not really caring about numbers creator” he has to pay his rent my guy. How can people be so entitled, listen to yourself for one second.

[@abbashussain7298]

@@_sjoe You don't have to agree with me if you don't want to. It's not that I don't want people to subscribe to his channel, frankly I don't have an issue with every person on earth being subscribed to Theo. I'm merely remarking on the fact that when he uses these corny segues it's off-putting and makes me cringe. I don't have to be a hater to think that a person saying "C'mon guys, only 43% of you are subscribed to the channel. Click that subscribe button" is so close to begging it makes me wince when I hear it. It makes me lose a lot of respect for whoever I hear it from because the creator hasn't realised that when people like your channel, they don't have to be prompted to click the button. They will subscribe of their own accord. My opinion. Nobody has to agree with me. I just find it cringe. Off-putting. Corny. Embarrassing.

[@Dev-Siri]

I am currently subscribed to you. But every video you are !ing me and switching the boolean.