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

6 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?

6 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