What is the TypeScript-first database stack using Drizzle ORM + Nitro in Nuxt ?

npm install drizzle-orm drizzle-kit @neondatabase/serverless
npm install -D drizzle-kit
      

// db/schema.ts
import { pgTable, serial, text, timestamp } from 'drizzle-orm/pg-core'

export const users = pgTable('users', {
  id: serial('id').primaryKey(),
  name: text('name').notNull(),
  email: text('email').unique()
})
      

// server/utils/db.ts
import { drizzle } from 'drizzle-orm/node-postgres'
import { users } from '~/db/schema'

export const db = drizzle(client, { schema: { users } })
      

// server/api/users.get.ts
export default defineEventHandler(async () => {
  return await db.select().from(users)
})
      

<script setup lang="ts">
const { data: users } = await $fetch<User[]>('/api/users')
</script>