Search
Star
Feedback
Setup for Free
© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
Simulate enums with SQLite `CHECK()` - Drizzle Team
DT
Drizzle Team
•
3y ago
•
11 replies
Jökull Sólberg
Simulate enums with SQLite `CHECK()`
I
'm a heavy enum user in Postgres
. Using SQLite now
, wondering if anyone has come up with something clever to narrow a TEXT value to some values
, perhaps based on
CHECK()
CHECK()
constraints
, which kind of give you what ENUM does
.
Drizzle Team
Join
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Similar Threads
Was this page helpful?
Yes
No
Similar Threads
drizzle-zod sqlite enums not being able to createInsertSchemas
DT
Drizzle Team / help
11mo ago
Problem with ENUMs PostgreSQL
DT
Drizzle Team / help
15mo ago
Enums
DT
Drizzle Team / help
2y ago
Enums
DT
Drizzle Team / help
3y ago