Skip to content

Instantly share code, notes, and snippets.

View ThimoDEV's full-sized avatar

Thimo ThimoDEV

  • Netherlands, Breda
  • 16:44 (UTC +02:00)
  • X @ThimoDEV
View GitHub Profile
// TODO: make `pages` optional and measure the div when unspecified, this will
// allow more normal document flow and make it easier to do both mobile and
// desktop.
import {
createContext,
useCallback,
useContext,
useEffect,
useMemo,
useRef,
@ThimoDEV
ThimoDEV / drizzle-turso-local.ts
Created November 12, 2023 15:27
A gist for building a Drizzle local sqlite together with turso, while being able to make partial select queries
import { createClient } from "@libsql/client"
import { env } from "~/env.mjs"
import Database from "better-sqlite3"
import { drizzle as drizzleLocal } from "drizzle-orm/better-sqlite3"
import { drizzle as drizzleTurso } from "drizzle-orm/libsql"
import * as schema from "./schema"
const drizzleType = drizzleTurso({} as any, { schema })
type DBType = typeof drizzleType
@ThimoDEV
ThimoDEV / clear-planetscale-db-drizzle.ts
Created November 6, 2023 09:59
A simple script to clear all the data of your planetscale DB (force-reset from PrismaORM)
// db.ts
import * as schema from "./schema"
export const db = drizzle(connection, { schema })
//reset.ts
async function reset() {
const tableSchema = db._.schema
if (!tableSchema) {
throw new Error("No table schema found")