Drizzle ORM SQLite and Nuxt - An Introduction To CRUD with API Routes
#drizzle #database #nuxt #sqlite
Drizzle is an Object Relational Mapper (ORM) for SQL databases. It is a lightweight and easy-to-use ORM that can map data between a relational database and an object-oriented programming language.
Better SQLite is a wrapper around the SQLite database engine that provides a number of improvements over the standard SQLite API. One of those benefits is type safety, Better SQLite uses TypeScript to provide type safety for queries, which can help to prevent errors.
This video walks through integrating Drizzle ORM into a Nuxt JS project and creating the server API routes for CRUD actions on a user object. The routes are tested using Thunder Client, a lightweight REST API Client Extension for Visual Studio Code; similar to Postman.
The next video will integrate the NUXT AUTH - • Nuxt, Drizzle ORM and SQLite - Integr...
💥 Sign Up For Our Newsletter - https://buff.ly/3lAk2jL
💥 Chapters
--------------------------
00:00 - Introduction
01:17 - Thoughts on Documentation
03:06 - Install Nuxt & Drizzle Related Packages
04:56 - Verify Nuxt Runs & Starting Config wit drizzle.config.ts
06:16 - Setting Up Schema File
07:39 - Running migrations and pushes with Drizzle Kit
09:48 - Running Drizzle Studio and Doing Another Push To See updates
13:08 - Drizzle integrating With Nuxt
15:01 - Implementing users.get
17:18 - Implementing users.post
22:00 - Implementing users.get for getting a user by id
28:41 - Implementing users.delete
31:04 - Implementing users.put, updating the user
34:01 - Testing PUT
32:20 - Testing DELETE
36:04 - Wrap Up Comments on Part 2 of Video Series
💥 Links
--------------------------
Drizzle Quick Start - https://orm.drizzle.team/docs/quick-s...
Drizzle Kit - https://orm.drizzle.team/kit-docs/ove...
Drizzle ORM Sqlite - https://github.com/drizzle-team/drizz...
Better Sqlite 3 - https://github.com/WiseLibs/better-sq...
SEE BLOG POST - https://dev.to/aaronksaunders/drizzle...
💥 Social Media
--------------------------
Twitter - / aaronksaunders
Facebook - / clearlyinnovative
Instagram - / aaronksaunders
Dev.to - https://dev.to/aaronksaunders
Смотрите видео Nuxt, Drizzle ORM and SQLite - An Introduction To CRUD with API Routes онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Aaron Saunders 05 Август 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 4,18 раз и оно понравилось 7 людям.