© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•2y ago•
1 reply
_Zaizen_

Issue with CURRENT_TIMESTAMP bun:sqlite

I have the following table:


export const token = sqliteTable("token", {
    token: text("token").notNull().primaryKey(),
    usage_started: integer("usage_started", { mode: "boolean" })
        .notNull()
        .default(false),
    usage_started_timestamp: integer("usage_started_timestamp", {
        mode: "timestamp_ms",
    }),
    used: integer("used", { mode: "boolean" }).notNull().default(false),
    used_timestamp: integer("used_timestamp", { mode: "timestamp_ms" }),
    expiration_timestamp: integer("expiration_timestamp", {
        mode: "timestamp_ms",
    })
        .notNull()
        .default(-1),
    instance_id: integer("instance_id")
        .notNull()
        .references(() => instance.id),
});

export const token = sqliteTable("token", {
    token: text("token").notNull().primaryKey(),
    usage_started: integer("usage_started", { mode: "boolean" })
        .notNull()
        .default(false),
    usage_started_timestamp: integer("usage_started_timestamp", {
        mode: "timestamp_ms",
    }),
    used: integer("used", { mode: "boolean" }).notNull().default(false),
    used_timestamp: integer("used_timestamp", { mode: "timestamp_ms" }),
    expiration_timestamp: integer("expiration_timestamp", {
        mode: "timestamp_ms",
    })
        .notNull()
        .default(-1),
    instance_id: integer("instance_id")
        .notNull()
        .references(() => instance.id),
});


When running

await db.insert(token).values({
        token: tokenId,
        instance_id: instanceId,
        expiration_timestamp: currentTimestamp + 86400000,
    });

await db.insert(token).values({
        token: tokenId,
        instance_id: instanceId,
        expiration_timestamp: currentTimestamp + 86400000,
    });
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Issue querying with relations in bun+sqlite
Drizzle TeamDTDrizzle Team / help
3y ago
SQLite: timestamp vs timestamp_ms modes
Drizzle TeamDTDrizzle Team / help
3y ago
Bun:SQLITE error with drizzle
Drizzle TeamDTDrizzle Team / help
16mo ago
SQLite auto-update timestamp
Drizzle TeamDTDrizzle Team / help
10mo ago