Neon
Neon
  • Видео 53
  • Просмотров 111 822
Postgres multi-tenant architecture for AI apps (database per user/workspace/org)
Instead of storing all vector embeddings in one shared Postgres database, you provide each tenant (a user, an organization, a workspace, etc.) their own dedicated Postgres database with pgvector
Code + demo: github.com/neondatabase/db-per-tenant
This means:
1. Each tenant's data is stored in a separate, isolated database not shared with other tenants. This makes it possible for you to be compliant with data residency requirements (e.g., GDPR)
2. Database resources can be allocated based on each tenant's requirements.
3. A tenant with a large workload that can impact the database's performance won't affect other tenants; it would also be easier to manage.
This is possible to implement using Post...
Просмотров: 545

Видео

CLI for scaffolding full stack JS apps just dropped (Next.js, Prisma, Drizzle, Auth.js and more)
Просмотров 7502 месяца назад
Learn about the CLI command `npx neonctl create-app`, which scaffolds an opinionated template for full-stack JavaScript apps powered by Postgres hosted on Neon. • The Experience of Deploying Next.js Apps on Cloudflare: davidgomes.com/the-experience-of-deploying-next-js-apps-on-cloudflare/ • CLI command reference: neon.tech/docs/reference/cli-create-app • CLI GitHub repo: github.com/neondatabase...
Why your preview deployments aren't production like (probably)
Просмотров 4314 месяца назад
Learn how to create isolated, anonymized copies of your production data for your Postgres database: neon.tech/blog/how-to-create-previews-with-anonymized-production-like-data-in-seconds Try Neon at neon.tech/youtube → Neon Discord: neon.tech/discord → Follow us on Twitter: neondatabase → Star us on GitHub github.com/neondatabase/neon
Ship better apps with this CI/CD flow
Просмотров 1,5 тыс.5 месяцев назад
Learn to integrate Postgres into your Software Development Life Cycle with Database Branching. We go over creating database branches for preview deployments and local development. Demo code: github.com/neondatabase/preview-branches-with-fly Try Neon at neon.tech/youtube → Neon Discord: neon.tech/discord → Follow us on Twitter: neondatabase → Star us on GitHub github.com/neondatabase...
Postgres on Neon: a new approach to database development
Просмотров 3,8 тыс.6 месяцев назад
Neon, a fully managed serverless Postgres database, is generally available 🎉 In this video, we cover some of the features that were released as part of this launch. → Try Neon at neon.tech/youtube → Neon Discord: neon.tech/discord → Follow us on Twitter: neondatabase → Star us on GitHub github.com/neondatabase/neon Instructor: thisismahmoud_ | linkedin.com/in/mahmoud-codes
Restore a 1,000GB+ Postgres database in 1 second (literally)
Просмотров 2,7 тыс.6 месяцев назад
→ Try Neon at neon.tech/youtube → Neon Discord: neon.tech/discord → Follow us on Twitter: neondatabase → Star us on GitHub github.com/neondatabase/neon Instructor: thisismahmoud_ | linkedin.com/in/mahmoud-codes
Prisma essentials: from development to production (Prisma Migrate workflow)
Просмотров 3 тыс.6 месяцев назад
Learn about database migrations using Prisma Migrate and how to go from Development to Preview to Production. - Code example: github.com/neondatabase/preview-branches-with-fly/tree/with-prisma - Try Neon at neon.tech/youtube → Neon Discord: neon.tech/discord → Follow us on Twitter: neondatabase → Star us on GitHub github.com/neondatabase/neon Instructor: thisismahmoud_ |...
A Postgres database for Every Vercel Preview Deployment
Просмотров 1,5 тыс.7 месяцев назад
Learn how to create a Postgres database for every preview deployment using the Neon integration on Vercel If you have an existing CI pipeline, check out this blog post, which covers achieving the same result using GitHub Actions and the Vercel CLI: neon.tech/blog/branching-with-preview-environments. Instructor: thisismahmoud_ | linkedin.com/in/mahmoud-codes → Try Neon at neon.tech/y...
This Postgres Driver Is Perfect for Serverless Apps
Просмотров 3,2 тыс.7 месяцев назад
Learn how you can use the Neon Serverless Driver. It provides WebSocket and HTTP transport options because some environments don't support raw TCP (e.g. Cloudflare Workers didn't when we released the driver, and Vercel Edge Functions still don't). More on this here: neon.tech/blog/serverless-driver-for-postgres In a serverless environment, you may need to reconnect with every web request, so we...
AWS Amplify Gen 2 Full stack CI/CD with Postgres (SSR, Web Compute, Auto-detection, SSM)
Просмотров 1,4 тыс.7 месяцев назад
Neon Postgres Branch for each Amplify Hosting app branch. ⭐ GitHub repo with example Amplify Hosting Build Settings and Bash script: github.com/siegerts/neon-branches-amplify-cicd This video walks through how to integrate AWS Amplify Hosting with Neon Postgres for database management through CI/CD pipelines. The setup includes a custom Bash script for creating and cleaning up Neon database bran...
Copy a 1,000GB+ Postgres database in 1 second (literally)
Просмотров 6 тыс.7 месяцев назад
Learn how you can instantly create isolated copies of your Postgres database on Neon Instructor: thisismahmoud_ | www.linkedin.com/in/mahmoud-codes/ → Try Neon at neon.tech/youtube → Neon Discord: neon.tech/discord → Follow us on Twitter neondatabase → Star us on GitHub github.com/neondatabase/neon 00:00 - Intro 00:19 - Checking Postgres database size 00:45 - pgbench sch...
Build a Serverless API (Cloudflare Workers, Drizzle ORM, Hono & Neon)
Просмотров 15 тыс.8 месяцев назад
Final code: github.com/neondatabase/cloudflare-drizzle-neon In this video, you'll learn how to use Cloudflare Workers, Hono, Drizzle ORM, and Neon to build a serverless API. Instructor: thisismahmoud_ | www.linkedin.com/in/mahmoud-codes/ → Try Neon at neon.tech/youtube → Neon Discord: neon.tech/discord → Follow us on Twitter neondatabase → Star us on GitHub github.com/ne...
Learn Drizzle ORM in 13 mins (crash course)
Просмотров 30 тыс.8 месяцев назад
Code used in the video: github.com/neondatabase/drizzle-overview In this video, you'll learn Drizzle ORM. We'll talk about its different components, how to define your database schema, and its SQL-like querying API as well as its relational API Instructor: thisismahmoud_ | www.linkedin.com/in/mahmoud-codes/ → Try Neon at neon.tech/youtube → Neon Discord: neon.tech/discord → Follow u...
A Postgres Database for Every Fly.io Preview (ft. Drizzle ORM & GitHub Actions)
Просмотров 1,3 тыс.8 месяцев назад
Demo app: github.com/neondatabase/preview-branches-with-fly Learn how you can create a Postgres database for every Preview using Neon, GitHub Actions, Drizzle ORM, and Fly.io Instructor: thisismahmoud_ | www.linkedin.com/in/mahmoud-codes/ → Try Neon at neon.tech/youtube → Neon Discord: neon.tech/discord → Follow us on Twitter neondatabase → Star us on GitHub github.com/n...
What is Neon Serverless Postgres?
Просмотров 9 тыс.8 месяцев назад
➡️ Try Neon at neon.tech ➡️ Follow us on Twitter neondatabase ➡️ Star us on GitHub github.com/neondatabase/neon ➡️ Join the Neon Discord neon.tech/discord
The Safest Way to Test Postgres Destructive Queries
Просмотров 3708 месяцев назад
The Safest Way to Test Postgres Destructive Queries
Secure Your Neon Database By Restricting Access to Known IPs
Просмотров 1819 месяцев назад
Secure Your Neon Database By Restricting Access to Known IPs
Code-Like Database Branching for Postgres with Neon
Просмотров 2,1 тыс.10 месяцев назад
Code-Like Database Branching for Postgres with Neon
Streamline your workflows with Neon Branch Reset
Просмотров 23710 месяцев назад
Streamline your workflows with Neon Branch Reset
Build an AI-powered book recommendation app using Hasura, pgvector and Neon (Simrat Hanspal)
Просмотров 30111 месяцев назад
Build an AI-powered book recommendation app using Hasura, pgvector and Neon (Simrat Hanspal)
The Future of Development Environments (Zach Zaro)
Просмотров 9611 месяцев назад
The Future of Development Environments (Zach Zaro)
Optimizing your workflows with Neon Branching (Raouf Chebri)
Просмотров 31711 месяцев назад
Optimizing your workflows with Neon Branching (Raouf Chebri)
Revolutionizing business intelligence using Appsmith and Neon (Kevin Blanco)
Просмотров 18211 месяцев назад
Revolutionizing business intelligence using Appsmith and Neon (Kevin Blanco)
State of Drizzle 2023 (Alex Blokh)
Просмотров 67411 месяцев назад
State of Drizzle 2023 (Alex Blokh)
Using Natural Language to Query Postgres (Jacob Lee)
Просмотров 18211 месяцев назад
Using Natural Language to Query Postgres (Jacob Lee)
Fullstack Preview Environments with Neon and Qovery (Romaric Philogène)
Просмотров 6211 месяцев назад
Fullstack Preview Environments with Neon and Qovery (Romaric Philogène)
Don't let bad data block you (Peter Pistorius)
Просмотров 3711 месяцев назад
Don't let bad data block you (Peter Pistorius)
Deploy Fullstack apps with Koyeb and Neon (Edouard Bonlieu)
Просмотров 37711 месяцев назад
Deploy Fullstack apps with Koyeb and Neon (Edouard Bonlieu)
How to use NPM packages outside of Node (George MacKerron)
Просмотров 3911 месяцев назад
How to use NPM packages outside of Node (George MacKerron)
Building internal apps with AI and Neon (George Du)
Просмотров 8211 месяцев назад
Building internal apps with AI and Neon (George Du)

Комментарии

  • @carlotadias9335
    @carlotadias9335 18 часов назад

    hello, I have this config import { defineConfig } from "drizzle-kit"; export default defineConfig({ schema:"./src/db/schema.ts", out: "./src/db/migrations", dialect: "sqlite", driver: "d1-http", strictNullChecks : true, strict: true, dbCredentials: { url: "file:./src/db/sqlite.db", }, }); And I'm having the error in the url inside of the dbCredentials : Object literal may only specify known properties, and 'url' does not exist in type '{ accountId: string; databaseId: string; token: string; }'.ts(2353) (property) url: string Any idea on what can be wrong ?? Thank you in advance,

  • @王琦-f3b
    @王琦-f3b 5 дней назад

    sir, how to get the direct url?

  • @carlotadias9335
    @carlotadias9335 5 дней назад

    great video thank you 😊😊😊😊😊😊😊😂😂

  • @zoranaw7964
    @zoranaw7964 9 дней назад

    Do you have any kind of affiliate program? For somebody who already have or plan to have youtube PSQL tut channel. Could be beneficial and useful. Please lett me know what you think about that.

  • @conradludgate
    @conradludgate 25 дней назад

    It's fascinating you could even consider an architecture like this

    • @iukeay
      @iukeay 23 дня назад

      This works dang well depending on the type of data that will be in the vector store (I'm not talking file types but access patterns) Depending on your metadata tied to each document / metadata that points to a summary index . 🫠🫠🫠🫠 I've learned a lot of this coming down to your application logic less so than the database.... But I have no idea what I'm doing

  • @aryan.prince
    @aryan.prince 25 дней назад

    6:31 Let’s say you have 10,000 users. This means the migration script will connect to db_1, run all migrations, close connection to db_1, then connect to db_2, on and on for... …every user? …does this ‘scale’ well? I’m talking more about time and complexity I guess, and what if db_7193 fails to run all migrations?

    • @conradludgate
      @conradludgate 25 дней назад

      It would make sense to store the schema version in the databases table, so it's easier to retry and to perform a gradual rollout. Performance wise it might be in the same order of magnitude as postgres schema changes might have to update every row anyway, so having smaller tables but more of them to update would equate to about the same amount of work

  • @8bitWatermelon
    @8bitWatermelon 28 дней назад

    Really enjoyed the video, currently learning to use drizzle for projects. For anyone who is trying to use drizzle-kit generate with cli params. The code in the video will not work. This is my solution after many trials and errors. "db:generate": "drizzle-kit generate --dialect postgresql --schema ./src/db/schema.ts --out=./src/db/migrations" Thank you.

  • @adityaparghi-j8e
    @adityaparghi-j8e 28 дней назад

    Hello can anyone please answer this, when i run npm create cloudflare --name and i select cloudflare workers , typescript, deploy no and when i go to vs code and run npm run dev it throws error errono -4095 i done everything uninstall Wrangler, install it again but it just doesn't work how can resolve this if anyone help

  • @mgmgmgmg00-s2z
    @mgmgmgmg00-s2z 28 дней назад

    Nice!

  • @andrewokoye8017
    @andrewokoye8017 Месяц назад

    I am struggling to connect my phoenix application to Neon, the issue is around SSL

  • @haydonge5328
    @haydonge5328 Месяц назад

    lots content for drizzle have been changed. Hope to update it with learning course.

  • @etj1237
    @etj1237 2 месяца назад

    Please Please Please tell us what theme and icon pack you're using !!!! 🙏🙏🙏🙏🙏

    • @neondatabase
      @neondatabase 2 месяца назад

      GitHub Dark default (theme) + Symbols (icons) - Mahmoud

  • @jamesbotwina8744
    @jamesbotwina8744 2 месяца назад

    Great work!

  • @francescoimpellizzeri1345
    @francescoimpellizzeri1345 2 месяца назад

    This is so good! I love the minimalistic approach and how the CLI sets up what’s needed to start building and nothing more. Super nice 🎉

  • @asadmehboob1300
    @asadmehboob1300 2 месяца назад

    Please add Hono beckend with nextjs and drizzle orm

    • @jamesbotwina8744
      @jamesbotwina8744 2 месяца назад

      Why would you want a Hono backend with NextJs?

    • @DavidGomes
      @DavidGomes 2 месяца назад

      This is not just Next.js! We’ll definitely add Hono in the future.

  • @jamesfoley4426
    @jamesfoley4426 2 месяца назад

    Adding the db:generate command to package.json. I could not get the shortcut working that is demoed in the video I had to use drizzle-kit generate --dialect=postgresql --schema=./src/db/schema.ts just in case you run into the same issue great video tutorial

  • @neondatabase
    @neondatabase 2 месяца назад

    Thanks for watching! If you have any questions, feel free to reach out in the Neon Discord neon.tech/discord Check out the documentation for the create-app CLI command: neon.tech/docs/reference/cli-create-app

  • @Ziko2687s8
    @Ziko2687s8 3 месяца назад

    Peerfect!!! This just saved our project!

  • @lapulapucityrider3227
    @lapulapucityrider3227 3 месяца назад

    Ip filter is not enough, cant even know the ip especially when deploying with ecs. Better vpc peering if you can do that also dont put it behind paywall ar atleast enable it with $19 dollar option

  • @rikawrites7104
    @rikawrites7104 3 месяца назад

    love your energy !!! this was fun to wactch

  • @JOELJACOBEMMANUELJOELJACOBEMMA
    @JOELJACOBEMMANUELJOELJACOBEMMA 3 месяца назад

    honestly neon had one of the best visually appealing website ive ever seen. love what you guys do.

  • @HassanElMghari
    @HassanElMghari 3 месяца назад

    Great video!!

  • @eliuddyn
    @eliuddyn 3 месяца назад

    Amazing 🔥🔥

  • @hakuna_matata_hakuna
    @hakuna_matata_hakuna 3 месяца назад

    no local dev?

  • @kenshinhimura3140
    @kenshinhimura3140 3 месяца назад

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

  • @darkbgm4582
    @darkbgm4582 4 месяца назад

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

  • @JissJoy-zt1is
    @JissJoy-zt1is 4 месяца назад

    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.

  • @eliastouil7686
    @eliastouil7686 4 месяца назад

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

  • @lifanhuang3181
    @lifanhuang3181 4 месяца назад

    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.

  • @MahmoudMahmoudTobi
    @MahmoudMahmoudTobi 4 месяца назад

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

  • @VB-sn2qn
    @VB-sn2qn 4 месяца назад

    Its free or not??

  • @raine-works
    @raine-works 4 месяца назад

    What theme and icons are you using for VSCode?

  • @TurtleMotion
    @TurtleMotion 4 месяца назад

    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?

  • @abhisekdas9976
    @abhisekdas9976 4 месяца назад

    What vscode icon pack are you using?

  • @dyelbruv
    @dyelbruv 4 месяца назад

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

    • @neondatabase
      @neondatabase 4 месяца назад

      This example app isn't using Vercel as the deployment provider, it's using Fly.io. If the example app was using Vercel, then the using the Vercel integration would make more sense :) - Mahmoud

    • @HHJoshHH
      @HHJoshHH 4 месяца назад

      You're awesome Mahmoud. Thank you for these videos! I hope I spelled your name right. 😊

  • @bilbo_skywalker
    @bilbo_skywalker 5 месяцев назад

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

  • @NicholasHaley-zc7ym
    @NicholasHaley-zc7ym 5 месяцев назад

    This is so great

  • @tzuilee588
    @tzuilee588 5 месяцев назад

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

  • @budivoogt491
    @budivoogt491 5 месяцев назад

    Great walkthrough, thanks Mahmoud.

  • @dus10dnd
    @dus10dnd 6 месяцев назад

    What even is Neon?

  • @Mouradif
    @Mouradif 6 месяцев назад

    Is this a response video?

    • @MahmoudAbdelwahab
      @MahmoudAbdelwahab 6 месяцев назад

      No haha. We planned our GA launch a while ago (April 15th) and this is a recap of what we shipped :)

  • @runescapes
    @runescapes 6 месяцев назад

    very exciting features

  • @neondatabase
    @neondatabase 6 месяцев назад

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

  • @jan.tichavsky
    @jan.tichavsky 6 месяцев назад

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

  • @DroisKargva
    @DroisKargva 6 месяцев назад

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

  • @PKristianCZ
    @PKristianCZ 6 месяцев назад

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

  • @brayanyevenes5954
    @brayanyevenes5954 6 месяцев назад

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

  • @neondatabase
    @neondatabase 6 месяцев назад

    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

  • @abhinasregmi9742
    @abhinasregmi9742 6 месяцев назад

    You look so happy 😊 😊

  • @javierfuentesmora1814
    @javierfuentesmora1814 6 месяцев назад

    do you need to close the db connection ?