khadinakbarlabs/expo-mobile-app-builder/add-drizzle-sqlite

pnpm add drizzle-orm
pnpm add -D drizzle-kit
npm exec --no -- expo install expo-sqlite

// db/schema.ts
import { sqliteTable, text, integer } from 'drizzle-orm/sqlite-core';
export const habits = sqliteTable('habits', {
  id: text('id').primaryKey(),
  name: text('name').notNull(),
  streak: integer('streak').default(0),
  createdAt: integer('created_at', { mode: 'timestamp' }).notNull(),
});

// db/index.ts
import { drizzle } from 'drizzle-orm/expo-sqlite';
import { openDatabaseSync } from 'expo-sqlite';
import * as schema from './schema';
const expoDb = openDatabaseSync('app.db');
export const db = drizzle(expoDb, { schema });

// drizzle.config.ts
import type { Config } from 'drizzle-kit';
export default {
  schema: './db/schema.ts',
  out: './db/migrations',
  dialect: 'sqlite',
  driver: 'expo',
} satisfies Config;

npm exec --no -- drizzle-kit generate

import { useMigrations } from 'drizzle-orm/expo-sqlite/migrator';
import migrations from './db/migrations/migrations';
const { success, error } = useMigrations(db, migrations);

import { eq } from 'drizzle-orm';
const all = await db.select().from(habits);
const one = await db.select().from(habits).where(eq(habits.id, '123'));
await db.insert(habits).values({ id: '123', name: 'Read', createdAt: new Date() });
await db.update(habits).set({ streak: 5 }).where(eq(habits.id, '123'));
await db.delete(habits).where(eq(habits.id, '123'));

pnpm add expo-sqlite/build-utils  # for encryption