Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅
APACHE-2.0 License
Bot releases are visible (Hide)
Published by github-actions[bot] over 1 year ago
drizzle-orm
in both ESM and CJS environments.drizzle-orm/sql
and drizzle-orm/expressions
should now be imported from drizzle-orm
instead.Published by github-actions[bot] over 1 year ago
.limit()
and .offset()
const stmt = db
.select({
id: usersTable.id,
name: usersTable.name,
})
.from(usersTable)
.limit(placeholder('limit'))
.offset(placeholder('offset'))
.prepare('stmt');
const result = await stmt.execute({ limit: 1, offset: 1 });
Published by github-actions[bot] over 1 year ago
Published by github-actions[bot] over 1 year ago
Published by github-actions[bot] over 1 year ago
Published by github-actions[bot] over 1 year ago
enumValues
propertyPublished by github-actions[bot] over 1 year ago
Published by github-actions[bot] over 1 year ago
Would suggest to upgrade to this version anyone who is using postgres dialect.
0.23.9
and0.23.10
are broken for postgresql migrations
Published by github-actions[bot] over 1 year ago
Published by github-actions[bot] over 1 year ago
You can now use transactions with all the supported databases and drivers.
node-postgres
example:
await db.transaction(async (tx) => {
await tx.insert(users).values(newUser);
await tx.update(users).set({ name: 'Mr. Dan' }).where(eq(users.name, 'Dan'));
await tx.delete(users).where(eq(users.name, 'Dan'));
});
For more information, see transactions docs:
Published by github-actions[bot] over 1 year ago
Published by github-actions[bot] over 1 year ago
INSERT IGNORE
support for MySQL (contributed by @FugiTech via #305)Published by github-actions[bot] over 1 year ago
IN
operator (#382)pgEnum.enumValues
type (#358)pgEnum
Published by github-actions[bot] over 1 year ago
Published by github-actions[bot] over 1 year ago
Published by github-actions[bot] over 1 year ago
Published by github-actions[bot] over 1 year ago
InferModel
from drizzle-orm