วีดีโอ

no local dev?

Cool to see a brother with a food life, god bless you

this is not free when i am adding ip addres asking for upgrade

Great stuff! It was really informative. I had a slightly different question. 😅 The editor folder icons and theme, which extension are you using? I really liked em! Would be glad if you could share it.

This is a great intro thank you! Came here from Fireship's vid.

Hi, I have a suggestion with the Neon authorization 3rd party APPs part. I found that you authorized Cloudflare to read the Neon project, and then Cloudflare could fetch the DB password with such permissions. I think it's necessary to add a explicit hint at the authorization page, that the Read permission can see your DB password.

lol was a bit trippy when i saw my name on the link there. not everytime I see my name on a tech tutorial.

Its free or not??

What theme and icons are you using for VSCode?

Is there a way to integrate this with the automatic CI/CD integration you have with Vercel? I believe the integration automatically creates new branches for every preview deployment. Is it possible to anonymize the data in those automatically created branches?

What vscode icon pack are you using?

How come you didn't use the Vercel integration with Neon to create the preview branches instead of GH actions?

why is this only on scale plan? need it on launch too

This is so great

Thank you for your clean explanation and taking the time to answer questions in comments below, its super helpful! 😁

Great walkthrough, thanks Mahmoud.

What even is Neon?

Is this a response video?

very exciting features

Neon is Generally available! 🎉 Check out the announcement blog post: neon.tech/blog/neon-ga

The best is to use SELECT instead of DELETE to see what you will be deleting but this is good 2nd option 😀

fk I have ont touched db stuff for so long that I forgot how to "database" 😅

not gonna lie, this sound interesting af :) will definetly check it out

Is necessary change build command 8:45 in vercel when usign drizzle orm o the default build is ok?

Try Neon at neon.tech/youtube and instantly spin up a Postgres database for free 🚀 - Point In Time Restore in Neon under the hood: neon.tech/blog/point-in-time-recovery-in-postgres - Documentation: neon.tech/docs/introduction/point-in-time-restore

You look so happy 😊 😊

do you need to close the db connection ?

thank you, this was a nice one, hope there is another how relationships works in drizzle, tyy

An video with example to making a migration with a breaking change on the db would be awesome. There are not many good examples to do so with prisma migrations

What would be the right way to handle the db initialisation? Do I write the two lines in every single api single I need the env variables (since we are using hono)? Do I create the db in a middleware and then add that to hono context? What is the right way here?

Hello, was a good video and I appreciate all the work that has been done on the project. Just a quick heads up, in case someone isn't using the usual database name "neondb", you will need to provide the your database name on your workflow otherwise it will fail. env: NEON_DATABASE_NAME: ${{ secrets.NEON_DATABASE_NAME }} # change this to your database name jobs: name: Create Neon Branch with: database: ${{ env.NEON_DATABASE_NAME }} Also, this secret will need to be added to your github actions secrets. Appreciate your guides Neon, looking forward to the next features

Subscribing because the host is a cool guy

do i need to write this every endpoint need query/insert to db? const client = new Client({ connectionString: c.env.DATABASE_URL }); const db = drizzle(client); await client.connect();

This is the best intro to Drizzle I've ever seen

Can you guys make a video on migrations I came from planet scale and they had they best migration experience with branches, why isnt neon doing that

Pool and Client - in the edge environment doesn't make any difference let alone make any sense. Very confusing to use Pool - but not actually mean or get a Pool!! :( Why not EdgeClient? Clear in what it does and the mental model is gracefully guided to remember to close the connection.

Neon's free tier is too miser as compared with turso's

If you'd like to create a Postgres database for every Preview deployment using Platforms other than Vercel, check out the following guides: - Automation using GitHub Actions: neon.tech/docs/guides/branching-github-actions - Neon CLI: neon.tech/docs/reference/neon-cli - Automated database branches using GitHub Actions and the Vercel CLI: neon.tech/blog/branching-with-preview-environmentsneon.tech/blog/branching-with-preview-environments

export const db = drizzle(sql) This line is showing me the error: "Argument of type 'NeonQueryFunction<false, false>' is not assignable to parameter of type 'NeonQueryFunction<boolean, boolean>'. Types of property 'transaction' are incompatible.

Can you tell how to access the env vars outside the get method? I read the docs but couldn't understand.

Could you help me with this line? const db = drizzle(sql); The parameter is giving an error, but I did it identically to yours, I defined the environment variable the error follows: Types of property 'transaction' are incompatible. Type '<ArrayModeOverride extends boolean = false, FullResultsOverride extends boolean = false>(queriesOrFn: NeonQueryPromise<false, false, any>[] | ((sql: NeonQueryFunctionInTransaction<ArrayModeOverride, FullResultsOverride>) => NeonQueryInTransaction[]), opts?: HTTPTransactionOptions<...> | undefined) => Promise<...>' is not assignable to type '<ArrayModeOverride extends boolean = boolean, FullResultsOverride extends boolean = boolean>(queriesOrFn: NeonQueryPromise<boolean, boolean, any>[] | ((sql: NeonQueryFunctionInTransaction<ArrayModeOverride, FullResultsOverride>) => NeonQueryInTransaction[]), opts?: HTTPTransactionOptions<...> | undefined) => Promise...'. Types of parameters 'queriesOrFn' and 'queriesOrFn' are incompatible. Type '((sql: NeonQueryFunctionInTransaction<any, any>) => NeonQueryInTransaction[]) | NeonQueryPromise<boolean, boolean, any>[]' is not assignable to type '((sql: NeonQueryFunctionInTransaction<any, any>) => NeonQueryInTransaction[]) | NeonQueryPromise<false, false, any>[]'. Type 'NeonQueryPromise<boolean, boolean, any>[]' is not assignable to type '((sql: NeonQueryFunctionInTransaction<any, any>) => NeonQueryInTransaction[]) | NeonQueryPromise<false, false, any>[]'. Type 'NeonQueryPromise<boolean, boolean, any>[]' is not assignable to type 'NeonQueryPromise<false, false, any>[]'. Type 'NeonQueryPromise<boolean, boolean, any>' is not assignable to type 'NeonQueryPromise<false, false, any>'. Type 'boolean' is not assignable to type 'false'.ts(2345) const sql: NeonQueryFunction<false, false>

Why would a http/websocket connection be better than just a direct TCP connection?

If I use neon branches, do I still have to create migrations? Planetscale explains that branches negate migrations so use db push instead of db migrate (for prisma)

This was absolutely boring, lol JS devs are probably dying of boredom.

Kudos on the thumbnail

"Instead of TCP it offers HTTP and WebSockets" doesn't make sense. HTTP (unless you're talking HTTP/3) is basically always built on TCP as is the WebSocket protocol. It is also not clear to me, why adding additional complexity to fetching data from a database is actually useful here. As I see it, constructing a HTTP request or WebSocket payloads is way more resource intensive than just opening a TCP connection, especially since authentication and certificate checks still have to be done (twice actually, since the API has to do it for the incoming connection and then the Postgres Database has to do it again for the API). Curious to know if I'm missing some big advantage here.

Great in Deno Deploy this configuration also works very fast 👌

If you enjoyed watching this video, make sure to like and subscribe so you don't miss out on any future videos. How the driver works: - How the WebSocket version of the driver works: neon.tech/blog/serverless-driver-for-postgres - How we reduced the driver's latency by cutting network round-trips in half: neon.tech/blog/quicker-serverless-postgres#baseline-nine-round-trips-to-first-query-result - Performance of SQL-Over-HTTP: neon.tech/blog/sub-10ms-postgres-queries-for-vercel-edge-functions Try out Neon: neon.tech/youtube The Neon Serverless Driver: github.com/neondatabase/serverless

If you enjoyed watching this video, make sure to like and subscribe so you don't miss out on any future videos. Try out Neon: neon.tech/youtube Neon documentation: neon.tech/docs/

bro do you have any full tutorial video i want to learn more about your neon database