The database platform for content-driven websites

// Define your Posts table
const Posts = defineTable({
  columns: {
    author: column.text(),
    title: column.text()
    content: column.text(),
  }
});

// Retrieve all post titles by author
await db.select({ title: Posts.title })
  .from(Posts)
  .where(eq(Posts.author, "James"))

// Define your Submissions table
const FormSubmissions = defineTable({
  columns: {
    fullName: column.text(),
    email: column.text(),
    message: column.text(),
  }
})

// Insert a new response
await db.insert(FormSubmissions).values({
  fullName,
  email,
  message,
})

// Configure your database schema
const Reactions = defineTable({
  columns: {
    postId: column.number({ references: () => Post.columns.id }),
    emoji: column.text()
  }
})

// Insert a new post reaction
await db.insert(Reactions).values({
  postId: "12345",
  emoji: "🔥"
})

// Define your tables
const Users = defineTable({
  columns: {
    id: column.number({ primaryKey: true }),
    username: column.text()
  }
})
const Sessions = defineTable({
  columns: {
    id: column.number({ primaryKey: true }),
    userId: column.number({ references: () => User.columns.id }),
    expiresAt: column.number(),
  }
})

// Read and validate session cookie
const sessionId = context.cookies.get('session')
const { session, user } = await lucia.validateSession(sessionId)

// Query the user profile
const profile = await db.select()
  .from(Users)
  .where(eq(Users.id, user.id))