Meta tags:
description=Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.;

Headings (most frequently used words):

schema, zod, install, the, dependencies, select, insert, update, refinements, factory, functions, data, type, reference,

Text of the page (most frequently used words):
#schema (43), const (32), drizzle (30), number (29), users (27), from (23), zod (21), orm (21), integer (20), name (20), import (19), string (18), age (15), mode (14), the (14), text (13), pgtable (12), max (11), parse (11), data (10), notnull (10), parsed (10), and (9), length (7), limit (7), min (7), date (7), core (7), createselectschema (7), bit (6), enum (6), userinsertschema (6), createinsertschema (6), will (6), can (6), user (6), select (6), tuple (5), dimensions (5), type (5), lower (5), upper (5), bigint (5), coerce (5), createschemafactory (5), use (5), primarykey (5), userselectschema (5), database (5), postgres (5), postgresql (5), array (4), object (4), point (4), timestamp (4), generatedalwaysasidentity (4), used (4), update (4), await (4), api (4), insert (4), rows (4), query (4), migrations (4), custom (3), boolean (3), json (3), int (3), pgenum (3), set (3), types (3), extended (3), instance (3), for (3), you (3), function (3), preferences (3), bio (3), successfully (3), defines (3), shape (3), validate (3), roles (3), bun (3), add (3), our (3), studio (3), sql (3), buffer (2), any (2), null (2), union (2), line (2), geometry (2), bigserial (2), 9_007_199_254_740_991 (2), varchar (2), char (2), uuid (2), val2 (2), val1 (2), reference (2), createdat (2), above (2), this (2), true (2), case (2), john (2), openapi (2), advanced (2), factory (2), functions (2), theme (2), field (2), extends (2), optional (2), extend (2), modify (2), refinements (2), jane (2), where (2), userupdateschema (2), undefined (2), createupdateschema (2), requests (2), error (2), not (2), into (2), usersviewschema (2), usersview (2), pgview (2), rolesschema (2), basic (2), admin (2), views (2), pnpm (2), yarn (2), npm (2), install (2), dependencies (2), web (2), goodies (2), dark (2), light (2), system (2), extensions (2), effect (2), typebox (2), queries (2), overview (2), relations (2), upgrade (2), cockroachdb (2), mssql (2), singlestore (2), sqlite (2), mysql (2), instanceof, bytea, size, basedatatypeschema, datatype, record, jsonb, abc, vector, halfvec, 9_223_372_036_854_775_807, 9_223_372_036_854_775_808, javascript, safe, integers, 140_737_488_355_327, 140_737_488_355_328, doubleprecision, 2_147_483_647, 2_147_483_648, serial, 8_388_607, 8_388_608, real, 32_767, 32_768, smallserial, smallint, regex, time, sparsevec, numeric, macaddr8, macaddr, interval, inet, cidr, same, configuration, only, dates, all, specify, others, coercion, example, now, zodinstance, hono, using, more, cases, overwrites, including, its, nullability, before, becoming, nullable, 1000, each, create, accepts, additional, parameter, that, completely, overwite, defining, callback, while, providing, overwrite, updated, values, defined, inserted, users_view, enums, are, also, supported, returned, queried, responses, christmas, deal, per, analytics, one, dollar, stats, product, team, giving, off, turso, scaler, pro, year, cloud, partner, primary, backer, run, gateway, package, extension, benchmarks, discord, twitter, become, sponsor, graphql, eslint, plugin, legacy, arktype, valibot, validations, jit, mappers, codecs, read, replicas, dynamic, building, cache, batch, transactions, generated, columns, operations, serverless, performance, comments, magic, operator, aliases, joins, utils, filters, delete, access, your, versioning, generators, seeding, config, mobile, teams, check, export, pull, push, migrate, generate, row, level, security, rls, schemas, sequences, indexes, constraints, manage, expand, proxy, aws, netlify, nile, pglite, xata, supabase, prisma, vercel, neon, planetscale, connect, connection, fundamentals, relational, updates, how, gotchas, latest, releases, tutorials, guides, why, sustainability, get, started, meet, 35k, docs, merged, alternation, engine, beta, release, try, out,

Text of the page (random words):
drizzle orm zod we ve merged alternation engine into beta release try it out docs postgresql mysql sqlite singlestore mssql cockroachdb postgresql 35k light dark system postgresql mysql sqlite singlestore mssql cockroachdb postgresql meet drizzle get started sustainability why drizzle guides tutorials latest releases gotchas upgrade to v1 0 how to upgrade v0 v1 updates relational queries v1 to v2 fundamentals schema relations database connection query data migrations connect postgresql planetscale postgres neon vercel postgres prisma postgres supabase xata pglite nile bun sql effect postgres netlify database aws data api postgres drizzle proxy expand manage schema data types indexes constraints sequences views schemas drizzle relations row level security rls extensions migrations overview generate migrate push pull export check up studio custom migrations migrations for teams web and mobile drizzle config ts seeding overview generators versioning access your data query select insert update delete filters utils joins aliases magic sql operator sql comments performance queries serverless advanced set operations generated columns transactions batch cache dynamic query building read replicas custom types codecs jit mappers goodies validations zod install the dependencies select schema insert schema update schema refinements factory functions data type reference valibot typebox arktype typebox legacy effect schema extensions eslint plugin drizzle graphql system light dark become a sponsor twitter discord v1 0 98 benchmarks extension studio studio package gateway drizzle run our goodies our primary backer our cloud partner drizzle is giving you 10 off turso scaler and pro for 1 year product by drizzle team one dollar stats 1 per mo web analytics christmas deal zod install the dependencies npm yarn pnpm bun npm i drizzle orm rc zod yarn add drizzle orm rc zod pnpm add drizzle orm rc zod bun add drizzle orm rc zod select schema defines the shape of data queried from the database can be used to validate api responses import pgtable text integer from drizzle orm pg core import createselectschema from drizzle orm zod const users pgtable users id integer generatedalwaysasidentity primarykey name text notnull age integer notnull const userselectschema createselectschema users const rows await db select id users id name users name from users limit 1 const parsed id number name string age number userselectschema parse rows 0 error age is not returned in the above query const rows await db select from users limit 1 const parsed id number name string age number userselectschema parse rows 0 will parse successfully views and enums are also supported import pgenum pgview from drizzle orm pg core import gt from drizzle orm import createselectschema from drizzle orm zod const roles pgenum roles admin basic const rolesschema createselectschema roles const parsed admin basic rolesschema parse const usersview pgview users_view as qb qb select from users where gt users age 18 const usersviewschema createselectschema usersview const parsed id number name string age number usersviewschema parse insert schema defines the shape of data to be inserted into the database can be used to validate api requests import pgtable text integer from drizzle orm pg core import createinsertschema from drizzle orm zod const users pgtable users id integer generatedalwaysasidentity primarykey name text notnull age integer notnull const userinsertschema createinsertschema users const user name john const parsed name string age number userinsertschema parse user error age is not defined const user name jane age 30 const parsed name string age number userinsertschema parse user will parse successfully await db insert users values parsed update schema defines the shape of data to be updated in the database can be used to validate api requests import pgtable text integer from drizzle orm pg core import createupdateschema from drizzle orm zod import eq from drizzle orm const users pgtable users id integer generatedalwaysasidentity primarykey name text notnull age integer notnull const userupdateschema createupdateschema users const user age 35 const parsed name string undefined age number undefined userupdateschema parse user will parse successfully await db update users set parsed where eq users name jane refinements each create schema function accepts an additional optional parameter that you can used to extend modify or completely overwite a field s schema defining a callback function will extend or modify while providing a zod schema will overwrite it import pgtable text integer json from drizzle orm pg core import createselectschema from drizzle orm zod import z from zod v4 const users pgtable users id integer primarykey name text notnull bio text preferences json const userselectschema createselectschema users name schema schema max 20 extends schema bio schema schema max 1000 extends schema before becoming nullable optional preferences z object theme z string overwrites the field including its nullability const parsed id number name string bio string null preferences theme string userselectschema parse factory functions for more advanced use cases you can use the createschemafactory function use case using an extended zod instance import pgtable text integer from drizzle orm pg core import createschemafactory from drizzle orm zod import z from hono zod openapi extended zod instance const users pgtable users id integer generatedalwaysasidentity primarykey name text notnull age integer notnull const createinsertschema createschemafactory zodinstance z const userinsertschema createinsertschema users we can now use the extended instance name schema schema openapi example john use case type coercion import pgtable timestamp from drizzle orm pg core import createschemafactory from drizzle orm zod import z from zod v4 const users pgtable users createdat timestamp notnull const createinsertschema createschemafactory this configuration will only coerce dates set coerce to true to coerce all data types or specify others coerce date true const userinsertschema createinsertschema users the above is the same as this const userinsertschema z object createdat z coerce date data type reference pg boolean schema z boolean pg pgenum name val1 val2 schema z enum val1 val2 pg date mode date pg timestamp mode date schema z date pg date mode string pg timestamp mode string pg cidr pg inet pg interval pg macaddr pg macaddr8 pg numeric pg text pg sparsevec pg time schema z string pg bit dimensions schema z string regex 01 max dimensions pg uuid schema z string uuid pg char length schema z string length length pg varchar length schema z string max length pg text enum pg char enum pg varchar enum schema z enum enum pg smallint pg smallserial schema z number min 32_768 max 32_767 int 16 bit integer lower and upper limit pg real schema z number min 8_388_608 max 8_388_607 24 bit integer lower and upper limit pg integer pg serial schema z number min 2_147_483_648 max 2_147_483_647 int 32 bit integer lower and upper limit pg doubleprecision schema z number min 140_737_488_355_328 max 140_737_488_355_327 48 bit integer lower and upper limit pg bigint mode number pg bigserial mode number schema z number min 9_007_199_254_740_991 max 9_007_199_254_740_991 int javascript min and max safe integers pg bigint mode bigint pg bigserial mode bigint schema z bigint min 9_223_372_036_854_775_808 n max 9_223_372_036_854_775_807 n 64 bit integer lower and upper limit pg geometry type point mode tuple pg point mode tuple schema z tuple z number z number pg geometry type point mode xy pg point mode xy schema z object x z number y z number pg halfvec dimensions pg vector dimensions schema z array z number length dimensions pg line mode abc schema z object a z number b z number c z number pg line mode tuple schema z tuple z number z number z number pg json pg jsonb schema z union z union z string z number z boolean z null z record z any z array z any pg datatype array schema z array basedatatypeschema length size pg bytea schema zod custom buffer v v instanceof buffer