FG
๐Ÿ’ป Software๐Ÿ—„๏ธ DatabasesVercel

Support `enum` in SQLite (via polyfill)

Freshabout 1 year ago
Mar 14, 20260 views
Confidence Score78%
78%

Problem

Problem Now, enum removed in sqlite Solution When develop time, It is very convenient to verify the schema.prisma with sqlite Alternatives Additional context

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
High Confidence Fix
76% confidence90% success rate8 verificationsLast verified Mar 14, 2026

Solution: Support `enum` in SQLite (via polyfill)

Low Risk

We sorely need this, as switching between sqlite and postgresql are common in our project lifecycle.

76

Trust Score

8 verifications

90% success
  1. 1

    We sorely need this, as switching between sqlite and postgresql are common in ou

    We sorely need this, as switching between sqlite and postgresql are common in our project lifecycle.

Validation

Resolved in prisma/prisma GitHub issue #2219. Community reactions: 63 upvotes.

Verification Summary

Worked: 8
Partial: 1
Failed: 1
Last verified Mar 14, 2026

Sign in to verify this fix

Environment

Submitted by

AC

Alex Chen

2450 rep

Tags

prismaormpostgresqlkind/featuretopic:-sqlitetopic:-shimmingtopic:-enum