Chris Dosé Comments - Answer Overflow

Chris Dosé

•Created by Chris Dosé on 10/16/2024 in #help

Question about Live Queries and when they update

seems like the change listener is only added to the main table, source here: https://github.com/drizzle-team/drizzle-orm/blob/64b3c85953d35bf37342ba8cb2b48f2ad08ee7a8/drizzle-orm/src/expo-sqlite/query.ts#L39

3 replies

DTDrizzle Team

•Created by Chris Dosé on 10/16/2024 in #help

Question about Live Queries and when they update

3 replies

DTDrizzle Team

•Created by Chris Dosé on 10/16/2024 in #help

[solved] SQLite in expo with useMigrations is failing without any error (just rollback)

oh... do the names have to be unique? This is not made clear 😅 wish the error message told me this!

2 replies

DTDrizzle Team

•Created by Chris Dosé on 10/15/2024 in #help

[solved] useLiveQuery seems to always run the query twice

thank you! this really explains things 😅 sorry for what appears to be a react-n00b question

10 replies

DTDrizzle Team

•Created by Chris Dosé on 10/15/2024 in #help

[solved] useLiveQuery seems to always run the query twice

thank you, I had no idea dev mode rendered or ran hooks twice. This page here doesn't explicitly mention that though, where is this mentioned in the docs?

10 replies

DTDrizzle Team

•Created by Chris Dosé on 9/24/2024 in #help

Expo app + drizzle-kit migrations and enabling journal_mode = WAL

I'm doing it like this now, is this ok to do?

import { drizzle } from "drizzle-orm/expo-sqlite";
import { openDatabaseSync } from "expo-sqlite";

import * as schema from "./schema";

export const expoDb = openDatabaseSync("ambry.db", {
  enableChangeListener: true,
});
expoDb.execSync("PRAGMA journal_mode = WAL;");
export const db = drizzle(expoDb, { schema });

import { drizzle } from "drizzle-orm/expo-sqlite";
import { openDatabaseSync } from "expo-sqlite";

import * as schema from "./schema";

export const expoDb = openDatabaseSync("ambry.db", {
  enableChangeListener: true,
});
expoDb.execSync("PRAGMA journal_mode = WAL;");
export const db = drizzle(expoDb, { schema });

2 replies

Gaming

Programming