Discover Drizzle, a modern, type-safe ORM that's lightweight and highly performant. Learn how to define and manage database schemas in TypeScript and access your data in a SQL-like manner.
Drizzle stands out for its flexibility and performance, making complex queries simple and efficient.
In this tutorial, we'll cover ORM basics, self-hosting a database with Docker, and dive into a full project: a blog website with user sign-ups, posts, comments, and advanced search functionality. Unlock the full power of SQL within TypeScript with Drizzle!
#drizzle #sql #postgresql #nodejs
🔗 Links:
Commands and Code Snippets:
[ Ссылка ]
Project Github Repository (Don't forget to leave a star⭐) :
[ Ссылка ]
What you will learn:
What are ORMs (Object Relational Mappers)?
How to self-host your own SQL database server using docker?
How to self-host SQL database management admin dashboard?
How to define tables in Drizzle?
How to define relations between tables and columns in Drizzle?
How to define many-many, one-to-many and one-to-one relations in Drizzle?
How to insert, update and delete records on Drizzle?
How to migrate SQL database in Drizzle?
How to seed SQL database in Drizzle using faker-js?
How to handle pagination in SQL and Drizzle?
How to sync Zod schemas with Drizzle?
⭐️ Contents ⭐
⌨️ 00:00:00 Intro
⌨️ 00:02:25 Project Setup
⌨️ 00:09:20 Docker Database Server
⌨️ 00:12:40 Database Structure Schema
⌨️ 00:19:20 Relations in Drizzle
⌨️ 00:29:20 Drizzle and Zod
⌨️ 00:52:20 Seeding
⌨️ 01:01:32 Replacing Mock Data With Real Database
🔗 Resources:
[ Ссылка ]
